|
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)
-
How Fast Can You Learn?
/
Self-analysis and emotional intelligence are valuable assets. Internal, or even external, dialog aids in problem solving and understanding. Knowing yourself is more important than any skill that…
-
T-SQL Tuesday #85: STOP! Restore Time!
/
I know, I know. That was a bit much. This month’s T-SQL Tuesday is being hosted by Kenneth Fisher (b | t). T-SQL Tuesday…
-
Rotating Tables with Indicators in SSRS 2016
/
When creating SSRS (SQL Server Reporting Services) dashboards, I like to use indicators to give clear and colorful data visualizations. In this post I am…
-
T-SQL Tuesday #84: Building an hour of content
/
This month’s T-SQL Tuesday is being hosted by Andy Yun (t | b). T-SQL Tuesday (#TSQL2SDAY) is a blog party founded by Adam Machanic…
-
Unique Indexes and Computed Columns in SQL Server
/
In the last post of this blog series, I discussed what a non-clustered index is and how to choose an ideal non-clustered index key.…
-
Demo God Recovery Kit
/
I was scheduled to give a virtual presentation to the MagicPASS user group. The week before I received a beta update for Windows 10.…
-
Non-Clustered Indexes in SQL Server
/
In the last post of this blog series, I discussed what a clustered index is and how to choose an ideal clustered index key.…
-
Measuring Availability Group Synchronization Lag
/
With all of the high-availability (HA) and disaster recovery (DR) features, the database administrator must understand how much data loss and downtime is possible…
-
Choosing Subway
/
By the time this post is published I will likely be pulling into the parking lot at the Subway World Headquarters, ready to receive…
-
SQL Agent 2016 Jobs Running PowerShell Scripts
/
I recently performed a side-by-side upgrade of a SQL Server 2008 R2 instance to SQL Server 2016 RTM. This particular instance had over 200…