News

I have worked with SQL Server for many years now, back to Sybase SQL Server days and there has always been confusion over Logins and Users.
Patch Tuesday fixes 137 vulnerabilities, including critical flaws in SQL Server, Netlogon, Office, and the .NET Framework.
Built on the .Net platform, xSQL Object 1.5 supports SQL Server 2000 and requires .Net Framework 1.1 or later. Pricing starts at $199 for a single-user license; $499 for a 5-user license; and $999 ...
During the last few articles, we have covered the basics of working with SQL server using the Server Management Objects (SMO) and PowerShell. We have covered things such as viewing the state of ...
Open up new reporting options for your SQL Server with these PowerShell tips.
With end of support looming for Windows Server 2008 and SQL Server 2008, Microsoft has a new option for those users to keep getting security updates: By moving workloads to Azure.
Let me explain. Traditionally, SQL Distributed Management Objects (DMO) and SMO have been complicated enough to code that many DBAs stayed away from them.
In this three-part series, Bill Venners compares the traditional approach to defining client/server interaction, using protocols and documents, with Jini's strategy of using objects and interfaces ...
With SQL Server 2016, you can store JSON objects in your rows. Here’s how to work with JSON objects, including how to update them once you’ve found them.
The mssql extension for Visual Studio Code, used to support SQL Server connections and T-SQL editing, has been updated with IntelliCode functionality and a new Object Explorer, among other new ...