Phil Factor PowerShell SMO: Just Writing Things Once Sometimes, you can tire of writing the same PowerShell code once again. After this happened to Phil whilst keying in... 19 July 2012 26 min read
Warwick Rudd Encrypting Your SQL Server 2012 AlwaysOn Availability Databases It is likely that you'll want to add a database with TDS Encryption to your AlwaysOn Availability Group. If you... 04 July 2012 8 min read
Phil Factor Handling Constraint Violations and Errors in SQL Server The database developer can, of course, throw all errors back to the application developer to deal with, but this is... 29 June 2012 27 min read
Annette Allen SSIS Basics: Adding Data Flow to Your Package Annette continues her popular series for SSIS beginners by showing how a data flow task can be used in a... 12 June 2012 16 min read
Alex Kuznetsov Developing Low-Maintenance Databases Alex's team of developers are geared to doing rapid development of database applications in a busy corporate setting, yet take... 12 June 2012 21 min read
Peter Larsson The Road to Professional Database Development: Database Normalization Not only is the process of normalisation valuable for increasing data quality and simplifying the process of modifying data, but... 07 June 2012 27 min read
Annette Allen SSIS Basics: Setting Up Your Initial Package When working with databases, the use of SQL Server Integration Services (SSIS) is a skill that often needs to be... 21 May 2012 19 min read
Joe Celko SQL VIEW Basics SQL Views are essential for the database developer. However, it is common to see them misused, or neglected. Joe Celko... 10 May 2012 19 min read
Timothy Wiseman SQL Scripts Manager and IronPython As well as running TSQL and PowerShell, the free SQL Scripts Manager tool can also run Python scripts. This allows... 04 May 2012 10 min read
Bud Aaron How to set up a database-driven Azure site So how easy is it to set up a database-driven application on Azure, using the tools that one is familar... 26 April 2012 12 min read
Richard Morris No More Disconnected SQL Development in Visual Studio Some types of development work are much more effectively accomplished if the developer can work directly on SQL Server Databases... 12 April 2012 7 min read
Jeremy Jarrell MongoDB Basics for .NET by Example MongoDB is one of the more intriguing 'NoSQL' databases to emerge from 'Cloud' computing. Sometimes, the best way of understanding... 26 March 2012 11 min read
Phil Factor Generating Data for Database Tests It is more and more essential for developers to work on development databases that have realistic data in both type... 08 March 2012 22 min read
Richard Morris Glenn Berry: DBA of the Day Glenn Berry works as a Database Architect at Avalara in Bainbridge Island, Washington. He is a SQL Server MVP, and... 23 February 2012 11 min read
Peter Larsson The Road to Professional Database Development: Set-Based Thinking Under the pseudonym of 'SwePeso', Peter Larsson is famous on SQL forums for the amazing performance he can get from... 21 February 2012 7 min read
Phil Factor Automated Script-generation with Powershell and SMO In the first of a series of articles on automating the process of building, modifying and copying SQL Server databases,... 03 February 2012 24 min read
Dave Green Using SQL Test Database Unit Testing with TeamCity Continuous Integration With database applications, the process of test and integration can be frustratingly slow because so much of it is based... 02 February 2012 22 min read
Brad McGehee How to Document and Configure SQL Server Instance Settings Occasionally, when you install identical databases on two different SQL Server instances, they will behave in surprisingly different ways. Why?... 30 January 2012 74 min read
Rob Garrison What’s the Point of Using VARCHAR(n) Anymore? The arrival of the (MAX) data types in SQL Server 2005 were one of the most popular feature for the... 30 January 2012 11 min read
Grant Fritchey SQL Cop Review Static code analysis is used a lot by application programmers, but there have been surprisingly few tools for SQL development... 19 January 2012 7 min read
