Automating like an Enterprise DBA

TSQL Tuesday
The second Tuesday of the month comes to us a little early this month. That means it is time...

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

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