For those of you interested, I have recorded an interview with The Thirsty Developer ( http://www.thirstydeveloper.com ). The interview is based around a user group presentation that I give about the new features of SQL Server 2008 for developers. I do need to clarify one statement in the interview....
With SQL Server 2008, Microsoft introduced native backup compression. Prior to SQL Server 2008, the only way to get real-time backup compression was to buy a third-party tool. There were – and still are – several third-party tools on the market. I have used a few of them, and they each have...
I’ve been working on upgrading an application from SQL Server 2005 to SQL Server 2008. Simple process, right? Well, I ran into a few issues along the way that I thought I would share with you. First, make sure that your processor configuration matches your affinity mask. You might be thinking that...
For those of you who haven't heard, RC0 of SQL Server 2008 has been released. If you have played with any of the CTP releases of SQL Server 2008, you'll notice that there are a few differences in the installer - but not enough to cause you to relearn anything. I loaded it up on my dev box this...
The call for presentations for the 2008 PASS Community Summit closes on Friday, March 28, 2008. If you are interested in submitting an abstract, go to http://calltospeakers.sqlpass.org/ . The PASS Community Summit is a great opportunity to start your career as a conference speaker or to add to your presentation...
If anyone is interested, I will be presenting at the Wisconsin SQL Server User Group meeting in June. The meeting date is Tuesday, June 10, 2008, and it will be held at the Microsoft office in Waukesha, WI. The meeting starts at 4:30 PM, and usually is wrapped up by 6:30 PM (to allow people to make it...
Just a quick post to say that the February CTP of SQL Server 2008 has been released. You can download it from http://technet.microsoft.com/en-us/bb851664.aspx . You will need to subscribe to Microsoft Connect - if you haven't already. Have fun! I know I will. Chuck
I've been seriously ramping up on the SQL Server 2008 feature set over the past few weeks, and I'm noticing that there are a ton of new features in the database engine that not a lot of people are talking about. Everyone hears about the biggies - Resource Governor, new Date data types, Spatial...
Have you had a chance to check out the resource governor in SQL Server 2008 yet? If not, you should take a look. The resource governor allows you to categorize a connection (at the time of login) into a workload group. That group exists as part of a resource pool. At the pool level, you can set minimums...