Featured Article(s) Review: SoftTree SQL Assistant SQL Assistant is a tool that integrates into your environment of choice, offering to help with your SQL coding. The hope is that you will end up with standardized code, better, more efficient coding time since the tool would help you create the code and more. One reason to use Cursors than Set based […]
Author: Ben Taylor
Final Virtualization Thoughts and Feedback
Featured Article(s) Kill a Blocking Session After Waiting a Parameterized Wait Time Value The following stored procedure can be used inside a job that runs on a recurrent basis and kills all blocking session (block column in sysprocesses != 0) that the wait time column of the blocked session is greater than a parameter value (in miliseconds) The procedure kills […]
Final Virtualization Thoughts and Feedback
Featured Article(s) Kill a Blocking Session After Waiting a Parameterized Wait Time Value The following stored procedure can be used inside a job that runs on a recurrent basis and kills all blocking session (block column in sysprocesses != 0) that the wait time column of the blocked session is greater than a parameter value (in miliseconds) The procedure kills […]
Virtualization, Getting Help with SQL Server and More
Featured Article(s) New Features in ADO.NET (Part III) ADO.NET has introduced many cool features to improve the scalability and performance of data centric applications. With features like provider independent factory models, support for XQuery handling with xml data type and asynchronous processing techniques, the amount of LOC, code complexity and maintenance has been greatly reduced thus helping the developers to […]
Virtualization, Getting Help with SQL Server and More
Featured Article(s) New Features in ADO.NET (Part III) ADO.NET has introduced many cool features to improve the scalability and performance of data centric applications. With features like provider independent factory models, support for XQuery handling with xml data type and asynchronous processing techniques, the amount of LOC, code complexity and maintenance has been greatly reduced thus helping the developers to […]
SQL Server Virtualization Discussion, Happy New Year!
Happy New Year! 2008 should be interesting… again. With the release of SQL Server, Windows Server, VS and all of the assorted tools and technologies, there is a lot happening that will keep us all watching the releases, the updates, the testing and so-on. I think there will be some great things to come out of both the new products […]
SQL Server Virtualization Discussion, Happy New Year!
Happy New Year! 2008 should be interesting… again. With the release of SQL Server, Windows Server, VS and all of the assorted tools and technologies, there is a lot happening that will keep us all watching the releases, the updates, the testing and so-on. I think there will be some great things to come out of both the new products […]
OMIGOSH III (Attacking A SQL Server Issue)
Do You Have Your Free 90 Day SSWUG Membership Yet? You can get it quickly just by registering for the conference. By registering before 12/31/2007, you will receive a complimentary 90 day membership to the site. It’s easy to register and the conference will feature more than 36 technical tracks, exhibits, no sales info in the tech tracks, and much […]
OMIGOSH III (Attacking A SQL Server Issue)
Do You Have Your Free 90 Day SSWUG Membership Yet? You can get it quickly just by registering for the conference. By registering before 12/31/2007, you will receive a complimentary 90 day membership to the site. It’s easy to register and the conference will feature more than 36 technical tracks, exhibits, no sales info in the tech tracks, and much […]
OMIGOSH, Round II
Featured Article(s) New Features in ADO.NET (Part II) ADO.NET has introduced many cool features to improve the scalability and performance of data centric applications. With features like provider independent factory models, support for XQuery handling with xml data type and asynchronous processing techniques, the amount of LOC, code complexity and maintenance has been greatly reduced thus helping the developers to […]