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

If we can do it, so can you

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.

Steve Jones from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums

Video and Audio versions

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

Follow Steve Jones on Twitter to find links and database related items and announcements.

Steve Jones

Windows Media Video ( 22.0MB) feed

MP4 iPod Video ( 26.4MB) feed

MP3 Audio ( 5.2MB) feed

Feeds are available at iTunes and Mevio

To submit an article, rant or editorial,
log in to the Contribution Center


How do you search your database schema?

"I use SQL Search regularly and think it's great." Gregor Suttie, Senior Software Engineer, Pulsion Technology. Download Red Gate SQL Search while it's free.

SQL Backup Pro

New! Easy retention policies for offsite backups

Quickly and easily delete old offsite backups with new features in SQL Backup Pro. Get your first 5GB of storage free. Find out more.

SQL Compare

Need to compare and sync database schemas?

Let SQL Compare do the hard work. ”With the productivity I'll get out of this tool, it's like buying time.” Robert Sondles. Download a free trial.

Featured Contents


Automate SQL Server Log Monitoring

Willem Gossink from SQLServerCentral.com

Let SQL do the work and monitor your SQL Error Log files. More »


SQL Saturday #228 Cambridge, UK

Press Release from SQLServerCentral.com

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 »


Backup to the Cloud: The Silver Lining

Additional Articles from SimpleTalk

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 »


From the SQLServerCentral Blogs - Insert data from Excel to SQL Server

UmaShankar Patel from SQLServerCentral.com

Here I am discussing about data insertion from MS Excel into SQL Server table. SSMS provides  Export Import wizard by... More »

Question of the Day

Today's Question (by Samith C):

What will be the result of this batch?
declare @i int 

set @i = 2

if @i = 1 
  print @i
  declare @j int
  print @i

set @j = 1

print @j

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

We'd love to give you credit for your own question and answer.
To submit a QOD, simply log in to the Contribution Center.


SQL Server 2012 Integration Services Design Patterns

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

Yesterday's Question (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
select @@LANGUAGE
select @@datefirst

set datefirst 2
select @@DATEFIRST

set datefirst 3
select @@DATEFIRST

Open a new query in the same DB and run this again:

select @@DATEFIRST

What value will it retrieve?

Answer: 7

Explanation: The value of @@datefirst defaults to 7 for us_english. This value is set per connection.

Ref: @@datefirst - http://msdn.microsoft.com/en-us/library/ms187766%28v=sql.90%29.aspx

» Discuss this question and answer on the forums

Featured Script

List database restore COMPLETION datetime

SQLVoila from SQLServerCentral.com

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

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

SQL express version - Hi Guys, I know I might be in the wrong topic group but I am new here and don't know how...

SQL Server 2012 : SQL 2012 - General

Exposing ERP data on a public web/ecommerce site - from the SQL point of view - My company wants a new internet presence consistent with the possibilities provided by current technology. This means a website that provides...

How to add multiple stopwords to a stopwords table ? - I keep getting this error message, when i use insert into or update. insert into sys.fulltext_stopwords values('5', 'resume', 'English', '1033') I have 10k...

bcp unicode - Hello, I have a great mystery about bcp command.I have this table: CREATE TABLE myTable ( PersonID smallint, FirstName nvarchar(50) , LastName 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...

SQL Server 2012 : SQL Server 2012 - T-SQL

Msg 2812, Level 16, State 62, Line 2 Could not find stored procedure 'xml_schema_namespace'. - Hi, my version is sql server is as follow [code="sql"] SELECT @@VERSION Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Feb 10 2012 19:39:15 Copyright (c)...

SQL Server 2008 : SQL Server 2008 - General

Cannot figure out my update correctly - Hi professionals I have a table like so [code] departmentid,Barcode,Invoiceno,expirydate 2036,xyz,12345,23/01/2013 2077,xyz,56245,05/05/2012 2036,abc,67654,02/11/2012 [/code] my employer wants me to update the table column invoiceno and concatonate the invoiceno...

I Can’t Connect to Analysis Services in SSMS 2008R2 - Installed SQL Server 2008 R2 and chose to install SSIS, SSRS and SSAS. now I am unable to connect SSRS...

Issues with msdb.dbo.sp_send_dbmail procedure - Hi All, For the last several days I'm trying to resolve issue with sending emails by following procedure (I've ommited some...

Give priority to union statements - Hi, if I have several SELECT statements with UNION how can I tell to sql to process which one first? Please...

Sql force me to include Row_Number() in group by - Hi, this is my table structure: [code="sql"] CREATE TABLE #table1 (ID INT, Col1 NVARCHAR(1), Col2 INT); INSERT INTO #table1 VALUES(1,'B',100); INSERT INTO #table1 VALUES(2,'A',200); INSERT...

Concat column values - I have following table [code="sql"] DepartmentID Employee ------------- --------- 1 John 1 Michael 2 Jenson 2 Lily 2 Lara [/code] I want the output in following format [code="sql"] DepartmentID Employees ------------- ---------- 1

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? for example: I hava two views with following columns att_date, student_id, AM_attendance code...

Job Details - How to get job schedule details, I mean detailed schedule like, all the jobs on all 7 days. Sun Mon...

Group by without soring - Hi, this is initializations: [code="sql"] 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...

Birthdate - I have this stored proc USE [SMS] GO /****** Object: StoredProcedure [dbo].[usp_Birthday] Script Date: 09/13/2013 22:26:36 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROC...

subquery vs join returns are different results - I have 2 tables(label and product) both has the column called uniqueCode which is nvarchar(255) datatype and nullable column. product...

get only the alphabets from string - i have productname column in my table and the query i need to get only the alphabets. column contains the special...

Error during SQL 2008 ( Enterprise edition) command prompt installation - Hi All , I am trying to install MSSQL 2008 using the below command. Setup.exe /CONFIGURATIONFILE=” C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100817_185628 \ConfigurationFile.ini”. Find...

SQL Server 2008 : T-SQL (SS2K8)

Searching a particular table in DB - Hi All, I have list of columns (say col1,col2,col3). I need to find the table in the database which contains these...

t-sql full table scan problem - I am having a performnace problem is a sql server 2008 sql. The stored procedure does a full table scan...

Move row value into column - I would like to pull a query with each student each day an attendance record. Our database setup an AM and...

return results where value exists in another table - Hi, I would like to get results from the two tables below where the ITM$Con_Note value is in both tables. I...

use results of view in where statement - I have a sql server 2008 stored procedure where I want to use the results of a view in a...

Extract string between to characters - I've a string in following format: <1|458|test|q><2|789|test2|s><5|567|test3|p> 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...

Finding gaps within date ranges - Hi, I have a group of date ranges and wanted to identify all of the date gaps within the ranges,...

SQL Server 2008 : SQL Server 2008 Administration

which table sql server will create database after log shipping and in which system database it will create? - which table sql server will create database after log shipping and in which system database it will create?

SQL Server 2008 : SQL Server 2008 Performance Tuning

script to find top queries for physical IO usage - Can please provide a script to find the top queries for physical IO usage?

out to find where is the problem in a stored procedure - Hi, I'm noticing very low Page Life expectancy <5 mins very frequently when ever a stored procedure is running. How to find...

about T-SQL Scripts tuning - There are four questions nee all help, many thanks! 1. when I create an index in a table or views, is...

SQL Server 2005 : Business Intelligence

RDL to RDLC - hi how to convert RDL to RDLC for .Net integration i saw the below but it does not work for me. http://msdn.microsoft.com/en-us/library/ms252109(VS.80).aspx Thanks Parthi

SQL Server 2005 : SQL Server 2005 Integration Services

SSIS - Input Excel file - updating Table - conditional split? - Hi - I am SUPER new to SSIS , kind of thrown into it with no training or help other that what...

Reporting Services : Reporting Services 2008 Development

ssrs 2008 options to run faster - In an SSRS 2008 rreport that I am working on, I am having a performance problem. The report is taking...

Dynamically back track records - Hi, Just made changes with my requirements. I need to dynamically back track 1 day at a time in extracting of records...

Data Warehousing : Strategies and Ideas

good book for temporal db design? - I was looking at.Temporal Data & the Relational Model (The Morgan Kaufmann Series in Data Management Systems) C. J. Date Has anyone read...

Data Warehousing : Analysis Services

auto generated mdx from reporting services - hi All, Am trying to get my head around mdx generated from reporting services when a parameter is entered e.g SELECT NON...

How do I calculate the subtotal for a calculated column using the subtotals of the other columns used in the calculation? - I have in the underlying database a column computed from other values in the same row. In ssas all these...

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 ©2013 Red Gate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com