The Project Graveyard
This post is a response to this month’s T-SQL Tuesday #107 prompt by Jeff Mlakar. T-SQL Tuesday is a way...
2018-10-18 (first published: 2018-10-09)
2,726 reads
Blog Posts
Fix SQL Server with one click
Tempting headline, isn’t it? It might even seem like clickbait, but that’s not the intention. The SQL Server default configuration...
2018-10-17
295 reads
Generate a random number of children for each parent
I was asked an interesting question the other day.
Is it possible to get a different random number of rows...
2018-10-17 (first published: 2018-10-03)
2,057 reads
How to Start Speaking
At the last few events I attended, I’ve gotten into conversations on how to begin as a speaker. So I...
2018-10-17
337 reads
Pagination pattern or how to fetch a large dataset for a web report.
In this post we will discuss how to fetch data from a large dataset for web applications using pagination technique....
2018-10-17
416 reads
SQL Server Data Collection and Management Data Warehouse
We all have the need to collect system and performance information regarding our SQL Servers. Some of us use third-party...
2018-10-17 (first published: 2018-10-03)
3,429 reads
2018-10-17
207 reads
What is the Object Explorer Details tab good for?
For a long time there I would see the Object Explorer Details tab show up when I opened SSMS (SQL...
2018-10-17
286 reads
Azure SQL Database Hyperscale
At Microsoft Ignite, one of the announcements was for Azure SQL Database Hyperscale, which was made available in public preview October 1st, 2018 in 12 different Azure regions. SQL Database Hyperscale is...
2018-10-16
86 reads
Conditionally Returning Rows Based On Query Results
Watch this week's video on YouTube
While I normally prefer formatting my query results in a downstream app/reporting layer, sometimes I can't get around adding some business formatting logic to...
2018-10-16
7 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
Alamat Kantor BCA KCU Cianjur Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur,...
Alamat Kantor BCA KCU Depok Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Margonda Raya No.182, Kemiri Muka, Kecamatan Beji, Kota Depok,...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers