In this issue

Featured Articles

Editorial

Featured Script

advertisement

Just starting to learn TSQL? Well known author and trainer Kathi Kellenberger will be teaching End to End TSQL in Orlando Mar 31-Apr 1. This $299 class targets beginners and is a great way to grow your knowledge fast!

SQL Toolbelt What's simplest way to make your SQL life easier?
"We are currently using SQL Packager for all of our new deployments. It was never easier than this!" Mustafa Bashiti, Dutco Group. Make your own SQL life easier. Download a FREE trial of the SQL Toolbelt here.

Featured Articles

SQLCE Workshop IV - Integration with Visual Studio 2005

Continuing on with his series on SQL Server 2005 Compact Edition, regular author Jacob Sebastian takes a look at how Visual Studio fits into your SQL CE project.More »


Featured Blog: SQL Server 2008: Spatial indexes

Paul Randal talks about the new spatial data types and their indexes.More »


Controlling Information as a Strategic Enterprise Resource

Information governance is defined by Larry English as the act or process of leading, directing, controlling and assuring that information is managed effectively as an enterprise resource. (PDF download)More »


Worth a Second Look - The 400,000 Member Milestone

We crossed 400,000 members yesterday and it's a great achievement for us. As a celebration, we've decided to give out some prizes. Read on to see if you're one of the lucky winners. More »


Worth a Second Look - Forum Etiquette: How to post data/code on a forum to get the best help

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.More »


Editorial - The In-House Expert

We increasingly move towards specialization.

How much knowledge does you in-house staff need? Should you run with a shoestring staff to maintain operations and then use consultants for any additional or specialized work?

It's a tough question and I think that many companies tackle this in waves. They'll hire everyone they need for a period of time and then when they look to restructure and perhaps change focus or projects, they let people go. Unless your particular specialty is seen a mission critical, and even then unless you're the only person that understands it, you might not be the person kept around.

Or even worse. Suppose you were the DTS expert and learned the ins and outs, built complicated packages, and more, and now your boss tells you now we've moved the SSIS development to another group and we want you to learn Reporting Services so our annoying boss can just come to you for reports and not bother the development team.

I don't mind learning new technologies, but I hate to be told which ones I have to learn.

And yet as you become more specialized, it's increasingly possible that you might pick a dead end specialty, at least at your company. You might get the choice of changing companies or changing focus. My guess is that the more specialized that you become, the less willing you are to change your focus and move in a completely different area.

I think that more and more there will be a need for the two-minute expert. People that know small parts of the system extremely well, and you can call on them for very short engagements. Just like we have consultants now for things like SSIS, Database Mirroring, etc., but I think they'll be more and more of these experts and the ways to find and engage them, will become easier to navigate over time.

Especially as more and more of them raise their visibility and success stories on the Internet.

As SQL Server and other software packages grow to include more and more features, it's harder and harder to be an expert on the system. More and more of us generalize on the platform and then specialize in one or two areas. There's nothing wrong with that and I'd encourage most of you to follow that path.

And if your specialty becomes strong enough and there's the demand, you might just find yourself working for a new boss: yourself.

Steve Jones

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


The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are now available at sqlservercentral.podshow.com to get better bandwidth and maybe a little more exposure :). Comments are definitely appreciated and wanted, and you can get feeds from there.

Overall RSS Feed: or now on iTunes!

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.

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

» To submit a tip, rant or editorial, log in to the Contribution Center


Question of the Day

Today's Question:

What does sp_validname do?

Think you know the answer? Click here, and find out if you are right.

This question is worth 1 point in this category: T-SQL. We keep track of your score to give you bragging rights against your peers.

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


Yesterday's Question of the Day

In the SSIS Slowly Changing Dimension wizard, which change type do we need to choose for implementing SCD type 2 on a dimension column? Today's question is sponsored by Apress and Vincent Rainardi, author of Building a Data Warehouse: With Examples in SQL Server.

Answer: Historical Attribute

Explanation: The “Changing Attribute” change type is for SCD type 1 (overwriting existing values), and “Historical Attribute” is for SCD type 2 (preserving historical values by writing the new values into new records). We choose “Fixed Attribute” when we want to treat changes as error. There is no change type called “Type 2 Attribute” in SSIS SCD Wizard.

Ref: Chapter 8, Page 258-259.
Slowly Changing Dimension Transformation - http://msdn2.microsoft.com/en-us/library/ms141715.aspx

Sponsored by Apress and to Vincent Rainardi, author of

» Discuss this question and answer on the forums


Featured Script

Using DDL Trigger

Using DDL TriggersMore »


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 2005 : Administering

dual in sql server - hi all, Is there anything like dual in sql server ? regards Josh

Timeout expired - I have an application with a Purge functionality. When I execute the SP from SQL Server 2005, it gets executed...

My new company uses SQL Server 2005.... - I use SQL Server 2000 at this point, I have very little experience in SQL Server 2005. What can I...

Changing table/column collation - Hi All, I am currently testing migrating a database from SQL 7 to SQL 2005. Following a backup/copy/restore to the new server,...

Problems connecting to Database - Hi, We are developing a home-grown Project . We have created a Database using SqlServer 2005 Express. We have a web application...

Migrate DTS to SSIS - Hi Guys, We are upgrading SQL Server 2000 to 2005 and I have to migrate the DTS to SSIS. SQL2K5 no...

how to improve cube processing time? will indexes help? - i would like to increase the speed at which it takes some of the cubes in analysis services to process. if i...

How to add a trigger on a database table so that I can get a complete Information on the updation, deletion, Insertion process on that table - Hi, I have many tables in my database, I want to know which value is getting change on each table when...

SQL Mail Not Working in SQL 2005 - I've looked everywhere but still can’t solve this issue. For legacy application reasons, we still need to use SQL Mail...

GUID Error when creating a new maintenance plan - Can anybody tell me what this error msg means: "Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxxxx) I am new to...

Management Studio - After Installation MS-SQL 2005 I cannot see SQL Server management studio. How to get the shortcut Icon? Nita

Compatibility Level 90 - Hi guys, I have a database in compatibility level 80 and I need to upgrade it to 90. But here and there...

Trigers and procedures become invalid automaticaly - Hi to all I have been appointed as DBA recently in company . the application and database was developed in VB and...

Does renaming a server cause problems with SQL 2000 or 2005? - We are due to migrate from SQL 2000 to SQL 2005. As part of this plan we will be renaming...

Running DB script on another server and no able to log on - Hello, I got a strange issue and I need some explanation: I created a DB script using Management Studio 2005 (Highlight the...

MSDTC error after upgrading to Sql 2005 - One of our application is failing with the below error after upgrading to SQl 2005. this was working in 2000....

How to Create Linked Server for a MySQL database using SQL Server Management Studio - It took me about a day to figure this out, so I thought I'd try to save someone else the...

SQL Server 2005 : Business Intelligence

SSRS - Specifying Test db and live db connections - Hi, Does anyone know if it is possible to create a report to point to a test DB which can be...

SQL Server 2005 : CLR Integration and Programming.

varchar(n) in C# (and C/C++) - I have an extended stored procedure in C++ that I am converting to CLR so that it will also work...

SQL Server 2005 : Data Corruption

Database in Transition - I was trying to detach a database offline but the operation failed because there was an existing connection. Now, when...

SQL Server 2005 : Development

Removing trailing spaces in a table column - Hi I am having trouble removing trailing spaces in a table column (query phrase). so far i have tried using Ltrim...

Save Image in database or in web server - Hi Experts, We are going to create Photo Printing & Social Networking site like Shutterfly.com,picsqare.com,kodakgallery.com,facebook.com. Everything is running fine. But Now I...

Query problem - Hi All, I have a table with following cols. monthwon int,Productcategory varchar(100) and revenue float. I want the result in below given format ProductCategory ...

ISNULL in a CASE statement??? - Hi, Would someone please point out why the following is incorrect / not working, and how it should be achieved... CASE [myRow] WHEN 1...

Custom Stored Procedures in MSDB - This may seem like a stupid question and I am pretty sure I already know the answer but I wanted...

SQL Server 2005 : SQL Server 2005 General Discussion

Uploading data for reporting on twice daily - I am fairly new to SQL Server 2000 and have been asked to take some of the data from 4...

Resources for learning SQL Server 2005: Suggestions? - I just took the opportunity at my company to move over to becoming a DBA. We are mostly a Oracle...

problem in sql 2005 Reporting service tool - I am very new to sql 2005 Reporting service tool .. I have installed IIS and Reporting service tool ..but while...

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered. - Can someone please help me. I executed these Commands EXEC sp_configure 'show advanced options', 1; GO RECONFIGURE; GO EXEC sp_configure 'Ad Hoc Distributed Queries', 1; GO RECONFIGURE; GO --- Error...

SQL 2005 storage partition question - We have our SQL 2005 data on a SAN logical drive but would like to move it to a smaller...

Convert nvarchar to datetime - i have some fields in SQL Server table as nvarchar(50) and the user actually enters date (example : 02/05/07) now they...

TempDB is 13gigs and growing - Hello everyone. I am back. I inherited a server that is running Microsoft SQL 2005. I was doing some routine server...

SQL Server 2005 : SQL Server 2005 Strategies

Using one table as a source for three others - I have a general design question that has me a little stumped. I have tried doing a number of searches on...

Recovery Strategy - First off I'm new at this so please be kind. Scenario is I'm trying to create a recovery strategy if a...

How do I insert data in a table which is used on the web? - I have a table which read by the web program and the web is up 24/7. But everyday I have...

SQL Server 2005 : SQL Server 2005 Performance Tuning

Index Tuning - I just want to get a bit of insight on this issue...When you get text fields like where [Name]='Dialler Wrap...

Linked Server connectivity delays - Create a linked server to another box. exec sp_serveroption 'RemoteServer', 'connect timeout', '1' exec sp_serveroption 'RemoteServer', 'query timeout', '1' Pull the network cable...

SQL Server 2005 : SQL Server 2005 Integration Services

How to select arabic or english when column have both english and arabic? - Hi, How to select arabic or english when column have both english and arabic? Please help me

What is limit of colums in SQl server 2005? and size limit of one cell or column? - Hi, I want to know How many colums can SQl server 2005 have? and size limit of one cell or column?

Package failed to execute - I've designed a package using 'SSIS import/export wizard'. This package just copy some tables from one server to another. First...

SSIS Flat File read error retry? - I am trying to read a flat file in SSIS. If the file is currently locked, I want to be...

SSIS + PHP Script - Hi Is there a possiblity to call a PHP Script with SSIS? Need the call of this script for writing the...

SSIS Package to export a stored proc result set to Excel file - I have a stored proc that produces a result set. I can do "Execute SQL Task" with ADO.NET connection to...

Storing SSIS packages... - Hi, Wanted some expert advice on what is the best practise in storing the SSIS packages, storing it in msbd...

Pushing data to an AS400 - In SQL Server 2000 I can easily push data to our AS400 using an ODBC connection - which then uses the...

SQL Server 2005 : T-SQL (SS2K5)

dateadd function - Hi All, I need help about the syntax of the sql as below When I try to Execute the tsql as below...

a subquery and tables with composite keys - I am trying to return all company's that are not holding interviews by, state. companyname, division are composite keys(Primary in...

SQL Store procedure - Hi Sir, Iam new in SQL.I need the solution for a store procedure.How create a store procedure that help me to...

fn_virtualfilestats - Can anyone tell me why the following query will run against a database with a compatibility level of 90 but...

How to simulate OBJECT_NAME(object_id, db_id) prior to SP2? - I'm doing some performance investiagations and came across what appeared to be a useful query, but unfortunately it uses the...

How to return a LOT of other columns with group by - I have a MyNames table which contains over 100 columns. The Name column may have the same name in many...

help-how to generate date backward from end to start - [b]how to generate date backward from end to start[/b] like this [code] begin -- loop to insert date backward while @end_date>=@start_Date begin INSERT INTO @tb_temp [/code] from middle of the...

SQL Server 7,2000 : Administration

MCITP - Dear All, I am Preparing For MCITP ( 70-441, 70-442), anybody give me suggestion for how to prepare for this exam,...

Logshipping Erroe - Hi, I have a log-shipping setup conigured for production DB, This is happening every 15 minutes backup/copy/restore. I would like to add...

Link to Borland Interbase - Hi We are currently using SQL Server 2000 both for creating databases, and as an integration tool with an Oracle Server...

Wrong filename syntax error... - A database has been created with a logical name hansjestest-0_Log. Note the line, NOT underscorde between ..test and 0. This...

error occurred during 2187 hot fix installation - When I apply 2187 hot fix on a sql2000 sp4 named instance on a cluster virtual server I got the...

??? SQL Server 2000 Transaction log Growing to 180 GB cannot truncate ??? - Hi Transaction log of our user database has grown up to 180 GB and now we are not able to truncate...

Error 8968: Table Error: IAM Page - Hi I'm looking for some help on the following error: Error 8968: Table Error: IAM Page(1:126078)(Object ID xxxxxxxx, Index ID 0)...

Configuring SQL Mail - Does anyone have experience configuring sqlmail or sqlserveragent mail when your Exchange server is in a seperate (non-trusted) domain from your...

SQL Server 7,2000 : Backups

SQL backup with Block-Level technology - Hi, I am running Block-Level Backup software on all my servers. The backup software provider recommends putting my SQL Server Databases...

differential backups - Hi Guys, I'm trying to implement a differential back up plan but I was thinking that it would be a good...

Restore Database missing LOG from FileGroup - Hi, I'm a web developer and defacto DBA for a small marketing company. So I get a BAK file from a client...

Remove data base file fragmentation? - What option (GUI Options) or sql command can be used to remove fragmentation from Inserts, Updates and Deletes? (SQL Server...

SQL Server 7,2000 : General

windows application - Hello, again guys I have one more question to ask regarding windows application. May be my question is stupid but...

sp_SQLSMTPMail up and died on us - Hi... We have been using sp_SQLSMTPMail as found on this site to be able to send emails from all of...

SQL Server 7,2000 : Security

Schema and View Security - This has probably been asked many times, please bear with me. Have a central database table that is populated by multiple...

SQL Server 7,2000 : Strategies

SQL server on the blade server - Hi Guys, I'm not a h/w guy. Can I install my database server on the blade server? We are in SQL...

Reporting from many SQL Servers - Does anyone have a solution which will allow them to query a number of databases on a number of remote...

SQL Server 7,2000 : SQL Server Newbies

Multiple Groupings - I need to write a query that pulls rows from multiple tables, but I don't know how to group them....

Saving SELECT Results to a CSV file - Hi, I need to automatically save the results of a SELECT statement to a CSV file. I don't want to use...

SQL Server 7,2000 : Performance Tuning

I got the Suspected MDF & LDF file. I am unable attach it. pls let me know how to attach it. - I got the Suspected MDF & LDF file from my friend. I am unable attach it. pls let me know how...

Documentum 6 causing PAGELATCH_EX Locks - Trying to resolve why this API from Documentum keeps causing blocking issues. The issue is that users are being blocked...

Microsoft: "Don´t use the prefix sp_" - A few days ago I visited one of Microsoft's "The Architect Blueprint" event in Sweden. Suddenly the "Architect Evangelist" said...

SQL Server 7,2000 : Replication

Scripting Replication - Hi, Does anyone know why when you generate a drop script for a publication the following is done, Drop Subscribers - - That's fine exec...

Unable to truncated log after restoring replicated - Hello! I have been asked to help with replication related problem. Database with replication enabled has been restored on a different...

Merge replication remove indexes on subscribers - I have a publisher that had an issue the other night that required SQL servers to be stopped and restarted....

adding target server - Hi, I've got about 15 servers I need to add.  6 worked.  the rest failed with Enlistment failed (reason: Error 14262:...

The process could not bulk copy into table ''"customer"''. - The process could not bulk copy into table '"customer"'. Last command - select * from "customer" where 1 = 2 Transaction sequence number and command...

SQL Server 7,2000 : T-SQL

help about dateadd - Hi All, I need help about the syntax of the sql as below When I try to Execute the tsql as below...

How could I know if a hash join has been executed with spilling or not? - I'm using sql2k sp3 standard ed. Looking @ the exec plan of a slow query (~9 sec for ~ 200 rows) I found...

What T-SQL commands exist which can be used in Query Analyzer to export a select statement within a stored procedure? - I eagerly await you SQL guru's out there and appreciate your help and statement examples if possible. Thanks! David

Reading IIS log files using DTS package - Hi, I've created a DTS package for reading the IIS log file daily and ported into Tables. I used Text...

sp_executesql hangs for a particular stored procedure - We have a randomly reoccurring issue (that cannot be easily replicated) on our Microsoft SQL Server 2005 - 9.00.3050.00 (Intel X86)...

SQL6.5,7,2000 and 2005 - Experts, I am going to take a session about 'Difference between Sql6.5,7,2000 & 2005 on first week of february in my office.It...

SQL Server 2008 (Katmai) : SQL Server 2008 - General

UK Katmai Launch Event - Hi All, Anyone know when the UK will get dates for the SQL 2008 Launch event? Been looking on the Heroes...

SQLServerCentral.com : Anything that is NOT about SQL!

I got a job but ..... - I finally got a job offer. It is a non-profit organization, running SQL Server 2000 standard version. I will be...

Interview Question - Hello, My friend has recently faced the usual interview question. why are you looking for change ? How to answer for this question...

Daily Newsletters for past two days??? - Were there newsletters set out the past two days? The only thing I've gotten is the Database Weekly newsletter, not...

Reporting Services : Reporting Services

Subreport not aligning inside report upon deployment - I have a report showing an overview of some data and for each row I have a subreport. When I...

Tooltip box - Does anyone know if there is a way to get a text box to appear when you hover over a field...

Database Design : Design Ideas and Questions

How to design - I have problem about how to design table to keep the document version I want to let the user to edit...

how to design table for store document - I want to design table for storing document file. Which should be my design, any suggestion? 1. store all content in column,...

Data Warehousing : Integration Services 2005

Copying multiple tables from one db to another using SSIS - Hi, Can anyone tell how to copy multiple tables from from one db to another using SSIS object model. I am confused...

Data Warehousing : Data Transformation Services (DTS)

bulk loading from flat files - Hi, I am a beginner to sql server. As a part of my first assignment, I have to load incoming flat...

DTS Package Scheduling error - I have a DTS package which runs fine when I run it manually from the Enterprise Manager. When it is...

Finding my SSIS Package on Microsoft SQL Server 2005 - I am just getting started with SQL 2005. I am trying to get familiar with the SSIS options in SQL...

Stripping out double quotes (") in bulk insert - We have a client that's still on SQL Server 6.5 (yes, I know, I struggled to remember that far back too!),...

Article Discussions by Author : Discuss Content Posted by David Bird

Missing package - Where can I find the last (full) package ?

Article Discussions by Author : Discuss Content Posted by Jason Selburg

MS BI-Passing date from Date picker (Reports ) to MDX query using SSAS - Hi, Currently I am working on SSRS using SSAS for reports. When I pass date from Date picker from SSRS...