Lukas Vileikis in MySQL MySQL Index Overviews: PRIMARY KEY Indexes Learn how to use PRIMARY KEY indexes in MySQL - a type of B-tree index designed to help a database... 15 August 2025 16 min read
Joe Celko in SQL Server Mastering SQL VIEWs: Syntax, Use Cases, and Best Practices Learn how to use SQL VIEWs effectively with practical examples, syntax breakdowns, and expert tips for recursive, union, and updatable... 05 August 2025 10 min read
Edward Pollack in Featured How to Increase SQL Server Column Width Without IO (Input/Output) Overhead One of the most hassle-prone changes that can be made in a SQL Server database is to widen an existing... 28 July 2025 14 min read
Matt Gantz in SQL Server How to Measure Replication Latency in SQL Server AlwaysOn Synchronous Availability Groups Learn how to measure replication latency in SQL Server AlwaysOn synchronous availability groups using performance counters and DMVs for better... 25 July 2025 8 min read
Edward Pollack in Featured How to Use the New PRODUCT() Function in SQL Server 2025 Learn how the new PRODUCT() function in SQL Server 2025 simplifies multiplicative aggregation. See examples, performance tips, and use cases.… 21 July 2025 8 min read
Edward Pollack in Featured Using Regular Expressions (Regex) in SQL Server 2025: A Complete Guide Everything you need to know about Regular Expressions (Regex) in SQL Server 2025 - learn what it is, how to... 14 July 2025 18 min read
Edward Pollack in SQL Server Columnstore Index Improvements in SQL Server 2025 Learn about the improvements to columnstore indexes in SQL Server 2025, including detailed demonstrations for each of these new changes.… 30 June 2025 11 min read
Louis Davidson in T-SQL Programming DISTINCT and UNION: What happens when you use them together? When I was perusing my LinkedIn feed the other day, I came across this thread about using SELECT *. In... 26 May 2025 11 min read
Dennes Torres in T-SQL Programming Techniques to query Azure SQL’s new JSON Datatype The new JSON field type and new functions in Azure SQL brings a new world of possibilities for JSON manipulation... 07 May 2025 15 min read
Ben Johnston in Blogs Writing an Efficient Query SQL is easy to start writing. The basic syntax to start returning data is very simple. This low threshold for... 19 October 2024 20 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... 01 August 2020 22 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... 18 March 2020 22 min read
Blogs Dennes Torres in Blogs Graph Edge Constraints and a Crystal Ball When I read the list of new features in SQL Server 2019 I became very proud of my crystal ball... 08 December 2018 2 min read
Blogs Phil Factor in Blogs Spoofing Data Convincingly: Doing the Shuffle and Zip Having spent a lot of my working life trying to preserve the integrity of data, there was a certain intriguing... 13 August 2018 6 min read
Blogs Phil Factor in Blogs Spoofing Data Convincingly: Credit Cards I haven’t seen a SQL Server table with real unencrypted credit card numbers for several years, and I don’t know... 08 August 2018 8 min read
Blogs Louis Davidson in Blogs Operator Precedence versus the Confusing Constraint Translation The other day, a person I work with was creating some fairly complex CHECK constraints to protect data in a... 30 April 2018 6 min read
Blogs Louis Davidson in Blogs Just What Exactly Will Cast to a Bit Value? I am working through my OneNote folder of blog ideas, and this one, while being one of the least consequential... 02 April 2018 4 min read
Blogs Phil Factor in Blogs Using Stored Procedures in SQL Server that return several results. Stored Procedures give you more freedom than functions, and so they would be the obvious way of developing processes in... 07 March 2018 3 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... 31 March 2016 22 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... 09 March 2016 21 min read
