Making a Change Log Easier With PowerShell
Having a Change Log is a good thing. A quick and simple place to find out what has changed on...
2014-12-16 (first published: 2014-12-08)
5,160 reads
Blog Posts
Rebuilding and Reorganizing Clustered Columnstore Indexes
Clustered Columnstore Indexes, as well as “regular” indexes, support the Rebuild and Reorganize operations. However, the meaning of those operations...
2014-12-16 (first published: 2014-12-11)
6,821 reads
SQL Server Developer Tips that Can Save Your XXX
Last week I had the honor to present a seminar at Expert Days 2014, which is an annual conference for...
2014-12-16
814 reads
Create a clustered index and a primary key on existing tables
It’s the simple things in life that can trip people up. I find that creating primary keys and clustered indexes...
2014-12-15
654 reads
Does a clustered index sort the rows within a page
This is just something I was curious about. I ran my tests and got an answer and now I thought...
2014-12-15
1,374 reads
Last Weeks Top “Reading” Links #113
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-12-15
492 reads
RegEx Those Dates
Recently I was working on transforming some dates, and wanted to generate a large n number of dates for testing....
2014-12-15
1,307 reads
SQL Server Disk Space Emergencies
One of the things I’ll see happen often with SQL Server instances is that the system will run out of...
2014-12-15 (first published: 2014-12-08)
7,698 reads
The Value of Writing Good
Most of my peers, and likely yours as well, work in some sort of technical field. Odds are that they’re...
2014-12-15
555 reads
Why You Should Benchmark Your Storage
You should benchmark your storage immediately. If you are a database administrator, you should benchmark it yesterday. And today. And...
2014-12-15
1,281 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers