Joe Celko Declarative SQL: Using UNIQUE Constraints In SQL, you can express the logic of what you want to accomplish without spelling out the details of how... 04 December 2015 14 min read
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... 17 November 2015 23 min read
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,... 16 November 2015 12 min read
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... 04 November 2015 8 min read
Peter Gerrard Jodie Beay and the Deployment of the Cross-Database Dependency When you use AdventureWorks as a practice database, have you ever looked at the code and thought 'what idiot did... 03 November 2015 13 min read
Sjors Takes Implementing Continuous Integration for Databases Continuous integration (CI) is becoming more and more common in application development. It ensures code and related resources are integrated... 02 November 2015 8 min read
Grant Fritchey Top 10 Most Common Database Scripts What are the scripts that a working DBA uses so often that they become part of the 'muscle memory'? Grant... 15 October 2015 14 min read
Doris Robinson Testing and the Application Lifecycle In application or database development, testing is too often given secondary importance. There are advantages to the whole delivery process... 07 October 2015 19 min read
Laerte Junior Automating Your SQL Server Best Practice Reports:The Checks A DBA in charge of a whole lot of databases and servers has to check regularly that there are no... 06 October 2015 13 min read
Artemakis Artemiou Introducing SQL Server In-Memory OLTP In-Memory OLTP, aka Hekaton, originally shipped with 2014, and although it certainly helped the performance of certain types of workload,... 30 September 2015 10 min read
Adam Aspin SQLXML Bulk Loader: The Sequel SQLXML isn't exactly new technology, and parts of it aren't pretty, but if you need to heave vast quantities of... 25 September 2015 24 min read
Phil Factor Dependencies and References in SQL Server It is important for developers and DBAs to be able to determine the interdependencies of any database object. Perhaps you... 24 September 2015 20 min read
Casimir Saternos SQL and R Not only can you easily retrieve data from SQL Sources for analysis and visualisation in R, but you can also... 18 September 2015 17 min read
Jason Crease Writing Build vNext tasks for Visual Studio Online Hosted TFS, now called Visual Studio Online (VSO), has a new way of writing build processes called Build vNext. Agent... 09 September 2015 9 min read
Frazier Kendrick Stumbling Towards Database Change Management The scale of change in the insurance and financial markets is such that there is little time for the application... 09 September 2015 22 min read
Dwain Camps How to Avoid Conditional JOINs in T-SQL Relational databases go out of their way to execute SQL, however bad the crimes against Codd and relational theory within... 07 September 2015 14 min read
Robert Sheldon Working with SQL Server data in Power BI Desktop What's the best way of providing self-service business intelligence (BI) to data that is held in on-premise SQL Server? Not,... 24 August 2015 24 min read
Edward Elliott Non-Breaking Online Database Deployments For an experienced database developer, the idea of doing non-breaking database deployments while the database is still online holds respect... 21 July 2015 11 min read
Adam Aspin SQLXML Bulk Loader Basics SQLXML isn't exactly new technology, but like the even more venerable BCP, it remains the quickest and most reliable way... 02 June 2015 26 min read
Alex Kuznetsov Reusing T-SQL Code Database programmers are often caught in the paradox of wanting to implement business rules and complex functionality in one place... 28 May 2015 27 min read