| A community of more than 1,600,000 database professionals and growing |
| | A True Lift and Shift Microsoft bought a data center. That's not news, after all, they've been building and buying data centers for some time as they look to expand their Azure footprint, as well as continue to power their own internal systems. As they've grown, they've also learned quite a bit and regularly redesigned their data centers, moving from racks to shipping containers, from large warehouses to outdoor facilities. They are always trying to become more efficient in how they not only power and cool the systems, but also manage the deployment of servers. They don't want to rack individual servers, nor do they even want to have systems with unnecessary wiring, choosing to order custom motherboards and other hardware. In fact, they are looking to move beyond containers to ITPACs, whatever they are. I'm getting off track here, since I think data centers are really cool and well designed. I used to evaluate and rent space in them, so I get intrigued. Back to my point. Microsoft bought a data center. Is this news? I find it interesting because in this case, Microsoft bought a data center from Chevron for a facility valued at US$80mm. That's not a lot for a data center, but it comes on the heels of a deal between the companies to use cloud services for Chevron and make Microsoft the primary provider. It seems like Chevron wants to get out of the data center business and just rent the services it needs from Azure. Since they work in the oil and gas industry, with lots of data analysis and predictive requirements, perhaps this makes sense. That's a good sales tactic from Microsoft. Use our stuff, which can save you money, and by the way, we'll buy your old DC so you don't have to lose that investment. An argument like that might sway quite a few large customers, allow Azure to continue to grow, and also ensure a strong base for Azure revenues for some time to come. That kind of moves makes me think I ought to buy more Microsoft stock. This won't make a difference for the smaller companies, but face it, many of them likely have a limited number of servers, dozens perhaps. There are still potential cost savings for them if they can move to a managed solution in the cloud, and I know quite a few Redgate customers that are considering a variety of moves, often a combination of IaaS and PaaS. Not everyone wants to move, but there are plenty of advantages for some companies to consider cloud type solutions. Microsoft Azure is growing quite a bit and I continue to be impressed with the capabilities and options available. From Managed Instances to Machine Learning on demand to Cognitive Services, I think there is tremendous opportunity for companies to use technologies that might have been cost-prohibitive just a few years ago. Of course, if you're a basic, just need a RDBMS for an app, you probably are just as happy to run (or rent) space in a smaller data center, where you have more control over resources, options, and costs. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 4.5MB) podcast or subscribe to the feed at iTunes and Libsyn. 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 | | Don’t just fix SQL Server problems, prevent them from happening SQL Monitor helps teams looking after SQL Server be more proactive. Not only does SQL Monitor alert you to current issues, it gives you the information you need to stop them happening in the future. Download SQL Monitor now and get a 14 day free trial |
| | 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 |
|
|
|
| | | This article will discuss why deadlocks occur, why they require immediate investigation by the DBA, and the diagnostic data required to troubleshoot them. More » |
| Additional Articles from SimpleTalk Developer shops may decide to use Read Committed Snapshot Isolation (RCSI) to reduce contention, and possibly improve performance, but it is not without its own pitfalls. In this article, Uwe Ricken describes a situation where long running transactions caused a severe performance degradation when RCSI was in use. More » |
| Gail Shaw from SQLServerCentral Blogs I originally wrote about catch-all queries early in 2009, just as something that I’d seen several times in client code.... More » |
| Arun Sirpal from SQLServerCentral Blogs We all know that the magic figure for cost threshold for parallelism is 5 by default, meaning if the estimated... More » |
|
|
| | Today's Question (by Steve Jones): I have an Availability Group setup between two instances. If I have a page become corrupt on the primary, it is automatically repaired with a copy from the secondary replica, except if it is one which types of pages? |
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: Automatic page repair. 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 | Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server and design your databases to support a given instance and workload. Pick up your copy of this great book today at Amazon today. |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I had someone delete all the data in a table of my Sales database. This database has CDC enabled inside of it. If I restore a full backup of this database to the same instance with the same name, what happens with CDC? Answer: CDC is enabled after the restore automatically Explanation: If a CDC enabled database is restored to the same instance with the same name, it remains automatically enabled. Ref: CDC with other features - click here » Discuss this question and answer on the forums |
|
|
| | Jayendra Viswanathan from SQLServerCentral.com SQL Server has a feature to implement many-to-many relationships model. SQL server graph database capabilities is available in SQL Server 2017. Let us see the codes to implement the same. We shall create the base table as “Org”. Load data into the table with the Insert command. We shall create “OrgNode” table as Node. The data from Base table “Org” will be loaded with Node details into the “OrgNode” Node table. “OrgEdge” is the table that stores the relationship data between the rows in the Base table “Org”. Edge table contains the From and To of Node table “OrgEdge”. Once the data is ready in he “OrgEdge” table, we will use MATCH clause to retrieve the data. In the example, George is the first level employee, he has 1 employee who reports to him which is Peter. Peter has two resources who reports to him they Jeff and Tedd. The last query in the above code sample will get the employees reporting to the Peter, they are Jeff and Ted. More » |
|
|
| Database Pros Who Need Your Help |
| |
| This email has been sent to newsletter@newslettercollector.com. 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 |
|
|