<p>eWeek has an article up discussing the possibility of Microsoft including automatic patching in the next version of SQL Server. The article is unclear about what exactly this would entail, but it ...

Ahead of Microsoft Build (and a possible SQL Server announcement), let's break down what we know and speculate about what we don't. One topic that has come up in several conversations with customers ...

Everyone wants faster database queries, and both SQL developers and DBAs can turn to many time-tested methods to achieve that goal. Unfortunately, no single method is foolproof or ironclad. But even ...

A SQL Server expert gives his take on the absolute, No. 1, very worst thing IT pros can do when it comes to indexing. Consultant, author and Microsoft MVP Denny Cherry travels the world helping ...

Polybase, Query Store, dynamic data masking, row-level security, and temporal data JSON support -- just some of the new features that veteran SQL Server Live! presenter Leonard Lobel covers in this ...

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 ...

You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here’s how you can do so by using SQLAgentReaderRole in SQL Server. We may earn ...

I'm trying to add to a table in SQL Server by creating a connection in VB.NET. The table has very many columns. I can currently open the connection and write just fine, but I'm not sure I'm doing it ...