I am old enough to remember when many large corporations implemented chargebacks. Essentially, each internal department was charged for their usage of IT systems, similar to how we are charged in the cloud. It was a mess, and individual departments had to answer for excessive charges. I don't know that any department ever lost service, […]
Microsoft introduced Columnstore with SQL Server 2012 and have improved the feature in every version since then. You may be wondering why they are different than traditional indexes and how they work. In this series, Edward Pollack explains the architecture of Columnstore indexes. In future articles in the series, he will describe best practices for Columnstore.
Database deployments are on the rise, with more organizations releasing weekly or daily. But this does not always result in more value being delivered. Steve Jones advises the steps you can take to unlock the value of frequent releases in this blog.
Most of us use SSMS (SQL Server Management Studio) to manage our SQL Server instances or to write database code. However, Microsoft does give us database options with Visual Studio, VS Code, and Azure Data Studio. It does seem as though Microsoft would prefer more of us move to ADS, but I'm not sure I'm […]
In this article we look at how to find SQL Server deadlocks using the system health Extended Events session.
Could you spare 3 minutes to help us out at SQL Server Central? Take this short survey, tell us about who you are and why you come to SQL Server Central, and you could win a $50 Amazon voucher.
A simple question, and you can vote by leaving a comment for this article. Do you still want me to include the coping tips in the newsletter after June? When the pandemic shut down much of the world in March, our CEO at Redgate Software asked us to think about what we could do to […]
With the PASS Summit moving to a virtual format, Steve is going to support the event.
Microsoft provides a number of different deployment options for its Azure SQL Database offerings. While most of them share the same characteristics, one in particular warrants special attention from the standpoint of its infrastructure dependencies. That exception is Azure SQL Database Managed Instance, which will be the topic of this article.
From performance to recruitment, cloud adoption to estate growth, the findings from the 2020 State of Database Monitoring report offer us some key insights into the trends and challenges facing the industry this year. Redgate’s Jamie Wallis unpicks the findings in this latest blog.
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