Poor Man's Enterprise Feature - Lock Pages in Memory
Enable Lock Pages in memory on Standard edition was ONLY an Enterprise feature until now. Read this article to see how you enable this setting in SQL Server.
Afraid of Help
Is it hard for technology workers to ask for help? Or accept it? We seem to often be the type of people that want to solve problems and fix things on our own. Is that a problem? Steve Jones thinks that we should sometimes put aside our pride and get things done.
Afraid of Help
Is it hard for technology workers to ask for help? Or accept it? We seem to often be the type of people that want to solve problems and fix things on our own. Is that a problem? Steve Jones thinks that we should sometimes put aside our pride and get things done.
Afraid of Help
Is it hard for technology workers to ask for help? Or accept it? We seem to often be the type of people that want to solve problems and fix things on our own. Is that a problem? Steve Jones thinks that we should sometimes put aside our pride and get things done.
Finding Data Corruption
Rodney describes how a working DBA goes about troubleshooting data corruption. He demonstrates the tools and scripts required to seek out and fix data corruption in a timely manner, and so prevent it propagating into your backups.
How to Backup and Restore a SQL Server FILESTREAM Enabled Database
Most SQL Server DBAs have questions about backing up and restoring FILESTREAM enabled databases. In this tip, we will take a look at the steps Database Administrators need to follow in order to perform a backup and restore of a FILESTREAM database.
Sparse Columns – ConvertSVtoXML & XMLToResv
Not very often I run across something with zero matches in a search engine, but had it happen recently. I had set up a simple demo of a sparse column set and happened to look at the execution plan, was interested to see that the Compute Scalar was backed by ConvertSVtoXML. This was on a select from a table with one row, and then, being a little more curious, updated it with an xml fragment I saw a call to ConvertXMLtoResv. I’d venture that those serve to convert back/forth from XML storage.
Great DBA’s in History
What great historical figures would make great DBAs? A guest editorial from Grant Fritchey examines the traits and characteristics we look for in this role and which famous people we might choose and why.
Databases in the Cloud: Elysian Fields or Briar Patch?
The cornucopia of products for handling distributed data in the cloud includes everything from lightweight key-value stores to industrial-strength databases
Great DBAs in History
What great historical figures would make great DBAs? A guest editorial from Grant Fritchey examines the traits and characteristics we look for in this role and which famous people we might choose and why.
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers