Tag Archives: SQLNewBlogger

A Basic Encryption Primer for SQL Server

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Encryption is a function call in SQL Server, where we pass in the text to encrypt and a key. … Continue reading

Posted in Blog | Tagged , , , | 3 Comments

Computed Columns for Grouping–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran into someone trying to do some grouping for an accounting report. In this case, they had a … Continue reading

Posted in Blog | Tagged , , | Comments Off on Computed Columns for Grouping–#SQLNewBlogger

Basic XML Queries–#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 recently on querying an XML document. While I think XML is a pain and … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Basic XML Queries–#SQLNewBlogger

Basic OFFSET–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The other day I saw an article on the OFFSET clause in a SELECT. I had seen this come … Continue reading

Posted in Blog | Tagged , , | 1 Comment