Computational Biologist
A job Steve Jones has never heard of is using data to improve medical treatments.
Converting to data-driven code
How converting extensive, repetitive code to a data-driven approach resolved a maintenance headache and helped identify bugs
Calculate the Statistical Mode in SQL Server using T-SQL
Next to the average and the median, there is another statistical value that you can calculate over a set: the mode. This is the value that appears the most often in the set. The average and the median are straight forward to calculate with T-SQL in SQL Server, but how can we determine the mode using T-SQL?
SQL Saturday #387 - Madison, WI
SQL Saturday is coming to Madison, Wisconsin on April 11th 2015. Join us for a free day of SQL Server training and networking and hear expert speakers like David Klee, Wendy Pastrick, and Jes Borland. Register while space is available.
Setting Different Colors for Connections in SSMS
Learn how to set colors for different connections in SSMS.
Defusing Database Time Bombs: Avoiding the Need to Refactor Databases
Where applications are evolved by gradually molding them to a growing understanding of the business domain, this presents great challenges to database development. If databases are designed too loosely, and initial errors are allowed to fester, the results become harder and harder to refactor until eventually they constitute a database time bomb. Thomas LeBlanc describes how to avoid a few basic, but very common, database time bombs.
Data Mining Part 26: Data Mining and Microsoft Azure
This article shows a step by step tutorial to create a virtual machine in 15 min on Windows Azure.
Azure Blob Storage Part 7: Snapshots
Robin Shahan introduces the concepts of snapshots in relation to Azure blob storage. She explains what they're for and how to take them, promote them, and delete them.
Database Continuous Integration workshop, Los Angeles
Redgate are hosting a 1-day public workshop on April 10th 2015 in Los Angeles, California. This workshop will teach you how to link your source control system to a build system, trigger database builds automatically, and lay the foundations for package-based deployments.
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