|
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)
-
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…
-
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…
-
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…
-
You must just have the touch
/
Over the years, I’ve found my professional maturity to be a growing entity. One piece of evidence of this is how I react to being the…
-
Windows Server 2012 R2 Product Key Failure
/
Today I had an odd experience with installing Windows Server 2012 R2. I downloaded the ISO from the MSDN subscriber’s downloads. Then I got…
-
Becoming a Senior DBA – SQL Hammer
/
My life in the work force began like many others, as a waiter at a Greek restaurant in my home town, Newtown, CT. After…