Looking Back
In July 2011 I took what felt like a big chance and a detour to lead a large and complex...
2013-04-24
738 reads
Blog Posts
PowerSQL – Generate Only Index Script of All Tables or Specific Tables
Background of this implementation-As a part of Performance tuning, We noticed huge avg_disk_queue_length on F drive after analysis, we’ve recommended to...
2013-04-24
859 reads
SQL Power Doc Update - Version 1.0.1.0
A quick note to let you know that SQL Power Doc version 1.0.1.0 is now live. This release fixes issues...
2013-04-24
1,040 reads
SQL Server index related dynamic management views and functions (Part 2)
SQL Server uses indexes to sort and organize table data. It creates indexes based on ordering values from one or...
2013-04-24
789 reads
Thank you Triangle SQL Server User Group
Thank you TriPASS for a great SQL Server Users Group session tonight! Thank you all for attending, and your questions...
2013-04-24
706 reads
The 200 Billion Dollar Tweet
Hello Dear Reader! Ever try to convince someone that they should be paying attention to Twitter? A co-worker, Vice President...
2013-04-24
1,138 reads
The Public Role – a potential high risk security concern for DBAs
The public role is a special fixed-database role, which exists in every SQL Server database. The public role is different from all other database-level...
2013-04-24
11,149 reads
VMworld Presentation Voting – I Would Appreciate Your Votes
This year is the first year that I have submitted a session to VMware’sVMworld 2013, to be held in San...
2013-04-24
613 reads
Exploring Excel 2013 for BI Tip #6: GeoFlow–The Latest Excel Visualization
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-04-23 (first published: 2013-04-11)
3,346 reads
Fargo SQL Saturday (#SQLSat175) Schedule Is This Weekend
We are down to the last few days before first SQL Saturday in Fargo. It’s been some work pulling it...
2013-04-23
505 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
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...
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