The open source MySQL spin-off has steadily added features all its own. Here are five good reasons to switch to MariaDB. MariaDB may have started as a MySQL fork, following Oracle’s acquisition of ...

Who are these scripts for? You need to troubleshoot performance problems with SQL Server, and you need to do it now. You don't have time to track down a bunch of DMVs, figure out Extended Events, ...

With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work. Today, at Ignite, Microsoft announced the general availability of SQL ...

Why is the language developers and DBAs use to organize data such a mess? Here are 13 reasons we wish we could quit SQL, even though we probably won't. For all its popularity and success, SQL is a ...

Database administrator with 14+ years of hands-on experience in database management and database design. I still remember the morning our CTO walked into our weekly team meeting and dropped the bomb: ...

This system stored procedure takes a table name as a parameter and generates a MERGE statement containing all the table data. This is useful if you need to migrate static data between databases, eg.

Author’s note: this blog has been updated with a link to the Request – Response method. Users who want to execute a SQL stored procedure in Flow can now send its resulting array into PowerApps. The ...

Data has become the lifeblood of the enterprise. It’s the foundation for keen insight and effective decisions that lead to business growth. One of our primary design goals for SQL Server 2016 was to ...