Tag Archives: T-SQL

Will Terminators Be Required?

Posted on August 6, 2018 by

I was looking at an article the other day and noticed that there was a CTE sample with the semicolon on the line before the code. I’ve been seeing this convention for years, starting your CTE with a semicolon because … Continue reading →

Posted in Editorial | Tagged | Leave a comment

Solving Ken’s FizzBuzz 3D–#SQLNewBlogger

Posted on July 16, 2018 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I like the FizzBuzz test. It’s cute and fun, and I’ve had my kids solve it, just to think … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Finding Inconsistent Key Values–#SQLNewBlogger

Posted on July 11, 2018 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was reading Iris Classon’s blog recently and ran across a post on her day at work. I think … Continue reading →

Posted in Blog | Tagged , , | Leave a comment

Getting All Users

Posted on May 15, 2018 by

I saw someone that wanted to get all users from all databases on their instance. Seems like that ought to be simple, right? The user wanted to use sp_MSforeachdb to query users, but wanted a single result set for all … Continue reading →

Posted in Blog | Tagged ,

Defining FKs in CREATE TABLE–#SQLNewBlogger

Posted on May 3, 2018 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the important things that a database developer can do is to define Foreign Keys (FK) at table … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Exploring the Caves of Code Analysis in #SQLPrompt

Posted on April 16, 2018 by

I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes and go through it. I wrote about a few of the items, and this post continues on with a feature … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

Trekking Through Formatting Forest on the #SQLPrompt Treasure Map

Posted on April 11, 2018 by

I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes and go through it. I wrote about Code Snippet Cove recently, and this post continues to move across the map. … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

Code Snippet Cove on the #SQLPrompt Treasure Map

Posted on April 9, 2018 by

I’ve been away a bit in the last week with personal and family commitments. As a result, I feel a bit out of touch with work, and I have some catching up to do. However, when I ran across the … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

Date Fun with SQL Server

Posted on April 3, 2018 by

I saw a people discussing date formats on Twitter after PASS put out an advertisement for a webinar with a mm-dd-yyyy format. Plenty of people were annoyed and wanted to be sure that they realized that much of the world … Continue reading →

Posted in Blog | Tagged , | 2 Comments

I learned about the order of logical operations #SQLNewBlogger

Posted on March 22, 2018 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I had logic in a CS curriculum many years ago and I’ve worked with AND and OR statements for … Continue reading →

Posted in Blog | Tagged , , | 6 Comments