| A community of more than 1,600,000 database professionals and growing |
| | Cloud Snake Oil I'm sure that those of you reading this have a variety of opinions about the "cloud". Actually, I'd guess that many of us have different definitions of what the cloud actually means. That's fine, since it's really an amorphous, marketing term that encompasses quite a bit of different technologies, services, and products from many different companies. Some of you might use the cloud, and if you do, then perhaps this will ring true to you. I was reading Dr. Greg Low's blog, and he asked the question in a post about what a managed service was. In this case, Dr. Low was looking to host his blog on some service, and apparently the definition of a managed service varied from provider to provider. His first provider didn't tell him that backups were being run, with each file being counted against the space that he'd contracted for. When he asked for them to be deleted, he was told it would take a day or two as there wasn't anyone to provide the service. He continues looking at how other providers define service, which does vary, but the interesting thing to me is that many of these companies aren't really providing management of systems. They're selling you a product, which has some capabilities, but they aren't really managing anything. At least, that is my impression. I know if someone asked me to manage a system, I'd expect to deliver some level of service that would be useful for the client. In the cloud, it's really a wild west version of computing, where companies want to sell you some service, often touting various management aspects, but they may not necessarily provide the level of service you expect. Cloud vendors, even worse than other computing vendors I've dealt with, want to work at scale, and they want to standardize how things work as much as possible. They don't want to engage in person to person communications if possible. I learned this lesson with Google and their products, few of which had any way for a user to contact a help desk. Apart from that, what I've seen too often in the cloud is that a company wants to offer some service or capability, but they don't often have the tooling available for end users. This is especially true for new services, where it seems the purchase process works flawlessly, but the configuration or cancellation process doesn't work, or might not even exist. The one piece of advice I'd pass on from my cloud experiences is that anyone using services needs to reconcile their bills regularly. We can add resources easily, but removing them is hard, and often a customer service person promising removal doesn't follow through. I've had people in the support centers not even be sure of what resource I was referring to when requesting removal or credit. It's a frustratrating experience that has led me to adopt another habit. I grow resources very slowly, ensuring that I know what the billing is and that I really need the service. That seems like the opposite of what the "cloud" is supposed to offer. 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.7MB) 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 | | NEW SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps Create and manage database copies effortless and keeps compliance central to the process. With SQL Provisions virtual cloning technology, databases can be created in seconds using just MB of storage, enabling business to move faster. Sensitive data can be anonymized or replaced with realistic data to ensure data is protected as it moves between environments. Download your free trial |
| |
|
|
| | | John F. Tamburo from SQLServerCentral.com The business decides on a packaged application and buys it. After installation, you look at the schema and realize that is is a nightmare. How do you manage this nightmare? More » |
| There are several ways to to anonymize / pseudonymize email addresses. This post discusses a few frequently used approaches, as well as how you can use Redgate Data Masker for SQL Server to achieve realistic masking of email columns. More » |
| Additional Articles from MSSQLTips.com Check out these scripts to create SQL Server jobs and Alerts when a login is created or dropped, a database user is added or dropped and when logins are added or removed from server roles or users are added or removed from database roles. More » |
| Arun Sirpal from SQLServerCentral Blogs vCore based performance levels are very new, currently in preview and not yet rolled out to all Azure regions (The... More » |
|
|
| | Today's Question (by Steve Jones): I have an Extended Event (XE) session called "QueryTuning". How do I start this session on my instance in T-SQL? |
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: Extended Events (XE). 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 | Pro Power BI Desktop This book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease then add metrics and KPIs to project the insights that create your competitive advantage. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I decide I want to setup an Extended Events session. I create a session with one event and one target with this code: CREATE EVENT SESSION [BareBones] ON SERVER ADD EVENT sqlserver.error_reported( ACTION(sqlserver.client_hostname)) WITH (STARTUP_STATE=OFF) GO I then decide to run this code: ALTER EVENT SESSION BareBones ON SERVER DROP EVENT sqlserver.error_reported GO What happens? Answer: The code runs successfully Explanation: This code runs fine and the session continues to exist on the server, but without any events or targets. This is the event tab in SSMS Ref: Alter an Extended Events Session - click here This doesn't explicitly say all events can be removed, but they can be. » Discuss this question and answer on the forums |
|
|
| | Suresh Kumar from SQLServerCentral.com While taking my training classes for SQL Server, students ask many times if they can get some large sample tables to do perfroamce tuning. So I thought of writing a script to generate the sample data as per my need. To use this script to generate data, you need to have AdventureWorks2012 DB on that machine. If you don't have it, you may download it from : https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks Then you may run the script to generate sample data in table AllCustomerOrders. You just need to specify how many rows you want to generate. e.g. to generate 100 records, I have specified it like this: Declare @RowsRequired Bigint =100 So instead of 100, you may specify a big number. I tried a sample run on my Core i5 4 GB RAM laptop And below are the results: Number Of recordsSizeTimeTaken(hh:mm:ss) 5 million -500MB00:04:00 10 million990 MB00:09:00 90 million 8.9 GB01:49:00 If any of you need explanation how the code is written, Let me know and I will be happy to assist. 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. Migration of DB from server to server - Hi All, I have recently come across a new error with little info about why this is happening. I am currently... Transactional Replication to Multiple Subscribers - Hi all: I'm attempting to set up replication from a SQL 2017 Instance to multiple subscribers. One is another SQL 2017... Converting a MS Access query to SQL - I am attempting to move a database from MS Access to SQL Server. For the most part things have gone... Removing stored procedures to move to cloud - I got an interesting email today about cutting back on the reliance of the applications on databases and plans to... Refreshing lower environments with prod copy - I know this isn't something new and people might be doing this in their environment. I have a requirement to... Publisher performance - transactional replication - We have setup push transactional replication, with the same server acting a both the subcriber and distributer. There are 28 Publications... How to update with new ID - Declare PowerShell Sql job - Hi, I 'm working to launch with a Sql Agent Job a powershell script. (the script is saved into network share because... SQL 2014 Standard - Reindex DB Processing Time - At the end of each month I reindex a critical financial database on a relatively new SQL 2014 Server that... Need to add MMM-yyyy to end of file in exp.builder-SSIS - Hello, I've built a basic ETL ssis package that drops an Excel file from on network share to another network share.... Prepared Statement Running Exponentially Longer - Hello All, I've seen this behavior now on 2 different queries on different databases, but still can't figure out anything on... How to check sql 2000 compatibility on sql server 2012 or above? - So, I made a mistake at my company yesterday. I was assigned to make some stored procedure fixes to one... Spills into tempdb poor performing query fixed by converting to SP - Hi Guru's I had a poor performing query that took and average almost 4 seconds to execute. In the execution plan there... Subquery as column - Is this select (select top 1 organisation from sysfile) as org,* from area1 More efficient than a join ? i.e. will it do... String size causing error - I get the following error with the following code. This code is stripped from a larger piece of code to... user typed "begin transaction" and went home - Good Morning Experts, A user typed "begin transaction" and went home. Will this have any affect on the log file(.ldf file).... What to do IN RECOVEY and lock database in the same time does not allow to be ONLINE - Dear Colleagues, I have moved a Database (1.5T) to a new server, same version (2k8r2), detached and attached, ok. After a few ... Creating derived columns from column of variable length components - Hi All, I'm hoping to get your guidance on this. I have a column, consisting of variable length sections that needs to be... Small numbers in the cube shown as zero in excel - rounding error? - Hi all, I've created a Tabular SSAS Cube recently. Certain numbers within the cube are very small (e.g. 0.0000612762). When I connect... Unable to get format file to work - I am importing a text file with tab delimiters into an SQL2005 table. The BCP command works fine without specifying the... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. | 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: [email protected] |
|
|