ExpressProfiler: Yet another "when and why" story.
Core of ExpressProfiler was born about 8 years ago when I worked for a company whose mission was the migration...
2014-06-23
764 reads
Microsoft Azure Data Services
Azure Data Services
Microsoft’s Azure data services provides you with a method to enhance your enterprise architecture and business intelligence options. ...
2014-06-21
1,144 reads
Clustered Columnstore Indexes – part 31 (“Memory Pressure and Row Group Sizes”)
Continuation from the previous 30 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This blog post is focusing on one of the most important real...
2014-06-21
235 reads
Baton Rouge SharePoint Saturday 2014: SQL Server Best Practices for SharePoint Databases
Thanks for joining us at the first annual Baton Rouge SharePoint Saturday!
Here is my presentation for the 1:15 presentation in...
2014-06-21
646 reads
Clustered Columnstore Indexes – part 30 (“Bulk Load API Magic Number”)
Continuation from the previous 29 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
It has been a long time (almost a year) since Microsoft revealed...
2014-06-20
216 reads
Reblog: June 13 to June 19
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-06-20
583 reads
Poecilonym Madness-Question of the Day
Poecilonym Madness! is my latest question that tests your knowledge of creating/dropping tables, views, and synonyms. Here’s the fun part...
2014-06-20
616 reads
Partitioning Basics – Part 3 – Switching Data
This post follows on from Partitioning Basics – Part 2
In this final part, I want to go through how partitions can...
2014-06-24 (first published: 2014-06-20)
3,247 reads
Friday Followup For June 20, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-06-20
303 reads
SQL Server Performance Tuning & Troubleshooting Workshop in Antwerpen/Belgium
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-06-19
1,212 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers