|
Category: Azure
#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…
-
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…
-
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…
-
DBCC CLONEDATABASE
/
Often I hear developers claim that they need production data in order to properly tune their queries. There are a couple of reasons that…
-
Active sessions and block duration
/
As a DBA, we all need the ability to take a quick glance at the currently active processes on our servers. A lot of…
-
Availability Group fail-over test with PowerShell
/
I have a number of SQL Server Availability Groups in my organization. Of them, most are multi-site configurations for disaster recovery. Naturally, the latency…
-
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.…
-
Automate Service Account Password Changes with Powershell
/
I am a believer that regular rotation of passwords is an important security measure. I worked at an organization that, when they were small,…
-
April SQL Server Updates
/
SQL Server 2014 Cumulative Update #1 is Available Microsoft has released Cumulative Update #1 for SQL Server 2014. KB Article: KB #2931693 114 fixes listed…