Extended events (XE): Create a simple XE
When someone says still uses SQL Profiler.
Image is taken from hereAn ancient, dark place, a source of many legends and...
2018-07-23
1,579 reads
Eduardo Pivaral
- Website: http://www.sqlguatemala.com
PowerBI: Implement a What If parameter
Our Guinea Pig DashboardPowerBI is focused on creating interactive, analytical reports, from a lot of different data sources and with...
2018-07-17
170 reads
Display SELECT query or table as HTML
This post is part of #tsql2sday event :)For my current job I support a lot of SQL Servers, they come...
2018-07-10
374 reads
Saving disk space by choosing the correct data type
"Database is almost 4 TB in size, user is complaining on long times for DEV data refresh and high storage...
2018-07-03
1,762 reads
Check instant file initialization and lock pages in memory options
Study your server reports do the work for you!
Instant file initialization and lock pages in memory are 2 windows operating...
2018-06-28
2,665 reads
What it is Page Life Expectancy (PLE)
Which cup will you prefer to go the less
number of times to the coffee maker?image was taken from hereLet us...
2018-06-21
235 reads
Collation considerations to create robust queries
Is your code "This" robust?What is Collation? In short words: are the sorting rules, case, and accent sensitivity properties for...
2018-06-11
207 reads
Add a custom report to SSMS
Maybe some of you don't know this, but to view Report Definition Language reports (RDL) , you aren't forced to use...
2018-05-25
623 reads
Query to determine last statistics update for a database
Statistics are a vital part of SQL Server database engine, these are used for the query optimizer to create query...
2018-05-16
137 reads
Quick charts in SQL Server Operations Studio
Sample chart for quick insightsSQL Server Operations Studio will be a new tool for managing SQL Server, Azure SQL Database,...
2018-05-14
126 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