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 ...

By using a single tool like PowerShell, you can access your data wherever it is stored. It does not matter if it is in the cloud in an Azure SQL database or in an on-premises MS-SQL server, MySQL or ...

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 ...

It has been enhanced with each later version of the SQL Server database engine since SQL Server 2008. Extended Events has had a slow uptake in usage as there was no user interface available until ...

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...

Helps to resolve complex corruption-related errors Conclusion The SQL Server errors, like 823, 824, and 825, usually occurs due to corruption in pages in SQL database. In this article, we’ve covered ...

What are the advantages of using Access as the front end to a SQL Server database? For starters, it's likely that your client's users will be more familiar with it, and it's relatively easy to put ...

Every SQL Server database has at least two files; a data file and a transaction log file. The data file stores user and system data while the transaction log file stores all transactions and ...