Just how awesome are table parameters in SQL Server 2008?
I would have to say, that one of the coolest new features of SQL Server 2008 is the ability to pass a table as a single parameter to a stored procedure. While we have been able to do this in the past, by using XML to pass more than one value in, then break it […]
Getting rid of Instant File Initialization (or enabling it if that strikes your fancy)
SQL Server 2005 introduced us to Instant File Initialization. This allows SQL Server to create files of any size without sitting there for minutes or hours (depending on the size of the files). While this is great when creating your database, or extending your database files there is a cost to doing so. Before each […]
Ask your Exchange Server questions to the Exchange MVPs
If you are like me you work with Exchange, and probably have to work with Exchange Server at least some times, and you may some all sorts of questions about it. Well here is your chance to ask some of the top Microsoft Exchange MVPs all those questions. Combined the MVPs on this chat have […]
SQL Clustering Article in SQL Server Magazine
For those of you who are SQL Server Magazine Subscribers you should be getting your copies right about now (if you haven’t already). When you do be sure to check out the article which I have in the magazine about clustering your SQL Server. For those without a subscription you can sign up for a […]