T-SQL Command Line Options – Part 3 – PS w/ .NET

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

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 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.”…

Editorial: Automation

Often I find myself thinking to myself, “if only I had one more DBA.” I’m sure we’ve all said this often enough and probably not just to ourselves, I’m sure the boss gets an ear full every now and again. But,…

Running SSIS Packages in 32-bit

Explanation of the issue Many of our servers run the 64-bit version of SQL Server and Integration Services and use components and /or providers that require 32-bit execution. There are several articles and blog / forum posts that address the…

September Updates – SQL Server 2008 SP3 CU #13 and 2012 SP1 CU #6

SQL Server 2012 SP1 Cumulative Update #6 is now available. KB Article: KB #2874879. Build Number is 11.0.3381. Applicable to @@VERSION 11.0.3000 through 11.0.3380. SQL Server 2008 SP3 Cumulative Update #13 is now available. KB Article: KB #2880350. Build Number is 10.00.5846….

Creating Logins and Users – Why I can’t connect

If you have ever used database projects with SSDT I’m sure you’ve experienced a situation where that user you just created yesterday is suddenly complaining to you that they can no longer access the database. Often this is because SSDT…

SQL Server 2012 RTM Cumulative Update 9

SQL Server 2012 RTM Cumulative Update 9

SQL Server 2012 RTM Cumulative Update #9 is now available. KB Article: KB #2867319. Build Number is 11.0.2419. Applicable to @@VERSION 11.0.2100 through 11.0.2410.