Notes from SQLSaturday #81
I started by journey to Birmingham by leaving work at 1130 and getting to the airport in time to have...
2011-08-01
308 reads
We Have Another New Contributor…
I’d like to introduce you all to my friend Ian Treasure who has kindly volunteered to write some posts and...
2011-08-01
616 reads
Telecommuting - Hype or Happening? - Making the Case to your Higher-ups
We've seen the argument before, that working from home, actually increases productivity. This is one of the major cases in...
2011-08-01
2,558 reads
PowerPivot – Creating Hierarchies
Hierarchies are one of the long awaited features that will now be available in the latest version of PowerPivot. Hierarchies...
2011-07-31
4,846 reads
Spoke at #sqlsat81
I presented two sessions this weekend in Birmingham AL at SQL Saturday 81. I was in the first slot of...
2011-07-31
1,454 reads
The Good, the Bad and the Ugly SQL Cursor types
T-SQL cursors are generally bad approach and are often misused. In today’s world of correlated subqueries, CTE’s, recursive CTE’s, ranking...
2011-07-30
1,956 reads
Lookup functions in SSRS 2008 R2 - III
Introduction
This is the final post to discuss the last Lookup function Multilookup(). The other two – Lookup() and LookupSet() have already...
2011-07-30
11,360 reads
SQL Saturday #85 Orlando
SQL Saturday #85 is quickly approaching. It will be held in sunny Orlando, FL so if you live in the...
2011-07-30
2,067 reads
SQL Azure – simple description, part I.
I was studying SQL Azure parameters some time ago and found out that there are no materials which tell you...
2011-07-29
1,777 reads
SQL Server Hardware Book News and Reviews
Today was an exciting day, since I discovered that fellow SQL Server MVP Brent Ozar (Blog|Twitter) had posted a very...
2011-07-29
1,488 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
Alamat BCA KCP Menara Thamrin Telp:0821°7555°651
Telp/Wa 628217555651 Menara Thamrin, Jl. M.H. Thamrin No.Kav. 3 Lantai 1 Ruang 106, RT.10/RW.10,...
Alamat BCA KCP Duta Merlin Telp:08218200233
Telp/Wa 628218200233 Komp. Duta Merlin Blok A No. 24-25, Jl. Gajah Mada No.3-5, RT.2/RW.8,...
Alamat BCA KCP Tanah Abang Zona 3 Telp:08218200203
Telp/Wa 628218200233 Gedung Tanah Abang Zona III Lantai 3A L03A, Jl. KH. Fachrudin, Kp....
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