Andrew Clarke SSMS: The Query Window Keyboard Shortcuts Simple-Talk's free wallchart of the most important SSMS keyboard shortcuts aims to help find all those curiously forgettable key combinations... 10 June 2011 5 min read
Louis Davidson What Counts for A DBA – Logic “There are 10 kinds of people in the world. Those who will always wonder why there are only two items... 09 June 2011 4 min read
Joe Celko A Tale of Identifiers Identifiers aren't locators, and they aren't pointers or links either. They are a logical concept in a relational database, and,... 09 June 2011 14 min read
Phil Factor Sitting Pretty Guest Editorial for Simple-Talk IT Pro newsletter ‘DBAs and SysAdmins generally prefer an expression of calmness under adversity. It is... 08 June 2011 4 min read
Michael Sorens Harnessing PowerShell’s String Comparison and List-Filtering Features When you are first learning PowerShell, it often seems to be an 'Alice through the looking-glass' world. Just the simple... 07 June 2011 4 min read
Johan Veldhuis Migrating from OCS 2007 R2 to Lync: Part 2 In the story so far, Johan has described how to check that the migration from your OCS to Lync is... 07 June 2011 13 min read
Louis Davidson See you in Columbus Saturday? Assuming all goes as planned, I will be in Columbus, OH this Friday night and Saturday for SQL Saturday 75.... 06 June 2011 3 min read
Simon Cooper Anatomy of a .NET Assembly – Custom attribute encoding In my previous post, I covered how field, method, and other types of signatures are encoded in a .NET assembly.... 03 June 2011 7 min read
Rebecca Amos Got that Friday feeling? Saturday is just around the corner, and we’re all starting to wrap up for the weekend. If you’re the DBA... 03 June 2011 2 min read
Laila Lotfi Windows 8 and the future of Silverlight After Steve Ballmer’s indiscrete ‘MisSpeak’ about Windows 8, there has been a lot of speculation about the new operating system.... 03 June 2011 3 min read
Peter Raganitsch Multi-Language database applications using Oracle Apex It isn't straightforward to design a database application that has to provide text data in several languages. There are several... 03 June 2011 12 min read
Simon Cooper Inside Red Gate – Project teams Within each division in Red Gate, development effort is structured around one or more project teams; currently, each division contains... 02 June 2011 5 min read
Simon Cooper Inside Red Gate – Divisions When I joined Red Gate back in 2007, there were around 80 people in the company. Now, around 3 years... 01 June 2011 3 min read
Simon Cooper Inside Red Gate – Introduction I work for Red Gate Software, a software company based in Cambridge, UK. In this series of posts, I’ll be... 31 May 2011 2 min read
Rebecca Amos Exceptional DBA Awards 2011 From today, we’re accepting nominations for the 2011 Exceptional DBA Awards. DBAs make a vital contribution to the running of... 31 May 2011 2 min read
Louis Davidson Normalization and How to Know When You Are Done… The short version… A while back, I was working on a short article about Normalization for a book that never got published (admittedly... 29 May 2011 9 min read
Simon Cooper Anatomy of a .NET Assembly – Signature encodings If you’ve just joined this series, I highly recommend you read the previous posts in this series, starting here, or... 27 May 2011 4 min read
Robert Sheldon Subqueries in SQL Server Subqueries and derived tables can add great versatility to SQL statements, cut down complexity, but can occasionally be a curse... 26 May 2011 16 min read
Grant Fritchey SQL Server Backup and Restore for the Accidental DBA Not everyone who is tasked with the job of ensuring that databases are backed up, and easily restorable, consider themselves... 24 May 2011 15 min read
Database DevOps Troy Hunt in Database DevOps The 10 Commandments of Good Source Control Management Simple-Talk generally doesn't re-publish anything from another site, but Troy's popular blog post on the Ten Commandments of Source Control... 23 May 2011 19 min read