Midlands PASS Meeting tonight with Andy Leonard

If tonight you’re in or can get to the Columbia, SC area, we have a treat for you! Former SQL...

Msg 8909, Level 16, State 1, Line 1 Table error: Object ID index ID partition ID

  Being a DBA , you will see database...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Msg 8909, Level 16, State 1, Line 1 Table error: Object ID index ID partition ID

Advertisements 
Being a DBA , you will see database corruptions in your environments. I got four or five and not affected much...

Point In Time Restore for Azure SQL Database

Point In Time Restore for Azure SQL Database
This article try to explain

Automatic backups services provided by Azure 
Backup retention periods
How to take the point in time database restoration

This database restoration...

Point In Time Restore for Azure SQL Database

Point In Time Restore for Azure SQL Database
This article try to explainAutomatic backups services provided by Azure Backup retention periodsHow to...

Prevent Full Script Execution (Understanding and Using PARSEONLY and NOEXEC)

(last updated: 2019-01-08 @ 13:53 EST / 2019-01-08 @ 18:53 UTC )
There are times when I am working on a SQL script that...

Speaking at SQLSaturday Nashville – 815!

Speaking at SQLSaturday Nashville – 815!
I’m proud to announce that I will be speaking at SQL Saturday Nashville on January 12th 2019! And wow,...

Speaking at SQLSaturday Nashville – 815!

Speaking at SQLSaturday Nashville – 815!
I’m proud to announce that I will be speaking at SQL Saturday Nashvilleon January 12th 2019! And wow, 815 SQL Saturdays! This one won’t let you...

T-SQL Documentation Generator

This post is a response to this month's T-SQL Tuesday #110 prompt by Garry Bargsley.  T-SQL Tuesday is a way for the SQL Server community to share ideas about...

T-SQL Documentation Generator

This post is a response to this month’s T-SQL Tuesday #110 prompt by Garry Bargsley.  T-SQL Tuesday is a way...