Tag Archives: SQLNewBlogger

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 , , | Leave a comment

Using Out-GridView To Pick Parameters–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was editing an article on PoSh and learned something cool. I can use Grid-View to surface an object … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Do I have a Database Master Key in a database? #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. How can I tell if I have a Database Master Key in a database? It’s actually easy. I query … Continue reading

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

Getting Started Blogging–#SQLNewBlogger

It’s a new year, and the perfect time for you to start blogging about your SQL Server work. I think blogging is a great way to showcase your knowledge, and over time, this can become as important to your potential … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Checking Permissions for Keys–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I got a call from someone wanted to check how permissions were stored for encryption objects. I ran a … Continue reading

Posted in Blog | Tagged , , | Leave a comment