If your shop is even close to the typical Microsoft SQL Server environment there are several people that can make changes to the production environment and what's in SourceSafe does not match what's on the SQL Server. This freeware by Bill Wunder will make archiving DDL and DTS packages a piece of cake and simplify deployment of SQL Server code. Available exclusivily for SQLServerCentral.com members.
2003-07-17
849 reads
As you might guess from the title, this is an extended stored procedure that you can use to interact with MSMQ. It's supposed to be extremely fast, able to handle 4-5k messages per second and have a very small memory footprint. (Press Release)
2003-07-17
1,310 reads
In part two of this article Chris explains how to handle some common issues you'll run into while using version control and how to manage the process. Defintely read part one first if you haven't already.
2003-07-16
4,805 reads
New author! Tom publishes his first article with us by writing about how business intelligence and data warehouses work together at a high level. Interesting stuff.
2003-07-15
9,327 reads
At Last! No need to convert SQL Scripts from one dialect to another. Although SQL is a simple language, it can be tedious, inaccurate and frustrating when developing equivalent SQL scripts for multiple database servers. This product handles the conversion for you. (Not Reviewed)
2003-07-15
804 reads
Hopefully you've heard by now that we're publishing a book consisting of our best content from 2002. Sign up for the book is going well, but we could still use a few more. This update answers some of the questions we've received so far.
2003-07-14
4,210 reads
Dinesh is back with another article on user defined functions, giving some more great examples. If you haven't read the first one, definitely go back and read it first.
2003-07-14
7,097 reads
Need more templates for Proc Blaster? LockwoodTech Software has partnered with Harjai Software Consultants to develop templates for Proc-Blaster, a development tool for ASP Code Generation.
2003-07-14
825 reads
So how many servers do you have in your environment? In this review of AppDetective by Brian Knight, he shows you how AppDetective helped him find SQL Servers he didn't even know about in his environment.
2003-07-11
4,743 reads
Here, in one definitive volume, is all the information you need to understand and use SQL and its implementations in accordance with the established SQL99 standard. Whether you want to learn database programming from scratch, you’d like to sharpen your SQL skills, or you need to know more about programming for a heterogeneous database environment, this book provides the complete menu. (Not Reviewed)
2003-07-11
948 reads
I am excited to host T-SQL Tuesday for the first time. I want to...
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Comments posted to this topic are about the item Measuring Productivity
Comments posted to this topic are about the item Importing Excel files into SQL...
Comments posted to this topic are about the item Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers