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
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Hi , i installed winscp on my pc, added it to GAC thru vs...
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...
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