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 ...
Fix SQL Server connection problems If you are a developer experiencing “Connect to Server” errors using SQL Server Management Studio on your local machine or development box, consult the checklist ...
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?
Microsoft announced on Oct. 30 that it expanded SQL Server passive use rights for organizations licensing SQL Server with Software Assurance (SA) coverage. Organizations with SA coverage on SQL Server ...
StreamSets, provider of a DataOps platform, is supporting and integrating its platform for Microsoft’s recently announced SQL Server 2019 Big Data Clusters. With this integration, SQL users are ...
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 ...
Determine when to use stored procedures vs. SQL in the code Your email has been sent Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one ...