Review: Professional SQL Server 2000 XML
Professional SQL Server 2000 XML - Find out if this book from Wrox is as interesting as it sounds.
Connection Pooling with Microsoft SQL Server 2000 Analysis Services
This white paper describes how to use the connection pooling objects included with the Microsoft XML for Analysis Provider to develop scalable client and Web applications for Microsoft SQL Server 2000 Analysis Services. (11 printed pages)
An Alternative to Windows NT
Left over from the Y2K fiasco, but a good corporate memo that might still be useful as an alternative to XP.
Death of the Production DBA
If you see a priest outside your cubical, beware! He could be trying to read you your last rites. If he hasn't showed up yet, don't worry, he'll be over shortly because the production DBA is dead or will be shortly.
SQL Server Database Coding Conventions and Best Practices
Learn the key basics of writing quality Transact-SQL code.
Measure for Measure
Do OLAP tools shortchange users with time-varying data? This article by Seth Grimes looks at some of the problems with OLAP tools.
What is OLAP?
An interesting question and one that The OLAP Report attempts to answer. This article is an analysis of what the increasingly misused OLAP term is supposed to mean.
Reattaching Databases - Some Code AND a Contest!
Attaching and detaching databases isn't rocket science, but if you have a lot of databases to attach it's pretty boring. Andy has written some VB code that uses SQL-DMO to speed up the process. But DMO isn't the only way - can you write a TSQL script to do the same thing? Fame and fortune await!
Blogs
T-SQL Tuesday #155 –The Dynamic Code Invitation
By Steve Jones
Apologies for the late invitation. A minor snafu has me hosting again. This is...
Daily Coping 6 Oct 2022
By Steve Jones
Today’s coping tip is to remind yourself that you are enough just as you...
What you can do is based on more than your direct permissions.
What you have access to is not just what you have direct permissions to....
Forums
Problem extracting Data from JSON string
Hi there I have a JSON sample and struggling to extract data from it....
I must be loosing my mind. Odd data issue
I have a guest table on two servers. Call them prod1 and prod2. The...
Ask SSC