Contents tagged with Atlantis Interactive

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