|
Category: Uncategorized
#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)
-
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…
-
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…
-
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…
-
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…
-
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…
-
Bug: INSERTing into a MySQL Database via Linked Server
/
Recently I found myself involved in a project where a tab delimited text file (updated daily) was being imported into a MS SQL Server…
-
May Updates for SQL Server
/
May Updates for SQL Server Cumulative Update #11 for SQL Server 2008 SP3 is now available. KB Article: KB #2834048. Build Number is 10.00.5840. Applicable…
-
Editorial: Automation
/
Often I find myself thinking to myself, “if only I had one more DBA.” I’m sure we’ve all said this often enough and probably not…
-
Huge distribution database
/
The Problem: Today I noticed the data drive of one of my Production servers growing. It wasn’t growing overly fast and it had been…
-
Misleading Merge Replication Error – Msg 14052
/
Recently I blogged about two methods to repair transactional replication. Transactional Replication – Fixed in Minutes Today I was attempting to apply the same…