Database Performance Transparency
Describes the benefits of publishing instance performance metrics including a script to generate HTML-based Performance Snapshot.
Going Solo
This editorial was originally published on Mar 20, 2007. It is being republished as Steve Jones is on vacation. Today Steve Jones talks about going into business for yourself, and reminding you it's not as simple as it might seem.
Rebuilding SQL Server indexes using the ONLINE option
As each year goes by the uptime requirement for our databases gets larger and larger, meaning the downtime that we have to do maintenance on our databases is getting smaller and smaller. This tip will look at a feature that was introduced in SQL Server 2005 that allows us to leave our indexes online and accessible while they are being rebuilt.
Feedback and Big Data
Continuous improvement comes from measurement, analysis, and changes. Steve Jones talks about how we should be doing that with our data collection, analysis, and storage.
TSQL function to detect SQL Agent job state
This article has a T-SQL function to detect the SQL Agent job state.
Converting String Data to XML and XML to String Data
In general XML documents or fragments are held in strings as text markup. In SQL Server, XML variables and columns are instead tokenised to allow rapid access to the data within. This is fine, but can cause some odd problems, such as ' entitization'. What do you do if you need to preserve the formatting? As usual Rob Sheldon comes to our aid.
Aggregate Function Product()
The TSQL aggregate function SUM() gives a number based on the addition of the values of multiple rows to each other. Do the same thing but with multiplication instead of addition.
Insider Security Threats
The biggest security threat always seems to come from insiders and today Steve Jones talks about the need to monitor your environment.
SQL Server 2012: Creative Thinking for a Creative New Licensing Model
It seems inevitable that many customers will end up paying more to get the same features they have today, under the new SQL Server licencing model, unless they respond to Microsoft's creativity with some of their own.
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 Morowali Telp:Cs.08216977726
Whatsapp:08216977726 Jl. Trans Sulawesi, Keurea, Kec. Bahodopi, Kabupaten Morowali, Sulawesi Tengah 94974
BCA KCP Kertopaten Telpon. 083135766741
WhatsApp 083135766741 Jl. Pegirian No.114, RT.007/RW.10, Sidodadi, Kec. Simokerto, Surabaya, Jawa Timur 60145
BCA KCP Kas Palu Barat Telp:Cs.083831618816
Whatsapp:083831618816 Jl. Sungai Malei No.35, Ujuna, Kec. Palu Bar., Kota Palu, Sulawesi Tengah 94111
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