Tag Archives: SQLNewBlogger

Getting a Day Difference in PowerShell–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. SSMS froze on me the other day. Actually, it lightly responded to some things, but the window wouldn’t redraw … Continue reading

Posted in Blog | Tagged , , | Comments Off on Getting a Day Difference in PowerShell–#SQLNewBlogger

Checking if a database has a master key–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I’ve been working with encryption in SQL Server for a long time, and have delivered quite a few presentations … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

Creating a new User-Defined Data Type–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran across a question on user-defined data types, which I hadn’t worked with in a long time, so … Continue reading

Posted in Blog | Tagged , , | 2 Comments

A Little Current Date Arithmetic in Powershell–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a fun post on Twitter recently asking days until retirement. I wrote this code: DECLARE @YearsToRetire INT … Continue reading

Posted in Blog | Tagged , , | 1 Comment