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,152 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,786 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
803 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
649 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,366 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
486 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,302 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,692 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
542 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,270 reads
Blogs
Distance Metrics for Semantic Similarity Searches in SQL Server 2025
Next up in my series talking about The Burrito Bot is diving into the...
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers