I get a lot of requests for explanations about the different concepts and the easiest way to demo partitioning in SQL Server 2008. So in the spirit of education I have adapted the demo from the new features white paper from Microsoft, added explanations and guidance as to how to…

Ok, so I can’t promise you’ll be smooth by the end of this entry, but I can promise you’ll be compound operating like a champ. In SQL 2008 there is a new feature called .. you guessed it … Compound Operator. What Microsoft means by this is they have implemented…

With the advent of SQL Server 2005 and 2008, mail in the database engine has changed dramatically. Previously you had several options for working with email in the database. You could use any of the following procedures:

XP_SENDMAIL – Click here for details on this procedure

XP_READMAIL– Click here for…

Greg emailed me a great question from my week of warehousing webinar the other day. We were discussing disk performance and kept saying the term “spindles”as in using more of them to increase performance and throughput. The term means an individual hard drive in array. Many large disk systems have…

We seem to be busting at the seams lately with quality content from great providers. I wanted to recommend to you a great series of webinars that is being delivered by Microsoft. They cover all the reasons you should examine SQL Server 2008 as your next generation relational and intelligence… Read more

How exciting was last week! Some of the top experts in the country all gathered together through support from SQLServerCentral.com, Wrox and Wiley Press and of course, us here at Pragmatic Works. The week went well and I want to point you to a few links where you can watch…

We are all facing the challenges of this new economy. There are very few people and industries in the world today that have been unaffected by the failures and poor management of some of our largest institutions. I would like to discuss an alarming trend that I have seen in…