Network Computing - Is It Simply a Different Form of Client/Server?
New author! Dale discusses the differences between network computing and client server. Do you know where SQL fits into that? It's good reading, covers the topic at a high level.
SQL Agent Problem
Andy takes us through a recent troubleshooting session that includes a call to PSS. Ever run agent from the command line? Have a good idea of what justifies a call to PSS? Read this to learn more.
Example VSS Framework - Source Code Management - Part 1
We asked Chris to put together some information on how he uses VSS, a subject that comes up a lot as we have articles and discussions that involve change management. Change management isn't easy, you definitely need a pattern to work from. This two part article gives you a pattern you can start with and customize to your needs.
The Best of SQLServerCentral.com 2002 - We Did It!
The book is almost here! We've been working on it for months, now you can find out what it's going to look like, who the authors are, and how much it costs. It's been a lot of work but we think it's been worth it. Read the article to see how to save $3 off an already low price.
Microsoft SQL Server 2000 Weekend Crash Course
The big day is Monday. The day you get to show off what you know about SQL Server 2000. The problem is, you're not really up to speed. Maybe it's been a while since you worked with SQL Server. Or maybe you just like a challenge. Open the book Friday evening and by Sunday afternoon, after completing 30 fast, focused sessions, you'll be able to get right to work on a SQL Server 2000 databases.(Not Reviewed)
Stored Procedure Script Generation By Dependency
This article from Robbe Morris at EggheadCafe.com looks at how to generate a script for a stored procedure that includes all it's dependencies.
IIS 6 Map
Chris does a lot of work with IIS and based on that he put together this nice map showing how all the bits and pieces go together. No SQL here, but most of us deal with IIS so we thought it might be of interest.
Dealing with Addresses
David writes about the system he put together to handle addresses and the pros and cons of various techiques. Familiar with Soundex? He uses that too! Even though some of the info is specific to Great Britain, it's good reading. Addresses are one of the hardest pieces of information to handle!
SQL Server Upgrade Recommendations and Best Practices - Part 2
This article, Part 2 – SQL Server 6.5 to 2000 Critical Upgrade Decisions and Redundant Upgrade Architecture, will begin to detail the technical components faced by the DBAs and Developers during the Upgrade process. The technical components detail the Critical Upgrade Decisions related to ANSI NULLS, Quoted Identifiers and other items.
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers