| A community of more than 1,600,000 database professionals and growing |
| | The Financial DBA I've got an Azure subscription. At least, I think I have just one. I know I have a few Microsoft accounts, across 4 (or more) different email addresses, that I use for various VSTS development purposes, but only one should have any Azure resources. When I check each of them, I find that I do only have resources (and charges) for one. However, I also found a strange charge on my credit card statement from Microsoft Azure. It was just a couple dollars, but as I started digging through the various statements, I couldn't determine where the charge was from, or what it was for. As of now, I've opened a support case with Microsoft to track down my usage. This has me thinking of the future of many data professionals, some of whom will certainly have a few assets in a cloud based environment. I have a small subscription, but plenty of resources, and keeping track of which items belong to which resources and what I need isn't always easy. It's quite the challenge, especially when billing and finance aren't my job. In an organization like Redgate, I'd guess we have lots resources, some of which developer provision, need, and then might forget about. Who reconciles this and ensures the assets we have are those we need? As we move to a world where services are used as often as assets, perhaps interchangeably, I expect that many of us will need to be accountable for not only the usage, but tracking why we've engaged that service. Over time, we need to retire and get rid of assets, but ensuring we remember exactly what we're using and why can be hard over time. With a little employee movement, many of us might find ourselves in charge of services that we don't understand, and might not be sure are necessary. We also might not be sure these services can just be discarded. The last thing we want is some uptime disruption because we terminated some service contract. A whole new dimension to our job is likely coming, and for many of us, this will test our documentation and organizational skills. I wouldn't be surprised to find many DBAs or lead developers having a standing monthly meeting with someone in finance to be sure we aren't wasting money. 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 ( 3.3MB) 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 | | 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 |
| | 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 |
|
|
|
| | | Adam St. Pierre from SQLServerCentral.com A gripping expose into the deep, dark world of ANSI_PADDING! What could be more exciting? More » |
| 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 » |
| Additional Articles from SQLPerformance.com Erin Stellato takes a thorough look at the way DML statements might benefit from In-Memory OLTP, especially with natively compiled stored procedures. More » |
| matthew.mcgiffen 73574 from SQLServerCentral Blogs T-SQL Tuesday For T-SQL Tuesday this month Raul Gonzalez has asked us all to blog about lessons learnt the hard way: http://www.sqldoubleg.com/2017/07/03/tsql2sday-92-lessons-learned-the-hard-way/ My... More » |
| kleegeek from SQLServerCentral Blogs I get asked all the time – “why virtualize SQL Server if I’m content with my physical servers today?” The normal... More » |
|
|
| | Today's Question (by Steve Jones): I create a new Availability Group for a few SQL Server instances and use \\Sales01\Sync as the Initial Sync Folder. All of my replicas are up to date, can I now delete the sync folder from my network? |
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: AlwaysOn Availability Group. 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-768 Developing SQL Data Models Prepare for Microsoft Exam 70-768–and help demonstrate your real-world mastery of Business Intelligence (BI) solutions development with SQL Server 2016 Analysis Services (SSAS), including modeling and queries. 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 today from Amazon. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): In Python, how do delimit a block of code? In other words, if I have an IF statement, how do I determine which lines of code are related to the THEN action of the IF statement? Answer: indent all lines related to the IF statement Explanation: Python is a language that uses whitespace and indentation. Lines indented from the IF as part of the statement. As in: if start == -1: failed = 1 print("i:" + i) Ref: Python Introduction - click here » Discuss this question and answer on the forums |
|
|
| | Simon Hundleby from SQLServerCentral.com Another Proper case function that utilises the ASCII function to convert to Proper case Useage SELECT [dbo].[fnProperCase](' CONVERT tHis toPROpper cASE') More » |
|
|
| 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 geo-cluster 2016 - Dear Everyone Ikeep reading online that its not recommended to virtualize SQL Server clusters (4 nodes) Backup command with multiple threads. - Hi, Is there any switch / option is available to take the backup in multiple threads (parallelism) so that it can be... Buffer Pool Extension - Hello. I have been puzzling over this for some time and still can't grasp what the benefit of BPE is over... Developer Edition - Free to use (or not)? - Hello. Does anybody have a definitive source for whether use of Developer Edition in a commercial business (for non-Production use) is... Using Named Transactions - Hi Guys, According to what I've read SQL Server allows you to give transactions a name. Is it possible to execute... High level performance report aimed at senior management - Hi all, I've been in the SQL space for a number of years now and recently been asked to act as... Is Cursor the option?? - Select from a table, is there an easier way (without using Cursor) to have the data with the same "Invoice... Outer Apply - Alternative - Hi I am trying to utilize the below query but without using otter apply Can someone help me out with an alternative? Thanks, [code... Case Statement Help - CREATE TABLE #INPUT ( ADDRESS_1 VARCHAR(200), IS_PO_BOX BIT ) INSERT INTO #INPUT Values ('PO BOX 123',0) INSERT INTO #INPUT Values ('PO BOX 123 Washington st',0) INSERT... Question regarding SQL Injection - Hi all, I've a question regarding potential vulnerabilities in my application, with respect to SQL Injection. Most of my database queries operate loosely as... DAX Query - QoQ Growth, reset at beginning of each Year - I have created a simple Model, 1 Fact table, 1 Date table and 1 Dimension Table. The data relates to captured... Deleting records based on Item matching and Drill Level - Would like to write query which will delete all the reocrds at that TreeLevel where the item and matchItem is... How to consolidate employees from different databases into single database - Hello Folks, In one of my project, requirement is to consolidate all employee and their related tables into one centralized database... |
|
| 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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com |
|
|