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,…
A globally unique identifier (GUID) is a great way to identify a record in your database. It can be easily created at the database or application layer and, when generated, is guaranteed to be unique regardless of other records already…
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…
Infographic: “Your Backups – Restored from the Dead” To be a database administrator is to accept a life of stress and paranoia. We are charged with the responsibly of protecting one of a business’s most valuable resources, its data. We…
SQL Server 2012 SP1 Cumulative Update #7 is now available. KB Article: KB #2894115. Build Number is 11.0.3393. Applicable to @@VERSION 11.0.3000 through 11.0.3381.
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…
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…
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 SQL Server 2008 in the form of a mini-console called SQLPS.exe. This mini-console was originally based…
Powershell and SQLPSX SQLPSX is an open source codeplex project that was created to provide an intuitive interface for interacting with SQL Server in Powershell. The module uses the SMO objects which are backwards compatible to SQL Server 2000 and…
Powershell and .NET Objects Now that we’ve covered SQLCMD.exe with the command prompt I’d like to dive into the present and future of Windows command line, Powershell. One of the great things about Powershell is that for every task there…