|
Category: Performance
#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)
-
The end of an era
/
Today is my last day working for Liberty Tax Service. Liberty took a chance on me when I was fresh out of the Navy…
-
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…
-
A first timer’s lessons learned at PASS Summit 2014
/
Me, as a #sqlfirsttimer Just one year ago I didn’t know what the PASS Summit was. What came after has been a series of serendipitous events. I…
-
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.…
-
ApexSQL’s Response to the Community
/
The end of last year I did a review on ApexSQL Restore, a tool used to attach SQL Server native backup files to a…
-
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…
-
Querying Central Management Servers
/
SQL Server Central Management Servers have a number of great features such as, policy enforcement, spawning group connection query windows, and organizing your list…
-
Automated Unattended (Silent) SQL Server Installs with PowerShell
/
Last time we covered the basics of unattended installs in my post, Unattended (Silent) SQL Server Installations. Here I will be providing and explaining…