During the last few articles, we have covered the basics of working with SQL server using the Server Management Objects (SMO) and PowerShell. We have covered things such as viewing the state of ...

When a Windows login is created, we can map it to a particular Windows User Account (not to be confused with SQL Server Database User Accounts; here’s where the confusion starts…) but usually ...

Types of SQL Server Database Corruption SQL page-level corruption: page-level corruption occurs when the information or data stored in the header, body, or slot array of a database page is altered ...

The world of the data professionals and DBAs is swirling with threats and risks, and those dangers are on the rise. You're probably accustomed to using longstanding database fea­tures to secure your ...

Joey on SQL Server Hands-On with Copilot for Azure SQL Database I've been playing around with the new Microsoft service, currently in preview and it's time to show off what it can do. By Joey D ...

There's a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative ...

Development hiring managers and potential interviewees may find these open-ended SQL Server proficiency interview Q&As useful.

SQL Server cannot start without TempDB (or master and model) and is massively dependent on it, for a large number of both system and user operations.

With the latest public preview available, it's time to see if you want to upgrade to the most cloud-connected version of SQL Server so far.