Blogs Dennes Torres in Blogs What’s new in T-SQL in SQL Server 2022 There are many new features in SQL Server 2022. In relation to T-SQL querying, there are a few as well and they usually are left... 04 July 2022 8 min read
Database DevOps Grant Fritchey in Database DevOps What is database continuous integration? Have you ever longed for a way of making the delivery of databases more visible, predictable and measurable? Do you ever wish that they would... 07 October 2020 9 min read
Phil Factor Temporary Tables in SQL Server Temporary tables are used by every DB developer, but they're not likely to be too adventurous with their use, or exploit all their advantages. They... 01 August 2020 22 min read
Blogs Phil Factor in Blogs Tackling Imperial and US Customary Measurements in Databases The old measurements of length, area, volume and weight in the UK and the States refuse to die. They are known as the Imperial and... 06 May 2020 10 min read
Roy Ernest Introduction to SQL Server Spatial Data Many applications require the handling of geospatial data. Roy and Surenda take you through the basics of SQL Server spatial data types. … 18 March 2020 22 min read
SQL Books Kalen Delaney in SQL Books SQL Server Internals: In-Memory OLTP In this book Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered in this book will help... 07 December 2017 2 min read
Hugh Bin-Haad Relational Algebra and its implications for NoSQL databases With the rise of NoSQL databases that are exploiting aspects of SQL for querying, and are embracing full transactionality, is there a danger of the... 01 April 2016 4 min read
Robert Sheldon SQL Server System Functions: The Basics Every SQL Server Database programmer needs to be familiar with the System Functions. These range from the sublime (such as @@rowcount or @@identity) to the... 31 March 2016 22 min read
Elizabeth Ayer The Comeback of Migrations-Based Deployments With database deployments, not all script-based processes are equal. Some use change scripts in a free-and-easy way, and some, which are normally called 'migrations-based approaches',... 17 March 2016 11 min read
Kathi Kellenberger T-SQL Window Function Speed Phreakery: The FIFO Stock Inventory Problem Sometimes, in the quest for raw SQL performance, you are forced to sacrifice legibility and maintainability of your code, unless you then document your code... 16 March 2016 14 min read
Matthew Skelton Database Lifecycle Management for ETL Systems Few databases are self-contained. They take data from other sources, and publish them to downstream consumers of data. These ETL processes tend to grow in... 16 March 2016 32 min read
Enrico van de Laar The SQL Server 2016 Query Store: Forcing Execution Plans using the Query Store The SQL Server 2016 Query Store can give you valuable performance insights by providing several new ways of troubleshooting queries, studying their plans, exploring their... 16 March 2016 7 min read
Dennes Torres Creating a Date Dimension in a Tabular Model As well as its multidimensional model, SQL Server Analysis Services (SSAS) now has a tabular model of database that either runs in-memory or in DirectQuery... 15 March 2016 23 min read
Matthew Skelton Database Migrations: Modifying Existing Databases It should be simple to upgrade a database to a new version. It certainly can be, but if you need to preserve the existing data... 09 March 2016 34 min read
Robert Sheldon SQL Server Metadata Functions: The Basics To be able to make full use of the system catalog to find out more about a database, you need to be familiar with the... 09 March 2016 21 min read
Uwe Ricken When AUTO_UPDATE_STATISTICS Doesn’t Happen When your SQL Server database is set to have its statistics automatically updated, you will probably conclude that, whenever the distribution statistics are out-of-date, they... 07 March 2016 10 min read
Laerte Junior The PoSh DBA: Assigning Data to Variables Via PowerShell Common Parameters Sometimes, it is the small improvements in a language that can make a real difference. PowerShell is able to introduce extra common parameters that can... 07 March 2016 7 min read
Matthew Skelton Issue Tracking for Databases Any database development project will be hard to manage without a system for reporting bugs in the code, anomalies and incidents from live environments, and... 25 February 2016 20 min read
Dennes Torres Creating a Date Dimension in an Analysis Services (SSAS) Cube A walk-through can be a great help to understanding SQL Server Analysis Services, especially when it solves the problem of providing an effective date dimension... 24 February 2016 33 min read
Grant Fritchey Better Ways to Build a Database The purpose of a database build is simple: prove that what you have in version control can successfully create a working database. And yet many... 19 February 2016 40 min read
