|
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)
-
Upgrading SQL Server with Replication
/
Recently I had to create an upgrade plan for a company with 50+ SQL Servers with replication, both transactional and merge, spider-webbed between most…
-
SQL Server 2014 CTP1 Product Guide
/
SQL Server 2014 CTP1 Product Guide has been released. List of Inclusions White papers SQL Server 2014 Mission Critical Performance SQL Server 2014 Faster…
-
SQL Server 2012 RTM Cumulative Update 9
/
SQL Server 2012 RTM Cumulative Update #9 is now available. KB Article: KB #2867319. Build Number is 11.0.2419. Applicable to @@VERSION 11.0.2100 through 11.0.2410.
-
July SQL Server Updates
/
July Updates for SQL Server SQL Server 2012 Service Pack 1 Cumulative Update #5 is now available. KB Article: KB #2861107. Build Number is 11.0.3373. Applicable…
-
Free SQL Tools
/
Below is a collection of free tools every DBA should know about. Plan Explorer Apex SQL sp_Blitz sp_BlitzIndex sp_WhoIsActive Index Defrag Script 4.1 SQL…
-
Creating Logins and Users – Why I can’t connect
/
If you have ever used database projects with SSDT I’m sure you’ve experienced a situation where that user you just created yesterday is suddenly…
-
Attention users running SQL Server 2008 and 2008 R2! – SQL Hammer
/
This is a bit of a piggy back post but I find the information very important and should be publicized far and wide. Complete…
-
Querying Central Management Servers
/
SQL Server Central Management Servers have a number of great features such as, policy enforcement, spawning group connection query windows, and organizing your list…
-
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…