Featured Article(s) Pivoting Data With Oracle 11g’s Pivot Operator One of the new Oracle 11g features is the Pivot and Unpivot operators used to summarize rows into summarized pivot tables. This article describes how to use this feature in your Select statements Do THIS SQL Job Before THAT One Did you know you can use SQL Sentry Event Manager to […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

Featured Article(s) Troubleshooting SQL Server 2005 CLR Problems In this article, Alexander Chigrik explains some problems that you can have when you work with CLR objects. He also tells how to resolve these problems. Thanks To Our Sponsors We’ve worked with some great companies this year! We really appreciate their support and help in bringing you SSWUG. Over the next […]

Featured Article(s) Oracle 11g Software Installation on LinuxCentOS-5 After going through the 2-Day DBA guide and talking about installing Oracle software, I thought it would be interesting to write an article that covered an actuall install of Oracle 11g on Linux–CentOS-5. Thanks To Our Sponsors We’ve worked with some great companies this year! We really appreciate their support and help […]

Latest SQL Server Show Live Now This SQL Server show has a LOT of information. Interviews with some tools makers, information about protecting your holiday time, 60 second tip of the day, our SQL Server discussion list watch and a whole lot more. > Watch Now Also available Watch: SQLonCall Show – Interviews and more. Featured Article(s) New Features in […]