On October 21st, 2009 at 11am (Pacific) / 2pm (Eastern) I’m going to be presenting a free Webcast on how to setup a Windows 2008 Cluster when using iSCSI. Additionally I’ll be going over some tuning tricks you can use to improve the performance of your iSCSI network. Continued »
While many of the technologies used for HA and DR are similar (or even the same) HA and DR are two different types of events which should be handled differently. Continued »
The slide deck only has a couple of slides in it, so my it self it isn’t all that interesting. The recording has taken via Net Meeting. It’s the first time I’ve recorded something via Net Meeting directly, so if it isn’t great sorry. I’ll try better next time.
The recording works in IE, I don’t think Firefox likes the format.
Join me tomorrow September 30th, 2009 as I talk about virtualization with the PASS Virtualization Virtual Chapter. I’ll be presenting my presentation entitled “Diving into Server Virtualization, Deciding if Virtualization is a good choice for your SQL Server“. The presentation starts at 9am (Pacific) / 12pm (Eastern). (This link goes to the live meeting site.) Continued »
If you are a computer science major, or taking a computer class of some sort, then by all means use the Internet for research. That’s what it’s there for. If you’ve written some code and it’s just not working correctly then by all means post your question on a forum (with the code) and ask what you are doing wrong. Someone will be more than happy to point you in the right direction. Continued »
It’s been pointed out to me just how screwed up yesterdays post was. I’m a big boy, I can admin it when I muck something up, especially something that badly.
Sorry about that, apparently I needed a lot more sleep (or a lot more coffee) when I wrote that post. I’ve corrected yesterday’s post so that it’s actually accurate now.
Based on some questions on forums and some of the responses that people have been giving there appears to be done misunderstanding about what the WITH ROLLBACK IMMEDIATE option does when added to the ALTER DATABASE command. My goal here is to try and clear up at least some of the confusion. Continued »
SQL Server rights are pretty easy to work with most of the time. You grant a bunch of rights to an object, then you deny rights to those objects and the user looses the rights. Pretty easy. Now the catch is that if you use the fixed database roles, those roles overwrite any denies that are in place. Continued »
The datetime data type can be one of the hardest to work with when it comes to index optimization. Most queries that use a datetime data type for filtering (part of the where clause) only want to match the date portion of the value. Most people handle this via a convert function around the date column. This causes the index that you create to become useless as the convert function causes the index to be scanned not seeked.
A white paper which I wrote for Starwind Software is now available. The link to register for the webcast (October 21, 2009) has also been put up. The webcast and white paper go together, so I recommend that you grab the white paper now and I hope to see you at the webcast next month.