|
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)
-
Unattended (Silent) SQL Server Installations
/
As promised from my last post, Relocating SQL Server System Databases without Access to the Instance, today I will be blogging about ‘unattended’ or…
-
The Peter Principle
/
The Peter Principle The Peter Principle, as referenced above, is, “the theory that employees within an organization will advance to their highest level of…
-
Temporary Stored Procedures
/
We are all familiar with table variables, local temp tables, and global temp tables but what some people over look is that stored procedures…
-
T-SQL Command Line Options – Part 3 – PS w/ .NET
/
Powershell and .NET Objects Now that we’ve covered SQLCMD.exe with the command prompt I’d like to dive into the present and future of Windows…
-
Optimizing the BACKUP Command
/
One challenge for a DBA is to setup the appropriate backup plans for the databases under our responsibility. It is easy to use SSMS’s…
-
October Updates – SQL Server 2012 RTM CU #10
/
SQL Server 2012 RTM Cumulative Update #10 is now available. KB Article: KB #2891666. Build Number is 11.0.2420. Applicable to @@VERSION 11.0.2100 through 11.0.2419. NOTE:…
-
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…
-
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…
-
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…
-
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…