Stairway to AlwaysOn Level 5: Analyse and Deploy a Failover Cluster Instance (SQLServerCentral 3/20/2019)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [Stairway to AlwaysOn Level 5: Analyse and Deploy a Failover Cluster Instance]( - [Free eBook: Inside the SQL Server Query Optimizer]( - [Transfer Data to the Cloud Using Azure Data Factory]( - [Using Indexing To Solve Blocking and Deadlocking Issues]( (From the SQLServerCentral Blogs) - [Disabling and enabling triggers]( (From the SQLServerCentral Blogs) The Voice of the DBA How Virtualized? This editorial was originally published on May 5, 2015. It is being re-run as Steve is out of town. I went to a talk recently where I saw this statistic: "50% of all workloads were virtualized in 2009. That number is 72% today." That's a really big number, at least in my mind. That implies the vast majority of all servers, file, print, database, email, etc. are virtualized. Inside of companies that have their own data centers and machines, they must be heavily virtualized. I'm sure that all those instances in the "cloud" also count, but still, 72%? That's big. However I'm sure that's skewed towards those machines that don't require a lot of resources, like file and print servers, DNS hosts, etc. This week, I thought I'd see what the percentage is inside of your organization. What percentage of your SQL Servers are virtualized? Give us numbers of physical v virtual if you can. I'd combine all instances, from development to test to production, not worrying about size or workload. If you have a single guest on a host, using almost all the resources, that's a virtual server. My suspicion is that the percentage of SQL Servers is much lower than that of other workloads, but I'm curious. With the low overhead of modern hypervisors, and the free (or low) cost, it makes sense to virtualize servers. If for no other reason than to remove any weird hardware dependencies for DR purposes. However I'm sure that there are large workloads that require more resources than the current hypervisors can expose, at least for some database instances, and those need to remain on physical machines, but my guess is more often than not, it's the human concerns or lack of confidence that prevents virtualization. Let us know this week how your organization is doing in the trend towards virtual servers. Steve Jones from [SQLServerCentral.com]( Join the debate, and [respond to today's editorial on the forums]( ADVERTISEMENT [Data Masker]( Redgate Acknowledged as Representative Vendor in 2018 Gartner Market Guide Data Masking has come of age and Gartner’s?2018 Market Guide for?Data Masking includes analysis, recommendations and representative vendors to help you start your data masking journey on the right foot. [Get your complimentary copy now]( [SQL Provision]( SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps With SQL Provisions virtual cloning technology, databases can be created in seconds using just 1MB of storage, and sensitive data can be anonymized or replaced with realistic data to ensure it is protected as it moves between environments. [Download your free trial]( Featured Contents  [] [Stairway to AlwaysOn Level 5: Analyse and Deploy a Failover Cluster Instance]( Perry Whittle from [SQLServerCentral.com]() In Level 5 of this stairway, we help you understand and deploy a Failover Cluster Instance (FCI).[More »]( ---------------------------------------------------------------  [] [Free eBook: Inside the SQL Server Query Optimizer]( Press Release from [SQLServerCentral.com]() This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.[More »]( ---------------------------------------------------------------  [] [Transfer Data to the Cloud Using Azure Data Factory]( Additional Articles from [MSSQLTips.com]( In this tip we look at how to configure Azure Data Factory to move data from an on-premises SQL Server database to an Azure SQL Database.[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Using Indexing To Solve Blocking and Deadlocking Issues]( david.fowler 42596 from [SQLServerCentral Blogs]( A while back, I was having a conversation about a deadlocking issue and suggested that an index could perhaps help...[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Disabling and enabling triggers]( Kenneth Fisher from [SQLServerCentral Blogs]( I tend to feel that a lot of people who use triggers don’t really understand them. That said, every now...[More »]( Question of the Day Today's Question (by Steve Jones): I have this set comprehension. a = {x%2 for x in range(10) if x % 2 == 0} How many elements are in the final set? Think you know the answer? [Click here](, and find out if you are right. --------------------------------------------------------------- We keep track of your score to give you bragging rights against your peers. This question is worth 1 point in this category: Python. We'd love to give you credit for your own question and answer. To submit a QOTD, simply log in to the [Contribution Center](. Yesterday's Question of the Day Yesterday's Question (by Steve Jones): Which of these Microsoft IDEs has an integrated terminal built into the product that allows you to run command line executables from the tool? Answer: VS Code and Azure Data Studio Explanation: Visual Studio Code and Azure Data Studio have integrated terminals. SSMS does not, and Visual Studio does not come with one, but there are extensions that will allow one to run inside Visual Studio. Ref: Integrated Terminal (VS Code) - [click here]( Integrated Terminal (ADS) - [click here]( --------------------------------------------------------------- [» Discuss this question and answer on the forums]( Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- [SQL Server 2017]( : [SQL Server 2017 - Administration]( [Do I need to add my SQLserver agent service account as a login]( - A question about SQL Server agent service account. I am using SQL server 2017. We have a windows domain account (for... ["SQL Server Windows NT - 64 bit" in Task Manager: CPU high]( - hi, I have setup a new VM (VMware) with latest Windows 2019 Server Standard (as domain), Sharepoint 2019 Enterprise and SQL... [Pitfalls of cross-database views?]( - Hi, I currently work for myself and provide IT services to a hedge fund with around ~30 traders and analysts who... --------------------------------------------------------------- [SQL Server 2017]( : [SQL Server 2017 - Development]( [SSMS Ctrl+U Shortcut]( - For as long as I can remember, Ctrl+U takes you to the list of databases on the server, allowing you... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Development and T-SQL]( [Cast of Sceientific notation different result on different SQL version]( - Hi, i got a question today and I just can figure out an answer. When casting a Sceientific notation to Numeric(32,16)... [SP with Conditional Where clause where]( - I need to create a stored procedure with an optional where clause and I'm just not sure how to get... --------------------------------------------------------------- [SQL Server 2014]( : [Development - SQL Server 2014]( [Change in row values identification]( - Dear Fellows, How could be find the records where specific values/field changed. In the sample table we need to find those... [Get the distinct records which having same date with different time stamp.]( - Hi Team, Need some on the below requirement. I have the table and data like below. create table trend ( keyinstn INT, ratingdate datetime, rating varchar(10)) insert into... [Select latest and 2nd latest date rows per user]( - I have the following query to select rows where the LAST_UPDATE_DATE field is getting records that have a date value... --------------------------------------------------------------- [SQL Server 2012]( : [SQL 2012 - General]( [Help me with the SQL - ( Issue with excluding nearby visits )]( - Good Day Folks!     I need a listing of members who had a hospital visit.     Please omit any visits that are within 30... [Varchar(Max) storage]( - Dear Experts, Have a confusion regards to the storage capacity of varchar(max). My question is , when 8000 bytes (the whole page)... --------------------------------------------------------------- [SQL Server 2012]( : [SQL Server 2012 - T-SQL]( [Split strings by space into individual rows]( - Hi, String operations are one of my weakest areas in SQL. My requirement is to split strings separated by spaces with... [Convert xml column data from x and shred the elements into a tabular structure.]( - I am looking to have the xml column converted into a table. Basically shred the xml into columns. I am... [trimming SSNs]( - I have thousands of social security numbers I need to trim to leave only the last 4 digits... it is... [Parse string based on a list of values]( - Rather that use a bunch of replace functions, is there a better way to parse these values, CH,HC,MA,NH,OA,OTH,PSY,SNF, out of... --------------------------------------------------------------- [SQL Server 2008]( : [T-SQL (SS2K8)]( [Proper way of querying hierarchical data]( - Hi all, This one's gonna be a bit tough to properly explain, so if there's anything I can provide to help... --------------------------------------------------------------- [Reporting Services]( : [Reporting Services]( [Report Parameter to populate other Report Parameters]( - Hi, I've got a requirement to produce a series of reports that are exactly the same thing apart from they would... --------------------------------------------------------------- [Reporting Services]( : [Reporting Services 2008 Development]( [Allocate Meetings to Employees (randomly generated) with daily maximum hours set at 5]( - Hi all, I am currently working on a project where I need to allocate meetings to employees (randomly generated, E0,E1,E2,E3,E4,E5, F0,... --------------------------------------------------------------- [Data Warehousing]( : [Analysis Services]( [SSAS Cube (Multidimensional) Processing hangs / gets stuck after DB CL change]( - Today, after I changed the relational database that feeds the cube from compatibility level 100 (2008) to 120 (2014), the cubes... --------------------------------------------------------------- [Data Warehousing]( : [Data Mining]( [Netezza Query takes forever and eventually times out, can this be re-written to run quicker?]( - SELECT        SS.ITEM,SS.SHIPMENT, MAX(SS.PROCESS_DATE) PROCESS_DATE FROM SHIPMINTS SS         where SS.shipment > 14959039         and SS.QTY_RECEIVED is not null     &nbs This email has been sent to {EMAIL}. To be removed from this list, please click [here.]( If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. --------------------------------------------------------------- This newsletter was sent to you because you signed up at [SQLServerCentral.com](. Feel free to forward this to any colleagues that you think might be interested. If you have received this email from a colleague, you can register to receive it [here](. --------------------------------------------------------------- This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com