|
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)
-
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…
-
Connecting to an Availability Group Listener with SQL Server Management Studio
/
Background When a cluster has an Availability Group installed on it, there is an optional listener which is used to manage connections through fail-over events.…
-
How to change the schema of a table
/
The other day I set out to performance tune a database deployment. The company was getting ready to implement almost a year’s worth of…
-
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…
-
Query Central Management Server with PowerShell SMO
/
All production or operational DBAs need to maintain a server / instance list. SQL Server’s Central Management Server (CMS) is a great means of managing that…
-
Rebooting HRSSUG
/
This week I’m excited to announce the reboot of the Hampton Roads SQL Server User Group (HRSSUG). We will be coming back online this…
-
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.…
-
Dynamically create table results from non-query
/
Have you ever executed a command with a result set but you didn’t know the exact schema being returned? Have you ever wanted to…
-
Disconnect Users from Database – SQL Hammer
/
There are some operations that we execute in SQL Server which need exclusive access to the database. For everyone who has ever attempted this, I’m…
-
Query Object Dependencies
/
SQL Server Management Studio has a decent interface for viewing object dependencies, check out TechNet .aspx)for those procedures. But, we all know the value…