They are a basic type of query that every DBA and developer should be able to write, but aggregates are sometimes misunderstood and result in strange behaviors and results. Kathi Kellenberger brings us a tutorial on what aggregate queries are and a few hints on how to become more proficient at writing them.
2007-10-02 (first published: 2005-12-19)
37,471 reads
The SQL Server 2000 security model is not the best one of all the RDBMS platforms and requires some work to secure properly. One of the practices that is recommended is removing the builtin/administrators group from accessing the SQL Server. New author Kathi Kellenberger shows us some of the pitfalls she encountered when removing this group from her servers.
2007-10-02 (first published: 2005-01-12)
30,122 reads
In SQL Server 2005, object ownership will have a different meaning, but since most of us work with SQL Server 2000, Kathi Kellenberger has written a good introduction to understanding how object ownership works and why you might want to follow certain practices.
2007-10-02 (first published: 2005-07-18)
54,913 reads
I work almost exclusively with third party applications. I don't get to do a lot of tuning except for reports...
2007-09-30
1,294 reads
We are trying to move to version 2 of our accounting data warehouse (more likely called a datamart), but it...
2007-09-25
1,601 reads
When I first got into IT full time 10 years ago, I noticed that my mind was constantly solving programming...
2007-09-25
1,282 reads
Somehow between the sessions, networking and socializing I never found time to post anything last week. So, I'm going to...
2007-09-23
1,335 reads
This was my 5th year at PASS and every year I enjoy catching up with old friends and meeting many...
2007-09-23
1,363 reads
SQL Server 2000 is the basis for the new Access database storage. However there are still many cases where applications developed on Access are outgrown and need to be moved to SQL Server to support the load. Author Kathi Kellenberger brings us a look at the Upsizing Wizard and how you can move your databases to SQL Server.
2007-09-22 (first published: 2005-02-22)
30,837 reads
I haven't posted much lately, but it has been a busy few months with many family activities. At work, I...
2007-07-09
448 reads
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Comments posted to this topic are about the item TempDB Facts I
Comments posted to this topic are about the item Have you done a Mid...
Can I set Accelerated Database Recovery on tempdb?
See possible answers