Writing Repeatable T-SQL

Writing Repeatable T-SQL

Writing code for a database is more of a challenge than writing for applications. Before the developers bite my head off, I do not mean that the languages, such as T-SQL, are more difficult or that applications are any less…

SQL Server SCHEMABINDING

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 from MSDN, SCHEMABINDING… Specifies that the is bound to the database objects that it references. This…

Row Level Security in SQL Server 2016 CTP2

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 Server 2016 CTP2, and expected to be included in the RTM version. When I first saw…

QS-Config v2.0 Enters Open Beta: Major Refactoring

QS-Config v2.0 has passed closed beta and is now entering open beta. Feature changes / additions: Supports PowerShell v2.0 and higher. Supports SQL Server 2014. One script for all supported versions of SQL Server, rather than a script per version….

Choosing a Git Client

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. Most of my career I’ve used Microsoft’s Team Foundation Server (TFS)¬†for my VC system. I have…

Multiple Server Management – Finding the Database Server

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 still have on SQL Server 2005?” This article will cover how to use SQL Server’s Central…

PowerShell Start-Job

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 and our time is important. If I want to inventory the Windows services running on every…

The end of an era

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 with no experience as a DBA and has been there every step of the way as…

QS-Config v2.0 coming soon

QS-Config v2.0 coming soon

Years ago I found myself frustrated with the SQL Server installation wizard. I was working for an organization where SQL Server installs were needed regularly during points in their operational cycle and often they were not cookie cutter. Tweaks were…