Grant Fritchey asks you to experiment, to make an effort, to just try it.

Calculate the Statistical Mode in SQL Server using T-SQL

by Additional Articles

MSSQLTips.com

Statistical Analysis (mathematics)

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

by Press Release

SQL Saturday

Events

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

by Peter Schott

SQLServerCentral.com

Management Studio (SSMS)

Learn how to set colors for different connections in SSMS.

Defusing Database Time Bombs: Avoiding the Need to Refactor Databases

by Additional Articles

SimpleTalk

Database Design

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

by Daniel Calbimonte

SQLServerCentral.com

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

by Additional Articles

Just Azure

BLOB Storage

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

by Press Release

Redgate

Events

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.

Stairway to SQLCLR Level 5: Development (Using .NET within SQL Server)

by Solomon Rutzky

SQLServerCentral.com

This time we take a look at various aspects and limitations of working with SQL Server's CLR that affect what can be done and how to do certain things.