|
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)
-
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…
-
Let your burdens drive you forward
/
A few nights ago my wife and I were talking over dinner. We were discussing her co-worker’s behaviors regarding stress and deadlines. For the…
-
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…
-
Query Cached Execution Plans
/
Often I need to examine an execution plan from a production server. Just as often, I can’t re-run the stored procedure in that environment.…
-
SQL Saturday #320 Raleigh in Review
/
This past Saturday, September 6th, I had the privilege of attending SQL Saturday #320, in Raleigh, NC. It was a great day. The highlight of…
-
Ramping up for SQLSaturday #320 – Raleigh, NC
/
In just a couple of hours I will be driving down to Raleigh for tomorrow’s SQLSaturday #320. It looks like a great line up…
-
Configuring PowerShell Remoting with Group Policy
/
Last week I promised a post on enabling PowerShell Remoting when we discussed automating service account password updates. So, let’s break down the two…
-
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,…
-
Scripting Objects with PowerShell
/
The ability to script out the definitions of objects is valuable to any DBA. Most of us are intimately familiar with SQL Server Management…