The Useful Cloud Tags
Tagging is important to keep track of resources in the cloud. Today Steve asks how you approach this topic.
Working with T-SQL function AVG ()
Learn about the T-SQL function, AVG(), and see how it is used in a few different cases.
Implementing ETL Logging on Lakehouse using Delta Lake's Time Travel capability
In this article I demonstrate how to use Delta Lake's time travel functionality for ETL logging along with steps to take to implement.
The VALUES clause or building tables out of nothing
The VALUES clause makes inserting literal values into a table simple and easy. In this article, Joe Celko explains how to use the VALUES clause.
Returning To An Employer
Leaving an employer on good terms is important, and Steve thinks employers ought to consider hiring former employees, even if they were let go in a layoff.
Stairway to Columnstore Indexes Level 2: Columnstore Storage
To fully appreciate just how different columnstore indexes are, and why work so well in reporting and online analytical processing (OLAP) workloads, but not for online transaction processing (OLTP), we must first look at the traditional “rowstore” indexes.
How to tell what SQL Server versions you are running
Check out this tip to easily find out what version of SQL Server you are running.
SQL Monitor: On-demand demo [Watch now]
Haven't seen SQL Monitor in a while? If you'd like to see how it enables you to always have the answers to the health of your estate, and proactively find potential problems before they impact your users, here's a 30 minute demo for you to watch whenever it suits you.
Blogs
Scaling PowerShell – Lessons from a Technical Interview
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell at...
Installing Old Versions of PowerShell Modules with Their Dependencies
By alevyinroc
I don’t recall where this came up (probably in SQLSlack), but I had a...
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Forums
how to get notification that my database has corssed 8gb
i have sqlexpress on rds, is there any way i can get notifacation that...
SQL Server, Heaps and Fragmentation
Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation
Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Question of the Day
SQL Server, Heaps and Fragmentation
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers