Cost estimation for SQL Server Azure VMs (SQLServerCentral 12/3/2018)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [Cost estimation for SQL Server Azure VMs]( - [Monitoring Changes in Permissions, Users, Roles and Logins]( - [Adding a Primary Key to a Prepopulated Table using a SQL Server Integration Services Package]( - [Running SQL Server with Docker on the Mac]( (From the SQLServerCentral Blogs) - [Query Store and Plan Cache Plans Compared]( (From the SQLServerCentral Blogs) The Voice of the DBA GitHub Downtime I didn't notice any issues with GitHub, but others did. The majority of my interaction is just through the git protocol, so things tend to work fast, and I don't have any database access. I rarely use the Issues, and other parts of GitHub, which were affected when GitHub had a MySQL cluster fail over. There's a good write up of [the post incident analysis]( that's worth reading, from a database perspective. I'm not a big MySQL guy, only running an instance to power [T-SQL Tuesday](. The structure of a write primary and many read replicas that GitHub describes makes sense. It's similar to what I've done in SQL Server, and certainly the idea of some quorum management, handled at GitHub with the Orchestrator software, is something that needs to be configured properly. Allan Hirt has talked about the complexities of quorum in large installations, and it's not a simple thing to configure. In reading about this, there are a couple things that strike me. First, the analysis talks about a degredation of service because East coast applications had to send writes to West Coast database servers. There were some problems with the way the database servers were working, but it seems to me that there should be some sort of application failover that's possible. If you can't have an application and database fail separately without customer impact, then there should be some way to fail applications over. Perhaps not, but if you're responsible for designing HA for the database, make sure you talk to the application people and test for issues. The second thing for me is that somehow there was a period of time when writes were occurring to the East Coast system that weren't sent to the West Coast. My ignorance of how this HA stuff works in MySQL prevents me from making a big deal of this, but this isn't something that should happen. If the quorum moves data to another node, it must stop writes to the first node. This could happen in SQL Server, but for me, this is the level of data loss I'd need to accept in my RPO. 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]( ( 3.4MB) 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 [Webinar]( What we’ve learned about adopting Database DevOps, and what to avoid Wednesday 5 December, 16.00-17.00 GMT / 10.00-11.00 CST - Panellists Kendra Little, William Durkin and Hamish Watson are joined by guest, Tony Maddonna-Microsoft Platform Lead & SQL Server Enterprise Architect at BMW Manufacturing, to discuss examples of things they’ve learned the hard way. [Register now]( [SQL Prompt]( Write, format, analyze, and refactor SQL fast with SQL Prompt Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with code analysis you get suggestions to improve your SQL as you type. [Download your free trial]( Featured Contents  [] [Cost estimation for SQL Server Azure VMs]( Deepak Prasad Sahu from [SQLServerCentral.com]() This article provides pricing guidance for SQL Server virtual machines in Azure.[More »](IaaS+VM/180428/) ---------------------------------------------------------------  [] [Monitoring Changes in Permissions, Users, Roles and Logins]( Compliance means keeping a close grip on any changes to the permissions and access control of a database. Sadly, the law has had to acknowledge, from bitter experience, that it is not just external intruders who want to do this, but it could also be attempts at fraud or data theft from within the organisation. Permission changes are certainly one of the things that security experts advise you look out for; you need the equivalent of CCTV trained on your servers.[More »]( ---------------------------------------------------------------  [] [Adding a Primary Key to a Prepopulated Table using a SQL Server Integration Services Package]( Additional Articles from [MSSQLTips.com]() In this tip we look at how you can use SSIS to build a package to add a primary key to an existing table that does not already have a primary key.[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Running SQL Server with Docker on the Mac]( Klaus Aschenbrenner from [SQLServerCentral Blogs]( (Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Query Store and Plan Cache Plans Compared]( Grant Fritchey from [SQLServerCentral Blogs]( Query Store plans and the plans in cache are identical, right? There won’t be differences because the plan that is...[More »]( Question of the Day Today's Question (by Kendra.Little): How many missing index requests are in the execution plan below, seen in SQL Server Management Studio? 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: Execution Plans. 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 [Expert T-SQL Window Functions in SQL Server]( Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. [Get your copy from Amazon]( today. Yesterday's Question of the Day Yesterday's Question What does this code return? DECLARE @m MONEY; SELECT @m = \; SELECT @m Answer: 0.00 Explanation: You can initialize a money value with \, which sets this to 0.00. No idea why this works. --------------------------------------------------------------- [» 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 - Development]( [For XML Explicit Column order]( - Is it possible to generate output from FOR XML EXPLICIT a specific column order - any help much appreciated. Example SQL declare @orderID... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Administration]( [SQL server cluster upgradee- Rollback process]( - Hi, I have an sql server cluster.I am planning an upgrade and I read that rolling upgrade is suggested method for... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Development and T-SQL]( [Need a suggestion for my SQL requirement]( - Hello everyone, [Request code review for UDF: ContainsControlChar and CleanString]( - Hi, I have a lot of dirty data in my upstream data sources. I've written two UDFs to assist in my... [Replace trigger with some other approach?]( - I have an SCD2 table like so: TableName_PK Recnum BusKeyA BusKeyB BusKeyC Valid_From Valid_To TableName_PK is an identity column.  Recnum is a surrogate... --------------------------------------------------------------- [SQL Server 2014]( : [Administration - SQL Server 2014]( [Replication - publication / subscription]( - Hi all. I've never done replication or worked with it, so I've started researching and ran into some questions.. if I set... [MSDB Size]( - Hello. Reading about MSDB growth and understand that this issue usually gets put down to tables with millions of rows relating to... [Transaction Logs and VLFs etc]( - Hello Bit of a silly question I think, but for my peace of mind...............… We have 2 servers - Live and Reporting, and... [SQLLOGSHIP.EXE]( - Hello. We have a Reporting Server that relies on Transaction Log Shipping (currently but will change). The database is set to Standby/Read... [DBCC CHECKDB]( - I understand that in order to have DBCC CHECKDB use parallel threads you need to be on Enterprise Edition, and likewise... --------------------------------------------------------------- [SQL Server 2012]( : [SQL 2012 - General]( [Left Join with View taking more time in SQL Server]( - The below query is taking twenty seconds to display 53,000 records. This query has five left joins with views. But... --------------------------------------------------------------- [SQL Server 2012]( : [SQL Server 2012 - T-SQL]( [Pseudo code help]( - Need a little guidance regarding a personal project. I don't want any actual code, just pointers in the right direction. There... --------------------------------------------------------------- [Reporting Services]( : [SSRS 2016]( [My subreport only shows 1 record, even when there are more. Why?]( - I've got a main report, which is a detail report. And a smaller report, that's used by the main report... --------------------------------------------------------------- [Data Warehousing]( : [Integration Services]( [Writing to multiple XL spreadsheets of the same workbook within same workbook]( - I need to produce 100s of .xlsx files via the foreach loop from which the dataflow source gets parameter for... 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