Excel Tip #21: Hiding Scrollbars in Excel Services Web Part
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-03-17
812 reads
T-SQL – Find Number of Rows of Database(s) tables Using Undocumented Procedure – sp_MSforeachdb and sp_MSforeachtable
Added few more examples
Prashanth Jayaram
On Technet forum, Op was looking for a way to get table cardinality for all databases...
2015-03-17
937 reads
Combating the CXPacket Wait Type
Often, when DBAs are looking at total wait statistics on the servers they manage, CXPacket is at or near the top of...
2015-03-24 (first published: 2015-03-17)
7,471 reads
Increasing ColumnStore compression ratio for archival and “Cold storage”
At my present client, part of the task I have to under take is to re-engineer the “Cold Storage”. This...
2015-03-17
365 reads
The Demo Setup–Attaching Databases with Powershell
I found another use for Powershell, one actually suggested by someone else: attaching specific SQL Server databases.
TL;DR I have a...
2015-03-16
4,581 reads
“Thing IS NOT NULL” isn’t the same as “Thing != NULL”
I’ve talked about NULLs before. (Ref: Here’s a bit on ISNULL(), and here’s one about understanding NULL at a basic level.)...
2015-03-16
584 reads
Review of Minion Reindex
Back in October 2014 Midnight SQL released v1.0 of Minion Reindex, a free, open source index maintenance solution. I’m all...
2015-03-16
637 reads
Review of Minion Reindex
Back in October 2014 Midnight SQL released v1.0 of Minion Reindex, a free, open source index maintenance solution. I’m all...
2015-03-23 (first published: 2015-03-16)
7,909 reads
How To Speak At SQL Saturday Events
The PASS SQL Saturday events are meant to be a place to grow the pool of speakers, provide a mechanism...
2015-03-16
847 reads
There are #temp tables and then there are ##temp tables.
Temporary tables are a common enough thing in T-SQL that most of us have probably used them on a fairly...
2015-03-16
674 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers