How many people are getting ready to upgrade to SQL Server 2005? Why are they upgrading? Why not? Edgewood Solutions conducted a survey and the results are in. Read on for the executive overview and learn how to get a complete copy of the results.
2005-11-02
5,273 reads
We all know testing is important, but face it, testing is not the highlight of anyone's daily work. And more important than testing your code the first time is regression testing after you have fixed a few bugs. Kristian Wedberg brings us a new article that uses SSIS to build a harness that allows repeatable testing of code and applying benchmarks to be sure that things are working as expected.
2005-11-02
8,251 reads
The problems caused by the SQL Sapphire Worm, also know as the SQL Slammer, have caused many sites to do a quick upgrade to SQL Server 2000 Service Pack 3 (SP3). It includes the fix that prevents infection by the worm. While moving to the latest service pack is usually a good thing, to do so without thorough testing risks breaking a working application. That is exactly what happened to one of my clients over the weekend.
2005-11-02
2,068 reads
Take this survey for a chance at a $20 gift certificate from Amazon. Give your reasons to upgrade and your insight on performance issues.
2005-11-01
4,569 reads
Having a good tool to read your SQL Server transaction log can be a lifesaver, or a job saver. RegGate Software, maker of a number of useful SQL Server utilities has a log reader and Grany Fritchey takes a look at this product and how it might work in your environment.
2005-11-01
10,421 reads
How often do you check your SQL Server tables for fragmentation? How often do you defragment them? This is one of those technologies that has been available for disks for a long time, but now is here for SQL Server. Norb Technologies is offering a discount to the SQLServerCentral.com community on this product.
2005-11-01
4,110 reads
One of the lesser used features of SQL Server is the ability to access the functionality in various DLLs using a COM interface. Dinesh Asanka brings us a basic article with a few examples in how you can work with COM components from inside SQL Server 2000.
2005-10-31
12,524 reads
You can just hear it now: At the table down the hall, there’s a group of people having, (as it seems to you) yet another academic discussion on the merits of third-normal form and the structure of primary keys. You’ve heard many discussions like this before — it all seems so pointless. After all, doesn’t it just boil down to “create table” commands and a bunch of DDL? You mastered all that in your first DBA class. What could be so hard?
2005-10-31
3,688 reads
Building a highly available system is hard. This short white paper from Sonasoft shows some of the differences between a cluster and their standby server product.
2005-10-28
10,571 reads
SQL Server 2000 had extensions built in to allow you to work with XML data, however, most installations did not work with it. XML has proven that it is a very powerful way of transmitting and working with data, but creating it from relational data has proven to be difficult. New author Hugh Lynch, CTO of Restricted Stock Systems, Inc. brin gs us a method for easily creating XML from your SQL Servers.
2005-10-27
10,483 reads
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Comments posted to this topic are about the item What is Page Density
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Looking to confirm my understanding of these three products and how they can be...
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers