Uses For Derived Tables
In this article by Robert Marda, he shows you how to use derived tables to solve some of SQL's problems.
A Grain of Salt
At a recent seminar, Steve Jones heard a quote that really struck home. Especially in the computer business. Read on about a look at a DBAs take on listening to what you hear and being a little cautious in how you interpret it.
Snapshot Replication for the Beginner - Part 2
This article covers how to build the snapshot subscription without getting bogged down in too many low level details. You'll learn enough here to get started experimenting and get results. Depending on comments from you, we may ask Andy to move on to transactional replication or to dig deeper into snapshot options. Tell us what you think!
SQL Injection!
Do your developers really understand how to prevent injection attacks? Or scarier still, how many know what an injection attack is? Chris has some great examples of how sql injection works and how to prevent it.
From the soapbox: Does anyone know what disaster recovery is?
New Author! Written as a rant, this article covers a couple basic issues that STILL tend to get overlooked in a lot of places. It's run to rant sometimes but we plan to maintain our focus and continue to keep these a small percentage of our content. Let us know what you think.
Snapshot Replication for the Beginner
Andy continues writing about replication, this week discussing the many options available when creating a snapshot publication. As we noted on his last article, this one may take longer than usual to load due the large number of images but we think the readability of having it all one page is worth while.
The DBA Code of Ethics
What code governs how a DBA acts? What is the framework for DBA ethics? There have been numerous articles on what the DBA job entails, the daily tasks and responsibilities. This article looks at the larger picture of principles which a DBA can use..
QA Lite - .Net Version of Query Analyzer
A free product from RAC4SQL, if you need something a little different maybe this will help. (Note: We're looking for a review of this, if you're using it drop us a note)
Asynchrous Execution with C#
Definitely not a beginner article, this one describes how to asynchronous execution using delegates in C# (C Sharp). Async is usually harder to implement - conceptually at least - but offers benefits in that the user/application isn't blocked while you wait on results.
Permissions on System Tables Granted to Logins Due to the Public Role
Many of you know that Brian Kelley is our resident security guy. If you didn't, this might prove it! There is a ton of information in this 63 page document worth reading. Let us know what you think.
Blogs
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
Forums
String_agg not working as needed
I'm trying to get this string_agg to put all the 'comments' into one result...
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers