SQL Sequence vs Identity Column
Let’s take a look at what a Sequence is in relation to an Identity Column in SQL Server. Did you...
2017-10-04
5,128 reads
SQLEspresso
Just Check ALL the Boxes
Today I ran into something on a client server I unfortunately see too often. The DBA goes through the trouble...
2017-10-05 (first published: 2017-09-27)
1,653 reads
Hmmm… What’s This?
OK So, I am doing some digging and peaking around again in SQL Server and came across a database option...
2017-09-27 (first published: 2017-09-20)
2,040 reads
What does this little check box do?
Ever wander around SQL Server properties and wonder what these little check boxes turn on? I do, and I get...
2017-09-13
341 reads
Please Don’t Do This!
Please, please, please Admins do not leave your default index fill factor at 0. This means you are telling SQL...
2017-09-18 (first published: 2017-09-06)
3,884 reads
System-Versioned Temporal Tables
Every once in a while, I like to take a moment and learn something new about the latest SQL Server...
2017-08-30
1,164 reads
VLFs the Forgotten Foe
How many of you check the amount of Virtual Log Files (VLFs) your transaction logs have?
Working as a consultant now,...
2017-09-07 (first published: 2017-08-23)
2,013 reads
TIL: Microsoft Azure Part 2
Last week I started a multi-part series on Today I Learned (TIL) about Microsoft Azure. This is part two of...
2017-05-24
926 reads
TIL: Microsoft Azure Part 1
I thought maybe it would be a good idea to start a multi-part series on Today I Learned (TIL) about...
2017-05-17
524 reads
Blogging at SQLPerformance.com
I am honored to be a Guest Blogger at SQLPerformance.com. As a member of the SentryOne Product Advisory Council (PAC)...
2017-04-18
357 reads
Blogs
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Forums
How to Repair Corrupt MySQL Tables
Comments posted to this topic are about the item How to Repair Corrupt MySQL...
The Funny Dynamic SQL
Comments posted to this topic are about the item The Funny Dynamic SQL
sqlbackups through veeam not updating msdb tables
We have veeam backups happening everyday on a server where all sql databases are...
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers