(Ahmad Osama) In this class I will talk about ways to handle error in a stored procedure.

(Thomas LaRock) I’ve been involved in a virtualization projects for almost ten years now. In that time I’ve had the opportunity to track my own list of “best practice” items. It’s a list I share freely with clients and customers that seek me out for virtualization advice.

(Sadequl Hussain) Auditing and inventorying is not something new in any IT environment. Depending on the purpose, it can take many forms. Sometimes the auditing is about security and data access. Sometimes it is about software usage and licensing. Often it is about consolidation and cost saving.

(Seth Delconte) We have an XML file that must be kept in its current form, but would like to query it from SQL Server. In this tip we will look at how to use SQL Server to query an external XML file and return results within SQL Server.

(Dandy Taylor) With the release of SQL Server 2012, Microsoft has added some nice features. Recently I’ve spent time with one of those, the SQL Server Integration Services (SSIS) Catalog and its supporting database. For those of you unfamiliar with it, the SSIS catalog is the new model for logging i

(Kenneth Fisher) I spend a reasonable amount of time looking through various forums, answering some questions and reading the answers to others. One of the things I’ve noticed is that while I frequently see system views referenced I only very rarely see the INFORMATION_SCHEMA views mentioned. This s

(Pinal Dave) Here is an email I received during the weekend.

(Daniel Calbimonte) Sometimes SQL Server Analysis Services query response time is too slow and we want to improve the performance. How can we do so? What options are available to improve SQL Server Analysis Services performance? In this tip we will improve the performance by testing two parameters

(Pinal Dave) I have previously written about the difference between UNION ALL and UNION multiple times over this blog but it seems like this question never gets old and I keep on getting the question again and again.

(Jen McCown) Here’s a quick mystery. You have a SQL Server with several jobs that appear to be running properly and on schedule, but many of them show no history. You look around, and there doesn’t seem to be a nightly job history purge (you’re looking for something with “sp_purge_jobhistory“). So