Tag Archives: T-SQL

The Code Coverage Report

I had someone that told me recently that they needed to find a way to get code coverage in T-SQL. Not for them, not to improve quality, but because their manager wanted a report. OK, here it is. First, build … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Bulk Inserting Build Data–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the common tasks that many DBAs need to do is insert data into a database. Often this … Continue reading

Posted in Blog | Tagged , , , | 2 Comments

Adding a New Default to a Column

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. This is a … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Using Merge–#SQLNewBlogger

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

DevOps–Fixing Poorly Named Constraints

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

FizzBuzz–#SQLNewBlogger

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

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

A Busy Few Years

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

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

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