SQL Server

Microsoft Consolidates SQL Server Technical Content into a Single Support Blog

Microsoft teams are continuing to consolidate its resources and efforts and participate solely in a couple areas. For documentation, there’s the Docs platform (docs.microsoft.com). For community, it’s the Tech Community web site (techcommunity.microsoft.com). The latest team to begin migrating content is the SQL Server support team. We are excited to announce the launch of the new SQL Server Support blog and welcome you to this space. This blog space will focus on deep technical content related to the SQL Server product and features. The content of this blog will come from experts in the support team who provide troubleshooting guidance and advice to SQL Server customers. Bookmark this link: https://techcommunity.microsoft.com/t5/SQL-Server-Support/bg-p/SQLServerSupport RSS fee...

Your First Chance to Go Deep-dive with SQL Server 2019

Microsoft Ignite is an awesome opportunity to get to know Microsoft’s vision for its next products. But, it’s difficult to get deep-dive instruction on the newly christened products and services and most of the recorded sessions are still pretty high level. IT/Dev Connections is the first chance most will get to work with the announced products and services. Each year, immediately following Microsoft Ignite, the IT/Dev Connections speakers quickly update their session abstracts to include the content about the new products that they were under obligation or NDA not to talk about until announced at Ignite. Here’s a great example… Bob Ward, Principal Architect at Microsoft, will be delivering sessions at IT/Dev Connections on SQL Server.  Prior to Ignite, his sessions...

Microsoft Releases Fix for August’s Botched SQL Server Update that Slipped Past QA

As we reported, Microsoft released its second known bad update this month that it subsequently recommended uninstalling – but this time for SQL Server. At the time of the admission, the company suggested that it was working on a fix. That fix is now available and can be downloaded from here: Security Update for SQL Server 2016 SP2 CU (KB4458621) Executing a specially crafted query involving calculating difference between values of different date types and aggregation of the results, could lead to stack corruption, if the query runs in batch mode. Depending on particular values processed by such query, this could lead to terminating the SQL Server process, or a possibility of remote code execution. More information about the vulnerability can be found here: SQL Server 2016 SP2 CU  The...

Botched SQL Server 16 SP2 CU Sneaks Through and Microsoft Recommends Uninstalling

UPDATE: Microsoft has now released a fixed update for this issue: Security Update for SQL Server 2016 SP2 CU (KB4458621) Original article… Microsoft has already suggested one update from this month should be uninstalled – now here’s another. In a blog post announcement, the company says… On Tuesday August 14, we published a Security Update for six different releases of SQL Server 2016 and 2017. For one of those releases, SQL Server 16 SP2 CU (KB4293807), we inadvertently published additional undocumented trace flags that are normally not on by default. We are working on replacing the update in the next few days. If you installed KB4293807 and are experiencing issues please uninstall the update until the replacement update (KB4458621) is available.   Looking for...

Tip: Improving SQL Performance for Configuration Manager Database Queries

A more common problem has recently surfaced that causes certain ConfigMgr database queries to time out or slow the admin console to a crawl. The problem is due to changes in SQL Server Cardinality Estimation (CE) changes. Essentially, Microsoft has made updates to  SQL Server 2014, SQL Server 2016 and SQL Server 2017 that require some additional configuration for ConfigMgr environments when the database software is upgraded instead of installed from scratch. Fresh installations will be automatically configured according to the new specs. The article SQL query times out or console slow on certain Configuration Manager database queries details the issue and offers fixes. The issue can affect System Center Configuration Manager (current branch), SQL Server 2017 on Windows (all editions), SQL ...

Microsoft Will Extend SQL Server and Windows Server Support if Customers Move to the Cloud

Microsoft has devised yet another scheme to get customers to move to its Azure cloud service. For SQL Server 2008 (EOL, July 9, 2019) and Windows 2008 (EOL, January 14, 2020) customers, by hosting their workloads in Azure, Microsoft will get an extra 3 years of support and discounts for Azure. SQL Server 2008 Rehost your SQL Server 2008 and 2008 R2 with no application code changes in Azure Virtual Machines Get three years of Extended Security Updates at no additional charge, and upgrade to a current version when ready Use existing licenses and save up to 55 percent on migrations to Azure SQL Database with Azure Hybrid Benefit   Windows Server 2008   Rehost Windows Server 2008 and 2008 R2 workloads to Azure Get three years of Extended Security Updates at no additional charge, and ...

Microsoft Announces GA of Azure SQL Data Sync

Microsoft has now taken the public wraps off its sync service that allows organizations to store SQL Server data in two locations – both on-premises and in the cloud. This gives organizations redundancy should a connection to Azure be faulty or down. It allows companies to take a hybrid approach to storing and using SQL Server data. We are delighted to announce the general availability (GA) of Azure SQL Data Sync! Azure SQL Data Sync allows you to synchronize data between Azure SQL Database and any other SQL endpoints unidirectionally or bidirectionally. It enables hybrid SQL deployment and allows local data access from both Azure and on-premises application. It also allows you to deploy your data applications globally with a local copy of data in each region, and keep data synchroni...

Microsoft SQL Server 2016 Service Pack 2 Now Available

Overnight, Microsoft has released the next big update for its latest SQL Server database platform. Microsoft SQL Server 2016 service packs are cumulative updates. SQL Server 2016 SP2 upgrades all editions and service levels of SQL Server 2016 to SQL Server 2016 SP2. In addition to the fixes, SQL Server 2016 SP2 includes hotfixes that were included in SQL Server 2016 Cumulative Update 1 (CU1) to SQL Server 2016 SP1 CU8.   SQL Server 2016 SP2 Download the package now. SQL Server 2016 SP2 Express Download the package now. Microsoft SQL Server 2016 SP2 Feature Pack Download the package now. Looking for an awesome, no-nonsense technical conference for IT Pros, Developers, and DevOps? IT/Dev Connections kicks off in Dallas, Texas in 2018!

SQL Community Family Member Passes, GoFundMe Campaign Setup to Help the Family

SQL Community member, Robert Davis (@SQLSoldier), passed away suddenly this week. Robert has helped so many with his knowledge and expertise, the community is recommending helping his family. A GoFundMe campaign has been setup for those willing to give back to someone who gave so unselfishly. IT/Dev Connections speaker, Grant Fritchey, made this plea on YouTube today…   Looking for an awesome, no-nonsense technical conference for IT Pros, Developers, and DevOps? IT/Dev Connections kicks off in Dallas, Texas in 2018!

SQL Operations Studio Updated with Three New Features, Two Bug Fixes

Microsoft has now delivered the January 2018 update for SQL Operations Studio. SQL Operations Studio is still in preview. SQL Operations Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB, and SQL DW from Windows, macOS, and Linux. Here’s what’s new: Enable the HotExit feature to automatically reopen unsaved files. Add the ability to access saved connections from Connection Dialog. Set the SQL editor tab color to match the Server Group color. Fix the broken Run Current Query command. Fix the broken pinned Windows Start Menu icon.   Download the update: https://docs.microsoft.com/en-us/sql/sql-operations-studio/download   Looking for an awesome, no-nonsense technical conference for IT Pros, Developers, and DevOps? IT/Dev Connections...

PSA: Hold Off Patching SQL Server for Meltdown/Spectre if Running ConfigMgr

UPDATE: Microsoft has now supplied additional information on this potential issue here: Microsoft Releases Additional Guidance for Configuration Manager and Speculative Execution   Original article… David James, Director of SCCM Engineering at Microsoft has Tweeted a warning about the updates that are available that patch SQL Server against the major processor vulnerability. If you haven’t yet patched your #SCCM DB’s SQL server for this week’s intel issue… maybe wait a little bit. We are investigating issues where that patch might be breaking SCCM+Sql functionality. — david james (@djammmer) January 5, 2018   James is promising a full update (blog post or doc) hopefully later today.   Looking for an awesome, no-nonsense technical conference for ...

December Update for SQL Operations Studio Available

Microsoft has now delivered an update for SQL Operations Studio that fixes bugs and brings new functionality. SQL Operations Studio (preview) is a free tool that runs on Windows, macOS, and Linux, for managing SQL Server, Azure SQL Database, and Azure SQL Data Warehouse; wherever they’re running. Download and install SQL Operations Studio Release Notes   Looking for an awesome, no-nonsense technical conference for IT Pros, Developers, and DevOps? IT/Dev Connections kicks off in Dallas, Texas in 2018!

  • 1
  • 2
  • 7