Do you need to find out where the location of your SQL Server's database is? Here's a quick tip. Written by Arthur Fuller, Contributor. Contributor. March 4, 2004 at 12:45 a.m. PT.

Most Common Wait Types in SQL Server and What They Mean. ASYNC_NETWORK_IO—The async_network_io wait types point to network-related issues. They are most-often caused by a client application not ...

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

Microsoft on Wednesday announced the release of SQL Server 2019 release candidate (RC), but it was later updated to a new "refresh" verions (called "RC 1.1") per an August 29 post. The bits can be ...

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

Big warning - does the database you are copying from contain information about your customers (if you have such a concept).<BR><BR>If it does and you operate in the EU/US then you are almost ...