Introduction to Statistics
This article will give a brief overview of how statistics are generated, stored, and used in SQL Server.
Loading partitions incrementally using SSIS
In this article, we discuss how to load large partition tables incrementally.
Organisations and Technical Apartheid
Today we have a guest editorial that looks at DevOps and the need for your culture to promote collaboration.
Tips for Better Presentations
Brent Ozar gives some advice to those of you who give presentations to user groups and conferences.
The Road to Better Data Handling
As data becomes more valuable and regulations require safer processing, it is important we become more careful in our daily work.
What’s the Difference Between PERCENT_RANK and CUME_DIST?
Learn a bit about the different results you get from the PERCENT_RANK and CUME_DIST aggregate functions.
How can we close the tech skills gap?
One of the most profound challenges faced by technology companies today is talent. According to the latest Harvey Nash survey, 65% of CIOs believe that a shortage of tech skills is affecting their ability to respond to change.
Improving Tech with Compassionate Code
There is quite a bit of suffering within tech and caused by tech, from poorly commented code to shaming someone who asks a question on a forum. In this article, Samuel Nitsche explains why compassionate coding is a better way to go.
Collect SQL Server Index Usage Information for all Instances with PowerShell
In this tip we look at a PowerShell script you can use to collect index information for all of your SQL Server instances that you manage.
Blogs
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers