Tag Archives: T-SQL

Renaming a Column–#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 rarely do is rename objects. There are good reasons to do so, but often … Continue reading

Posted in Blog | Tagged , , | Leave a comment

ROLLing UP Totals–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was editing an article recently that talked about ROLLUP, and I wanted to play with this a bit … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Basic FORMATting– #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw the addition of FORMAT() to the T-SQL language, but didn’t play with it much. Recently it appeared … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Unit Testing T-SQL Code

Abstract Unit testing has become an integrated, expected part of most software development teams. Many database developers have yet to implement unit testing as a regular habit. This session will look at two-unit testing frameworks and show how to implement … Continue reading

Posted in Presentations | Tagged , | Leave a comment

Quick SQL Prompt Updates in a Pattern

I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things I like. SQL Prompt might be my favorite tool.  SQL Prompt will be yours as well if you give it … Continue reading

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

WAITFOR isn’t a function–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I needed to delay the execution of some code the other day. This was a test that was trying … Continue reading

Posted in Blog | Tagged , , | Leave a comment

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

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

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