|
Author: Derik Hammer
#TSQL2SDAY (8) Administration (41) AI (10) 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)
-
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…
-
T-SQL Command Line Options – Part 4 – SQLPSX
/
Powershell and SQLPSX SQLPSX is an open source codeplex project that was created to provide an intuitive interface for interacting with SQL Server in…
-
SQL Server 2008 R2 – Service Pack 2
/
Quick Announcement: I just wanted to throw a quick announcement out that SQL Server 2008 R2 SP2 is available. Service Pack 2 includes Cumulative Updates…