Microsoft has recently released a powerful new DMV specifically to help with memory issues, sys.dm_os_out_of_memory_events. It is currently available in Azure SQL Database and Azure SQL Man­aged ...

You've carefully crafted a concurrent application taking advantage of all the latest and greatest language features. It scales magnificently and it's the jewel of the cloud. But what about the ...

How to Attach an SQL Database to a Web Page. Your Web page can display up-to-date information dynamically -- all the time. And you never have to edit the page again. Attach your SQL database to ...

By performing these operations inside the database, what you are really doing is pushing application business logic down into the bowels of your database. You are taking this business logic out of ...

SQL Server Drill Down SQL Server Drill Down explores all aspects of Microsoft SQL Server and related applications, with a particular emphasis on issues of interest to SQL Server data professionals.

Microsoft this week announced various Azure SQL Database improvements, including migration, high-availability and information protection options.

Recent updates to Microsoft's Azure SQL Database service include migration, high-availability and information protection options, and other improvements.

The generated SQL is also always accessible. When you create database tables with Python objects, you use a class to declare the behavior of each field first, then its type.