SQL Consulting: SQL Server Is Our Only Business.
posted on
Internal fragmentation in a database log file is a frequently overlooked cause of poor performance in a SQL Server database. It is simple to find out if you have this problem. Run this command in a …
Continue Reading about Log File Fragmentation A hidden cause of poor performance →
posted on
Are There Reasons for You to Upgrade? Microsoft is cranking out the publicity for its new Release 2 of SQL Server 2008, currently scheduled for May. If they weren’t charging for it we might be …
posted on
The cost of a SQL Server license is a tremendous bargain when you consider all the different products included with the database engine itself. With other enterprise database platforms, features like …
posted on
There are conversations that every DBA wants to avoid. They often begin like this: “The data disk on the SQL Server crashed last night. The database backups have apparently been failing for several …
posted on
When Microsoft released Service Broker with SQL Server 2005 a lot of users quickly found uses for a simple, asynchronous messaging system within SQL Server. But with all of the new features …
Continue Reading about What Can Service Broker Do For You? →
posted on
It costs a lot of money to own and operate a relational database platform. Wouldn't it be nice to be free of that trouble and expense? What if your users could just ask for the data they want and …