|
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)
-
Alerts or Spam – Which do you receive?
/
As a database administrator it is our jobs to maintain healthy database servers. So what does that really mean? Well, unfortunately, everything. We must…
-
Transactional Replication – Fixed in Minutes – SQL Hammer
/
Any of us who have been responsible for managing transactional replication knows that bad commands are possible and do happen. So, we have a…
-
April 2013 – Updates for SQL Server 2008 R2 / 2012
/
SQL Server 2012 RTM Cumulative Update # 7 KB Article: KB #2823247 Build number is 11.0.2405 Applicable to @@VERSION 11.0.2100 through 11.0.2401 SQL Server 2008…
-
How to: Configure SQL Server 2012 AlwaysOn – Part 3 of 7
/
How to: Configure SQL Server 2012 AlwaysOn Enabling the AlwaysOn Feature Quick post on how to enable the AlwaysOn feature at the database instance…
-
How to: Configure SQL Server 2012 AlwaysOn
/
How to: Configure SQL Server 2012 AlwaysOn Scope and Architecture This is the first post in a series to provide step-by-step instructions on how…
-
Cluster Explanation:
/
Today I’m happy to be able to relay some troubleshooting information that I found extremely difficult to find on the internet. Partly because the…
-
SQL Server Index Column Order
/
At times I am in a position to advise development teams on their practices. What I have learned from this experience is that there is…
-
How to: Transfer Logins to a New Server – SQL Hammer
/
Often enough we encounter a situation where we need security to be migrated. Microsoft hasn’t made this task as easy as moving other things…
-
Automated Unattended (Silent) SQL Server Installs with PowerShell
/
Last time we covered the basics of unattended installs in my post, Unattended (Silent) SQL Server Installations. Here I will be providing and explaining…
-
Welcome to my blog! – SQL Hammer
/
Welcome to my first post on the new sqlHammer blog site. My name is Derik Hammer and I’m a believer in sharing knowledge. Few…