Automating like an Enterprise DBA

One of the things that should seem very commonplace to a data professional is the effort to become a lazy DBA. A lazy DBA is not a bad thing....

Automation starts by doing something once, very very carefully: T-SQL Tuesday #110

After a while the intros for my T-SQL Tuesday posts get a little boring. So without any further ado, it’s...

Azure – Creating a storage account

Azure offers a lot of features that enable IT professionals to really enhance their environment.  One feature that I really...

Basic PowerShell: Get-Member

Disclaimer: I’m still learning PowerShell. I’ve been using it more lately and I want to talk about it more. I’ll...

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

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

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! ]]

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...

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...

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...