SQL Server


Security Patch Support Ends for SQL Server 2008/R2

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.

How To Quickly Test a SQL Connection with PowerShell

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.

Microsoft Readies Azure SQL, SQL Server 2019 Preview Improvements

Microsoft detailed a raft of improvements coming to its database products at this week's PASS Summit.

Creating an Azure SQL Database with PowerShell

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.

SQL Server 2014 SP3 Released

SQL Server 2014 Service Pack 3 (SP3) was announced on Wednesday, about two years after the release of SP2.

Microsoft To Issue SQL Server CUs Every Other Month

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.

SQL Server Problems Caused by Microsoft's July Windows Patches

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.

Microsoft Offers 3-Year Security Reprieve for Older Server Products

Microsoft is replacing its "Premium Assurance" support offering for SQL Server and Windows Server with a new Extended Security Updates program.

Advanced Threat Protection Rolls Out for Azure SQL

Microsoft has expanded its sprawling Advanced Threat Protection product line with "a new security package" designed for Azure SQL Database.

Microsoft Rolls Out SQL Server 2016 SP2

The second service pack of SQL Server 2016 is now available, Microsoft announced last week.

Microsoft Updates Azure SQL Database with New Migration Features

Recent updates to Microsoft's Azure SQL Database service include migration, high-availability and information protection options, and other improvements.

Working with Database Users and Roles Using PowerShell

While we've covered how to add users to the database, let's take it one step further and designate specific roles.

Creating a SQL Server Login Using PowerShell and SMO

PowerShell helps us to turn the time-intensive process of creating new users into a quick and easy task.

Introduction to SQL Server Management Objects with PowerShell

Open up new reporting options for your SQL Server with these PowerShell tips.

SQL Server 2012 Service Pack 4 Now Available

The final SQL Server 2012 service pack is now available for download.

SQL Server 2017 To Receive Monthly Updates

Once SQL Server 2017 is released, it will also arrive with a faster update release pace.

SQL Server 2017 Release Announced

SQL Server 2017 will be generally available next Monday, Oct. 2., Microsoft announced today at its Ignite conference in Orlando, Fla.

Creating an SSIS Catalog with PowerShell

Here's how to deploy SQL Servers in an organization with custom business intelligence.

SQL Server 2017 Release Candidate 1 Now Available

This week Microsoft took one more step towards SQL Server 2017 being commercially available with the release of the first release candidate.

Premium Assurance Plans Now Available for Windows Server and SQL Server

"Premium Assurance" coverage plans for SQL Server and Windows Server can now be purchased from Microsoft.

Most   Popular