|
Author: Derik Hammer
#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)
-
DING – LEVEL 2 !!!
/
DING – LEVEL 2 !!! I am excited to announce that I have achieved level 2 in My Epic Life Quest. My epic life…
-
Start and Save Hyper-V VMs with PowerShell
/
I use Windows 8 or Windows Server 2012 R2 on most of my local workstations between home and work. In order to conserve memory,…
-
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…