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

A Technical Project Manager with expertise in agile methodologies, project planning, quality assurance, and more. SQL (Structured Query Language) is the universal language for managing and interacting ...

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.

A recent Crowdstrike blog post talked about how attackers were targeting a specific industry. What caught my eye was how they ensured that they were able to steal the ...