We hear constantly about the benefits, and potential pitfalls of cloud based applications. There are certainly reasons to move to the cloud, or stay away, depending on your particular situation and requirements. However one thing I hadn't thought was viable was software development in the cloud. Most of the companies I've seen that host applications in the cloud still do the development on desktops and laptops, with a build server somewhere on site. However Microsoft wants to show us that this isn't necessary.
There is a push inside Microsoft to perform more of their development in the cloud. Across the last year or two, various managers inside Microsoft have been moving development to the cloud, typically starting with testing and code analysis. Those are great fits for cloud services, since they are used at discrete periods, but may requite lots of resources. One of the interesting things in the piece was that the first objectives was to speed up the continuous integration process. At Red Gate (my employer), we've seen a lot of benefits from implementing continuous integration, both in our applications and databases, and we've done a lot of work to smooth out those processes.
Obviously Microsoft might have an advantage over many of our other companies in terms of Azure resources and cost, but I would bet the reliability is similar for their developers. If they can make it work, on products like Windows, SQL Server, Sharepoint and more, I'd think that many of us could make use of the platform as well. I know a few people that have worked with TFS on Azure, and they've been pleased with the performance and reliability. There are any number of other software services, like GitHub, that make use of distributed, cloud-based services for software development.
However even if you don't want to use the Azure platform, the idea of using virtual systems, of spinning up and down the machines you need to perform various functions makes lots of sense. You can make better use of your hardware resources, and even schedule continuous integration services (builds, tests, analysis) for different teams (or applications) at different times, improving your efficiency and not only speeding up your development processes, but hopefully improving the quality of the final code.
SQLSaturday #228 Cambridge is a training event for SQL Server professionals, Business Intelligence and SQL Server Developers and those just wanting to learn more about SQL Server. This event will consist of a pre-conference day on the 27th September and a free community day on the 28th September 2013. More »
Offsite backups are vital to data integrity, allowing for preservation and backup of data in catastrophic circumstances. Cloud backups have been around for a while, but are now really coming into their own. Tony Davis looks at how to get set up with cloud backups for restores and disaster recovery. More »
SQL Server 2012 Integration Services Design Patterns is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book show how to solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, using design patterns improves your efficiency as an SSIS developer. In SSIS Design Patterns, we take you through several of these snippets in detail, providing the technical details of the resolution. Get your copy from Amazon today.
Yesterday's Question of the Day
(by Sergiu Ungureanu):
In SSMS open a new query and run the followings (assume the default server language is us_english):
set language 'us_english' --just to make sure
set datefirst 2
set datefirst 3
Open a new query in the same DB and run this again:
What value will it retrieve?
Explanation: The value of @@datefirst defaults to 7 for us_english. This value is set per connection.
For restorehistory, BOL says [restore_date] is the Date and time of the completion of the restore operation. My test shows otherwise. it appears to be the start datetime of restore operation. Inspired by Steve's post, I came up with this script to show the actual completion datetime of database restore operation. The idea behind is SQL error log always contain the an entry of restore operation in the end of db restore. something like "Restore is complete on database 'my_database'. The database is now available."
- Hello, I have a great mystery about bcp command.I have this table:
CREATE TABLE myTable
FirstName nvarchar(50) ,
multi-valued report parameter weirdness
- SSRS 2012, SQL 2012
I watched Brian Knight's video on filtering a report using a multi-valued parameter (here:[url]http://www.sqlservercentral.com/articles/Video/64369/[/url]), and after seemingly...
Cannot figure out my update correctly
- Hi professionals
I have a table like so
my employer wants me to update the table column invoiceno and concatonate the invoiceno...
Sql force me to include Row_Number() in group by
- Hi, this is my table structure:
CREATE TABLE #table1 (ID INT, Col1 NVARCHAR(1), Col2 INT);
INSERT INTO #table1 VALUES(1,'B',100);
INSERT INTO #table1 VALUES(2,'A',200);
Concat column values
- I have following table
I want the output in following format
rebuild index for a table failed
- We had found logical consistency errors in the database when we ran dbcc checkdb.
The application vendor told us to rebuild...
Union overwrite null values
- Is there a way using union to overwrite null values?
I hava two views with following columns
att_date, student_id, AM_attendance code...
- How to get job schedule details, I mean detailed schedule like, all the jobs on all 7 days.
Group by without soring
- Hi, this is initializations:
CREATE TABLE #table1(col1 nvarchar(1), col2 int);
INSERT INTO #table1 VALUES('B','100');
INSERT INTO #table1 VALUES('A','200');
INSERT INTO #table1 VALUES('B','300');
INSERT INTO #table1...
- I have this stored proc USE [SMS]
/****** Object: StoredProcedure [dbo].[usp_Birthday] Script Date: 09/13/2013 22:26:36 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
Extract string between to characters
- I've a string in following format:
First I've to extract the strings between < and >
like: 1|458|test|q 2|789|test2|s 5|567|test3|p
after that I've...
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.