Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works. Database ...

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

Take advantage of the mission-critical capabilities in SQL Server 2016 for real time operational analytics, rich data visualizations and improved data security SQL Server is Microsoft’s flagship ...

String interpolation is a technique that enables you to insert expression values into literal strings. It is also known as variable substitution, variable interpolation, or variable expansion. It is a ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...

Russell Smith is a technology consultant and trainer specializing in management and security of Microsoft server and client technologies. He is a Microsoft Certified Systems Engineer with more than 15 ...

Helping & empowering business owners for over 15 years, helping them to understand how to protect own interests, build bridges to amplify joint ventures, adapting new business practices and solutions.

I had the pleasure to spend some time with my old friend at Microsoft, Mark Souza, while speaking at the SQL Saturday event in Dublin, Ireland. Now keep in mind that Mark and I have known each other ...