Monday, February 19, 2018

Webinar: SQL Server on Linux tools: SQL Server Integration Services

›
Microsoft is hosting a SQL Server on Linux tools: SQL Server Integration Services webinar/town hall on March 1st, 2018 10:00-11:00 AM Pac...

Reinventing the wheel

›
It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has changed, I...
Monday, January 15, 2018

When uncompressing data, make sure to use the correct function

›
SQL Server has offered data compression for a while now, you could either use PAGE compression or ROW compression, you had no ability so s...
1 comment:
Friday, December 29, 2017

The 15 most popular posts in 2017

›
Another year is almost over. As the last post of this year I decided to share with you the 15 most popular posts in 2017. I just used Googl...
2 comments:
Wednesday, November 29, 2017

Use T-SQL to create caveman graphs

›
I found this technique on Rich Benner's SQL Server Blog:  Visualising the Marvel Cinematic Universe in T-SQL  and decided to play arou...
5 comments:
Wednesday, October 25, 2017

How to update 2 tables with 1 statement in SQL Server..the hard way....

›
Every now and then you will get someone asking how to update two tables with one statement in SQL Server. The answer is usually, no that ...

Foreign Keys don't always need a primary key

›
In the post  Your lack of constraints is disturbing  we touched a little upon foreign key constraints but today we are going to take a clos...
Thursday, October 19, 2017

Your lack of constraints is disturbing

›
It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has changed, I...
Wednesday, October 18, 2017

SQL Server does support regular expressions in check constraints, you don't always need triggers

›
Someone posted the following question I need to add table called group with a column called code How do I add a check constraint to the...
Tuesday, October 17, 2017

Standardized Naming And Other Conventions

›
It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has changed, I...