|
Author: Derik Hammer
#TSQL2SDAY (8) Administration (41) AI (2) AlwaysOn Availability Groups (11) Azure (12) Career (25) Community (37) Continuous Integration / Deployment (7) Development (12) Disaster Recovery (27) General (20) High-Availability (9) Microsoft SQL Server (20) Performance (30) PowerShell (12) SQL Agent (8) SQL Server Management Studio (2) SSAS (1) SSIS (1) SSRS (2) T-SQL (14) Uncategorized (191) Windows Clusters (7)
-

Accelerating the restore process – ApexSQL Restore – Product Review
/
Infographic: “Your Backups – Restored from the Dead” To be a database administrator is to accept a life of stress and paranoia. We are…
-
Quick Links:
/
Hello, I’m happy to see that the buzz word “Free” did not fail to attract readers. NEVER FEAR! You will not leave this post…
-
Tell Microsoft we want UPN
/
It is commonly known that when using SQL Server with Active Directory you need to utilize the DOMAIN\UserName format and that the UserName cannot…
-

November Update – SQL Server 2012 SP1 CU #7
/
SQL Server 2012 SP1 Cumulative Update #7 is now available. KB Article: KB #2894115. Build Number is 11.0.3393. Applicable to @@VERSION 11.0.3000 through 11.0.3381. Written…
-

Managing Multi-Instance Cluster Failovers
/
A couple of weeks ago I was reviewing my daily news feeds and a featured post on SQLServerCentral.com caught my eye. Michael Lacy‘s post…
-
February 2013 Cumulative Updates for SQL Server 2008 R2 / 2012
/
SQL Server 2008 R2 Service Pack 1 Cumulative Update # 11 KB Article: KB #2812683 Build number is 10.50.2869 Applicable to @@VERSION 10.50.2500 through 10.50.2868…
-
Background
/
Background The days of restarting SQL Service with trace flags 1204 or 1222 (MSDN Detecting and Ending Deadlocks.aspx)) or being forced to start up…
-

T-SQL Command Line Options – Part 5 – SQLPS
/
SQLPS.exe and SQLPS the module SQLPS, like SQLPSX, is a set of extensions to Powershell for interacting with SQL Server. SQLPS first appeared with…
-
SQL Server 2008 MCM Readiness Videos
/
The other day I was doing some research on the Transaction Log of SQL Server and stumbled upon the MS SQL Server MCM Readiness…
-
RML Utilities for MS SQL Server – CU2 Released
/
Version 9.04.004 of the RML Utilities for MS SQL Server has been released. This package includes: SQL Azure – Connectivity and ReadTrace/Reporter database storage…