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
3,930

What’s New in Visual Studio Extensions for SSAS and SSRS

subhojitbasak on Dec 19 2022 05:35 AM
Learn more about the latest enhancements in Analysis Services Projects 2022 and Reporting Services Projects 2022
2,506

HADR_SYNC_COMMIT Wait Updates (In Progress)

BobDorr on Oct 03 2022 03:27 PM
HADR_SYNC_COMMIT Wait Updates (In Progress)
3,130

SQL Server Always on Availability Group Scalability Experiment and Result on Azure VM

zimwang_1993 on Feb 23 2021 08:42 AM
Today to meet the demands of fast business growth, many Tier 1 customers need to configure their Always On Availability ...
3,218

Released: Support for Distributed Network Names (DNN) Listeners for Always On Availability Groups

Kevin Farlee on Oct 19 2020 10:49 AM
We are pleased to announce support for Distributed Network Name based listeners in Availability Groups. As of SQL Server...
20.4K

Lift and Shift Always On SQL Server Failover Cluster Instance (SQL FCI) to Azure VMs

Mine Tokus on Jul 06 2020 09:51 AM
Today, we are announcing two new features enabling lift and shift of Always On SQL server Failover Cluster instances (SQ...
52.8K

SQL Server Licensing: High Availability and Disaster Recovery benefits

Amit Banerjee on Mar 05 2020 11:38 PM
Learn about how the new SQL Server High Availability and Disaster Recovery Software Assurance benefits can help you arch...
480

AlwaysOn Availability Groups: Comparing On-Premises Deployments and Azure VM Deployments

SQL-Server-Team on Mar 23 2019 01:24 PM
First published on MSDN on Feb 05, 2014 Cross posting from SQLCAT blog:http://blogs.
651

AlwaysOn Availability Groups, Listener, Named Instances, Port Numbers, etc.

SQL-Server-Team on Mar 23 2019 01:23 PM
First published on MSDN on Feb 05, 2014 Cross posting from SQLCAT blog:http://blogs.
339

AlwaysOn Availability Group in Windows Azure VM: Client Connectivity Scenarios

SQL-Server-Team on Mar 23 2019 01:23 PM
First published on MSDN on Feb 05, 2014 Cross posting from SQLCAT blog:http://blogs.
515

Published: Troubleshooting Guide for Availability Group Listener in Windows Azure

SQL-Server-Team on Mar 23 2019 01:23 PM
First published on MSDN on Jan 06, 2014 Before the holidays, this article was quietly published: http://msdn.
331

More Windows Azure E2E Scripts!

SQL-Server-Team on Mar 23 2019 01:22 PM
First published on MSDN on Dec 05, 2013 In case you're not already aware, I've written additional scripts for Windows Az...
287

Availability Group Listener in Hybrid IT: End-to-End PowerShell Script Published

SQL-Server-Team on Mar 23 2019 01:22 PM
First published on MSDN on Nov 22, 2013 Hello,Please check out the script at http://gallery.
421

Availability Group Listener in Windows Azure Now Supported! (And Scripts for Cloud-Only Configuration)

SQL-Server-Team on Mar 23 2019 01:21 PM
First published on MSDN on Aug 06, 2013 If you haven't noticed, AlwaysOn Availability Groups in Windows Azure now suppor...
699

AlwaysOn Availability Groups Troubleshooting and Monitoring Guide published!

SQL-Server-Team on Mar 23 2019 01:20 PM
First published on MSDN on Jun 06, 2013 AlwaysOn Availability Groups Troubleshooting and Monitoring Guide provides infor...
545

Upgrade and Update Guide for AlwaysOn Availability Groups published!

SQL-Server-Team on Mar 23 2019 01:19 PM
First published on MSDN on May 30, 2013 The upgrade/update guide for availability group servers is now live on MSDN.
1,166

Connecting to Availability Group Listener in Hybrid IT

SQL-Server-Team on Mar 23 2019 01:18 PM
First published on MSDN on Feb 14, 2013 In this blog, I'd like to explore client connectivity strategy when you have an ...
3,528

Test Lab: Create an AlwaysOn Availability Group in Windows Azure End-to-End

SQL-Server-Team on Mar 23 2019 01:15 PM
First published on MSDN on Jan 23, 2013 In this blog, you will learn how to configure AlwaysOn Availability Groups end-t...
431

HADR Tutorials for SQL Server in Windows Azure VMs

SQL-Server-Team on Mar 23 2019 01:01 PM
First published on MSDN on Dec 18, 2012 Hi Folks,For those interested in how to do SQL Server HADR in Windows Azure VMs,...
706

WSFC Cluster Configuration on Windows Azure Virtual Machines

SQL-Server-Team on Mar 23 2019 12:59 PM
First published on MSDN on Dec 03, 2012 Windows Azure Virtual Machines (VMs) are currently in preview at www.
1,283

How To: Migrate to AlwaysOn from Prior Deployments Combining Database Mirroring and Log Shipping – Part 2

SQL-Server-Team on Mar 23 2019 12:58 PM
First published on MSDN on Oct 16, 2012 Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May...
595

How To: Migrate to AlwaysOn AlwaysOn from Prior Deployments Combining Database Mirroring and Log Shipping – Part 1

SQL-Server-Team on Mar 23 2019 12:57 PM
First published on MSDN on Oct 16, 2012 Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May...
3,370

How To: Migrate from Failover Cluster Instances and Database Mirroring to SQL Server AlwaysOn – Part 3

SQL-Server-Team on Mar 23 2019 12:56 PM
First published on MSDN on Sep 28, 2012 Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May...
867

How To: Migrate from Failover Cluster Instances and Database Mirroring to SQL Server AlwaysOn – Part 2

SQL-Server-Team on Mar 23 2019 12:55 PM
First published on MSDN on Sep 28, 2012 Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May...
1,391

How To: Migrate from Failover Cluster Instances and Database Mirroring to SQL Server AlwaysOn – Part 1

SQL-Server-Team on Mar 23 2019 12:55 PM
First published on MSDN on Sep 28, 2012 Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May...
945

Migration Guide: Migrating to AlwaysOn Availability Groups from Prior Deployments Combining Database Mirroring and Log Shipping

SQL-Server-Team on Mar 23 2019 12:50 PM
First published on MSDN on Aug 20, 2012 Writer:Cephas Lin (Microsoft)Contributors: Sanjay Mishra (Microsoft)Technical Re...
1,170

AlwaysOn Architecture Guides

SQL-Server-Team on Mar 23 2019 12:49 PM
First published on MSDN on Jul 03, 2012 Newly published: two new architecture guides:AlwaysOn Architecture Guide: Buildi...
1,348

Quickly Setup SQL Server AlwaysOn Failover Cluster Instance (FCI) in Hyper-V

SQL-Server-Team on Mar 23 2019 12:49 PM
First published on MSDN on Jun 05, 2012 Author: Cephas LinContributors: Oleg Bulanyy Applies to: SQL Server 2008, SQL Se...

Latest Comments

Dragan_Radovac
in SQLCAT.com consolidated index of Whitepapers on Mar 28 2023 07:22 PM
Reading about the Diagnosing and Resolving Spinlock Contention on SQL Server, rather than spin, wouldn't it make more sense to have the threads queue for the resource ? By the way, great article
0 Likes
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