With over two decades of IT experience, Microsoft data platform MVP Thomas LaRock has seen nearly every SQL Server troubleshooting nightmare under the sun. In an upcoming session called "The Top 5 ...

In the world of SQL Server management, page-level corruption is an issue that can strike fear into the hearts of even the most experienced database administrators. When an 8 KB unit of data storage, ...

Ahead of Microsoft Build (and a possible SQL Server announcement), let's break down what we know and speculate about what we don't. One topic that has come up in several conversations with customers ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...

Data developers are still learning about all the new goodies that arrived with SQL Server 2022, which is chock full of new features and enhancements such as ledger for blockchain security. Microsoft ...