So, everything in this column is information I've surmised from looking at what's been going on with Azure SQL Database, which is the most common testing ground for new features, along with some ...

This wait type may also indicate the SPID is waiting for remote procedure calls, linked server queries, BULK INSERT commands, or full-search queries. PAGEIOLATCH_* —Buffer latches, including the ...

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

While some database workloads have migrated to the cloud—and the next version of SQL Server has more tools and integration with Azure services for backup or analytics to help with that if it’s ...

Variations on SQL are used by some of the most popular database tools in the world, including some of Oracle's database systems, MySQL, PostgreSQL and Microsoft's SQL Server.

MSDE, and its successor SQL Server 2005 Express, are still heavy-weight database engines. The download is large, the installation not entirely automated, and in the end you have a Windows service ...

Upsize data to SQL Server by creating an entirely new database on SQL Server without making changes to the actual MDB file. Access provides all the tools you’ll need for all three solutions ...

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

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 March 4, 2004 at 12:45 a.m. PT ...

I did not need actual data; an empty copy of the latest database would suffice. I could easily add a few test records for the demonstration after installing the database on my laptop. I created a copy ...