Administration

Are your backups enough?

“You only need one thing; a backup or a résumé. Never both.” This quote certainly summarizes a very important piece of being a DBA. You must be able to recover from a disaster. There are many ways to offer redundancy…

PRO TIP: Force table suggestions – Red-Gate SQL Prompt 6

PRO TIP: Force table suggestions – Red-Gate SQL Prompt 6

For those SQL Prompt users, like myself, I’m sure you love its table suggestion feature. Unfortunately, there are situations where you open a query window and the table suggestions don’t immediately populate. This can be annoying if you were looking…

Transactional Replication – Find the Publisher

I manage a moderately complicated topology that includes one-way transactional replication with push subscriptions to and from several database instances. Due to my day-to-day tasks I know this topology pretty well and often I simply know what my publications are,…

SQL Agent Monitoring – Long Running Job Queries

The SQL Server alert system does a great job of handling notifications for SQL Agent job failures but if want to know if a job is hung, taking longer than expected, or maybe it’s disabled and hasn’t been running, we…

Managing Multi-Instance Cluster Failovers

Managing Multi-Instance Cluster Failovers

A couple of weeks ago I was reviewing my daily news feeds and a featured post on SQLServerCentral.com caught my eye. Michael Lacy‘s post on Managing MaxMemory Values on an Active-Active Two Node Cluster provides a solution to the problem of…

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 support SQL Server 2012/2014 Client and Server Versions supported SQL 2005 thru SQL 2012/2014 Engine TRC…

October Updates – SQL Server 2012 RTM CU #10

SQL Server 2012 RTM Cumulative Update #10 is now available. KB Article: KB #2891666. Build Number is 11.0.2420. Applicable to @@VERSION 11.0.2100 through 11.0.2419. NOTE: We are likely to see CU #11 released for RTM in December but this will be…

T-SQL Command Line Options – Part 2 – SQLCMD.exe

T-SQL Command Line Options – Part 2 – SQLCMD.exe

SQLCMD.exe In SQL Server 2005 and above SQLCMD.exe comes packaged with each installation regardless of edition. This part of the T-SQL Command Line Options blog series will cover the basics for executing T-SQL queries and commands using SQLCMD with command prompt. In…

T-SQL Command Line Options – Part 1

Every SQL Server DBA is intimately familiar with SQL Server Management Studio (SSMS) and/or previous tools such as Query Analyzer. What some of us are less familiar with are the various options of executing T-SQL via command line or from…