Private Data
The laws and morals regarding privacy aren't well defined, but Microsoft is making a stand.
Database Lifecycle Management Webinar
Join Steve Jones for a Database Lifecycle Management webinar on Nov 17 at 11am EDT. Watch to see how smooth a database development pipeline can be.
Questions About CUBE, ROLLUP and GROUPING SETs That You Were Too Shy to Ask
There are few parts of SQL Syntax as familiar as the GROUP BY clause of the SELECT statement. On the other hand, CUBE and ROLLUP remain mysterious despite their usefulness and GROUPING SET is positively arcane, especially if you are too shy to reveal your ignorance of the subject by asking! William Brewer saves you the hassle.
Mind your Database Ps and Qs
Louis Davidson explains why a little database courtesy goes a long way.
SQL Server 2016 Stretch Database
SQL Server 2016 brings a new feature called Stretch Database, which allows a database to keep transactional data on local instance and warm and cold data on the Azure SQL database platform.
Hash Joins on Nullable Columns
Paul White explores some less well-known query optimizer features and limitations, and explains the reasons for extremely poor hash join performance in a specific case.
Capture Execution Plan Warnings using Extended Events
Erin Stellato of SQLskills shows how to use Extended Events to monitor for query plans with certain characteristics, such as joins missing predicates, columns missing statistics, and unmatched filtered indexes.
How to Install and Configure Baseline Collector Solution V2
In this article I go through the installation and configuration processes of my Baseline Collector Solution.
Automating Your SQL Server Best Practice Reports: The Document
If you're making a report from table-based data, an MS Word document is often a good option. In the second part of his introduction to SQL Server best-practice monitoring, Laerte Junior shows how to use PowerShell scripts to create a Word-based report with colour-coded alerts where there are problems or best practices aren't being followed.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Cara aktivasi ulang qlola ib token Soft token BRI instruksi selengkapnya
Reaktivasi qlola IB token (soft Token)ke ponsel baru dapat menghubungi QLola via whatsapp (0819-6000-608)...
BCA KCP Radio Dalam CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Radio Dalam Raya No.5 B-C, Gandaria Utara, Kec. Kby. Baru,...
BCA KCP Gedung Hijau CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Gedung Hijau Raya No.41, Pondok Indah, Kec. Kebayoran Lama, Kota...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers