Tag Archives: SQLNewBlogger

Getting Row Numbers with Window Functions–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In a recent post, I started looking at some basics for window functions. This post continues with a look … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Basic Window Functions–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Window functions are a class of functions that dramatically improve the performance of certain types of queries. We often … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Setting DebugPreference for Testing–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was working on a PoSh script recently and needed to debug some things. Rather than have Write-Host throughout … Continue reading

Posted in Blog | Tagged , , | Comments Off on Setting DebugPreference for Testing–#SQLNewBlogger

Creating a Symmetric Key–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is a series on working with the various encryption technologies in SQL Server. One of the encryption technologies … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Creating a Symmetric Key–#SQLNewBlogger