November Update – SQL Server 2012 SP1 CU #7
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.
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…
T-SQL Command Line Options – Part 5 – SQLPS
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…
T-SQL Command Line Options – Part 4 – SQLPSX
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…
T-SQL Command Line Options – Part 3 – PS w/ .NET
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…
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
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…
The Peter Principle
The Peter Principle The Peter Principle, as referenced above, is, “the theory that employees within an organization will advance to their highest level of competence and then be promoted to, and remain at, a level at which they are incompetent.”…