cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
SQL Server
Copied!
Home
Options
2,863

SQL Server 2019 on Red Hat Enterprise Linux 8 now Generally Available

Tejas Shah on 01-08-2020 10:07 PM
SQL Server 2019 CU1 is available on Red Hat Enterprise Linux 8 and as a UBI8 container. Read more about it here...
1,932

Updated process of configuring AD integrated authentication for SQL Server on Linux

Tejas Shah on 01-06-2020 10:30 AM
Configuring AD integrated authentication for SQL Server on Linux has been simplified and made into a single consistent p...
1,839

Released: Public Preview for Management Pack for SQL Server Reporting Services and Analysis Services

EbruErsan on 12-27-2019 01:32 AM
We are getting ready to update SQL Server Reporting Services and Analysis Services Management Packs (7.0.19.0). This rel...
3,753

Released: SQL Server Management Pack (7.0.20.0)

EbruErsan on 12-27-2019 12:54 AM
An updated version of SQL Server Management Pack is ready. It has many new features which are mostly based on your feedb...
2,507

Introducing Replication and Change Data Capture (CDC) for SQL Server 2017 on Linux with CU18

Tejas Shah on 12-12-2019 12:10 PM
While SQL Server 2019 is all over the news, SQL Server 2017 continues to introduce new capabilities to reduce functional...
2,389

Internals of TDE Encryption scan

goramesh on 12-10-2019 03:23 PM
Transparent Data Encryption (TDE) is a mechanism in SQL Server to secure the data and log files at rest by encrypting th...
2,290

Released: SQL Assessment API (GA)

EbruErsan on 11-06-2019 11:27 AM
SQL Assessment API is a new mechanism to evaluate configuration of your SQL Server for best practices. The API methods a...
5,193

SQL Server 2019 Standard Edition

Amit Banerjee on 11-05-2019 05:55 PM
On November 4th, we announced the General Availability of SQL Server 2019. As part of our General Availability announcem...
3,380

Released: SQL Assessment API (Public Preview 2)

EbruErsan on 09-30-2019 05:23 AM
SQL Assessment API is a new mechanism to evaluate configuration of your SQL Server for best practices. The API methods a...
2,748

Released: Public Preview Azure SQL Database Managed Instance Management Pack

EbruErsan on 09-23-2019 03:51 AM
This public preview release is for System Center Management Pack for Azure SQL Database Managed Instance. Download: Micr...
4,903

Non-Root SQL Server 2019 Containers

Vin Yu on 09-18-2019 10:00 AM
SQL Server 2019 containers makes it easier and simpler to work with data. In addition to the latest innovation and impro...
2,238

SQL Server CPU usage available in sys.dm_os_ring_buffers DMV starting SQL Server 2019 RC on Linux

Tejas Shah on 08-27-2019 11:43 AM
Starting SQL Server 2019 RC, sys.dm_os_ring_buffers returns correct CPU utilization for SQL Server on Linux, enabling mo...
9,805

Behind the Scenes on OPTIMIZE_FOR_SEQUENTIAL_KEY

Pam Lahoud on 08-16-2019 10:44 AM
In SQL Server 2019 CTP 3.1 a new index option was added called OPTIMIZE_FOR_SEQUENTIAL_KEY that is intended to address a...
3,122

Introducing Distributed transaction functionality on SQL Server 2017 on Linux starting with CU16

Tejas Shah on 08-02-2019 11:23 PM
Distributed transaction functionality is available with SQL Server 2017 on Linux starting CU16. Find out more about how ...
8,300

Introducing SQL Assessment API (Public Preview)

EbruErsan on 07-30-2019 12:55 AM
SQL Assessment API is a new mechanism to evaluate configuration of your SQL Server for best practices. The API methods a...
17K

Introducing UTF-8 support for SQL Server

Pedro Lopes on 07-02-2019 01:52 PM
SQL Server 2019 introduces support for the widely used UTF-8 character encoding. This has been a longtime requested feat...
7,931

What if the Actual Execution Plan was always available for any query?

Pedro Lopes on 04-03-2019 07:00 AM
In SQL Server 2019 CTP 2.4, there’s a new DMF sys.dm_exec_query_plan_stats that allows you to always access the last act...
4,325

Using xEvents to capture an Actual Execution Plan

Pedro Lopes on 04-01-2019 01:39 PM
If you still are working with SQL Profiler/SQL trace, welcome to the world of Extended Events (also known as xEvents or ...
1,176

Let’s talk about trace flags

Pam Lahoud on 03-23-2019 06:08 PM
First published on MSDN on Jan 14, 2019 One of the most confusing aspects of SQL Server configuration is often trace fla...
1,112

Replica Failover within the Secondary Availability Group in a Distributed Availability Group

SQL-Server-Team on 03-23-2019 06:08 PM
First published on MSDN on Jan 09, 2019 A distributed availability group (distributed AG) is a special type of availabil...
791

SQL Server 2017 on Linux: Support for third-party AD providers

SQL-Server-Team on 03-23-2019 06:02 PM
First published on MSDN on Nov 26, 2018 In the past, SQL Server on Linux has required SSSD to be configured for AD Authe...
1,469

Failover Detection Utility - Availability Group Failover Analysis Made Easy

Sourabh Agarwal on 03-23-2019 06:02 PM
First published on MSDN on Nov 19, 2018 To analyze the root cause for the failover of an Availability group, users are r...
2,951

String or Binary data would be truncated: replacing the infamous error 8152

Pedro Lopes on 03-23-2019 06:00 PM
First published on MSDN on Oct 24, 2018 In the recent announcement at Ignite 2018 on the release of SQL Server 2019 CTP ...
531

SQL Server 2019 CTP 2.0 New Features – Columnstore support for sp_estimate_data_compression_savings

Pam Lahoud on 03-23-2019 06:00 PM
First published on MSDN on Oct 22, 2018 Next up for new Storage Engine area features in SQL Server 2019 is an update to ...
523

SQL Server 2019 CTP 2.0 New Features – Introducing the Page Cracker (AKA sys.dm_db_page_info)!

Pam Lahoud on 03-23-2019 05:59 PM
First published on MSDN on Oct 16, 2018 Microsoft Ignite 2018 is fading away in the rearview mirror, but the excitement ...
570

SQL Server 2019 Preview

Amit Banerjee on 03-23-2019 05:58 PM
First published on MSDN on Sep 26, 2018 Earlier this week, we announced SQL Server 2019 Public Preview at Microsoft Igni...
591

Developer’s Choice: Hinting Query Execution model

Pedro Lopes on 03-23-2019 05:56 PM
First published on MSDN on Sep 19, 2018 Over the years you have read a number of blogs advocating for or against trace f...
383

SQL Server on Linux: ADAuth issues 3: Could not obtain information about Windows NT group/user ‘CONTOSO\user’

SQL-Server-Team on 03-23-2019 05:55 PM
First published on MSDN on Sep 06, 2018 AD authentication is a popular mechanism for login and user authentication.
350

SQL Server on Linux: ADAuth issues 2: Common AD Login Issues

SQL-Server-Team on 03-23-2019 05:55 PM
First published on MSDN on Sep 05, 2018 AD authentication is a popular mechanism for login and user authentication.
Latest Comments
DVKalashnikov
in Released: update for Kerberos Configuration Manager for SQL Server on 01-24-2020
Thanks for the update, @Pedro Lopes !Support SQL Server 2019 is what was really missing in the previous version. Great job!
0 Likes
DVKalashnikov
in Released: SQL Server Management Pack (7.0.20.0) on 01-24-2020
Hi @mkmaster78,Thank you for giving us your feedback on the SQL MP, we really appreciate it!Actually, the web-dashboards in SQL MP is in a beta status now. Currently, we're working on performance improvements and adding a load-indicator for dashboard tiles - that's why you can see nothing when click...
0 Likes
neilc
in Optimize TCO with new SQL Server Software Assurance Benefits for Disaster Recovery on 01-23-2020
Presumably this only applies if the OSE is dedicated to HA or DR and not being used for say development / testing?
0 Likes
Mine Tokus
in Optimize TCO with new SQL Server Software Assurance Benefits for Disaster Recovery on 01-23-2020
Correct. For 8 cores of primary Standard or Enterprise edition license; 8 cores of passive HA and additional 8 cores of passive DR is at no cost.
0 Likes
mkmaster78
in Released: SQL Server Management Pack (7.0.20.0) on 01-23-2020
Great Work!Thanks for adding in an HTML5 dashboard, much appreciated. I did notice a few issues with the dashboard, but they totally could be on my end, but if you could let me know, I'd appreciate it.1) Even though it looks like a clickable link, the status panels cannot be clicked. If you do click...
1 Likes