T-SQL Tuesday #39: More Efficient SMO with Server.SetDefaultInitFields
This T-SQL Tuesday is about PowerShell and how I use it with SQL Server. There…
Continue Reading
T-SQL Tuesday #39: More Efficient SMO with Server.SetDefaultInitFields
Log Shipping encounters corrupt log backup
I ran into an issue the other day and wanted to ensure that I shared…
Continue Reading
Log Shipping encounters corrupt log backup
Get SQL Server Service Accounts with WMI
Today I was tasked with retrieving the SQL Server Service accounts to validate them in…
Continue Reading
Get SQL Server Service Accounts with WMI
Opportunity to download Eval of Windows Server 2012
Use this link to download your copy of Windows Server 2012 for evaluation. I know…
Continue Reading
Opportunity to download Eval of Windows Server 2012
Powershell, SMO and Database Files
In response to some questions about renaming a physical file for a database, I have…
Continue Reading
Powershell, SMO and Database Files
The Best Thing I Learned at PASS
Being that I have never missed a PASS Summit yet (in the US), I thought…
Continue Reading
The Best Thing I Learned at PASS
SQL PASS 2007 has concluded
I went to the SQL PASS 2007 Summit this past week, and I have to…
Continue Reading
SQL PASS 2007 has concluded
Error in SQL (Error: 17806, Error: 18452) SSPI Problem
I recently came across this while managing a clustered SQL Server. There were various messages…
Continue Reading
Error in SQL (Error: 17806, Error: 18452) SSPI Problem
Working with SSIS in SQL Server 2005
I thought I would document my exploits in SQL Server SSIS 2005 conversion of DTS…
Continue Reading
Working with SSIS in SQL Server 2005