Azure DocumentDB: Working with Microsoft's NoSQL Database in the Cloud
Coding for the new NoSQL JSON database service that supports SQL queries.
T-SQL Fundamentals: Controlling Duplicates
When people start learning a new field, for example T-SQL, it’s tempting to spend very little time trying to understand the fundamentals of the field so that you can quickly get to the advanced parts.
SQL Window Functions Series: RANK() and DENSE_RANK()
Welcome to the fascinating world of SQL window functions! Today, we'll explore in detail: RANK() and DENSE_RANK().
“How do my peers do this?” The latest best practices for IT architects implementing a major business initiative
How do other architects solve the common problems they encounter when tasked with implementing a major new business initiative? We asked 9 of your fellow IT architects to tell us how they approach the most common challenges.
What are Warehouses in Microsoft Fabric?
In this article, we look at using Microsoft Fabric to build a data warehouse and some things you should know about doing this.
You Never Know
I'm writing this sitting at the PASS Data Community Summit. It's been a fantastic event. I gave a community session on Azure DevOps. I was able to help Redgate launch a new product. I've received a bunch of hugs from VERY dear old friends. I've met a ton of people. It's been great. Allow me […]
Scheduling SQL Agent Jobs on Alternating Weeks
Bi-week... semi-week... fortnight... "every two weeks" Recently on the SQL Community Slack group, someone asked if there was a way to schedule a backup to run on alternate weeks. I'm not exactly sure why (maybe they wanted to run full and differential backups on alternating weeks), but yes, we can do that. In part one […]
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