Click here to monitor SSC
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...

Matt Milner

Azure BizTalk Services: Monitoring and Managing BizTalk Services Solutions

Once you've built your BizTalk solution, you will need to deploy and monitor it. Matt Milner shows that, while there are several ways to monitor your solution, and manual deployment via Visual Studio, the automated deployment of BizTalk solutions is probably best served by Azure IaaS with BizTalk Server virtual machines. Read more...

Grant Fritchey

Using SQL Prompt to Accelerate the Top 10 Most Common Database Scripts

There may be some people who enjoy repetitive typing, but Grant Fritchey doesn't. He's always preferred SQL Prompt. The standard snippets suit developers fine but aren't so DBA-oriented, so he set about asking the SQLServerCentral community what they typed in the most, and set about producing a set of DBA snippets with the results. 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.