I like the cloud. It's very handy for a lot of the things I do. I like having backups restored for my iPhone upgrade. I appreciate having my documents synced through Evernote, Dropbox, and OneDrive (formerly SkyDrive) automatically moving to new machines. These services are incredibly convenient and handy. I expect that my mail will be accessible from multiple machines and my blog posts can be created, edited, and published from anywhere. Many of us work in a similar fashion, using the cloud as a service construct in much of our lives. In fact, many of us expect our own knowledge will be supplemented by the cloud. We use Google to search, getting us syntax, solutions, or ideas from sources that we expect to just be there.
Someone was talking to me about their concerns with the cloud recently. This person thought the cloud would be a fad that passes quickly and businesses will get back to owning, hosting, and managing their servers from the bare metal up to the network connection. I disagreed, and not because I use the cloud personally.
I remember setting up a web server in 1996 for a company. I remember installing an email server in 1999. I would never do either of those things again for my own company, and I wouldn't expect it from most companies. These days we've learned that email can easily be handled by a third party and more and more companies are using email services instead of managing their own systems. Web servers are mostly a shared service that we rent from any number of other companies, sometimes even stitching together a presence across multiple providers. Even many companies that want to manage their own host operating system are turning to third party companies to manage the hardware and networking. More and more we accept renting the things we need from others.
We'll get there with databases as well. Not all databases, but more and more of them will be hosted at third party companies. Whether this is in some type of VM environment or a service that hosts data, it will still be hosted at a third party. We will have concerns and we will have reasons to not do this, but I think for more and more of our data, we won't care.
Companies have lots of systems in place. They have legacy investments in infrastructure and facilities. In those cases, it's hard to justify the cost of cloud computing. However as we grow into new areas, or with new companies, we'll have to re-evaluate whether it is a good idea to continue to make those investments. As the management of software grows to allow the quick scale up and down of assets, I think we'll be much more likely to consider moving applications into the cloud than ever before.
We'll never be 100% in the cloud, or out of it, in the future, but increasingly, we'll be partners with the cloud.
Window Functions in SQL greatly simplify a whole range of financial and statistical aggregations on sets of data. Because there is less SQL on the page, it is easy to assume that the performance is better too: but is it? Dwain gets out the test harness to investigate. More »
When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works. An effective response to a crisis requires rapid decisions based on understanding its role in ensuring data integrity.
Hierarchical order by TSQL
- Dear Sir
create table Hierarchy
insert into Hierarchy values (101,1),(1,6),(101,2),(2,4),(2,5),(5,6),(5,7),(101,3),(3,5)
Please refer the Hierarchical order Diagram in order to understand how...
Odd (n)VarChar Behavior
- Run the following:
Declare @v nVarChar(4000);
-- Test 1
Set @v='Select * from sys.indexes where type=0';
Select @v,Len(@v),DataLength(@v),Cast(@v as VarBinary(128));
RaisError(@v,10,1) with NoWait;
Exec sp_executesql @v;
last 6 months data
Below is my table structure,
Table Name : MemberVisit
select * from(
select 1 as Id,'2014-01-13' as Visiteddate,20 as PutchaseAmount
select 1 as...
Can't get image to update.
- I am using Data Compare which does the following:
WHERE [EmployeeImageID] = 9
when I go back later and...
T-SQL Pivot Question
- Hello Everyone.
This should be an easy one. It's been a long time since I have used PIVOT and think...
Need help on SQL script
- Hello, I am learning SQL and wondering if someone can help me with script below – not sure if I am...
CPU always utilize 60% constantly?
CPU always utilize 60 % constantly, attached here execution plan.
I checked execution plan handle CompileTime="9" CompileCPU="9" = 81 Entries for that query,...
Query to find blocking is getting blocked.
- I have this query to find blocking:
SELECT DISTINCT sp.spid SPID, sp.blocked BlockingSPID, DB_NAME(tl.resource_database_id) DatabaseName, es.Status
, (SELECT Text FROM sys.dm_exec_sql_text(sp.sql_handle)) SQLText
How comma separated values are divided into rows?
- Hi Experts,
I have the input:
rank country city
1 india hyderabad, bangalore, delhi, shimla
2 usa newjersey, newyork, washington, texas
3 uk london, greenland, denmark, italy, spain
rank country city
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.