Last Weeks Top “Reading” Links #97
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-08-18
505 reads
SQLSaturday Orlando Marketing Plan-Part 36
Just checked in on my LinkedIn campaign. This is the one that uses job titles. Not a ton of impressions,...
2014-08-18
504 reads
SQLSaturday Precon Cost Structure
Many of you may already know that I am a PASS regional mentor for the South Central region of the...
2014-08-18
488 reads
Performance Counters: Why It Depends
When you’re working through some vague performance issues (e.g., “SQL Server seems slow today”), one of the common things to...
2014-08-18
1,255 reads
Playing with Pivot
I’ve been working on some skills, trying to grow some of my T-SQL, and started to mess with the PIVOT...
2014-08-26 (first published: 2014-08-18)
8,205 reads
Generating a restore script
In order to speed up our backups on a large database our team decided to stripe the backup files. In...
2014-08-25 (first published: 2014-08-18)
7,525 reads
SQL Server Keyboard Shortcuts
SQL Server Keyboard Shortcuts for Management Studio
SQL Server Management Studio is filled with lots of optional settings that lets you...
2014-08-22 (first published: 2014-08-18)
9,806 reads
SQL Code Guard v2.6 released
Today we released new version of SQL Code Guard, 2.6
Main changes:1. Bug fixing2. Small GUI and usability improvements3. Fixed support...
2014-08-22 (first published: 2014-08-18)
7,115 reads
Parameterization Part 1: Plan Caching
Many times, when I perform query tuning, the problem that causes the query to perform badly is related, one way...
2014-08-21 (first published: 2014-08-18)
8,630 reads
How To Split Non-Empty Partitions When A Clustered Columnstore Index Exists on The Table
Another pithily titled blog post, but this one revisits the feature of SQL Server 2014 that piqued my interest the most: Clustered Columnstore Indexes. I’ve been working with Clustered...
2014-08-18
372 reads
Blogs
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers