Resolve Network Binding Order Warning in failover cluster (SQLServerCentral 7/20/2017)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [Resolve Network Binding Order Warning in failover cluster]( - [Extending DevOps practices to SQL Server databases – Branching & Merging with VSTS]( - [Find Database Connection Leaks in Your Application]( - [Add new articles to existing Transactional Replication without initializing old articles]( (From the SQLServerCentral Blogs) - [SQL Server Rookie Mistakes]( (From the SQLServerCentral Blogs) The Voice of the DBA SSMS is Free Really, Management Studio (SSMS) is free as in beer. Go [download it today](. I got a note from a reader recently that was complaining about SSMS and the lack of MDI support. This individual mentioned that they would undock windows (something I never do) and if they minimzed the parent, the child windows all disappeared. I wondered if there were still issues with SSMS, so I fired up my version, undocked some windows and played around. Things worked as I expected, and every window was independent of the others. I had no issues working, though I did find I'd forget on which monitor a particular child window would appear. Last year (2016) we saw SSMS get released as a separate download for SQL Server. The tool has it's own release cycle, and we saw new updates every other month. As this development team at Microsoft got up to speed with the process and began improving and changing the product, we saw some rough release cycles, but things stabilized a bit late last year. The move to the Visual Studio 2017 shell with v17.x was nice, and I've found the latest version to be very stable and easy to use. After working with Enterprise Manager in my career, then moving to Management Studio and seeing the product languish over the years as SQL Server grew, I am pleased with the direction of SSMS. The [changelog]( is quite impressive, and I expect more things to be fixed and improved in the future. The team is more responsive, and while they won't fix everything I (or you) want, they are making progress. The new SSMS is not tied to any version of SQL Server. You can use it with SQL Server 2008 and later (though there are OS requirements). It will work with SQL 2000+, though there may be some issues. If you can, I'd say abandon whatever SSMS version you're using and get [the latest 17.1 release](. It works well, is stable, and has lots of fixes for previous issues. Plus, you won't need to apply those old 2008/2012/2014 patches to your workstation. Just update SSMS on your schedule. SSMS is free, and while some of us have known this for awhile, I regularly meet people still using the version that came with 2008, R2, 2012, etc. Go [download the latest bits]( today. This is the easiest SQL Server upgrade to justify. Steve Jones from [SQLServerCentral.com]( Join the debate, and [respond to today's editorial on the forums]( --------------------------------------------------------------- The Voice of the DBA Podcast Listen to the [MP3 Audio]( ( 4.1MB) podcast or subscribe to the feed at [iTunes]( and [Libsyn](. [feed]( The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. ADVERTISEMENT [SQL Clone]( SQL Clone: Now supporting databases up to 64TB Create copies of production databases and SQL backups in seconds and save up to 99% of disk space using SQL Clone. Redgate’s new tool removes much of the time and resource needed to create and manage database copies, allowing teams to work on local environments to develop, test and diagnose issues faster. [Try it free]( [SQL Compare]( The industry standard for comparing and deploying SQL Server database schemas Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. [Download your free trial]( Featured Contents  [] [Resolve Network Binding Order Warning in failover cluster]( Ganapathi varma Chekuri from [SQLServerCentral.com]() In this article, I’m going to show a procedure to resolve an issue that I found while running cluster validation report. you may receive below warning message that includes information about the cause of the warning, which can help you to resolve the issue.[More »](23SQLCluster+%23Failovercluster+%23Windowscluster/157658/) ---------------------------------------------------------------  [] [Extending DevOps practices to SQL Server databases – Branching & Merging with VSTS]( Join Microsoft Data Platform MVP Steve Jones for the next Database DevOps demo webinar on July 25. He’ll be plugging Redgate tools into Visual Studio Team Services and showing how you can branch and merge your database changes. Sign up now.[More »]( ---------------------------------------------------------------  [] [Find Database Connection Leaks in Your Application]( Additional Articles from [SQLPerformance.com]() Michael Swart shows how to investigate and fix database connection leaks, an application issue that can lead to connection timeouts.[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Add new articles to existing Transactional Replication without initializing old articles]( Dharmendra Keshari from [SQLServerCentral Blogs]( Suppose, you have Transactional Replication configured in your production environment. There is a business requirement to add a new article to the...[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [SQL Server Rookie Mistakes]( Arun Sirpal from [SQLServerCentral Blogs]( A quick elementary post which is my entry to this months’ T-SQL Tuesday entry hosted by a good friend SQLDoubleG...[More »]( Question of the Day Today's Question (by Steve Jones): When making disaster recovery plans, which concept deals with the amount of data loss you are willing to tolerate? 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: Disaster Recovery (DR). We'd love to give you credit for your own question and answer. To submit a QOTD, simply log in to the [Contribution Center](. ADVERTISEMENT [Exam Ref 70-761 Querying Data with Transact-SQL]( Prepare for Microsoft Exam 70-761–and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. [Get your copy from Amazon today](. Yesterday's Question of the Day Yesterday's Question (by Steve Jones): For these questions, I am working with RStudio without any additional packages installed. I want to plot the number of Home Runs for Hank Aaron. I create a vector with the CU count: HankAaron <- c(13,27,26,44,30,39,40,34,45,44,24,32,44,39,29,44,38,47,34,40,20,12,10) Now I to graph his home runs over time showing the count of each relative to the others. What should I run? Answer: barplot(HankAaron) Explanation: If I run the barplot() function, I'll get a plot of the counts. This looks like: If I run qqline(), I get an error without another plot. A histogram breaks the counts into groups. graph() returns an error. Ref: barplot - [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 2016]( : [SQL Server 2016 - Administration]( [User_update high but no user seek/scan. Is this an effective index?]( - Hello, Seeing the execution plan created one index for which I can see that the User_update is v high but no... [Adding an Artcle to an exiting publication need Snapshot agent to run?]( - Hi After adding an article to an existing publication if the snapshot agent is run which will apply and resync against... [Always on]( - Hi, i need to setup the always on my databases .i need to design the infrastructure .can any one suggest server... [SQL 2016 SP1 CU2 - sudden and unexplained shutdowns]( - Hi there, Anyone had problems with unplanned instance shut-downs on SQL 2016 SP1 CU2? We patched our Data Warehouse to CU2 in... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Development and T-SQL]( [UNION Question]( - I can't believe I'm having to ask this, but I am noticing some incredibly odd behavior with a UNION that... [70-461 exam]( - I bombed this exam and afterwards discovered the 70-461 Querying Microsoft sql server 2012 book has nearly all the material... --------------------------------------------------------------- [SQL Server 2014]( : [Administration - SQL Server 2014]( [Isolation level change]( - Please let me know the impact on Isolation level change from READ_COMMITTED to READ_COMMITTED_ISOLATION in sql server 2014 --------------------------------------------------------------- [SQL Server 2012]( : [SQL 2012 - General]( [Add where clause after a stored procedure.]( - In my asp.net project, I need to code to select a data from a stored procedure and then bind to... --------------------------------------------------------------- [SQL Server 2012]( : [SQL Server 2012 - T-SQL]( [How to select the column names of columns with a specific value]( - Hey guys Suppose I had the following table columns as well as the row: MyTable Col_A          Col_B         Col_C       Col_D  Y                   &nb [update column based on max date for each employee]( - Kinl provide the update query for update column TeamId based on max date for each employee Scenario: An Employee can be part of... [How to get top and bottom rows from where condition]( - Hi, Create Table Test ( Id int, name varchar(80) ) Insert into Test Select 1, 'A' union All Select 2, 'B' union All --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 - General]( [Distinct query with all columns]( - Hi Guys I am just looking at below the query which is hitting our database quite a lot. This is taking about... [Year, Month and Days from date of birth table]( - Hello, I need Year, Months and Days from date of birth column from age table. Can you please help me to extract... [Database not available]( - Hi hope someone can assist with this. We have a database running on SQL 2008 in our production environment which recently... [Database Design Theory regarding best practices for querying tables]( - Hi all, Up until now, I've largely operated on the principle that any database-related work should be done 100% on the... --------------------------------------------------------------- [SQL Server 2008]( : [T-SQL (SS2K8)]( [Formatting in HTML table]( - Hi guys, I have created a HTML table dynamically to send on mail. That table contains few amount columns. It's... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server Newbies]( [Job in hung state..How to fix]( - Good morning Experts, There is a job in hung state as shown above. Please help in troubleshooting this --------------------------------------------------------------- [Reporting Services]( : [SSRS 2016]( [Next Quarter Dates]( - Hello Everyone!     Can someone please tell me the expression to get the start and end dates for the next quarter? Thanks! --------------------------------------------------------------- [Data Warehousing]( : [Integration Services]( [Cannot deploy to SSISDB]( - Hhhhh --------------------------------------------------------------- [Career]( : [Events]( [The SQL Saturday Thread]( - As popular as SQL Saturday is, I'm surprised that nobody created a thread dedicated to SQL Saturday, so I created... 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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com