Introduction to DSN's
This article by Andy Warren is an introduction to DSN's; what they do, how they work, and where they are stored. Also pick up some ideas about how using a File DSN might save you a lot of administration!
This article by Andy Warren is an introduction to DSN's; what they do, how they work, and where they are stored. Also pick up some ideas about how using a File DSN might save you a lot of administration!
In SQL Server 2000, Microsoft has closed the gap between its multidimensional database offering, OLAP Services, and the rest of the market place.
The fourth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
Jon Winer talks about his adventures with Index Server and provides some hints to help you avoid some common problems.
Nothing is more annoying than having to disconnect users one by one. With this script, you will be able to quickly disconnect them with a few keystrokes.
The third part of Steve Jones's series on having SQL Server automatically report information to a DBA.
It is not always possible to run a process on a set schedule. This article by Steve Jones looks at a technique for ensuring that your processes can run on whenever you need them to without any loss of data.
The third part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with REPLACE.
The fourth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with numeric conversions.
By Arun Sirpal
I speak to many people who use cloud technologies, especially database tech and how...
I need to migrate from a single server to a flex server. Instead of...
By Steve Jones
An interesting AI experiment here with Copilot from GitHub in handling some code I...
Hi all We have setup History Cleanup tasks at clients to clear Maintenance plan...
Hey everyone! š Iām currently researching the best healthcare app development companies based in...
Hello , Consider the following - much simplified -Ā example of a conditional insert:...
What happens with this code:
DECLARE @Iteration INT = 0; WHILE @Iteration < 10 SELECT CustomerName, CustomerStatus FROM dbo.Customer WHERE CustomerID > 3; SET @Iteration += 1;See possible answers