|
Category: T-SQL
#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)
-
Top 10 Tips for Availability Groups
/
I have enjoyed working with Availability Groups ever since they were released with SQL Server 2012. Each major version since, the feature has improved…
-
Connecting your Azure regions
/
In this post, I am going to demonstrate how to configure virtual network gateways in Azure using Resource Manager. This is important for connecting…
-
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…
-
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.…
-
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…
-
A better way to search dates
/
SARGability is the ability of the query to properly search the arguments that you pass it. When your query is not sargable you cannot…
-
Clustered Indexes in SQL Server
/
In the last post of this blog series, I discussed what a heap is and how it impacts query performance. In this post, I…
-
Compare paths with PowerShell
/
The other day I came across the need to compare two different paths for equality. The most annoying part of this task is when…
-
The ‘B’ in B-Tree – Indexing in SQL Server
/
Some people advocate we should count by twelve rather than ten. This is because you can easily count the twelve segments of your fingers…