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.
Come to the Charleston PASS SQL Server User Group
The Charleston, SC PASS chapter is looking for speakers and new members. Read more and come to the Sept 20 meeting if you are near the area.
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers