SQL
SQL Poetry
This is not strictly a technical article, but nevertheless I decided to post it on my site. I believe quite a few of us, and by us, I mean SQL query writers, sometimes we feel Read more…
SQL
SQL: How to parse Microsoft Transact-SQL Statements in C# and to match the column aliases of a view with its related (dependent) tables.
This is a example on how to use the Microsoft T-SQL parser in C# which is part of the Feature Pack. Microsoft® SQL Server® 2014 Feature Pack: https://www.microsoft.com/en-us/download/details.aspx?id=42295 Microsoft® SQL Server® 2014 Transact-SQL Language Service: Read more…
SQL
SQL: ScriptDb 2.0
ScriptDb is a C# console app that uses SQL Management Objects (SMO) to script database objects. This project is a refinement and improvement of the orignal work of Jesse Hersch of http://www.elsasoft.org His project can Read more…
SQL
SQL: defragment,rebuild or show info about indexes in a database
This is a sql script I am using quite some time now, from 2010. It is based on the original work from Microsoft but it is heavily upgraded to give you more options and functionality. https://msdn.microsoft.com/en-us/library/ms177571.aspx Read more…