Click here to monitor SSC
Tony Davis

A Database to Diagram For

I occasionally need to build a very simple database model, no more than a small handful of tables, to test out some code for an article or presentation. The other day, I was indulging in my usual habit of slowly tapping out CREATE and ALTER TABLE statements in SQL, when a colleague politely alerted me to the error of my ways, as he often does. Read more...

Richard Morris

Clive Sinclair: Geek of the Week

Although most of the geeks of the IT industry are famous for their software, it was the geeky entrepreneurs that changed society by bringing cheap microcomputers to the market. Sir Clive Sinclair is most famous for applying his background in electronic engineering to provide a whole generation, both in America and Europe, with their first taste of programming. Read more...

Enrico van de Laar

The SQL Server 2016 Query Store: Accessing Query Store Information Using DMVs

The SQL Server 2016 Query Store provides several new ways of troubleshooting queries, studying their plans, exploring their context settings, and checking their performance metrics. In using the Query Store to ensure that performance is as good as possible, it isn't long before it becomes important to be familiar with the DMVs that are associated with the query store, and using them in custom queries. Read more...

Robert Sheldon

SQL Server System Views: The Basics

When maintaining or refactoring an unfamiliar database, you'll need a fast way to uncover all sorts of facts about the database, its tables, columns keys and indexes. SQL Server's plethora of system catalog views, INFORMATION_SCHEMA views, and dynamic management views contain all the metadata you need. Read more...

Phil Factor

De-duplicating Delimited Lists in SQL Server

A recent article comes up with the interesting problem of removing duplicates from lists of strings. It turns out that there are several ways of doing this, and the best way to do it depends on your requirements. Is it possible to find a technique that is neat, versatile, and performs well? Read more...

Laerte Junior

The PoSh DBA - Towards the Re-usable PowerShell Script

When starting out with PowerShell, it is hard to escape from the detail to work out the best strategy for creating scripts. Laerte explains how, when and why it pays to think in terms of versatile functions to meet varying demands. Read more...

Dino Esposito

Common Aspects of ASP.NET Code: in Web Forms and MVC

Is it time to abandon the use of Web Forms in favour of controller methods in ASP.NET MVC? As always, the answer is 'it depends', but it is certainly a good time to make sure that your skills-set includes the use of controller methods and understanding the software design principles behind MVC. Dino Esposito explains why. Read more...

Casimir Saternos

Data Manipulation in R: Beyond SQL

Although SQL is an obvious choice for retrieving the data for analysis, it strays outside it's comfort zone when dealing with pivots and matrix manipulations. R includes a number of packages that can do these simply. By combining the two, you can prepare your data for analysis or visualisation in R more efficiently. Read more...

Christos Matskas

Application Security with Azure Key Vault

The name 'Azure Key Vault' hides a valuable Azure service that allows us to easily protect our Cloud data by putting sound cryptography in Cloud applications without having to store or manage the keys or secrets. This makes it far easier to manage cloud data in applications in a way that that complies with industry-standards for sensitive data. Read more...

Joe Celko

Declarative SQL: Using CHECK() & DEFAULT

SQL is unusual is that data is not passively stored. Instead you use declarative SQL to specify the rules that underlie the data and its integrity. When used properly, constraints can avoid having to provide a lot of logic elsewhere. CHECK() and DEFAULT can do a lot to ensure that your data is correct Read more...

Simple-Talk Database Delivery

Patterns & Practices Library

Visit our patterns and practices library to learn more about database lifecycle management.

Find out how to automate the process of building, testing and deploying your database changes to reduce risk and make rapid releases possible.

Get started

Why Join

Over 400,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.