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 Blog
Options
2,839

Deploy Always On Availability Groups (AG) on SQL Server RHEL based Azure VMs - The Ansible Way!

amvin87 on Sep 02 2022 08:43 AM
1) Setting up and Configuring pacemaker cluster on three SQL Server RHEL based Azure VMs. 2) Configuring and deploying S...
3,008

Announcing SQL Server on Ubuntu Pro in Azure Virtual Machines

amvin87 on Nov 02 2021 09:03 AM
Announcing SQL Server on Ubuntu Pro in Azure Virtual Machines
3,415

Announcing GA of adutil-A tool to ease configuration of AD authentication for SQL on Linux/Container

amvin87 on Oct 01 2021 09:18 AM
Announcing General Availability of adutil - A tool to ease the process of configuring AD authentication for SQL On Linux...
19K

Deploy SQL Server – The Ansible way!

amvin87 on Jul 28 2021 08:15 AM
Automate SQL Server deployment on Linux using Ansible based system roles.
2,843

SQL Server 2019 on Ubuntu 20.04,python2 dependency removed for SQL Server 2019 across distributions.

amvin87 on Apr 07 2021 10:58 AM
SQL Server 2019 now available on Ubuntu 20.04 and no more python 2 dependency for SQL Server 2019 across distributions!
3,355

Watch and learn about SQL Assessment API and SQL Assessment Extension

EbruErsan on Feb 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...
9,757

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

amvin87 on Jan 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...
4,286

Exploring Azure SQL Managed Instance Management Pack

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

What is MaxDOP controlling?

Pedro Lopes on Jul 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...
3,367

It just works - Backup compression on TDE databases

Pam Lahoud on Jul 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...
3,396

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

Tejas Shah on Apr 13 2020 12:24 PM
SQL Server 2017 adds support for Red Hat Enterprise Linux 8 and Ubuntu 18.04
4,512

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

Tejas Shah on Mar 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...
7,189

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

Tejas Shah on Mar 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...
7,565

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

Tejas Shah on Jan 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...
3,388

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

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

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

EbruErsan on Dec 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...
8,314

Released: SQL Server Management Pack (7.0.20.0)

EbruErsan on Dec 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...
7,020

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

Tejas Shah on Dec 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...
5,646

Internals of TDE Encryption scan

goramesh on Dec 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...
7,081

Released: SQL Assessment API (GA)

EbruErsan on Nov 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...

Latest Comments

Adrian_Rupp
in Part 4 - SQL Server TDE and Extensible Key Management Using Azure Key Vault on Mar 28 2023 03:42 PM
So the credential that was created (is Step 4) is associatedwith the TDE_Login (in Step 9). It is the credential that SQL uses to contact AKV. Via the Azure Active Directory Application (from Part 2) This whole process is confusing and complicated. (Written years ago - way before my time). I've trie...
0 Likes
EricHe2020
in Part 4 - SQL Server TDE and Extensible Key Management Using Azure Key Vault on Mar 27 2023 12:19 PM
Adrian: Thanks so much for your reply. I understand TDE_Login is tied to credential linked to Asymmetric key, but TDE_Login is used by what to contact AKV? by application? I read your posting multiple times, seems that once the database TDE is turned on, there is nothing to config, right? there is n...
0 Likes
Adrian_Rupp
in Part 4 - SQL Server TDE and Extensible Key Management Using Azure Key Vault on Mar 27 2023 11:27 AM
Hello EricHe2020; Sorry for the delay in getting back to you, I've been out on leave for a few months. You are correct, this is not a login used for logging in to the server by a user. It is a login for the credential that is tied to an ASYMMETRIC Key. That is then used to contact AKV. This is a lot...
0 Likes
Ekhaat
in How and Why to Use Parameterized Queries on Mar 23 2023 09:18 AM
What if you need conditional parameters like textbox(id="txtName", Prompt="Filter by Name") strSQL = "SELECT * FROM tblNames "if txtName <> "" Thenparam = txtNamestrSQL &= "WHERE Name LIKE ?"end if ds = sqlsrv_query(conn, strSQL , param)(don't mind the syntax)Would that work?
0 Likes
EricHe2020
in Part 4 - SQL Server TDE and Extensible Key Management Using Azure Key Vault on Mar 20 2023 07:04 AM
Andrian; Thx for the excellent post. can I ask what is purpose of this ? this login is not for users to login? --Create a Login that will associate the asymmetric key to this loginCREATE LOGIN TDE_LoginFROM ASYMMETRIC KEY EKMSampleASYKey;
0 Likes