Tools Grant Fritchey in Tools SSMS Tools Pack 2.0 If you work with SSMS, you'll know how frustrating it can be when tasks you perform every day aren't part... 26 October 2011 12 min read
Richard Morris Geek of the Week: Linus Torvalds For Windows programmers, Linus Torvalds work has suddenly become relevant. No, we don't mean Linux, but Git. This distributed Source... 17 October 2011 15 min read
Grant Fritchey Auditing DDL Changes in SQL Server databases Even where Source Control isn't being used by developers, it is still possible to automate the process of tracking the... 12 October 2011 17 min read
Dino Esposito Never Mind the Controller, Here is the Orchestrator The Model-View-Controller pattern of the ASP.NET MVC allows the separation of the business logic from the input and presentation logic.... 11 October 2011 11 min read
Learn SQL Server Chris Shaw in Learn SQL Server Building Your DBA Skillset As a DBA and hiring manager, Chris Shaw has been on those sides of the recruitement process. As an MVP... 06 July 2011 23 min read
Robert Sheldon Table Value Constructors in SQL Server 2008 Table Value Constructors (TVCs) are a useful feature of 2008, allowing you to specify tables of values and expressions. This... 22 June 2011 11 min read
Alex Kuznetsov Yet Another SQL Strategy for Versioned Data There is a popular design for a database that requires a built-in audit-trail of amendments and additions, where data is... 22 June 2011 11 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
Wesley David Be the Puppet Master! Control Multiple PCs with one Keyboard and Mouse In the average IT department, geek-credibility is bound up with the number of monitors you are simultaneously using. What about... 20 May 2011 10 min read
David Berry Performance Implications of Parameterized Queries Why don't we emphasize the huge advantages of parameterized queries over ad-hoc queries in SQL Server? There is a severe... 28 April 2011 19 min read
John O'Neill, SourceGear Life After Retirement: Replacing Visual SourceSafe Source control systems aren't exciting, and they don't come less exciting than Visual SourceSafe. Developers continue to use it but... 31 March 2011 12 min read
Troy Hunt The unnecessary evil of the shared development database One of the greatest pain-points in developing a database-driven application happens when the application is in source control,but the database... 23 March 2011 16 min read
Johan Veldhuis A look at Microsoft Lync 2010 Lync manages office communications such as voice calls, video calls, instant messages, meetings, and shared whiteboard sessions all from a... 22 March 2011 12 min read
Grant Fritchey SQL Strategies for ‘Versioned’ Data If you keep your data according to its version number, but need to work only with a particular version, what... 17 March 2011 17 min read
Jonathan Medd An Introduction to PowerShell Modules For PowerShell to provide specialised scripting, especially for administering server technologies, it can have the range of Cmdlets available to... 11 March 2011 15 min read
Joydip Kanjilal EntityDataSource Control Basics The Entity Framework can be easily used to create websites based on ASP.NET. The EntityDataSource control, which is one of... 03 March 2011 8 min read
Grant Fritchey Change Management and Source Control So, given the many good reasons for using Version Control systems for managing the changes in database applications, how does... 03 March 2011 47 min read
Troy Hunt Continuous Integration for SQL Server Databases When it comes to the subject of putting databases into source control, Troy Hunt is no shrinking violet. "Database source... 01 March 2011 28 min read
Brad McGehee Correlating SQL Server Profiler with Performance Monitor Both Performance Monitor and SQL Server Profiler provide valuable information about your server. However, if you combine the data from... 16 February 2011 24 min read
Greg Larsen Which of Your Stored Procedures are Using the Most Resources? Dynamic Management Views and Functions aren't always easy to understand. However, they are the easiest way of finding out which... 11 January 2011 9 min read
