The Mystery Of The Slow Last Row
Things Go South
Recently I was troubleshooting a piece of software that archives data out of a very active import table....
Changing Text in Multiple Stored Procedures From a Stored Procedure
In this article Brian Davey present a solution for changing the text in multiple stored procedures using T-SQL.
Configuring Kerberos Authentication
Longtime author Brian Kelley brings us a new article on security and Kerberos authentication in SQL Server.
How to Deal with the Stresses and Anxieties in Today's IT Industry
Today we have a guest editorial from Stanley Popovich that talks about dealing with stress at work.
Patch Week
With SQL Server releasing new cumulative updates this week, Steve Jones talks about the patching strategy of SQL Server.
SSRS Reports Performance Debugging and Analysis
SSRS provides a very user friendly way to author and deploy reports. These reports can be accessed from different platforms where the reports are deployed - reports manager, SharePoint, stand-alone / distributed applications or programmatically using SSRS SOAP endpoints. Unfortunately, SSRS / BIDS does not provide any high-end debugging tools such as SQL Profiler for analyzing the performance of SSRS reports. In this tip we will look at different ways of debugging and analyzing SSRS reports performance using execution logs and freeware tools.
Statistics, row estimations and the ascending date column
SQL’s auto-updating statistics go a fair way to making SQL Server a self-tuning database engine and in many cases they...
The default trace in SQL Server - the power of performance and security auditing
Since the introduction of SQL Server 2005, there is a simple lightweight trace that is left running by default on every SQL Server. This provides some very valuable information for the DBA about the running server, but it isn't well-documented. Feodor Georgiev reveals many of the secrets of this facility and shows how to get reports from it.
What Differentiates Enterprise?
This Friday Steve Jones asks you about the Enterprise Edition of SQL Server, and what should the distinction be?
SQL Server 2008 Service Broker - Conversation Priorities
SQL Server 2008 Service Broker lets you process higher priority messages and conversations earlier than those with lower priority.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Sentral Cikini Hub.0813•7887•595
BCA KCP Sentral Cikini Hub.0813•7887•595.Jl. Pegangsaan Timur No.1, Cikini, Kec. Menteng, Kota Jakarta Pusat,...
BCA KCP Pajajaran Hub:Cs.083831618816
WhatsApp:083831618816 Jl. Raya Pajajaran No.5 & 6, RT.008/RW.09, Bantarjati, Kec. Bogor Utara, Kota Bogor,...
BCA KCP Mangga Dua ITC Tlp (+62 821°3111°179
No. 20-25, 29-32, Gedung ITC Mangga Dua, Jl. Mangga Dua Raya Lt. IV Blok...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers