Serious Storage
Steve Jones talks about the serious storage that EMC is bringing to the Vatican library.
2013-03-19
200 reads
Editorial
The Backup Process
Today Steve Jones talks about backups. Setting up a process is good, but you cannot count on it working forever. You need to check periodically to be sure it's working, and that your skills are not deteriorating.
2013-03-18
197 reads
Inconsistency
This Friday Steve Jones notes that changing and altering your opinions is good and invites you to share things you might have learned that changed your mind in the past.
2013-03-15
129 reads
The Gambler
If you are the type of person that doesn't run DBCC checks, Steve Jones thinks you're a gambler. And you might think about attending SQL Intersection next month in Vegas.
2013-03-14
213 reads
Resetting DMVs
Steve Jones asks the question why so much data in SQL Server is cleared when we restart an instance.
2013-03-13
178 reads
Self Describing Databases
Today Steve Jones gives his vision of the database in the future. He hopes that databases contain more information about not only their objects, but their needs, like backups and maintenance.
2013-03-12
355 reads
Cloud Services. Waiting for the 'paint to dry'?
Despite recent 'outages', The canny CIO will make use of the obvious advantages of public cloud services where it risks neither security or availability. Adoption of the Cloud services and platforms is going to be most effective where the Cloud’s advantages of rapid scalability can be harnessed.
2013-03-11
80 reads
Productivity and Accountability
The recent decision by Yahoo to end telecommuting elicits some comments from Steve Jones on the topic of remote work.
2013-03-07
156 reads
Two Plugs Away
The culture and practices at Valve are interesting to Steve Jones, but the desks really caught his eye.
2013-03-06
156 reads
Data We Don't Want
There's potentially an exploit that can download lots of data to a machine. This shouldn't be a concern for servers, but you never know.
2013-03-05
187 reads
Blogs
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers