SQL Server Professionals Survey – Win $50 Amazon voucher!
Take part in a simple 5-minute survey for SQL Server Professionals and win one of two $50 Amazon vouchers.
Field Level Auditing using Change Data Capture – Part 2
Second part of two part article on Change Data Capture for field level auditing and marting that data using SSIS for reports. I uploaded the entire Word document that includes the images.
Real Time Dangers
Steve Jones notes that our expert systems might not handle every situation well, and the quest to move towards more real time decision making can involve dangers if a human is not in the loop.
Script to calculate the Median value for SQL Server data
The standard SQL language has a number of aggregate functions like: SUM, MIN, MAX, AVG, but a common statistics function that SQL Server does not have is a built-in aggregate function for median. The median is the value that falls in the middle of a sorted resultset with equal parts that are smaller and equal parts that are greater. Since there is no built-in implementation for the median, the following is a simple solution I put together to find the median.
Going Green in Software Development
Today Steve Jones talks about the impact of better software programming on the energy use in your company's data center.
Never offend a captive audience
Write what you choose to when the reader can, in turn, choose not to read your work; but when you are writing about Technology, you have a captive audience. They need to read your work to keep abreast of the technology. Don't gratuitously offend them. It is not the action of a gentleman, D____it!
Quick and Dirty DR Solution Using Robocopy
This article covers how to use robocopy with SQL Server Agent to copy database backup files to another server.
Extracting and Loading SharePoint Data in SQL Server Integration Services
The SharePoint List Source and Destination Sample available on Codeplex provides an optimized solution with an easy-to-use interface for getting data out of or into a SharePoint list. The sample also includes an API for accomplishing these tasks efficiently outside of SQL Server Integration Services.
ETL
Today we have an editorial that was originally published on Aug 31, 2006 as Steve is traveling at DevConnections. It still seems relevant, so answer the poll this week.
Blogs
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...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
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
Everything is the right question away
Comments posted to this topic are about the item Everything is the right question...
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