Contents tagged with Microsoft SQL Server

Microsoft, please open source sqlcmd, Sqlps, SMO, and LogParser

Mar 28 2015No Comments by justin

Microsoft has open sourced part of the .NET framework. This is exciting news, although honestly not all that unprecedented. There was a time when AT&T defended the C language as its intellectual property. These days, the language is effectively in the public domain. (Note IANAL, the preceding was not legal advice. UNIX is a trademark of the Open Group). This lead to a few people asking if SQL Server would ever be open sourced. That answer is probably no for the time being. However, I do …

SQL, Open Source, Microsoft SQL Server Read more

A misleading SQL Error Message Error: 18456, Severity: 14, State: 38

Dec 10 2012No Comments by justin

On Friday I had to help a client out with an error that kept appearing in their event logs: Login failed for user 'domain\user'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.0.25] It took me a while to troubleshoot the error. The client's internal system administrator (who was quite sharp) only had to call me in in the first place because the error was a little misleading. See the first thing I did when I saw that was audit login failures. In the trace, the …

Microsoft SQL Server Read more

My ideas for The Atlantis Interactive Schema Engine

Mar 27 2011No Comments by justin

I first became aware of the open source Atlantis Interactive Schema Engine on Febuary 24th 2011 thanks to a retweet by Paul Randal. Its a .NET assembly which contains most of the "heavy lifting" code related to the schema operations in their various products. Matt Whitfield, the sole proprietor of Atlantis Interactive, is going to setup an account on codeplex or one of the other forges so people can post bugs, feature requests, and of course patches. Personally, I have several ideas for feature …

Atlantis Interactive, Microsoft SQL Server, Open Source Read more

How many ways can we 'script' a stored proc or UDF from the command line?

Mar 26 2011No Comments by justin

Update: Added link to the scripts on github. If you've worked with SQL Server for any length of time, you've probably written some stored procedures and user defined functions. If you're like me, you've written many. Usually, when you edit a stored proc or UDF. you do it from Visual Studio or Sql Server Management Studio (SSMS). However, what if you want to script the sproc or udf from the command line? Well, there are quite a few ways to skin this cat, and I'll go through a few. Using sqlcmd …

Atlantis Interactive, batch files, Microsoft SQL Server, PowerShell Read more