Steve Jones completed an online eLearning course with IMG University that provided an introduction to the OLAP / Analysis services available with SQL Server 2000. This article examines some of his impressions from this vendor.
2002-03-12
3,041 reads
LockwoodTech and SQLServerCentral.com have teamed up to give its members special discounts on Lockwood products. Discounts for SQLServerCentral.com members are more than 20% off. All for being a free member of SQLServerCentral.com!
2002-03-11
18 reads
This week Andy continues his series on how to reduce the number of round trips to the server by looking at some things you can easily add to your applications without a lot of rearchitecting.
2002-03-11
8,042 reads
myLittleTools is proud to announce the release of myLittleAdmin for SQL Server. With version 1.5a, myLittleAdmin etablishes itself as the best web-based database administration tool for ASP developers.
2002-03-11
3,250 reads
I found this on the Internet, but I think it's really my own personal list.
2002-03-08
2,633 reads
Middle tier applications often use a single database management system (DBMS) to store data, which can expose scaling limitations as the number of user requests increases. Caching, a technique used to increase application performance by copying data and then using the copied data in place of the original data, can dramatically increase the throughput (the number of application requests serviceable per unit time) and scalability of middle tier applications.
2002-03-08
2,221 reads
Robert Marda continues his series on dynamic SQL and shows you how to rewrite some queries that you may think need dynamic SQL.
2002-03-07
13,121 reads
DBEzze is a freeware product that can look into a database and generate XML structural or data output. It can also generate INSERT statements from a table, view or stored procedure. This freeware product is available for download from SQLServerCentral.com members only.
2002-03-06
102 reads
As I work with a particular topic or problem, I often research on the Internet
different opinions, white papers, etc. Here is a list of resources that are located both
on SQL Server Central and other sites that I have found useful.
2002-03-04
11,060 reads
Microsoft Corp. is considering bundling in the next version of Windows a pared-down version of its next-generation SQL Server database and the relational file system that goes with it.
2002-03-04
3,283 reads
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers