I’ve been digging through the 18 years’ worth of articles, editorials, blogs, contests, interviews, promotions, and announcements over at Simple Talk. There are over 5000 posts, and many are quite outdated, especially those announcing beta versions of software or other time-sensitive content. Some articles haven’t seen the light of day for 10 years, yet some […]
Read a step by step guide to setting up an Azure Data Lake Storage account.
Steve ran across a list of interview questions and wonders if it's a good test for an experienced database developer.
It's probably not your fault, but relying on the defaults of a SQL Server installation might be impacting the performance of your instance.
This article focuses on the use of OData Queries to integrate DevOps Analytics data to Power BI.
Git is a great tool for source control and in this tip we look at how you can utilize Git source control to build and deploy database hotfixes.
Building better software requires some experimentation, but also some learning. Building better software as an organization requires even more.
Introduction The analysis of blocking in SQL Server can be hard if the SQL Server instance has a high number of active connections. This analysis becomes complicated because busy instances could have more than one blocking connection, meaning that we could have more than just one blocking chain. For every group of blocked connections, we […]
Oracle archived redo size may be smaller than that of online redo log files. In this article, Jonathan Lewis takes a deeper look.
In this article we look at how to interpret and use the results of STATISTICS IO when tuning SQL Server queries.
By Vinay Thakur
Continued thinking about my Journey blog where we have to look back at the...
By James Serra
A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
By SQLPals
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026) ...
Comments posted to this topic are about the item Identities and Sequences II
Comments posted to this topic are about the item Using PostgreSQL as a NoSQL...
Comments posted to this topic are about the item Is Your Time "Free"?
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers