Where Do I Want To Go Today? - Upsert
Where should SQL Server go in the future? What enhancements are needed? Steve Jones starts to explore his wish list for future versions of SQL Server.
Finding and Deleting Duplicate Data
Bad data is almost a given, but true duplicate data can really cause you some headaches. How do you remove all the duplicates and still leave a 'keeper' record? If you think procedural code it's not too hard, but can you do a set based solution? Chris shows you show!
Database Server Clash Revisited (Eweek)
This is a follow up article on the database comparison they did about 18 months ago.
Creating a Chart From a Table
New author! This article has a stored procedure that will generate an HTML document - as long as the table has the proper schema. If you try it, be sure to download the associated zip which has some images and the script for the stored procedure.
The SQL Delete Statement
New Author! Narayana has some ideas on the delete statement and how you can have a fall back plan if something goes wrong.
Replacing BCP with SQLBulkLoad
New Author! Stephan writes about why he thinks the bulk load capabilities added in the SQLXML3 addition are a great way to handle imports - maybe so good that you'll stop using BCP.
Review: EditPlus
Everyone uses a text editor. Whether for programming, editing configuration files, or reviewing logs. Here's a look at an inexpensive replacement for notepad that performs a number of functions that DBAs might be interested in having.
Freeware : DDL Source Safe Archive Utility
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.
MSMQ Extended Stored Procedures For SQL Server
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)
Example VSS Framework - Source Code Management - Part 2
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.
Blogs
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
The Book of Redgate: What Our Staff Says
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Forums
Website Stability 2025/12/05
All week we've had issues with the site being up and down. There's been...
403 Forbidden
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
Question of the Day
Fabric Mirroring
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers