Ever since Microsoft introduced SQL Server Stretch Database in 2016, our guiding principles for such hybrid data storage solutions have always been affordability, security, and native Azure ...

The automation of repetitive tasks has become part of today’s workplace, whether CPAs are engaged in industry, governmental, not-forprofit, or public accounting. This automation can consist of ...

A (somewhat opinionated) list of SQL tips and tricks that I've picked up over the years. There's so much you can do with SQL but I've focused on what I find most useful in my day-to-day work as a data ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

When I joined the SQL Tools team as a PM back in October 2018, my top priority was to release SQL Server Management Studio (SSMS) 18. I expected a fair amount of work but didn’t realize how ...

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client. SQL Server ...

SQL Server Management Studio (SSMS) is the principal interface for working with Microsoft SQL Server. However, many subtleties of this powerful tool evade even the most seasoned professionals. Here ...

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.