This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them. Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Practical use cases for finding a maximum matching are quite obvious--for example, maximum utilization of agents. But what could be practical use cases for finding a maximal matching? Here's what you need to know.

August 12, 2017 marked the first day of Tech Outbound’s SQL Cruise Alaska. After 3 years away, SQL Cruise returned to Seattle under hazy skies from the forest fires burning in Central British Columbia.

If you’ve been following this series, you know that in part one, I addressed reasons for upgrading to Microsoft SQL Server 2016, as well as some pre-upgrade tasks to be mindful of, and in part two, I focused on tasks that should take place...

SQL Server Agent allows you to create a virtual team of DBAs to work when you can’t – i.e. 24 hours per day, seven days per week. It allows you to schedule jobs to fire on any schedule you can conceive and as the SQL services come online.

Microsoft has been on a rapid clip of releasing new SQL Server focused products and plugins as they also continue to move strongly forward with their scale-out to Linux and continued leadership in cloud data with Azure SQL Database and Azure SQ...

In the first post of this series on upgrading to Microsoft SQL Server 2016, I addressed reasons for upgrading, as well as some pre-upgrade tasks to be mindful of. In this installment, I’m going to focus on tasks that should take...

Those of you who are regular readers may notice that my content has shifted towards scripting and some of the emerging platforms and tools for interacting with Microsoft SQL Server. There is a method to this madness but I can’t go into details ...

In a recent article I presented you with an option for searching for any string of t-sql text inside your stored procedures; for that I used sys.syscomments. A point was raised by a reader that sys.syscomments, being a System Compatibility vi...