Tag Archives: T-SQL

Advent of Code 2017 Day 2–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is day 2 of the Advent of Code 2017. If you want to read about the puzzles, start … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Advent of Code 2017 Day 1–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I like the Advent of Code. I stumbled on the site a few years ago and enjoyed working through … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Restoring a Copy Only Backup–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. There was a question posted recently at SQLServerCentral about whether a copy only backup could be restore with a … Continue reading

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

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 ,

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

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

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