Security is a longstanding priority for Microsoft across its products and offerings. In fact, SQL Server has pro­duced the fewest security vulnerabilities of all the major database platforms for many ...
Microsoft announced a lot of Azure SQL news at Ignite this month, but few as critical to application development security than the public preview of Always Encrypted with secure enclaves. Here's how ...
One reoccurring SQL Server question that I see: Why is my TempDB database so large and what can I go to reduce the size of TempDB? The answer requires some basic understanding of the internals of how ...
On and off, over the years, I have followed and written about the SQL-on-Hadoop saga. The adventure started with Apache Hive, which originally provided a SQL layer on top of MapReduce, bringing new ...
Where other database vendors require you to purchase an entirely separate in-memory database engine, Hekaton is built right into SQL Server. It achieves blazing performance by storing tables in main ...