|
Category: Uncategorized
#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)
-
PowerShell Profile Tips
/
Automation is one of the purposes for using PowerShell. Automation is a funny thing, however. You can perform steps of automation almost to infinity.…
-
Merry Christmas Eve!
/
Merry Christmas Eve! A few weeks ago I posted on Availability Group fail-over tests with PowerShell. That post covered the basics of how to…
-
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,…
-
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…
-
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…
-
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…