|
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)
-
Derik’s Favorite Trace Flags – SQL Hammer
/
Recommended defaults Tempdb Trace Flag 1118 – Allocate full extents only Details: Trace Flags 1117, 1118, and Tempdb Configuration | Misconceptions around TF1118 Monitoring Trace…
-
Adding Your Entire Enterprise into Red-Gate SQL Multi Script Distribution List
/
RedGate sells a product call SQL Multi Script. The product allows you to asynchronously execute T-SQL scripts to large quantities of servers. There are…
-
Discovering Symantec NetBackup – SQL Hammer
/
I have worked with a large organization (150,000+ employees). This organization has a central location and hundreds of subordinate sites. Headquarters (HQ) has dictated…
-
Implicit Conversion Mine Field: Blowing SARGability away! – SQL Hammer
/
Implicit conversions are convenient. Implicit conversions are EVIL! When talking to professionals about implicit conversions, I’ve heard a few different comments, such as: (a…
-
Trace flags every DBA should know about
/
I have compiled a list of trace flags which I recommend enabling by default on all of you SQL Server instances and ones which…
-
Do not use percentage based auto-growth
/
Having autogrowth enabled on your SQL Server instance is great! Even in IT shops where you diligently right-size your database files (which is a good…
-
Fast, light-weight, row counts
/
Often we need to know the number of records in a table. If you are looking for something very specific, such as the number…
-
Synchronizing Server Objects for Availability Groups
/
After we create a strategy for synchronizing our data for disaster recovery, we then need to consider keeping our server objects synchronized. Depending upon…
-
It is who you know, or is it?
/
I have spent a lot of time learning about how to effectively network and the benefits that it can bring to my life and…
-
Writing Repeatable T-SQL
/
Writing code for a database is more of a challenge than writing for applications. Before the developers bite my head off, I do not…