SQL or MDX query trace in SSRS - trick of imagination or a real thing?
I sometimes have ghost memories - I remember some things that had never in fact happened. And I was wondering if ...
SQL Saturday #50 - East Iowa
Come to a SQL Saturday in Iowa City on Sept 18, 2010 and get a free day of training from the SQL community.
Check Twice, Update Once
An update to the Microsoft Best Practices Analyzer tool intrigues Steve Jones as it seems to have been enhanced to better help DBAs manage SQL Server.
Restricting SecurityAdmin on SQL Server 2005/2008
Members of the securityadmin role can escalate to sysadmin rights. Here's how to restrict them back to 2000 levels.
DMVs for Query Plan Metadata
Before you can tackle any performance issues with a working database, you need to know which queries to work on first: The ones that are taking the most time in total, and which are the most expensive in terms of cache, CPU and disk. Although SQL Server Management Studio can help, it isn't long before you need an armoury of DMVs to provide you the statistics to find the culprits.
How Old Are Your Database Statistics?
Unlike fine wine, database statistics do not improve with age. I recently helped out with a client who was having...
Parsing an ADO result set into a comma separated string in SSIS
This article describes a way to parse a result set in SSIS using For each loop container, variables and SQL task.
Where Are the Programmers?
Today Steve Jones has a little fun with titles in technology, and what we might start to call ourselves instead of DBAs.
What Every DBA Ought to Know About SQL Server Cursors (and Their Alternatives)
Cursors provide a means of processing through a set of records row-by-row. However, many companies have a policy against using cursors in their SQL Server standards. This article examines the problem with cursors and alternatives to using them.
Conditional WHERE Clauses and Boolean Algebra
Utilize simple boolean algebra and nullable parameters to implement conditional WHERE clauses without dynamic SQL.
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 Kas Mutiara Karawaci (+62 821°3111°179
Komplek Psr Modern, Jl. Mutiara Raya Ruko No.23 Blok D, Bencongan, Karawaci, Tangerang Regency,...
BCA KCP Pondok Timur No.Tlp.083179431643
Jl. Pd. Timur Indah Kompleks Perumahan Taman Nirwana No.8, RT.005/RW.019, Pengasinan, Kec. Rawalumbu, Kota...
BCA KCU HARAPAN INDAH No tlpon:083138717148
Whatsapp:083138717148.Jl. Harapan Indah Boulevard Kav. CP2 No. 1, Pusaka Rakyat, Kec. Tarumajaya, Kabupaten Bekasi,...
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