February 13, 2008 10:37 AM
Posted by: Denny Cherry
Article,
Cache,
RAM,
SQLI’ve published a new tip over on SearchSQLServer.com entitled “
February 11, 2008 8:00 AM
Posted by: Denny Cherry
Config,
Microsoft Windows,
RAM,
SQL,
Windows ComputingWhen using 64bit SQL Server getting the memory settings right is pretty easy. Simply set the maximum to what you want and you are good to go.
Getting them right in the 32bit versions of SQL Server is a bit harder. You have to deal with the OS level of enabling the Physical Address Extensions...
February 7, 2008 12:20 AM
Posted by: Denny Cherry
Article,
In Person Events,
Quest Software,
SoSSE,
SQL,
SQL Server 2005,
SSMSThe folks at Quest Software asked me to write a paper for them discussing the differences between managing a SQL Server using just the Microsoft provided tools and their Spotlight on SQL Server Enterprise product. That paper has just been released and can be downloaded
February 1, 2008 12:27 AM
Posted by: Denny Cherry
SQL,
SQL Server 2005,
SQL Server 2008,
WebcamOn Thursday Feb 7, 2008 at 8am Pacific (11am Eastern, 4pm GMT) myself and Jason Hall, Systems Consultant at Quest Software will be co-hosting a webcast looking into the challenges in seeing exactly what is happening within SQL Server (including SQL Server 2008) using Spotlight® on SQL Server...
January 28, 2008 11:56 PM
Posted by: Denny Cherry
Beta,
Cache,
CLR,
Config,
In Person Events,
Query tuning,
Resource Governor,
SQL,
SQL Server 2005,
SQL Server 2008,
SSMSThe SoCal Code Camp was this last weekend. I had a great time attending and speaking at the code camp this time around. I hope that everyone who attended my sessions had as much fun attending the sessions as I did speaking at them. I did my best to make them as much fun and interactive as I...
January 28, 2008 8:00 AM
Posted by: Denny Cherry
Installation,
SQL,
SQL Server 2000,
SQL Server 2005You can install SQL 2000 and SQL 2005 on the same machine. I always recommend that they be installed in this order to try and get everything working as best as possible.
- Install SQL 2000
- Install SQL 2005
- Install SQL 2000 SP4 (Or the latest service...
January 21, 2008 8:00 AM
Posted by: Denny Cherry
SQL,
VirtualizationVirtualizing servers is huge right now. And thanks to VMWare it is very easy to build virtual machines. In most of IT virtualizing servers is a good think. In the database world, that isn't always the case. As we know...
January 17, 2008 12:00 PM
Posted by: Denny Cherry
Article,
Bug,
SQL,
SQL Server 2005,
SupportI found this great little MS KB article today. It's got all the SQL Server 2005 post SP2 host fixes including bug numbers and descriptions of the bug. The MS KB article ID is 937137.
Denny
January 14, 2008 8:00 AM
Posted by: Denny Cherry
DR,
Log Shipping,
Replication,
SQL,
T/SQLMicrosoft's Log Shipping is pretty good. But it requires that you have SQL Server Enterprise Edition on both the machines. This makes the solution fairly expensive. Because of this I've written a replacement which can be used on any edition of SQL Server including SQL Server Express Edition...
