|
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)
-
SQL Server SCHEMABINDING
/
SCHEMABINDING is an option that is available for objects in T-SQL which contain user defined code. Examples include, stored procedures, indexes, and functions. Straight…
-
User Groups
/
Photo credit for Community Wall (above): Pat Wright (t | b) User Groups Rebooted the Hampton Roads SQL Server User Group (t | w)…
-
Row Level Security in SQL Server 2016 CTP2
/
Earlier this year Microsoft Azure implemented Row-Level Security (Brent’s announcement). In following Microsoft’s cloud-first release concept, this great feature is now part of SQL…
-
Store Optional Connection Parameters in SQL Server Management Studio
/
About six months ago I wrote about the challenges of using the Always-On Availability Group Listeners with SSMS. At the time, I had presented…
-
Choosing a Git Client
/
Version control (VC) is very important for any type of IT shop, big and small, as well as for application code and database code.…
-
Multiple Server Management – Finding the Database Server
/
Often database administrators must ask themselves a simple, yet tedious question, “what server is that database on,” or maybe, “how many servers do we…
-
PowerShell Start-Job
/
The Start-Job Cmdlet is a fast and extremely simple means of spawning asynchronous threads. Why do we care? Because performing parallel work is faster…
-
The end of an era
/
Today is my last day working for Liberty Tax Service. Liberty took a chance on me when I was fresh out of the Navy…
-
Database Deployment Work Flow with SQL Server Data Tools (SSDT)
/
Happy April Fools Day everyone! I hope that you do not spend too much time reading completely false blog posts today. I, for one,…
-
SQL Saturday #381 – Richmond, VA
/
Last Saturday I attended #SQLSATRVA, which was SQL Saturday #381. It was a blast! The day started off with the usual registration process. Thankfully,…