Tag Archives: SQLNewBlogger

Limiting the Max–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was chatting with someone the other day about MAX() and how it can work within a set of … Continue reading

Posted in Blog | Tagged , , | Leave a comment

DevOps Basics– git Cloning Repos

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This continues my series on git, because I think it’s good to know what the command line is and … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Watch Your DataTypes in Aggregates–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I’ve got a database of NBA statistics with data like this for players. I downloaded a CSV and loaded … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Getting a VHD into Azure with PoSh

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I thought this would make a nice SQLNewBlogger post, an easy get started one. I used the docs from … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Delete an Azure SQL Database from PowerShell

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the things I’ve been working on is trying to get my DevOps, continuous delivery pipeline working with … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Create a BACPAC–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the things that you might encounter at some point is the need to create a BACPAC. This … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Create a DACPAC to Move Databases–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In my last post, I talked about what a DACPAC was. Now let’s create one. This turns out to … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Implicit Time Conversions – #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was trying to work with times recently and needed to get the current time. I thought, well, Getdate(), … Continue reading

Posted in Blog | Tagged , , | Leave a comment

What’s a DACPAC and a BACPAC?

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. If you’ve worked with SQL Server development and database projects, you might have heard about DACPACs. However, if you … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Querying My Named Instance in PoSh–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was looking at some sample code the other day and it looked like this. cd sqlserver:\sql\localhost\default\databases This allows … Continue reading

Posted in Blog | Tagged , ,