|
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)
-
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…
-
Set Windows Failover Cluster Timeout Thresholds
/
Purpose: When dealing with a single site the default Windows Failover Cluster timeout settings have always done a good job for me but, once…
-
September Updates – SQL Server 2008 SP3 CU #13 and 2012 SP1 CU #6
/
SQL Server 2012 SP1 Cumulative Update #6 is now available. KB Article: KB #2874879. Build Number is 11.0.3381. Applicable to @@VERSION 11.0.3000 through 11.0.3380. SQL…
-
Running SSIS Packages in 32-bit
/
Explanation of the issue Many of our servers run the 64-bit version of SQL Server and Integration Services and use components and /or providers…
-
Relocating SQL Server System Databases without Access to the Instance
/
Recently I wrote myself a PowerShell unattended AKA silent installation script. I had thoroughly tested this script on clustered installations and stand-a-lone named instances…
-
PowerShell SQL Connection Test
/
In the interest of providing minimal surface area exposure to my servers I have taken on the common practice of not installing development tools…
-
Poll – How do you handle security?
/
MS SQL Server provides a wide range of options to choose from when deciding how to regulate security in our organizations? I’m curious how…
-
Detach and Attach User Databases
/
The Need I’ve found myself, more times than once, needing to change disk drives that my user databases are found on. This could come…
-
Bug: Local View + Synonym + Remote Query
/
Recently I came across an interesting bug when upgrading a SQL Server 2000 box to 2008 R2. With SQL Server 2005, 2008, and 2008…