|
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)
-
DBCC CLONEDATABASE
/
Often I hear developers claim that they need production data in order to properly tune their queries. There are a couple of reasons that…
-
Everything has a cost
/
Too often we end up in a conflict while trying to explain how a minimally impacting function has no true business impact. If you are…
-
Availability Group Architecture – DR on the Cheap
/
Last time, I discussed how to limit data duplication between data centers as a cost-effective option with an Availability Group. In this post I will…
-
Availability Group Architecture – Adding a Second Site
/
Last time, I discussed the simplest Availability Group architecture, with only a single site. In this post I will expand upon the same architecture,…
-
Availability Group Architecture – High-Availability Only
/
Availability groups offer us a variety of features. They offer high-availability (HA), they can give disaster recovery (DR), and they have connectivity and off-loading features…
-
T-SQL Tuesday #74 – Be the change (MERGE static data)
/
Each month, on the first Tuesday of the month, the announcement for the blog party T-SQL Tuesday comes out. Those that are interested then…
-
Keeping up with changes to Books Online
/
Keeping up with new features of SQL Server can be a challenge. What is even more challenging, though, is keeping up with changes to…
-
Performance tuning backup and restore operations – SQL Hammer
/
The standard backup strategy seems to always include backups running at midnight, hoping that they complete before anyone starts using the applications. There is…
-
Guest Post: Identifying and handling blocked processes in SQL Server – SQL Hammer
/
Author Bio: Priyanka Chouhan is a technical writer in Stellar Data Recovery with 5 years of experience and has written several articles on SQL server &…
-
T-SQL Search Snippets – SQL Hammer
/
Here are two snippets that I use often to search for objects on a variety of servers. The first will search any object within…