Tag Archives: T-SQL

Using Merge–#SQLNewBlogger

Posted on August 14, 2017 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was playing with some data, loading it into staging tables and then moving it to a real table. … Continue reading →

Posted in Blog | Tagged , , | Leave a comment

DevOps–Fixing Poorly Named Constraints

Posted on July 26, 2017 by

I was building some code the other day and kept getting problems in my deployment for a change. The deployment was having issues, and this came down to this statement. ALTER TABLE EventLogger DROP CONSTRAINT [PK__EventLog__5E548648B043C0BC] The problem was that … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

FizzBuzz–#SQLNewBlogger

Posted on July 24, 2017 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it. There’s been a … Continue reading →

Posted in Blog | Tagged , , | 3 Comments

Move a Stored Procedure to a New Schema–SQLNewBlogger

Posted on June 22, 2017 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 things I needed to do recently was move an object. I was testing the WideWorldImporters database … Continue reading →

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

A Busy Few Years

Posted on May 22, 2017 by

Last week on Twitter, a friend mentioned they were submitting to the PASS Summit and went through their previous speaking engagements. This person noted they had done over 40 talks in the last few years, which is a lot. I … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Limiting the Max–#SQLNewBlogger

Posted on April 27, 2017 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was chatting with someone the other day about MAX() and how it can work within a set of … Continue reading →

Posted in Blog | Tagged , ,

Watch Your DataTypes in Aggregates–#SQLNewBlogger

Posted on March 29, 2017 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I’ve got a database of NBA statistics with data like this for players. I downloaded a CSV and loaded … Continue reading →

Posted in Blog | Tagged , ,

Implicit Time Conversions – #SQLNewBlogger

Posted on March 2, 2017 by

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 , ,

Writing the Correct Query is Important

Posted on January 16, 2017 by

There’s a saying in the data world: garbage in, garbage out. We use that when we can’t get good information from our database because the data we’ve stored isn’t as useful as we would like. That’s a problem, and it’s … Continue reading →

Posted in Editorial | Tagged , ,

Quick Prompt Tips–Custom Procedure Templates

Posted on January 4, 2017 by

One of the things that I often do is create stored procedures. The syntax for doing so is simple, but it has a number of items that need to be included. SQL Prompt makes this much quicker with the “cp” … Continue reading →

Posted in Blog | Tagged , , ,