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

DevOps

The DevOps movement is supposed to promote a closer collaboration between developers, testers, operational people, and really anyone else that must help software gets build and deployed. The developers need to coordinate their needs and requirements with operational staff. They should work early on with any staff performing testing to help them ensure that bugs are caught quickly and fewer slip through to production. At the same time, operational staff should be responsive  and helpful in all the environments software moves through. Operational staff should help build and automate the configuration of development and testing environments, ensuring that systems are built in a repeatable fashion as well as the same way in each stage of the software development pipline.

However, is devops killing the developer? If developers are becoming responsible for testing, that's bad. If developers must learn to function as a DBA as well, then I certainly expect they'll write less code. If developers need to ensure the software can be installed on production systems and train operations staff, then I suspect they aren't very happy with their jobs.

But that's not DevOps. If that's how your organization runs its development, it doesn't understand DevOps. Developers should be leaning on and learning from, as well as teaching other staff. When I read that post, I think the developer has missed the idea of DevOps. It isn't that developers need to become completely versed and responsible for the full stack. It's that they should be working with everyone involved in the process the entire time that software is being developed, using the specialized knowledge each person has.

DevOps isn't something new. I've worked in teams that worked like this in the past, but we never had a name for what we did. We just thought we were part of the same team. I've also worked in organizations with walls between all groups. That wasn't a team, and we had lots of four letter words for that style of process.

DevOps is a good term and a good idea for software development. If a company implements it well, then it works and people are happier with the way software is produced. If they aren't, then the process hasn't been configured correctly.

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 ( 2.6MB) 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. Support this great duo at www.everydayjones.com.

Everyday Jones

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

ADVERTISEMENT
Can the DBA Team save the data

Can the DBA Team save the data?

There’s sinister work afoot at Monte Bank. Backups corrupted beyond repair – and without a trace of the cause. Can the DBA Team save the data? Find out in Part 3 of their new series, 5 Worst Days in a DBA’s Life.

SQL Source Control

24% of devs don’t use database source control – make sure you aren’t one of them

Version control is standard for application code, but databases haven’t caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out…

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.

Featured Contents

 

SQL-only ETL using a bulk insert into a temporary table (SQL Spackle)

Stan Kulp from SQLServerCentral.com

This article demonstrates a method of importing a data file directly into a temporary table and selectively inserting data from the temporary table into a SQL Server table, all in a single set of SQL commands. More »


 

Is Source Control Really That Boring?

Additional Articles from SQLServerCentral.com

The SSC team has put together a little quiz on database source control to go with Rob Richardson, Robert Sheldon, and Tony Davis' new book, SQL Server Source Control Basics. Do you daydream about source control... or daydream to avoid it? More »


 

Traits of a DBA - Part Two – The Personal Side of a DBA

Additional Articles from Database Journal

A good DBA needs to have good technical skills but he also has to have good personal skills. In this article, Greg Larsen discusses the personal skills a DBA should have. More »


 

From the SQLServerCentral Blogs - Get SQL Server Info - Quick Tip & Script

Robert Pearl from SQLServerCentral.com

There are a number of ways to collect basic information about SQL Server, its version, edition and other top-level properties.  What is... More »


 

From the SQLServerCentral Blogs - Yes, Virginia, you can have too much white space.

Kenneth Fisher from SQLServerCentral Blogs

When I was in college and taking programming classes (back in the days when “a T-Rex ate my 5.25 inch... More »

Question of the Day

Today's Question (by free mascot):

Which of these are true about the recovery interval? (Select correct 2 options)

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: Recovery Interval.

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

SQL Server 2012 AlwaysOn Joes 2 Pros®: A Tutorial for Implementing High Availability and Disaster Recovery using AlwaysOn Availability Groups

SQL Server 2012 brought in some great new features and one of the important ones is scalability and performance via AlwaysOn. AlwaysOn is a superset feature and is a combination of many things you will learn about. As the language suggests, this technology achieves a SQL Server infrastructure that can be "always on". For businesses that run 24x7 downtime means the loss of business. This type of risk is out of the question for these businesses. This book discusses in detail the concepts of SQL Server AlwaysOn starting from the basics.

 

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

Can I create a regular table in tempdb?

use tempdb;
go
create table MyTable
  (
   myid int
  , mychar varchar(200)
  );

Answer: Yes, we can run this as is.

Explanation:

We can easily create regular tables in tempdb. Run the code to see that this is allowed.


» Discuss this question and answer on the forums

Featured Script

Column Exists or not?

Shiva N (AxSys) from SQLServerCentral.com

We need some time to add the columns to Existing Table,

Then that column name already exists in the table or not?

we can use this function for dynamically execution.

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

The table with Name of 'Table Name' does not exist.An error occurred when loading the Model. - Hi SQL Server Friends, This is regarding an error related to SSAS tabular instance . The error is "The table with Name of...

SQL Server 2014 is very slow - Hi, Just installed standard editon, put tempdb on SSD and configured buffer pool extension to SSD. Ran some production replay trace....


SQL Server 2014 : Development - SQL Server 2014

SQL Help - I have a Contract table with a CoverageCode column. I what pull 5 records for each CoverageCode. Currently I am...

sp_send_dbmail truncates when attaching query results. - Installed SQL Server 2014 CU1. While testing sp_send_dbmail I noticed the query results, when attached are cut off or truncated....


SQL Server 2012 : SQL 2012 - General

RESTORE DATABASE - BUFFERCOUNT - Anyone have a good description of what the BUFFERCOUNT option does in a RESTORE DATABASE command? Can't find anything online...

Microsoft Baseline Configuration Analyzer 2.0 showing only 2008 R2 BPA - Hello experts, I'm trying to run the Microsoft SQL Server 2012 Best Practices Analyser (BPA) against a SQL 2012 server. First...

RAISE ERROR to THROW conversion - Hi, I have an old proc like below which I want to update to use THROW. Looks like THROW can save...

Allow a low privilege user to execute a stored procedure to create db users - I have a requirement to allow a user to restore a database and then create database users and add them...

Need help on Configure linked server with Failover partner - Hi, Firstly, I don't to it is possible to create Linked server with Failover partner option. I can query when primary...

Suggest me the best choice regarding Importing Data & Indexing - Hi Friends, I have a CSV File, I am importing this into SQL Server using SSIS package through Flat File source...

SQL 2012 Multi Instance Cluster - DTC - Hi all I am required to set up a multi-instance SQL/Windows Cluster. Windows 2012 Ent/SQL 2012 Ent There will be 12 instances across...

Index Maintenance and Update Stats - Hi there I am using Ola Hallengrens scripts for index and stats maintenance but I am wondering what most people to...

Converting Directory File Path into HierarchyID - I am trying to create hierarchyID for a directory file path. Can anyone please help and give any suggestion on...

15 minute interval report between two dates with total for each interval - Hello, I’m trying to create a report which will give me a break down of how many unique vehicles have been...

Insert sequence number - I need help to code to add sequence number. One claim number may have various max sequence number. For example, 1) Claim...

Database Data Files out of Sync - I've stepped into a new environment and have never dealt with multiple data files on user databases only with Temp...

How to run query execution plan for parameterized queries? - Hello Experts, I am curious to know if there is any way out to run execution plan for parameterized queries? As application...

Restart Computer Prompt - PendingFileRenameOperations does not exist - I am attempting to install SQL Server Express 2012. Th setup support rule to "restart computer" continues to fail. Based on...

Trigger after UPDATE INSERT based on column value - Hello All, I would like to change a value after the table updates \ inserts a new row based on the value...

Availability Group Listener Creation - I have just set a SQL 2012 availability group up, testing it is working and all seems fine. I am not...


SQL Server 2012 : SQL Server 2012 - T-SQL

How To Group By Values Over None Contiguous Data - HI Guys I was wondering if anyone can help me. Im trying to generate a list of data such as this [code="other"] STOCKID MIN_WKNUMBER MAX_WKNUMBER...

How to run a SQL job using different account. - Hi I have a job that needs to execute with different account. I figured i need a proxy so i...

how to have a conditional join, or a conditional union based on parameters passed to stored procedure - I am writing a stored procedure that takes in a customer number, a current (most recent) sales order quote, a...


SQL Server 2008 : SQL Server 2008 - General

Having issues transferring file from 1 server to another. - I d' like to get some help with the problem I am having transferring the backup file (42GB) from 1...

SQL 2008 - CXPACKET - I have an table with half a million records. A simple SELECT of 500 rows takes very long to finish....

changing a columns data type - Hi I have a requirement to change some fields from nvarchar(max) to something more suitable ie Nvarchar(50). When I check what 'dependencies'...

4 Data files and 3 Log files on same drives!! - I've got a Production server with 4 data files on D:\ and 3 Log files on L:\. which was migrated...

Cannot add foreign key - Hi, I dropped a foreign key constraint on a table and now trying to add it back again. However, I get an...

SNAPSHOT ISOLATION question/issue for sql server 2008 SP3 with security update - I'm running Microsoft SQL Server 2008 (SP3) - 10.0.5512.0 (X64) Aug 22 2012 19:25:47 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit)...

Snapshotting mirrored databases - Hi all I'd like some advice (and I can't find anything on Google) before I attempt this one. First some background..... Server A...

Datetime filter now working - Hello, I have no idea why i can't get this to work. In my where clause, i have a datetime field which...

Update based on multiple conditions in a single pass? - Hi, I have the following issue which I'm trying to resolve: essentially, I have a table of measurements on one side, then...

1 Quick question for all the DBA's - I am wondering if someone can help me out. I have become a SQL Server DBA about 7 months ago,...

What would your answer be for this question? - I have come across a question on of the job interviews, i have already answered the question but was curious...

Need Help parsing through the XML - i have an XML that needs to be written onto a table here is what i have done i created...

Simple question: How many users are connected to the sql server (instance)? - Hi all, I can't find perfect answer for this question: Can you check how many users are connected to the Sql...

Exporting SQL Jobs history - Hi, I know how to export a SQL Server job's history to a file by clicking on the Export button inside...

Index grows really fast! - Hi all , I have just created an index but it grows so fast... in 3 hours it becomes 95% fragmented...

Generate script to restore log backups - Hi, I have more than 2000 log backup files in Z:\Backups\t-logs folder to restore after restoring the full database backup on...

Adding version to row to ensure user updates the current row version - Hi! I'm having the problem described in the following example: Table Samples: SampleID | Color 1 Blue User A open sample 1, its color is...

How to efficiently import data in .rpt format into SQL 2008 - Good day, I have been told to import 100G data generated in SSMS and in .rpt format (10+ files) back to...

disk space 90% full... - Hi friends, Today i found that one server is having space issue, it has 90% disk space full and in that...


SQL Server 2008 : T-SQL (SS2K8)

Insert multiple values based on parameter - Hi All, I need to write SP where user select SUN to MON check boxes. If user select Class A with...

Where clause Integer Greater than - Hello! I'm not very technical on T-SQL so hoping this is an easy answer for someone. When I use the following...

Access EXCEL using OPENROWSET - I'm trying to access Excel file from SQL Server management studio using OPENROWSET using the below query but getting the...

Specifying Faiover partner in OpenRowset - We have a database,which has been mirrored.Also,We have an application which uses OpenRowSet to connect to this database. Is it possible...


SQL Server 2008 : SQL Server Newbies

Question about Parsing and Case Statement - I have to write a SQL script where one of the requirement is DeliveryIDcharacters 1-7 not equal to 'aaaaaaa' AND (If...

Comparing records to previous records in query - Hi, Here is a sample table: CustomerID------InvoiceID------Total ----95---------------3546--------#30 ----100--------------3547--------$12 ----95---------------3548--------$42 ----100--------------3549--------$25 ----100--------------3550--------$30 I'm looking to write a query that will only return the invoices for each customer that...


SQL Server 2008 : Security (SS2K8)

Users scheduling jobs - Is there a way to allow users to schedule a job that they don't own? If I'm reading it right -- and...


SQL Server 2008 : SQL Server 2008 High Availability

How to upgrade an Active & Active sql cluster? - Hi Experts, How to upgrade an Active & Active sql cluster? Is there any difference in upgrade for sql 2005 Active-Active cluster and...

Client side automatic reconnect fails after DB failover when SQL Server on non-default ports - Hi experts, I have the following issue: Three SQL Server DEFAULT instances with a database DBX (on two of them - Primary,...


SQL Server 2008 : SQL Server 2008 Administration

what is Hyperthred ratio? - Hi, In layman terms, what is hyperthread ratio mean? How is it used/useful in sql server ? Books online says, It is...

Shirnk Tlog(LDF) size? - Hi, Database High availability - Mirror setup configured, Principal server Tlog (.LDF) file size 25 GB, also warning messages recording at error...

Backing up a DB with log shipping turned on - I have a Db which has log shipping turned on. If I create a separate maintenance plan to do a...

SSRS Slowness - Hello Experts, I have situation where in SSRS is slow. I google regarding that and got a query to find the issue...

SOX Compliance - I apologize if this is not the correct place to post my question on SOX compliance....Did not know where else...


SQL Server 2008 : Data Corruption (SS2K8 / SS2K8 R2)

Dbcc checkdb says 0 errors but SQL error 823 produced - The db is working as normal, but in the SQL logs I see these 3 messages The operating system returned error...


SQL Server 2008 : SQL Server 2008 Performance Tuning

TempDB Avg Wait Times - Hi All, I am new to the forum and don't have a ton of SQL experience. In our environment we...

Taking long time for a single table execution - Hi, I am having a table "Test" with 70 columns. Out of them a composite primary key is defined with...

Force Parameterized Queries vs Missing Indexes - Working with a third party that would like me to enable the server option Force Parameterized Queries on MS SQL...


Cloud Computing : SQL Azure - Development

Accessing tables across databases? - Hi, As far as I am aware T-SQL stored procedures can only access tables in the database where the stored procedure...


SQL Server 2005 : Administering

The client was unable to reuse a session error - While trying to capture some info to be used to troubleshoot various problems, we created a trigger on the server...


SQL Server 2005 : Business Intelligence

Specify Values in SSRS parameter - Hi! I have a SSRS report , parameter @A uses 'specify values' (integer 1 and 2) as available values. What I need now...

SSRS hide column - I want to hide one of my column based on this logic; =IIf(First(Fields!TOLERANCE_CHECK.Value, "NetUnitPricingReport")= NULL, True,False) I get an error on the...

How to validate data of a flat file source with the data of different tables of my database? - Hi All, I am trying to find a solution for my task. My task is, I have a Flat File Source data....


SQL Server 2005 : Data Corruption

Repair Corrupt Access Database File - I am using MS Access 2010 and one of my databases on our shared network does not open for any...


SQL Server 2005 : SQL Server 2005 General Discussion

Adding a failed node back to cluster - Hi, This is on SQL Server 2005 / Windows 2003 environment. Node 1 of a 2-node cluster crashed, db is up and running...

comparision data between two servers - hi, I have two servers one is prod and test(replication of prod), I need to compare all the tables in all the...

Datime time based syncronization - hi, (i am Using windows 2008 ,windows xp and sqlserver 2005 ,2008) i have to put some data from one...

Spid of -3 holding permanent lock on database and tempdb does not have any tables after restart - I restarted my server's SQL Service when I could not kill a connection for nearly an hour. This caused many...


SQL Server 2005 : SQL Server 2005 Security

How to set password newly install Sql server 2005 by query? - Hi, I'm using Vb6.0 Database : SQL Server 2005. In my vb6.0 installation file, add sql server 2005 and install automatically if not already...


SQL Server 2005 : SQL Server 2005 Performance Tuning

Database Designing Related - Hi Friends, Please Help me...... I Have the below requirement........ 1. Design the DB for ‘Retail Stores Business’ where various products are on...


SQL Server 2005 : SQL Server 2005 Integration Services

format the output column in destination .csv - Hello, in ssis, I use a oledb source to execute a stored procedure and a flat file source to have the...


SQL Server 2005 : T-SQL (SS2K5)

Concatenating fields into one - Hi all I'm running SQL 2005 with SSMS 2012. I've got a table with the following fields: Visit ID Abstract ID QuerySeqID (Query Sequence ID) Response The...


Reporting Services : Reporting Services

?? on adding a day to a dataset filter date - Hi I have a two date parameters (StartDate and Enddate) I want to filter dataset1 by Startdate thru Enddate + 1 Day , I...

Multiple Databases - I have a query where in I Union two separate SQL database queries. It works fine. Now I need to...

ssrs 2012 rdl connect to data source - On a ssrs 2012 reporting server, I want to install load uploaded rdls to a test report server. The rdls...

Using two entities in a Report Builder filter expression - I am wondering if anyone has any idea if it is possible to using two entities in a Report Builder...

Frustrating Issue - I have created this report twice but don't seem to figure out the problem. I keep getting this error The SortExpression...

SSRS Chart issue..Bars dont show up but data does - I have created a column chart in which the data is showing up properly on the x and y axis...


Reporting Services : Reporting Services 2005 Development

SSRS 2005 development using SSRS 2008? is it possible ? - Hello I think I know the answer to this one already thought I'd ask; is it possible to develop SSRS reports...

SSRS 2005 Limitations help - Hello In a new job I am having to work extensively with SSRS 2005; however pretty much all the SSRS development...


Reporting Services : Reporting Services 2008/R2 Administration

reporting services - I have two reporting services environments. First one is a native running on the same sql 2008r2 box using the...


Reporting Services : Reporting Services 2008 Development

Help !!!! How to hide pdf export for specific report? - Hi all, Is it possible to disable the pdf export only for specific reports ?? I need your help. Lidou

SubReport problem - I need a report to display a bar chart report for top x items. The x value can driven from...


Programming : XML

need help parsing XML - i have a Storedprocedure that returns an xml EXEC [dbo].[bofa_sp_esb_sel_xxx] @SearchType = N'A', @SearchInputList = N'57575757', @FAsInputList = null below is the XML <AccountDetail> <Account> <AccountNumber>12345678</AccountNumber> <ShortName>john</ShortName> ...


Data Warehousing : Integration Services

ssis error in excel connection manager - Hi, i have a ssis package where i import excel to sql table destination. . i created a excel connection manager and...

Extracting VarBinary(MAX) column to Flat File - Facing Issue. - I’m extracting data from the table to flat file using SSIS,during this process I’m facing the data conversion issue in...

import to multiple excel files - Hi I have a query with the fields: unitname, pointname, point description as: worthington,anderton,comms status smithfield,waverley, boot status islignton, shenfield, exit status Select...


Data Warehousing : Strategies and Ideas

Hardware requirement new datawarehouse - Hello all, for our new datawarehouse I am trying to put together a hardware config. I understand this is not an...


Data Warehousing : Analysis Services

Input parameter based on text -- I don't want default values - Hi, I made my query in MDX, working fine. Moved it to SSRS report , not working completely. My question in short: I have...

Date Dimension Filtering - Hello, I have a date dimension [Facility].[Close Date] which I need to filter on. The criteria for the filter is to...


Database Design : Disaster Recovery

MS Access .mdb & .ldb database corrupted - I am using a A.mdb database. You know when connecting the databae Microsoft automatically create a .ldb file. Unfortunately my...


SQLServerCentral.com : Anything that is NOT about SQL!

Anyone going to SQL Bits 17-19 June Telford ICC, UK - Is anyone going to SQL bits who would like to meet up on the Wednesday or Thursday. @Gail - I know you...

Fantasy Football 2014 - SQLServerCentral would like to host a Fantasy Football league again in 2014. As of now, we'll run this league the...

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 : SQLServerCentral.com Website Issues

Active Threads link - The Active Threads link is really inconsistent lately. It does not appear most of the time. When this happens the...


Career : Certification

Any one like to share 70-433 legit exam practise questions (MeasureUp, SelfTest, Transcander) - Hi, I am preparing for exam 70-433 and looking to buy either MeasureUp or SelfTest practice exam question, please let me...


Career : Employers and Employees

Definition of a Database Architect - Been a loooong time since I last came here, seems like forever and yet remarkably familiar. Anyways, really got my curiosity...

This email has been sent to {user_email}. 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 ©2014 Red Gate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com