Skip to Content

drsql (187 Posts)

RSS

50ths… SQL Saturday and Life

Posted July 11, 2017

By ,

In Personal, SQL Saturday

This week I will experience a couple of events associated to the number 50. SQL Saturday Atlanta The second will be my 50th SQL Saturday Event! (49th speaking,... more »
0

SQL Saturday Chattanooga is THIS WEEK!

My goodness how time does fly. It seems like just a few months ago I was going to my hometown SQL Saturday in Nashville, and now here I go again to my NEW... more »
0

Father, Son, Daughter, and SQL

Posted June 18, 2017

By ,

In Off Topic, Personal, Un-SQL, Uncategorized

I don’t love Father’s Day. Mostly because I spoke to my father for the last time on Father’s day back in 1996. He wasn’t feeling well,... more »
0

Utility to temporarily drop FOREIGN KEY constraints on a set of tables

Posted June 15, 2017

By ,

In T-SQL, Uncategorized, Utility

I was working on a database a few weeks back (maybe longer, I am kind of busy with several projects right now), and I wanted to truncate a set of tables. There... more »
2

Utility to script a FOREIGN KEY Constraint

Posted May 24, 2017

By ,

In T-SQL, Uncategorized, Utility

Note: Amended to include the word include in the first Note (I am a terrible editor of my own writing!) and to fix a bug in the code with a misplaced... more »
0

Creating FOREIGN KEY constraints as enabled, trusted, non-trusted, and/or disabled

Posted May 07, 2017

By ,

In constraints, T-SQL

I am in the middle of building a utility (for work, and for my next SQLBLOG post), that will help when you need to drop the foreign key constraints on a table,... more »
3

Speaking at the Nashville SQL Server User's Group on April 28th.

Posted April 18, 2017

By ,

In Nashville, PASS, speaking, Uncategorized, Users Group

And they say you can’t go home again.. On the 28th of April I will be returning back to my old home of Nashville to speak at the Nashville SQL Server... more »
0

SQL Saturday Birmingham #593 is this weekend!

Posted March 14, 2017

By ,

In speaking, SQL Saturday, Uncategorized

It has been a while since I was last in Birmingham (Alabama) for a SQL Saturday. They didn’t have one last year, and the event they did have was on the... more »
0

Music City Code, a great conference that you may have never heard of yet

Posted February 26, 2017

By ,

In Music City Code, speaking, Uncategorized

For quite a few years, Nashville, and then Chattanooga had a conference called Devlink. It was low on cost, and high on education, and run by the awesome John... more »
0

A new (to me, and possibly you) SSMS feature – Query Plan Comparing

Posted January 26, 2017

By ,

In SQL Server 2016, SSMS, T-SQL

Wow, Microsoft has really changed in culture recently. This new rapid release cycle for SSMS is seemingly paying dividends in a major way. In a recent build of... more »
2