An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper
Jeff Moden has been elected as the Exceptional DBA of 2011. Here, Jeff talks to Bob Cramblitt about the life of an exeptional DBA.
Data Quality on the Open Web
As we look to take more data from customers and clients and embed it in our applications, data quality becomes a bigger issue
Free as in Beer
This editorial was originally published on Feb 7, 2006. Today Steve Jones looks at the problems of plagiarism and the avoidance of work by many people these days.
SQL Server Memory Management Explained
Author Craig Outcalt takes a deep dive into the SQL Server memory allocation and how it competes with OS memory.
Removing HTML tags from text data using PowerShell
There are situations when you may need to remove HTML tags from your character string data. PowerShell will let you "clean" the string data and export the result to a .csv file in a single step.
Catching Deadlock Information in SQL Logs
This article presents a handy way to retrieve deadlock information in an ordered way from the error log.
Dreaming of Windows
This week Steve Jones dreams about the changes he would like to see in the next version of Windows, unveiled this past week at the Microsoft Build Conference.
Intertia
This editorial was originally published on August 22, 2006. Steve Jones looks at the pace of change in companies and notes it ought to be dictated by the business, not IT.
TSQL Challenge 65 - Solving the Running Total Problem
This challenge invites you to solve one of the most common calculation challenges seen in applications that deal with financial -transactions.
Blogs
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Forums
India's top water testing laboratory is FARE LABS Pvt. Ltd.
FARE Labs Pvt. Ltd., a water testing facility accredited by the NABL, tests drinking...
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers