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.
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.
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.
Use sysindexes\DMVs insead of select count(*) to retreive table row counts
31 Days of SSIS
It’s Sunday afternoon and a good time to be putting up post twenty-three for the 31 Days...
At last, my blog is starting to pay real dividends. Not only do I get the opportunity to publish my...
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.
A new series of courses is available from SQLskills to help you better learn to manage and tune your SQL Server instances. These classes are designed to help you complete the MCM certification, but are also valuable for anyone that wants to become a better SQL Server DBA.
Steve Jones talks about the value of deep training. He is aiming to get some from SQLskills this year as part of their MCM training series, even without trying to pass the certification.
The next webinar from SQLServerCentral will look at backups and how you can create faster, smaller, and verified backups. Join Steve Jones and Rodney Landrum for this presentation on SQL Backup Pro and SQL Virtual Restore
My old Dell XPS that I used for personal stuff started to degrade; well,...
By Steve Jones
At the Redgate Summits this year, we’ve highlighted a few things in the Flyway...
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
WA:08218154393 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa Timur...
WA:08218154393 Jl. Tidar No.109, Petemon, Kec. Sawahan, Surabaya, Jawa Timur 60252
We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers