Blog Posts

Watch this week's video on YouTube
When I started working with T-SQL, I thought the GO command was optional, kind of like semicolons. It appeared in plenty of SSMS generated...

2018-05-29

9 reads

Converting JSON to SQL Server CREATE TABLE Statements

by Bert Wagner

Bert Wagner

Watch this week’s episode on YouTube.
Tedious, repetitive tasks are the bane of any lazy programmer. I know, because I am...

2018-05-28 (first published: 2018-05-22)

3,796 reads

Monday morning comic 2018-05-28

by Daniel Janik

Confessions of a Microsoft Addict

It always seems that when I give a talk on performance there are 100+ people packed in the room but...

2018-05-28

266 reads

SQL Server Stress Testing Using OStress – RML Utilities

by Dharmendra Keshari

SQL Geek

As a DBA, implementing a new database consists of a variety of aspects like correct table structure, tuning the stored...

2018-05-28 (first published: 2018-05-21)

7,239 reads

Add a custom report to SSMS

by Eduardo Pivaral

SQL Guatemala

Maybe some of you don't know this, but to view Report Definition Language reports (RDL) , you aren't forced to use...

2018-05-25

606 reads

Day 25 Optimization

by Vinay Thakur

Vinay Thakur

Locking is depends upon Isolation level and Storage Engine. MySQL uses table level locking (instead of page, row, or column...

2018-05-25

273 reads

dbachecks – Improved Descriptions

by Rob Sewell

SQL DBA With A Beard

With the latest release of dbachecks we have added a new check for testing that foreign keys and constraints are...

2018-05-25 (first published: 2018-05-19)

2,363 reads

Fix For Using Azure Active Directory and DacFX

by Richie Lee

Richie Lee's SQL Stuff

Update:
Refer to this post instead
Hello!
One of the things I feel strongly about is that a build/release pipeline needs to be as complete as possible - that is all configuration...

2018-05-25

5 reads