|
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)
-
Counting NULLs and sub-sets of data – SQL Hammer
/
Quick Tip: Counting NULLs and sub-sets of data You have been asked to produce a chart which will visualize a few data points. Total…
-
Presentation: Architecting Availability Groups – SQL Hammer
/
Track: Database Administration / Data Architecture Level: 200 – 300 Abstract: You are a DBA familiar with some basic Windows clustering and database mirroring…
-
Help! I am Locked Out of my SQL Server Instance – SQL Hammer
/
Beginning with SQL Server 2008, local administrators are no longer SQL Server sysadmins by default. Microsoft removed this feature in an attempt to increase…
-
Building up the PowerShell community – SQL Hammer
/
Last week I involved in a conversation with some SQL professionals who are also skilled with PowerShell. The SQL Server community is used to…
-
Policy Based Management Templates – TSQL2sDay #70 – SQL Hammer
/
T-SQL Tuesday (aka #TSQL2sday) is a monthly SQL Server blogger event started back in late 2009 by Adam Machanic (blog | twitter). The first…
-
Lone DBA, Lemming or Master of your Domain – SQL Hammer
/
> Are you a lone lemming or the master of your domain? Many organizations hire only one database administrator. This lone DBA is in…
-
Ding Level 3 in My Epic Life Quest – SQL Hammer
/
Wahooo! Today is a day to celebrate. I just realized that I have achieved level 3 in my Epic Life Quest. Stay tuned as…
-
Do we care about development environment performance? – SQL Hammer
/
Recently, but not for the first time, I was confronted with a server administrator that didn’t want to allocate more than one vCPU to a…
-
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…