Click here to monitor SSC
Jason Crease

Database Continuous Integration with SQL CI and Jenkins

Continuous Integration Continuous integration (CI) is the process of ensuring that all code and related resources in a development project are integrated regularly and tested by an automated build system. Code changes are checked into source control, triggering an automated build with unit tests and providing early feedback. Read more...

Phil Factor

The SQL of the Feast Days of Western Christendom

I've been intrigued for a long time by the Christian feasts. Nowadays, we start getting excited about Christmas around July, and it is considered by commerce to be fair-game as a de-walletizing activity from Halloween onwards. I would like far more feast days to get excited about. Read more...

Tony Davis

Issue Tracking Systems: Good Servant, Bad Master

Over time, many bug and issue tracking systems decline into a graveyard for bug-reports, a place where problems are buried rather than resolved. I’m not a developer but even so, any mention of bug-tracking systems elicits unhappy memories. Read more...

Robert Sheldon

The Logical Data Warehouse - Towards a Single View of All the Data

What is wrong with the Enterprise Data Warehouse? Quite a lot, it seems. By taking the narrow view that the struggle is that of accommodating and interrogating huge quantities of data, then initiatives such as the Virtual Data Warehouse and Logical Data Warehouse could make sense. But what about data quality, security, access control, archiving, retention, privacy and regulatory compliance? Read more...

Jon Smith

Deploying an Entity Framework database into production

Entity Framework can be useful for getting up and running quickly with a database application, but when it comes to deployment, EF’s built-in data migration feature doesn't inspire confidence. Jon Smith relates his quest to find a better answer. Read more...

Omid Afzalalghom

Doing a SQL Server Healthcheck via PowerShell

PowerShell is an ideal tool for doing health-checks of a collection of SQL Server instances, and there are several examples around, but few acknowledge the fact that individual DBAs have their own priorities for tests, and need something easily changed to suit circumstances. Omid's Healthcheck allows tests to be SQL or PowerShell and requires only adding, altering or deleting files in directories. Read more...

Edward Elliott

SQL Server Data Tools (SSDT) and Database References

SQL Server Data Tools (SSDT) provides, via the DacPac, interesting support for verifying not only those references within the database, but also those to other databases even if they are on other servers. Although it is adds an extra level of complexity to deployments, it can increase the probability that deployments will succeed without errors due to broken references or binding errors. Read more...

Michael Sorens

The Zen of Code Reviews: the Reviewer’s Tale

When you are reviewing your colleagues' code, it is a good idea to look closely at the unit tests to check that they match the requirements, test just one thing, and cover every branch in the main code. Do their names tell you what they test? Are they at the right level of complexity? Code reviews are about looking for patterns, absent or present. Read more...

Christos Matskas

Using SignalR to Create Mobile Applications

SignalR isn't just for web applications. It can also provide the basic real-time communications for a connected Windows Universal Application or even iOS and Android applications. Christos Matskas demonstrates how to get started with creating applicationsa cross a range of platforms that require real-time communication using SignalR Read more...

William Brewer

Questions About CUBE, ROLLUP and GROUPING SETs That You Were Too Shy to Ask

There are few parts of SQL Syntax as familiar as the GROUP BY clause of the SELECT statement. On the other hand, CUBE and ROLLUP remain mysterious despite their usefulness and GROUPING SET is positively arcane, especially if you are too shy to reveal your ignorance of the subject by asking! 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.