Wednesday, May 16, 2018

Azure SQL Data Warehouse, Azure SQL Database and SQL Server sessions from the Build 2018 conference

›
The Build 2018 conference happened last week, I decided to put all the Azure SQL Data Warehouse, Azure SQL Database and SQL Server sessi...
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...