|
Category: SQL Agent
#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)
-
Redgate SQL Prompt Grid Features
/
I love Redgate tools. Most of all, I love SQL Prompt because its features increase my productivity on a daily basis. Recently I discovered…
-
Azure SQL Database Elastic Pools
/
Azure SQL Database Elastic Pools are a mechanism for grouping your Azure SQL Databases together into a shared resource pool. Imagine for a moment…
-
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…
-
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…
-
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…
-
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…
-
Backup testing with PowerShell
/
This week I released a two part blog series on SQLShack.com. The series covers automated testing for your backup files and reporting on the results.…