What's a Passive Server?
Today Steve Jones talks about licensing and the complexity if brings in various scenarios. Do your passive servers have to be licensed? What is the definition of "passive"?
7 Things that High Availability is Not
Wesley has heard High Availablity touted as all sorts of technological cure-all for busy SysAdmins and DBAs, and now he's taking a stand against it. There are a range of things that High Availability is regularly confused with (either deliberately or innocently), and Wesley's clearing it all up
A Great Deal of Hot Air
Even though neither the science nor politics of climate change is fully established yet, the legislators and bureaucrats have smelt an opportunity to further tighten their grip on IT. A sign of things to come is the EU’s Code of Conduct for Data Centers on Energy Efficiency.
It's Almost Always the Humans
Today we have a reprint of an editorial from Sept 19, 2005 as Steve Jones is on vacation. In this one, Steve Jones reminds companies that saving money sometimes on Customer Service isn't as easy as you think.
Which of Your Stored Procedures are Using the Most Resources?
Dynamic Management Views and Functions aren't always easy to understand. However, they are the easiest way of finding out which of your stored procedures are using up the most resources. Greg takes the time to explain how and why these DMVs and DMFs get their information. Suddenly, it all gets clearer.
How To Get Table Row Counts Quickly And Painlessly
Use sysindexes\DMVs insead of select count(*) to retreive table row counts
31 Days of SSIS – Generating Row Numbers (23/31)
31 Days of SSIS
It’s Sunday afternoon and a good time to be putting up post twenty-three for the 31 Days...
Internals and Performance class in Dallas
At last, my blog is starting to pay real dividends. Not only do I get the opportunity to publish my...
Showplan Operator of the Week - Merge Interval
When Fabiano agreed to undertake the epic task of describing each showplan operator, none of us quite predicted the interesting ways that the series helps to understand how the query optimizer works. With the Merge Interval, Fabiano comes up with some insights about the way that the Query optimizer handles overlapping ranges efficiently.
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 Tebet Telp/Wa:08218200174
Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, Tebet...
BCA Rukan Patria Tlpn/wa:085373737551
Rukan Patria Park, Jl. DI. Panjaitan No.6 RK 05, RT.6/RW.11, Cipinang Cempedak, Jatinegara, East...
BCA KCP Kas Jatiwaringin Tlpn/wa:085373737551
Giant, Kompleks Ruko Graha Indah, Blok F/1, RT.001/RW.002, Jatiwaringin, Pondok Gede, Bekasi, West Java...
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