Click here to monitor SSC
Phil Factor

Silos and Monoliths – Moving On to the Past

The presenter positively glowed with enthusiasm as she showed us how easily the schemas collections of documents in MongoDB could follow the changes in the way you structure the data in your application. I was at an interesting presentation recently of MongoDB with .NET. The presenter explained, brightly, that using MongoDB was a liberating experience[…] Read more...

Dino Esposito

Handling Errors Effectively in ASP.NET MVC

ASP.NET MVC gives you more options in the way that you handle exceptions. Error handling isn't intrinsically exciting, but there are many ways of avoiding the classic yellow page of death, even getting ELMAH to manage error handling for you. Read more...

Simple-Talk Editorial Team

Monitoring SQL Server: An Interview with David Bick

Simple-Talk sat down with David Bick, a Red Gate Product Manager, to discuss his work on SQL Monitor and why passively monitoring SQL Server just doesn’t cut it anymore. Read more...

Joe Celko

Database Normalization Basics

The task of Database Normalization doesn't have to be painful, especially if you follow Old Mother Celko's Normalization Heuristics. Read more...

Michael Williamson

Moving from Practice to Production with Test-Driven Development

Test-driven development is often taught using simple examples, such as calculating the scores for a game of ten-pin bowling. Using the same practice effectively on a real code base isn’t as easy. This article covers some of the questions that arise when dealing with larger code bases and changing requirements. Read more...

Michael Sorens

PowerShell One-Liners: Help, Syntax, Display and Files

PowerShell is designed to be used by busy IT professionals who want to get things done, and don't necessarily enjoy programming. PowerShell tackles this paradox by providing its own help and command-line intellisense. We aim to make it a bit easier still by providing a series of collections of general-purpose one-liners to cover most of what you'll need to get useful scripting done. Read more...

Grant Fritchey

The DBA Detective: Disturbing Developments

Originally one of the articles in the first DBA Team series, Grant wonders what Raymond Chandler or Dashiell Hammett would have done if asked to write technical articles for Simple-Talk. He came up with the DBA detective, hard-boiled Joe Dee Beay Read more...

Robert Sheldon

14 SQL Server Indexing Questions You Were Too Shy To Ask

One of the first things one needs to understand well about SQL Server is indexes, but somehow many of the basic questions don't often get asked or answered much on forums. Rob Sheldon answers some of these shy-making questions about SQL Server Indexes and indexing: the ones we somehow feel silly asking in public, and think twice about doing so. Read more...

Matt Wrock

Automate the Complete Windows Environment Setup and Configuration

Boxstarter is an open-source application that enables you to do the unattended install of everything required to turn bare metal, Azure VM or Hyper-V VM into a working Windows Server. It is built on top of Chocolatey, Nuget, and PowerShell to make the repeated installation of windows-based machines into an automated error-free process. Matt Wrock, Boxstarter's creator, explains how to use it. Read more...

Robyn Page

Simple-Talk SQL Server Backup Crib Sheet

Robyn Page's crib sheet was a Simple-Talk classic, providing a terse but thorough roadmap of all of the important SQL Server backup-related considerations. It returns, newly revised to bring it up to date with SQL Server 2014 Read more...