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…

SQL Saturday #381 – Richmond, VA

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, I remembered to print out and cut my SpeedPass in advance. The line to use the…

Running PowerShell in a SQL Agent Job

Running PowerShell in a SQL Agent Job

When creating a SQL Agent Job to execute a PowerShell script, you have to decide which way that you want the PowerShell to run. Depending upon which version of SQL Server that you are using and which job step type that you…

Stored Procedures, Dynamic SQL and Execution Plans

Stored Procedures, Dynamic SQL and Execution Plans

Question If stored procedure execution plans are cached once and then reused, what version of the execution plan is cached for stored procedures that have dynamically created queries? Answer Dynamic SQL queries and stored procedures generate separate execution plans and…

Transact-SQL COUNT(*) vs COUNT(column) vs COUNT(1)

Transact-SQL COUNT(*) vs COUNT(column) vs COUNT(1)

I have heard a few different beliefs regarding how to write T-SQL queries when using the COUNT() function. Never use COUNT(*), it must read all columns and cause unnecessary reads. Always use COUNT(1) because, generally, the primary key is the…