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

Developer Pressure

I've been learning about continuous integration (CI) and continuous deployment (CD) from a number of people at Red Gate Software. As a company, we've embraced the concepts, pushing most, if not all, of our software through this process. We are using our Development Manager software internally for more and more of our web projects. Some of our tools, SQL Prompt, include "experimental features" pushed out rapidly to users, with the options for them to turn these features on or off as users desire. We update these tools often, releasing dozens of times a year. There are no shortage of challenges in working at this pace, but we are addressing the issues as best we can.

One of the big issues that I see in a CD environment is there is a bigger burden placed on developers to ensure the code is of very high quality. In this type of environment, there may be less QA work being done manually, and more automated testing. There is a quicker turnaround when you find issues that developers need to correct. Customers see changes sooner, and more often, and will expect corrections or new features to appear just as quickly. All of this adds up to more pressure on individual developers.

The question I wanted to ask this week is about how developers feel about this? You could take this question a number of ways, but let us know what you think.

Is Continuous Deployment good for developers?

Does this result in higher quality work from developers? Is it more stressful? Does it mean that developers get into a rut and not learn new techniques because they are working faster? Does a developer have less responsibility because automated test and customer feedback will allow them to quickly address issues?

I think this is a multi-edged sword for developers. It can be a burden or a blessing, but a lot of the way you view it probably depends the individual developer. No matter what the issues, if you use it to improve your skills, as well as your software, I think it's the best way to build software.

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 ( 17.5MB) feed

MP4 iPod Video ( 21.0MB) feed

MP3 Audio ( 4.2MB) feed

Feeds are available at iTunes and Mevio

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

ADVERTISEMENT
SQL Search

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 Monitor

Check SQL Server performance at a glance

We consulted 1000 SQL Server professionals to make SQL Monitor’s UI as clear as possible. Start monitoring with a free trial.

deploymentmanager

Deployment Manager 2 is now free!

The new version includes tons of new features and we've launched a completely free Starter Edition! Get Deployment Manager here.

Featured Contents

 

SQL Server Error Log Scanning

Rudy Panigas from SQLServerCentral.com

This article will show you how to scan SQL Server Error Logs with ease and track important information that is stored there. More »


 

Techniques For Improving SQL Query Performance - Indexing, Parameterization and Partitioning

Additional Articles from MSSQLTips.com

You are tasked with examining poor performance for queries on a certain table, or range of tables. Perhaps a sales report is timing out or running unacceptably slow; perhaps your web application is failing to return the result set before the application timeout is reached. You need to find out what's causing the bottleneck, and optimize either the queries used, the table schemata, or both. More »


 

SQL Licensing - What Managers Need to Know

Press Release from SQLServerCentral.com

PASS Professional Development Virtual Chapter will be hosting a session on what managers need to know about SQL Licensing, presented by Joseph D'Antonio on September 11, 2013. More »


 

SQL Saturday #244 Johannesburg

Press Release from SQLServerCentral.com

SQL Saturday is coming to Johannesburg, South Africa on Saturday, September 14 2013. Join us for a free day of SQL Server training and networking. More »


 

From the SQLServerCentral Blogs - Share Your Ideas for Improving PASS on September 9th (Suggestion Tsunami!)

Andy Warren from SQLServerCentral.com

My friend Aaron Nelson was in Florida recently for SQLSaturday #231 and we always find a few minutes to catch... More »


 

From the SQLServerCentral Blogs - The Case of the NULL Query_Plan

Patrick Keisler from SQLServerCentral.com

As a DBA, we're often asked to troubleshoot performance issues for stored procedures.  One of the most common tools at... More »

Question of the Day

Today's Question (by pramod singla):

Choose the meta-data items that are not included in an MDS model deployment package (choose 3)?

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

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

ADVERTISEMENT

Microsoft® SQL Server® 2012 Step by Step

Teach yourself the programming fundamentals of SQL Server 2012—one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems.

Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

If you are working with Filestream in SQL Server 2012 and delete a number of files, they might not be removed immediately. How can you force this garbage collection to occur right away?

Answer: run sp_filestream_force_garbage_collection

Explanation: You can force the Filestream garbage collection to run with sp_filestream_force_garbage_collection.

Ref: sp_force_filestream_garabage_collection - http://msdn.microsoft.com/en-us/library/gg492195.aspx/css


» Discuss this question and answer on the forums

Featured Script

SQL Powershell Script To Restore multiple databases at One Go

Raushan Srivastava from SQLServerCentral.com

#  This script is used ONLY in test/development environments!
#  If you are planning to use this to restore production databases you should first test and evaluate the script in a test environment.
#  You can change the script if needed to match your environment and needs.
 
# Script will restore all the databases (*.bak) which are located in the folder defined as parameter.
# It will place database files to location defined for data and log files in SQL Server instance settings

# Steps to run this script:

1)First Save the script in file "D:\PSScriptToRestoreDatabases.PS1" -- you can save it at any location and write the command accordingly.
2)Open Run-->sqlps
3)write below commands .. Specify the BackupFileLocation and SQLServerInstance in this command
   D:\PSScriptToRestoreDatabases.PS1 -BackupFileLocation [bak_file_location] -SqlServerName [SQL Server Instance]

Parameters:
   -BackupFileLocation parameter is the full path to the folder where the BAK files are located
   -SqlServerName parameter is the SQL Server instance name where to restore

#  Example:
#  D:\PSScriptToRestoreDatabases.PS1   -BackupFileLocation "D:\SQLBackups" -SqlServerName "DEFAULT"
#  D:\PSScriptToRestoreDatabases.PS1   –BackupFileLocation “D:\DBBackups” –SqlServerName “.\SQL2008R2”
#  D:\PSScriptToRestoreDatabases.PS1   –BackupFileLocation “D:\DBBackups” –SqlServerName “.\SQL2012”

You will get the results like below ...

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

Clustered indexes - [i]Clustered indexes also have some disadvantages compared to heaps. When you insert a new row into a full page, SQL...

sql server 2012 - hi folks, this is Imran, and kind of new bee to sql server 2012, I wanted to know what are the...


SQL Server 2012 : SQL 2012 - General

Is there a way of copying the securables definitions from 1 db to another? - We're finally moving to SQL 2012 from SQL 2005. Is there a way of automating the moving or copying of...

Upgrading from SQL 2008 R2 to SQL 2012 R2 - We're finally going to be upgrading our old SQL Server 2005 instance, to SQL Server 2012 R2. Therefore I need...

SSISDB deployed package run as windows user - Hi I am trying to run a SSISDB deployed package by windows user but as per My requirements I cannot directly...

Sql Server 2012 installation Error - Hi everyone, I hope I can find some help on my Sql Server 2012 Evaluation(x86).While installing I am getting this...

Impact of trace flag 272 on SQL Server 2012 apart from disabling identity jump - I am upgrading my application's SQL Server from 2008 R2 to 2012. As discussed in the below URL I am able...

what is the best way to copy database from 2012 to 2008r2 - Hi Everyone I am asked to copy and move database from 2012 instance to 2008r2 instance; those are on separate VM(virtual...

How to tell if instance is MSDN licenced or not - Hi, I've been evaluating SQL Server 2012 for a while now and have started to use it in production. I am...

SQL Server Full to Simple to Full Recovery Model - Whenever I have a huge log file for any database with Full as its recovery model This is what I do...

Minimum Active Directory required for SQL Server 2012 Enterprise - I have had a request from our Network Admin as to "what is the minimum level of Active Directory required...

AAG Backup - Hi all I have 2 doubts on this can anyone please clarify: On primary for system database backup I have...

SSRS 3.0 Parameters input issue - Hi all, I am building a report that will make a comparison with figures for the last 3 months, and last...

Backups \ Maint Jobs AlwaysOn SQL 2012 - Hello all, I have installed and completed a AlwaysOn 2 node VM failover cluster, what fun :-D! I was starting...

SSIS 2012 Log Provider for SQL Server displays progress error when logging messages using shared project OLE DB connection - Hi All I am building a SSIS project using the Project Deployment model of SSIS 2012. I am configuring package level...

SQL Server 2012 cluster install error - I am installing SQL Server 2012 Enterprise (x64) with SP1 on a Windows 2012 SP1 3 node cluster utilizing mount...


SQL Server 2012 : SQL Server 2012 - T-SQL

Reset ranking based on flag - Hi all, Looking for some help with a query problem that's had me banging my head against a wall :-) Basically I...

SELECT ONLY ONE ROW FROM MANY - I a table that stores item data. The tables contains an itemid, label code, date time and recordID. Each item...

Need to alter my code to show limited Info - I am trying to write a query to show by regions the top 4 languages spoken there. How can I...

Temp tables vs "permanent" temp table vs User Table Type - Hi, We have an SP that receives an XML field with loads of data (sometime it has over 1.000 records). The XML...

Is there any way to turn of parsing? - Hi, I'm writing a script that will gather server information from different versions of SQL, starting from 2005. I cannot run the...


SQL Server 2008 : SQL Server 2008 - General

Cumulative total column wise - I have an issue where I need to count the cumulative total column wise effectively and could not get a...

Problem with grouping in SSRS 2008 - When I create a report in SSRS 2008 and I add a group, the group appears in the object as...

Knowing which tables to drop - HouseKeeping - Hi, Over the years our DWarehouse has expanded and there are a few tables on the Databases that we think are...

Project Plan - Need Project Plan for SQL server 2008 Database server.. general overview.. please suggest Like we have SQL servers. so what would...

Getting table size greater than zero even row count is zero ? - Hi, I was checking table size and row count and found a table type heap with rowcount 0 is have space. Can...

Create table of unique alpha numbers to use as sku's - Hello all, I am new in the since of posting in the forum I do have some past experience with SQL...

Service Broker takes long time to insert into a table - I am new to service broker. One of our databases uses service broker on SQL Server 2008 R2. A Stored...

Same query, two users, different performance - Hey Gurus, I have a query that performs differently depending upon the user executing it. This was first brought to my...

SQL server startup parameters - Hi, i'm trying to find the startup parameters for sql server 2008 and 2005 using t-sql... for sql 2008 R2 i was...

Log Shipping using Virtual Servers - Good morning all, I'm looking at implementing log shipping on two virtual servers running VMWare and SQL Server 2008 R2 (Standard)...

Reporting Services - Two Questions about reporting services 1) Is it possible to rename the ReportServer database? I have just tried but change it...

Path to a Database Architect - Hi Guys, Would you please provide some links or books details to learn to become Database Architect.

Difference Between Restore And Attach - What is the difference between Attach And Restoring a Database in Sql Server?Looks like a Simple question?please folks share your...

[Microsoft][ODBC SQL Server Driver]Login timeout expired - hi everyone! i am a student working with SQL SERVER 2008R2 on windows 8 64-bit os.. from a month i...

SQL 2000 Install - I need to install SQL 2000 on a VM that already has 3 instances of SQl 2008 R2 installed. Something in...

How to update string based on Dates. - Create Table #temp ( Lnno varchar(15), Inst_Date Datetime , Amount Numeric(12,2) ) Create Table #temp1 ( Lnno varchar(15), No_of_Month Int, Date_Pattern varchar(15), ) Insert Into...

SQL Server Link to Oracle Inconsistent metadata problem - Hi I have created a linked server to Oracle using the Oracle OLE DB provider "ORAOLEDB.ORACLE" from SQL 2008. I can...

xp_regread execute permission denied - Hello All, I am having the issue described here: https://connect.microsoft.com/SQLServer/feedback/details/515132/management-studio-generates-scripts-that-use-unsupported-undocumented-procedures More specifically the user right-clicks on a table and gets 'EXECUTE permission denied...

Cannot login to Analysis Services 2008 from SQL Server Management Studio - Last week I installed SQL Server 2008 developer edition with service pack 1 on windows 7 Home Premium. Before install...


SQL Server 2008 : T-SQL (SS2K8)

Need SQL help - I am trying to schedule emails. I have to write my own tables. I am not the best SQL coder,...

String splitter function - Hi All, I need help with a function which accepts a string and returns in the column format for SQL...

Query Result in Email? - Hi. I have created database mail profile account with SMTP also email realy working.. Could you help me as below Query...

Find multiple status in one Column from different rows - I need to find the multiple relationship with a Customer in one row. It would be able to search based...

Trying to bypass via tsql a database when it is offline - IF EXISTS (SELECT name FROM sys.databases WHERE name = N'archer' and state = 0) BEGIN use archer SET NOCOUNT ON DECLARE @objectid int DECLARE @indexid int DECLARE...

case when looping through column values and applying conditions depending on value - Hi Hi I want to create a sql script which loops through a column (segment) and transforms the value if...

Finding row number which caused the error in Table value parameter insertion - Hi I am trying to write a Bulk import procedure, i am using table value parameter to insert thousands of rows...

Proplem Put Filter ("And" or "Or") in Query - Table With two Feild Name,Tools Example Table : 1-Mike Walker 2-Mike Cane 3-Steve Walker 4-Mitchell Cane I want someone who uses both(Walker and Cane ) to...


SQL Server 2008 : Working with Oracle

Making SSIS work for extraction from Oracle11g to Sql Server 2008 on a 64bit server. - Hi, I am trying to execute a sql agent job (ETL from Oracle 11g to Sql Server 2008) on a 64bit...


SQL Server 2008 : SQL Server Newbies

Recalculate Wages (Reposted for SQL 2008 with additional columns) - Recalculate "Amount" Column -------------------------------------------------------------------------------- Our Salaried Employees have to log in their time by department and by type of Earnings (Regular, Holiday,...

Using IIF to test for Null - This should be very easy and I am predicting a big forehead slap in just a few minutes after I...


SQL Server 2008 : SQL Server 2008 High Availability

MS cluster pre-setup question - For any MS cluster setup Active /Passive do I need Windows Server Failover Clustering (WSFC) set up also . Any other...

What are ways of Exporting data of Wahehouse Database from Production to Development Server? - Hi, I would like to export data of warehouse from Production to dev for special reasons, what are best possible ways for...


SQL Server 2008 : SQL Server 2008 Administration

Error while taking the backup - Hi All here we are trying to take a backup using job but we are getting error message we are trying...

Cancelling a Bulk Operation impact - Hi Experts, What happens if i cancel a bulk insert operation for 1 Billions rows into a table in between? is the...

Performance counters missing... - Hi Team , SQL Server performance database objects --------------------------------------- These SQL Server performance objects are not available: ''SQLServer:Cache Manager'' The SQL Server is not...

DTA - I uploaded a trace file to DTA, the file size is 4GB & i need to run it against all Databases. What...

Logical Backup Maintenance Plan - I have full backup jobs that run nightly. I would like to create a maintenance plan to run a 'logical'...

database in simple mode with growing log file into the GBytes - I'd like to get suggestions on how to handle the issue I'm facing. I have a database that sole purpose...

SQLServer 2008 R2 SP 2 confusion - We have three node cluster configuration for SQLserver 2008 R2. We are planning to do upgrade SP 2. We realized...

unable to connect to server - Hi all. here we are trying to connect to server which is not accessible and it through the below error. Error:The operating...


SQL Server 2008 : SQL Server 2008 Performance Tuning

Query Plans migrating from 2005 to 2008R2 - I'm migrating from a 2005 server to a 2008R2 Server on Windows 2012. I restore the backup to test on....

intermittment slow data modification on sql 2008 r2 - Hi Folks, I am working with sql server 2008 r2 standard (build 10.50.4000) Occasionally (not all the time) we get slow data...


SQL Server 2005 : Administering

Minimal permission required to read the Errorlog file. - Hi Guys Can you let me know what is the minimal level of access is required to read the SQL Errorlog...

Does differential backup creates LSN ? - Hi All, I have a query regarding differential backup. I have taken full backup F1 and Differential backup D1 and then...

What happens when we take SQL Server Full backup - Hi All, Please explain; what exactly happens internally in SQL Server when we take database full backup. Thanks in advance.


SQL Server 2005 : Backups

How to restore the database from MDF and LDF file - Hi all, I have only one MDF and one LDF files of my database. I want to restore the database from...

Backup Job gives Error - HI Guys. i cannt' understand what's going on the server.. actually i have created a two jobs for full backup for...


SQL Server 2005 : SQL Server 2005 General Discussion

Which page record,extents are currently used as mixed.. - Hi All, I would like to know here about pages ... as Which pages record, which extents are currently used as mixed...

Can you please help me?? - I have some doubts in using of loops in sql server 2005 can you please anyone help me? Thanks in advance


SQL Server 2005 : SQL Server 2005 Security

inaccessibility of DB for a certain user - The trouble is: We have an instance, there are several databases. We have a login (uses Windows authentication, lets call it...


SQL Server 2005 : SQL Server 2005 Integration Services

Guide on SSIS SFTP..... - Hi Forum, I am in very urgency to implement SSIS Package in my Project , As the client upload's the file using...

SSIS package last date/ time run - Hi, How to find date/time last SSIS packgae ran. Please let me know if you need any other details .. Thanks In Advance, -Krishna


SQL Server 2005 : SQL Server Newbies

Recalculate "Amount" Column - Our Salaried Employees have to log in their time by department and by type of Earnings (Regular, Holiday, Sick, etc)....

Stored procedure to run results of view - Hi everyone, Was hoping someone can help me with the following. We have a view that selects a selection of data...


Reporting Services : Reporting Services

Installation of Reporting Server through server clonning - Hi, We have rebuild one of our server from a clone of the physical disk from another server. When we...

SSRS Report Performance - I occasionally develop multiple data sets from my data source in the process of developing reports in SSRS and then...

Using SharePoint 2010 Lists in SSRS 2012 Filters / Parameter Questions - Hi all, We are trying to do a report off multiple SP Lists in a single report. im having trouble finding...

How to get the Report URL in SSRS - Hi Folks, Could you please let me know how to get the Report URL(i,e the URL gets generated after the report...

SSRS 2012 Report Issue On Server - I am having an issue with one of my reports. When I run the report in BIDS 2010 there are...

want to use SQL function that returns XML as datasource to SSRS report in 2008R2 - HI All, I am trying to use a SQL function which returns XML as a datasource for an SSRS report 2008R2. I...

Webservice reports issue - urgent help needed - Hi all, I'm trying to call a report via the web server ReportServer/ReportExecution2005.asmx?wsdl. I've got an odd error occurring which would appear...

Subreport on separate folder - I read on other topics that to use a subreport from another folder you set its path. I've looked on...


Reporting Services : Reporting Services 2008 Development

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

Parameter Eqaul to or Not Equal to - Hi, I am faced with a problem. I am trying to create a parameter that gives the choice, for example: I want...

Filter Parameter on Chart - I have a report with say for eg 13 Charts I have 3 parameters setup which are cascading DataCentre Instance DriveLetter So in my main...


Data Warehousing : Integration Services

Connecting to Excel via Agent job Issues - Hi all, Im guessing this is a simple one but im missing it somehow. We are trying to import data...

Using SSIS 2012 to read data from Oracle 11g R2 - Hi, I need to read and import into a SQL Server 2012 db data from an Oracle data source (Oracle 11g...

format of decimal - I have a SSIS package, of attendance data. most of them is a whole number like absent days 5 days,...

PKG with Attunity Connector fails with JobAgent - Hi, I am using Attunity 64 bit connector to load data from Sql server to Oracle database. It works perfectly when...


Data Warehousing : Analysis Services

Retrieving the last non-empty value and display it for each day - Hi all, I am new to SSAS and more so with MDX and I need your help with the following scenario...


SQLServerCentral.com : Anything that is NOT about SQL!

Fantasy football 2013 - I renewed the league, you should be getting an email soon. At the moment, there are no open spots, but...

Today's Random Word! - HI When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene...

Are the posted questions getting worse? - Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in...


SQLServerCentral.com : Articles Requested

change the default database - Show how to change this, in T-sql and ssms, for a login. Say a sysadmin to get them out of...

sp_executeSQL - A piece on how to use this.

What's a trusted FK? - Explain this and why it matters. Or doesn't matter.

Blocking Chain - Spackle - a short piece on how to identify a blocking chain and find the root blocker.

Export with Headers - How can you export data from a query, using bcp, SQLCMD, etc. and include the column headers at the top?...


SQL Server 7,2000 : Administration

Configure Logshipping for multiple databases using Scripts only (not by using SSMS) between two servers as a Disaster Recovery solution - Hi All, Description : We have One server with 2 instances with 75 DB's.All the Databases size is 135 GB.We would like...

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