When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some third-party alternatives. I get to work with a lot of customers, so I get to see a lot of ...

With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work. Today, at Ignite, Microsoft announced the general availability of SQL ...

SAN MATEO, CA--(Marketwired - Oct 12, 2016) - SIOS Technology Corp. (www.us.sios.com), the industry's leading provider of software products that help IT ensure the performance, efficiency, and high ...

Expert Tips for Using SQL Server’s Extended Events and Notifications SQL Server offers plenty of details on problems that have already occurred. But what about potential issues lurking in the shadows?

In the AI era, we're constantly talking about how important data is—storing data, disseminating data, and protecting data. As data specialists, we understand bad data management leads to bad use of AI ...

In this white paper, Microsoft examine how capabilities built into Microsoft SQL Server including enterprise-grade performance, security, availability, and scalability define a new mission critical ...

A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way? But ...

Microsoft is integrating AI features directly into SQL Server for the first time. The new version also brings JSON support and changes the licensing model.