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

  • 1,385 Blog Articles
Options
821

Watch and learn about SQL Assessment API and SQL Assessment Extension

EbruErsan on 02-23-2021 03:16 AM
If you are curious about how to easily determine if your SQL is following best practices guidelines, you can watch the D...
2,657

Deploy SQL Server on Azure Kubernetes Service cluster via Helm Charts - on a windows client machine!

amvin87 on 01-04-2021 07:45 AM
A brief snapshot of the conversation that my colleague and I had a couple of weeks ago: Colleague: "I am new to Kubernet...
3,390

Exploring Azure SQL Managed Instance Management Pack

EbruErsan on 07-21-2020 05:52 AM
We released System Center Operations Manager Management Pack for Azure SQL Managed Instance recently. It provides compre...
11.2K

What is MaxDOP controlling?

Pedro Lopes on 07-07-2020 07:00 AM
The Max Degree of Parallelism, or MAXDOP, is one of the most known settings in the SQL Database Engine. There are guidel...
2,185

It just works - Backup compression on TDE databases

Pam Lahoud on 07-01-2020 10:00 AM
Starting with SQL Server 2019 CU5, you no longer need to specify MAXTRANSFERSIZE >64KB to enable backup compression on a...
2,839

SQL Server 2017 adds support for Red Hat Enterprise Linux 8 and Ubuntu 18.04

Tejas Shah on 04-13-2020 12:24 PM
SQL Server 2017 adds support for Red Hat Enterprise Linux 8 and Ubuntu 18.04
3,519

SQL Server 2019 images with current Linux distribution support available in Azure marketplace

Tejas Shah on 03-25-2020 08:37 AM
The SQL Server team is glad to announce that the Azure marketplace PAYG (Pay As You Go) images for SQL Server 2019 on RH...
4,405

SQL Server 2019 now available on Ubuntu 18.04, supported on SLES 12 SP5

Tejas Shah on 03-17-2020 03:11 AM
Starting with Cumulative Update 3, SQL Server 2019 is now generally available on Ubuntu 18.04, which includes a native U...
5,554

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...
2,946

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...
2,768

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...
6,821

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...
4,965

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...
3,598

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...
4,083

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...
12.9K

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...
4,001

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...
3,447

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...
9,537

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...
4,717

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...
25.2K

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,938

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 ...
9,669

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...
61K

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...
9,416

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...
7,611

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,610

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,479

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...

Latest Comments

John_Kim
in Dynamic SQL & SQL injection on 02-21-2021
Hi,Thank you for sharing.Here is another great article about SQL Injection, Please visit - SQL Injection
0 Likes
John_Kim
in Blocking automated SQL injection attacks on 02-21-2021
Hi,Thank you for sharing.Here is another great article about SQL Injection by dot net guide - https://www.dotnetguide.com/sql-injection/
0 Likes
smilne
in Cumulative Update #16 for SQL Server 2016 SP2 on 02-11-2021
Does CU16 also include a security update for the below vulnerability? CVE-2021-1636 - Security Update Guide - Microsoft - Microsoft SQL Elevation of Privilege Vulnerability I don't see this mentioned in the CU16 KB article.
0 Likes
d_reategui
in Microsoft Drivers 5.9.0 for PHP for SQL Server Released on 02-05-2021
Hi,I just installed SQLSRV 5.9.0 in xampp and updated the server's ODBC Driver to the latest version 17.6.1.1 and I still getting the same result, I mean connection can't be stablished and some warnings about the driver (like the one that you mentioned in "known issues").In other machines with previ...
0 Likes
BryanHarper
in Step by Step Guide to Setup LDAPS on Windows Server on 02-04-2021
So ldp will connect if I use the computer name, but not the IP. Any ideas on what I need to do to get that to work?
0 Likes
Blog Dashboard