In this issue

Featured Articles

Editorial

Featured Script

Featured Articles

Suggestions for PASS

PASS is the global users group for SQL Server DBAs, but there are a number of people who have never heard of it. Longtime author Andy Warren has a few suggestions for PASS and encourages you to submit your own.More »


SQL Server 2005 Build List

Build List Updated with Cumulative Update 4 for SP2. More »


SQL Server 2005 Express Edition - Part 6 - Post Installation Configuration Tasks (Encryption)

In our new article, we will continue coverage of this topic by describing other activities that alter default connectivity settings applied during standard installation, focusing in particular on encryption.More »


Understanding the Difference between Owners and Schemas in SQL Server

SQL Server 2005 introduces the concept of schemas as opposed to object owners found in previous versions. This article will explain the differences between the two and, hopefully, clear up some of the confusion that still exists about schemas.More »


Editorial - Working with PASS

Professional Association for SQL ServerI joined PASS in 1999 and attended the inaugural Summit in Chicago. It was in the lower level of a hotel just on the river, I went to the last White Sox game of the year, and got to see Kalen Delaney speak about this newly released SQL Server 7.

I was excited, eager to grow my career, just starting to write, and I learned a lot from my 3 days in the windy city. I met a lot of interesting people and have felt that PASS helped grow my career and even motivate me to start this site.

Over the last 8 years as I've worked with PASS in various contexts, I've often tried to come up with suggestions and ways that the organization could grow and promote DBAs in a positive light. I believe in PASS and think it's a great organization for DBAs.

There's a "however" here, as there is for most things. Over the last few years I think PASS hasn't taken advantage of the excitement and growth surrounding SQL Server 2005 to really build their organization. And I'd like to see that happen as would many other people.

DBAs suffer from not being appreciated in many organizations. Just look at the descriptions on the web for our job or even open positions. They're all over the board and so many managers have no idea what value we bring to an organization on a regular basis. PASS could help us better define what we do, how we can be used, and why we're worth so much money :)

My business partner, Andy Warren of End to End training (and former partner in SQLServerCentral.com) has written an open article today that gives some suggestions for how PASS can grow and help the community. It's not really intended to knock the work done by PASS, but more to create some debate and try to see where we can grow PASS from here. And he'd like to see your comments and suggestions.

If you're not a member of PASS, and you're a DBA, you should be at least a free member. It would be nice to see you attend the conference, participate in local user groups, or help grow our profession out to others. You might disagree, but I really think that with a strong organization behind us, DBAs can only become more respected, appreciated, and hopefully, compensated.

Steve Jones


The Voice of the DBA

Everyday JonesToday's podcast features music by Everyday Jones. I really like the music and acoustic feel of this band. They're starving musicians on tour. Check them out in New York this week.

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

Someone called me the "Voice of the DBA" awhile back and I liked it. I'm looking to rename the show to that unless there are complaints, criticisms, or a large general outcry.

I've done video the last few days, but it's a big time consuming process and it's gotten me a bit behind on other things. I will probably drop to three times a week unless there's a lot of interest to keep going everyday. If you like it, tell the boss!

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

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


Compare your live DB to a backup!

Remember how long it takes to restore a full backup?
Can you imagine the PLEASURE of cutting out that step?

"The compare Live DB to SQL Server Backup is GREAT!
I used to routinely restore my backup files to a temporary DB to do this,
and this will save tons of time!"

Justin Webster, Software Developer/Technical Lead, Fortune 15 company

Download a 14-day free trial of SQL Data Compare Pro


 

 

Red Gate Software - ingeniously simple tools


Question of the Day

Today's Question:

Which type of export output is not possible from ReportViewer at client-side? Sponsored by Apress and Asif Sayed, author of Client-Side Reporting with Visual Studio in C#

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

This question is worth 1 point. 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 SQL Server 2005, how are the primary and secondary sustems in log shipping coupled?

Answer: loosely

Explanation: The two systems (or more ) in a log shipping scenario are loosely coupled. The logs are copied and restored asynchronously.

Ref: Loosely Coupled - http://en.wikipedia.org/wiki/Loose_coupling
Understanding Log Shipping - http://msdn2.microsoft.com/en-us/library/ms187103.aspx

» Discuss this question and answer on the forums

Today's Question is sponsored by Row Level Restore from Red Gate.

Have your chance to win a professional license of SQL Backup and SQL Data Compare 6. Faster and finer-grained than object-level restore, new Row Level Restore in SQL Data Compare Pro lets you easily restore the data you actually want. Submit your answer now to enter!


Featured Script

MOM 2005 Datawarehousing Catchup

I wrote this script because our MOM Datawarehousing got so damn behind. <BR/> Every time the windows Scheduled task tried to run to warehouse the data <BR/> out of...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 2005 : Administering

SQl LOG file growing - Hi, My company uses SQL Server 2005. We have a database which is not that large (aroung 5 GB) but the...

FULL-TEXT catalogs - In SQL 2000, I have two questions: 1. Why the new full-text catalogs is disable in EM, you need to go to...

SQL 2005 Maintenance Plan Cleanup - SQl 2005 standard edition SP2 GDR2 (9.00.3054) This is a consolidated server. I backup to a set directory with a sub-directory...

SQL 64bit memory - I am running sql2005 64bit on a 2 node cluster dedicated as a SQL server, and i am getting users...

An error occurred during the execution of xp_cmdshell - In SQL Server 2005, once in a while, the xp_cmdshell gives the following error. "An error occurred during the execution of xp_cmdshell....

backing up a mirrored SQL 2005 database - Hi All Does anyone have any experience with the following scenario: I have a mirrored database setup - Server A is the principal,...

3 Active and 1 Passive SQL Clustering Scenario. - Hi , I am looking some information regarding scenario in SQL 2005 where project team wants 3 servers running as active...

Log File growth after re-index - Hi, I have maintenance plan to check integrity,re-organize index,re-build index,updata statistic which run every Sun @ 2am. however I notice that on monday...

Allowing non dbo to create table as dbo - Hi, I would like non dbo user to be able to create table as dbo (I don't want the table created...

Runs in Production but not QA - We have an interesting problem, we have restored a database from production to QA. There is a specific stored proc...

Change the Owner of a Maintenace Plan - The owner of a new Maintenance Plan is always the user who created the plan. How can this owner be...

User permission - i have one user which i gave only data_reader permission only. i am suprise that he can update certain tables...

Sql Server 2005 Clustering - Hi Everybody, We have a cluster service accout used to create a Windows cluster and also the service account runs on...

Error during Login Process (to SQL Server 2005) - Hello all, I am using Management Studio to connect to a SQL Server 2005 Standard Ed + SP1. MStudio returns the following message: ------------------------------ Cannot...

Update SQL tables - Hi All,   I am very new to SQL programing and I am trying to update a table by receiving the data...

Impossible to attach Adventureworks - I just installed SQL 2005 and I tried (repeatedly) to attach Adventureworks; it fails displaying the Message Box below. I run DBCC...

SQL Server 2005 : Backups

I need do a restore from DB.A to DB.B in 2005 - I have a .bak file and I want to restore it on another server with a different DB name. In...

SQL Server 2005 : Business Intelligence

Article about BI consultancies - Article. ========= The business intelligence market is changing rapidly. Three major forces driven are changing the landscape. Firstly, BI software vendors are...

SQL Server 2005 : CLR Integration and Programming.

Actual Reason to Use CLR - Steve created a forum, might as well use it... The one question that none of the DBA's where I work have...

SQL Server 2005 : Development

execute SQL server query from Dos command prompt/ batch file. - Hi All, I need to wirte a batch file, which connects to SQL server, executes a simple Query and output the...

cant connect to my web method - i created this endpoint: createendpoint first_Endpoint state=started ashttp

INNER JOIN ON TWO DATABASES - Hi: I have a VB 2005 application that has two separate SQL Server 2005 databases in the application folder (Fees.mdf...

SQL Server 2005 : SQL Server 2005 General Discussion

Is 'on update cascade' include column name changing? - Hello, I'm using the exec sp_rename statmente as follows: exec sp_rename 'table.old_column_name','new_column_name','column' and I wondered if its my responsibilty to chang also all...

HOW TO INSTALL SQL 2000 & 2005 ON THE SAME SERVER - I have one Server(Dell Poweredge 600SC, 1GIG of Ram) and want to install both Sql Server 2000 & Sql 2005 on the...

Drop/Create index on a table in a DB that's on a linked server... - Is it possible to drop/create an index on a table that's in a database you are connected to that is...

Mirroring Large Databases - Are any of you currently using mirroring in a production environment with large (> 1Tb) databases? If so, how do...

How to search and replace multiple stored procedures? - We are promoting a lot of old stored procedures to production but the are referencing a development box. Is there...

T-SQL Code Bank - Hi, I was wondering if anyone had any interesting tools/solutions for creating a library of T-SQL scripts - i.e. compiling all of...

Returning rows in one table based on rows not in another table - Hi All, I am new to SQL, but based on the excellent response I got from a previous question I am...

Seperate digits - Hi There, I have a table, holding both streetnames and housenumbers/Housenumberintervals/letters in the same column, StreetnamesNumbersLetters Appelstreet, city 345 A James Hight 107-109 Upper...

About sql server capability - Hi, In my application i have to stored large number of data's in my tables minimum 1 lakhs per table. I...

SQL Server Management Studio Installation Issue - I am trying to install SQL Server Management Studio on my desktop so that I can use the tool from...

error saving Excel document in varbinary(max) field - Hello, We have a web site where users can upload and save various documents. These are being stored in an SQL Server...

Dabase Mirroring - Hi, I have a general question on database mirroring in synchronous mode. As I understand, in this mode a transaction is...

Encrypted Database - I have inherited a database that appears to have encrypted columns. All the interesting columns (user name, account number, etc)...

SQL 2005 (x64) linking to SQL 2000 (x86) problem - We run in a mixed environment of Intel 32-bit SQL 2000 and AMD 64-bit SQL 2005 servers. SQL 2000 runs...

VIA Protocol and how to disable - Hi I have a SQL 2005 server I am testing on, and I tried to apply SP1 onto it. I had...

Failed to notify ''operator name'' via email? - Following command sends email fine: EXECUTE msdb.dbo.sp_notify_operator @name=N'operator name',@body=N'test message' However, SQL Job with a notification to above operator doesn't work. Job history...

SQL Server 2005 : SQL Server 2005 Security

Experience with Database auditing tools - Hello all, I am in the process of evaluating and choosing proper third party tool for database auditing. Does anybody have...

SQL Server 2005 : SQL Server 2005 Strategies

Date encrytion - I have this situation where I need to retrieve information for a particular, date or a range of dates. My...

Xml Question - I am prototyping a Data-Auditing table in which all audits are stored in one table. I want to store the...

Always recursive query - Hello On the following auto referencing Table containing hierarchical documents CREATETABLET_DEVPART_DPT ( DPT_ID bigint NOT NULL PRIMARY KEY, DEV_ID bigint NULL, DPT_PID bigint NULL, DPT_ORD...

SQL Server 2005 : SS2K5 Replication

Transactional replication conflict - Hi, I Implemented Transactional replication (with immediate updating subscribers) between two sql 2005 servers. The server has got one database...

connection to subscriber - when i click the start button on view synchronization status dialog box then i get an error saying ' the process...

Replication between SQL 2000 and 2005 - All I want to do is to replicate a couple of tables between one server running SQl 2000 and another...

SQL Server 2005 : SQL Server 2005 Performance Tuning

Require info about the permormance impact between procedure and slowly changing dimension - Hi, I have to implement the logic ( insert, type 1 , type 2 handling) to load huge data into dimension table(Extracting the...

Performance Tuning Check List - Hi All, I'm new to SQLSC and always willing to learn. I have my own way of tuning SQL server but...

SQL Performance with Aggregete Sum on LOTS of data - Ok... I have a question and am at my wits end about this - here is the scenario: Ledger Transactions have 1..*...

SQL Server 2005 : SQL Server 2005 Integration Services

Logging package name for any event in sysdtslog90 Logging table - Hi, I decided to use SQL Server to store logging data of all my Integration Services packages. I also created...

IsolationLevel = Snapshot, TransactionOption = Required - For love nor money, we can't get this to work. I'm trying this oh so simple example on a dev...

Unable to retrieve Column information when using Ole Db Provider for sybase - Hi All, I am in process of transfering data from Sybase to Sql Server using SSIS 2005  have taken a Data Flow...

Importing HTTP file using SSIS? - Hi,   I am just wondering whether anyone has any experience of how I would import a .csv file from a website....

SQL Server 2005 : T-SQL (SS2K5)

Insert Problem - hi, Can you please help me in this issue? create table #check ( cno int , sal int default(200) ) -------- insert into #check values (1, default) above...

SQL Server xp_regread, Error Traping - CREATE PROC Reg_Get AS BEGIN EXEC master.dbo.xp_regenumkeys ‘HKEY_LOCAL_MACHINE’,'SOFTWARE\ISS\CPE’ IF @@ERROR 0 BEGIN RAISERROR (’Key doesnt exists ‘,10,1 ) RETURN 1 END RETURN 0 END GO – Calling Script EXEC Reg_Get – Result Msg 22001, Level...

returning balance value on TSQL - Hello comunity I have a TSQL to return an account of my customer, like this date document debit credit balance 16-10-2007 inv.111 100,00...

How to get user roles - When a user logs into my application, I would like to see which DB roles are assigned to that user....

Hierarchy - How to Convert Oracle Connect BY into T-SQL - I have a table with two columns that I received by UNION. Steps 1 and 28 are roots. from_step_id to_step_id 0...

Nested Update Statement (NEW) - Hi All, I just wanted to update different columns from multiple Table. I execute the below script, its working fine, Please correct me, If...

Converting Float value to varchar - say you run this sql: DECLARE @fl AS FLOAT SET @fl = 789512385 SELECT CAST(@fl AS VARCHAR(50)) it prints out 7.89512e+008 I need to get this...

Arranging the data?? - Let's say I have a table containing these values: Id name title -------------------------- 1 Seba Developer 1 Joe DBA 1 Steve Developer What should I...

sp_opencursor error Could not create an acceptable cursor - I was asked to run the profiler to check for an performance problem in an VB.NET program and found an...

SQL Server 7,2000 : Administration

full-text catalogs - In SQL 2000, I have two questions: 1. Why the new full-text catalogs is disable in EM, you need to go to...

Confess over DTS packages and DTS scheduled jobs - [size="2"]Hi, I am confessing over DTS package and DTS schedule job in SQL Server 2000, need advice on doubts below: 1)Based on...

System Performance - High CPU utilization--> SQLSRV.exe - Hi all, I have users complaining about slow performance. I have sql server 2000 installed on windows server 2003. 32 gb...

Designing a reporting database (Strategy needed) - Hello Everyone, I am currently looking at designing a reporting database for users to query data, there are massive/intensive reports that...

Intermittent Windows NT Login Problem - Every month (give or take), any new NT connection fails, and if one was already made, it is unaffected. SQL...

Tracking changes made thru EM - Hi, I have an issue. My fellow programmer once tried to change some code like commenting few lines in SPs...

Script for DB reindexing - Hi I was looking for a script for database reindexing (dynamically), but I couldn’t find it in the script section. ;) My...

Disk performance issues - Best candidates for a move? - Hi there, I'm looking for a bit of advice on the best file layout setup. We have a Server running SQL...

Linked server connetion??? - I am fairly new to a small IT group and getting my feet wet with DB admin.  I have been tightening...

xp_sqlagent_enum_jobs State field - I'm trying to determine what are the values that may be returned in the "State" field for the xp_sqlagent_enum_jobs and what...

SQL Server 7,2000 : Backups

how to enable sp_fulltext_database in sql server 2000 desktop engine - hi folks, hi just i want how to enable the full text search index or sp_fulltext_database in sql server 2000...

URgent: system error 33 - I am getting this error from a full backup: BackupMedium::ReportIoError: write failure on backup device 'F:\SQLDUMPS\Customers\Customers_db_200211200740.BAK'. Operating system error 33(error not...

SQL Server 7,2000 : General

need help in DB design - Hello everyone, i have some requirements for the project, i designed a db , but also need help to confirm it,...

bcp dump prompting for password - going nuts here - command: C:>bcp hrdb..employee_table out c:\temp\test.csv -t, -T Produces: Password: CTLIB Message: - L6/O8/S5/N3/5/0: ct_connect(): directory service layer: internal directory control layer error: Requested server name not...

SQL Server 7,2000 : Security

Preventing access to SQL Server from other Servers - ben_634 1hr 20mins ago I posted this question before but I'm not sure it was fully understood: I'm using MSSQL7, NT...

SQL Server 7,2000 : SQL Server Newbies

How to union tables with date-serialized names - I am trying to work some logs which are put into MSDE tables with names such as [i]sw_sysdblog_2007_10_15[/i] that have...

DTS problems after changing server - We have just move from one server to another. Now I have the following problem: My DTS's will not run through...

Temporary tables not recognised by Crystal Reports V9.2 - I am in the process of converting an application to use temporary tables. The SQL Server side of this has...

delete and determine dups by datetime field - Heya, I am trying to determine how to most efficiently keep my table free from duplicates. On an ongoing bases (every 20...

System Views for finding out what logs are applied? - Hello I set up Standby log shipping and the i am able to see the log getting shipped and restored on...

Merging data from rows to column on duplicated ID - I am currently working to solve this problem that i am facing. I just cant' get my desired solution to my...

SQL Server 7,2000 : Performance Tuning

Profiler - Can I trace a specific table? - I've run Profiler traces on a specific database, but I'm wondering if I can narrow it down even further to...

Question about SQL Server max memory configuration - Hello, I posted this at sql-server-performance.com (where I found good information on SQL performance audits) but thought I should post it...

SQL Server 7,2000 : Replication

Merge Replication Deletes Records - I have a publisher, separate distributor, and several anonymous merge subscribers. For some reason, replication will delete some child records...

identity - not for replication - I am trying to get my head around the not for replication on an identity column using merge repl. If...

SQL Server 7,2000 : T-SQL

Trying to understand SQL Server's handling of redeclared variables - I have some code I am writing and just wondering if this will cause some issues i.e. memory leaks etc....

Convert positive number to a negative - Hi All, How can you convert a positive number into a negative. I have tried *-1 but this doesn't seem to...

sum(float) != sum(float) - I've moved a databse from prod to dev and a calculation on a sum of a flaot column gives a...

How to join a table-valued Function - Dear Forum, I hope someone knows the trick. In a rather complicated computation, I use a table-valued function with two Parameters...

Convert rows into columns - Hi, I have the following table structure ID   Jan   Feb   March   April  May ...  Dec 1     a       b      c         d      e   ...   z 2     aa  

equivalent of DateSerial() in T-SQL? (SQL2000) - Hi, I need to calculate the last day of the month in a stored proc--any month. In VB, I do...

Career : Employers and Employees

Advice for a newbie - Hey guys, not sure if this is the place to ask this question, and if it isn’t I do apologize.

SQLServerCentral.com : Anything that is NOT about SQL!

I just want to do my job ! - It seemed for the past couple years, I had a lot of problems with my job mostly because of 'people'....

SQLServerCentral.com : SQLServerCentral.com Website Upgrade

Online formatting for Articles causes words to be cutoff - It's very, very annoying to try and read articles online when your formatting (CSS I'm sure) causes the HTML tables...

Code samples in the forums - I've been adapting the Simple-Talk prettifier to produce IFCodes, so you can paste code straight into forum entries. The idea...

Reporting Services : Reporting Services

Binding XML to Table or List - Hi Guys, I was wondering if what I'm trying to accomplish if feasible or not. I have this one field of nvarchar(max)...

Data Warehousing : Integration Services 2005

SSIS Questions - Hello all,  I'm having 8+ months of experience in SSIS, Can any one tell me Some Interview point of questions for...

Testing Center : Question of the Day (QOD)

Alternative for VARCHAR (MAX) or VARCHAR (8000) - Hi All, I am using the below SP to find out COUNT of datum for Number of Null Data and Number...

Microsoft Access : Microsoft Access

Server: Msg 7343, Level 16, State 2, Line 1 - I am trying to insert data in remote server which is an sql server 2000 database . while inserting following error...