|
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)
-
Tell Microsoft we want UPN
/
It is commonly known that when using SQL Server with Active Directory you need to utilize the DOMAIN\UserName format and that the UserName cannot…
-
Quick Links:
/
Hello, I’m happy to see that the buzz word “Free” did not fail to attract readers. NEVER FEAR! You will not leave this post…
-
RML Utilities for MS SQL Server – CU2 Released
/
Version 9.04.004 of the RML Utilities for MS SQL Server has been released. This package includes: SQL Azure – Connectivity and ReadTrace/Reporter database storage…
-
SQL Server 2008 MCM Readiness Videos
/
The other day I was doing some research on the Transaction Log of SQL Server and stumbled upon the MS SQL Server MCM Readiness…
-
T-SQL Command Line Options – Part 5 – SQLPS
/
SQLPS.exe and SQLPS the module SQLPS, like SQLPSX, is a set of extensions to Powershell for interacting with SQL Server. SQLPS first appeared with…
-
Bug: Local View + Synonym + Remote Query
/
Recently I came across an interesting bug when upgrading a SQL Server 2000 box to 2008 R2. With SQL Server 2005, 2008, and 2008…
-
Detach and Attach User Databases
/
The Need I’ve found myself, more times than once, needing to change disk drives that my user databases are found on. This could come…
-
Poll – How do you handle security?
/
MS SQL Server provides a wide range of options to choose from when deciding how to regulate security in our organizations? I’m curious how…
-
PowerShell SQL Connection Test
/
In the interest of providing minimal surface area exposure to my servers I have taken on the common practice of not installing development tools…
-
Relocating SQL Server System Databases without Access to the Instance
/
Recently I wrote myself a PowerShell unattended AKA silent installation script. I had thoroughly tested this script on clustered installations and stand-a-lone named instances…