July 9 marked the end of "extended support" for SQL Server 2008 and SQL Server 2008 R2, the last five-year phase of Microsoft's overall 10-year product lifecycle for these products.
When creating automation scripts to discover, add, update or remove records from a remote SQL database, you need to make sure your script can successfully connect to the database.
- By Adam Bertram
- 12/10/2018
Microsoft detailed a raft of improvements coming to its database products at this week's PASS Summit.
When you need a SQL database fast, the cloud is the best way to go. Azure provides a SQL database as a PaaS that eliminates the need to get an entire SQL Server deployment up and running.
- By Adam Bertram
- 11/06/2018
SQL Server 2014 Service Pack 3 (SP3) was announced on Wednesday, about two years after the release of SP2.
Microsoft recently unveiled some SQL Server servicing changes affecting SQL Server 2017 and newer editions, including the upcoming SQL Server 2019, which just reached the preview stage last month.
Microsoft Premier customers can now begin using the company's Project VAST security product to create data visualizations of their organization's security landscape.
An announcement last week by Microsoft's Customer Service and Support team indicated that Windows patches from Microsoft's July 10 "update Tuesday" release may have caused SQL Server failures after reboot.
The Azure File Sync service, which Microsoft first unveiled at last year's Ignite conference and is designed to enable centralized file shares, is now generally available.
Microsoft is replacing its "Premium Assurance" support offering for SQL Server and Windows Server with a new Extended Security Updates program.
Microsoft has expanded its sprawling Advanced Threat Protection product line with "a new security package" designed for Azure SQL Database.
The second service pack of SQL Server 2016 is now available, Microsoft announced last week.
Both MySQL and PostgreSQL are now generally available on the Azure Database service, Microsoft announced recently.
Recent updates to Microsoft's Azure SQL Database service include migration, high-availability and information protection options, and other improvements.
While we've covered how to add users to the database, let's take it one step further and designate specific roles.