SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

Featured Script

The Voice of the DBA

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.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.7MB) 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 Provision

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

Database DevOps

Continuous Delivery for SQL Server Databases

Spend less time managing deployment pain and more time adding value. Find out how with database DevOps

Featured Contents

 

Packaged-Application Database Nightmares - A Horror Story

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 »


 

Approaches to masking email addresses

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 »


 

Alerts and Notfications for SQL Server Login, Database User and Role Membership Changes

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 »


 

From the SQLServerCentral Blogs - Azure SQL Database vCore

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 »


 

From the SQLServerCentral Blogs - 24 Hours of PASS – April 25th–26th

Thomas LeBlanc from SQLServerCentral Blogs

Well, it is that time of the year, again. PASS puts on a 24 Hours of PASS where 1 hours... More »

Question of the Day

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

Featured Script

Generate Large Amount of Data For Performance Testing

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.

SQL Server 2017 : SQL Server 2017 - Administration

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...


SQL Server 2017 : SQL Server 2017 - Development

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...


SQL Server 2016 : SQL Server 2016 - Administration

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...


SQL Server 2016 : SQL Server 2016 - Development and T-SQL

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 Server 2014 : Administration - SQL Server 2014

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...


SQL Server 2014 : Development - SQL Server 2014

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...


SQL Server 2012 : SQL 2012 - General

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...


SQL Server 2012 : SQL Server 2012 - T-SQL

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...


SQL Server 2008 : T-SQL (SS2K8)

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...


SQL Server 2008 : SQL Server Newbies

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)....


SQL Server 2008 : SQL Server 2008 Administration

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 ...


Data Warehousing : Integration Services

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...


Data Warehousing : Analysis Services

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...


SQL Server 2005 : SQL Server Newbies

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]