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

Password Ninjas

For the time being, passwords are the way that we authenticate users and secure most of our systems. There might be a better system in the future, but for now everyone needs to manage a series of logins and passwords, even if you have authentication for many systems linked through an internal domain or external system, like OpenID.

I think password managers are almost required these days to manage passwords for most people. I recently ran across an article on ArsTechnica where five security experts were asked how they manage their complex passwords across a multitude of services. Four of these experts use password managers of some sort, though there is quite a variety of them. One actually remembers passwords, though he tries to use proximity tokens and one time passwords when possible.

Bruce Schneier, one of the security writers I've followed for a long time uses Password Safe, which is what I use. However he also likes to use his own advice of long sentences turned into passwords and keeping backups of passwords on physical paper. I don't like writing down passwords, but if you can keep the paper secure (not stuck on a monitor or under a keyboard), it's an easy solution to use.

There are various ports on different operating systems and different methods to keep your files in sync, if you choose to do so. Two others use competing products (1Password and KeePass), but one uses a text file in an encrypted virtual disk image that he keeps on a USB key. I'm not sure I like that, but with proper backups, it's not a bad solution.

There is a variety of advice, but overall there's one thing to keep in mind: security is serious business. All the more so as we use various services more and more to conduct business in our daily lives. Losing a password that you share across multiple services could severely compromise your life. Whatever method you choose, stick to it and be careful in choosing your passwords.

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

MP4 iPod Video ( 20.2MB) feed

MP3 Audio ( 3.6MB) feed

Feeds are available at iTunes and Mevio

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

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

SQL DBA Bundle

‘10 Tips for Efficient Disaster Recovery’

Steve Jones gives the final lesson in the ‘Top 5 Hard-earned Lessons of a DBA’. Read now and learn from the best.

SQL Compare

Compare and sync databases with SQL Compare

“SQL Compare is fast, extremely easy to use, full-featured and affordable. I wouldn't bother messing around with anything else.” Adam Machanic, SQL Server MVP. Download a 14-day free trial.

Featured Contents

 

Resolving Errors While Connecting to SSIS

Anurag Gaurav from SQLServerCentral.com

This article will help you solve connection errors with SSIS due to permission issues. More »


 

SQL in the City Seminar Sacramento 2013

Press Release from Red-Gate

Join Red Gate for a free a seminar on July 26 (the day before SQL Saturday Sacramento). SQL Server MVP experts, Steve Jones and Grant Fritchey will present sessions featuring best practices for SQL Server database development and deployment, in addition to showing Red Gate tools in action. More »


 

SQL Saturday #239 East Iowa

Press Release from SQLServerCentral.com

SQL Saturday will be in Iowa City on July 27, 2013. This free day of SQL Server Training and Networking will also have pay-for pre-conference sessions presented by Bill Pearson, Louis Davidson and Tim Mitchell. More »


 

How To Document Your PowerShell Library

Additional Articles from SimpleTalk

PowerShell provides comment-based help for functions and scripts with Get-Help, but when you want to document modues or generate a complete indexed API in HTML format, just as you can with Sandcastle for .NET or javadoc for Java, then stronger magic is required. Michael Sorens shows you how it is done, with source code. More »


 

From the SQLServerCentral Blogs - T-SQL Tuesday #44 Wrap UP

SQLBalls from SQLServerCentral.com

Hello Dear Reader, what a busy week we’ve had last week!  I’ve got 3 big Thank You’s that I would... More »

Question of the Day

Today's Question (by Steve Jones):

In what order do you need to create the keys when enabling TDE?

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 2 points in this category: Encryption.

Did you miss yesterday's question, Return? Answer now.

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 High-Performance T-SQL Using Window Functions

Optimize your queries—and obtain simple and elegant solutions to a variety of problems—using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you’ll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you’re a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks. Get your copy from Amazon today.

Featured Script

Quick view of User database and server roles

Wes Henriksen from SQLServerCentral.com

Input filters for database or database principals if desired.  Execute and review results.

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

In place upgrade from Standard edition to Enterprise edition - Hi, I got two server [Server ‘A’ and Server ‘B’] running SQL 2008 R2 standard edition [SP1]. ( Please check attached screen...

DB Free space issue - Hello, we have a vendor DB which always keeps around 3GB of free space. It is sql 2005 SP3 and DB Data...

sql server 2005 sp1 is slow - users experience slowness on the sql server 2005 sp1. Windows Server 2003 Standard Edition SP1 Physical RAM: 3.25 GB I set the...

Need to connect to sql instace using an intermediate sql server - Hi, I have a rare case need. I don't have direct access to one our clients sql server(cannot connect) I can...

Log Shipping Jobs on Secondary not getting created - Hi all: I'm trying to test my understanding of log shipping here. I'm currently trying to get it working on 2...

Database in Recovery Pending State - One of my databases is in [b]Recovery pending[/b] state. I tried to run an Alter command on the database to...

SQL Server 2005 : Backups

SQL Server Backups & Maintenance - Best Practices - Hi, I was wondering if you guys would be able to shed some light on a subject that seems very involved! We...

SQL Server 2005 : Development

FORXML not retrieving complete xml - Hi, I am having the below XML <marketDataSeries xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://pricesandcurves.ist.bp.com/xsd/CSL/IST/marketData/v1" xsi:schemaLocation="http://pricesandcurves.ist.bp.com/xsd/CSL/IST/marketData/v1 marketData.xsd" seriesID="urn:pc:FO.E.34639"> <observationDate>2013-07-15T00:00:00</observationDate> <timeZone>Londo

SQL Server 2005 : SQL Server 2005 General Discussion

any way this can avoid of index scan? - Hi, it looks impossible to me, but, is anyone know could this kind of query avoid of index scan? select * from...

query - show tables on some condition. - Hello world. I need to show all tables from my database that meet some conditions. For example tables with entries...

SQL Server 2005 : SQL Server 2005 Performance Tuning

History Data Comparision - Question :1 Server : sql server 2008 R2 a) I have "prestaging" table as source table. b) I kept working table...

History Data Comparision - History Data Comparision

SQL Server 2005 : SQL Server 2005 Integration Services

5 excel file each file contain 5 sheets we want to load into data using single Dtata Flow task - Hi All, My Name is vivek,i have few doubts below any one know to how to resolve please give me advise. 1).I...

History data Comparision and then Update flag on target table. - Question :1 Server : USING sql server 2008 R2 a) I have "prestaging" table as source table. b) I kept working table and History...

SQL Server 7,2000 : T-SQL

Dynamic Pivot for multiple columns - Hi, Here is my friend's sql server version info : Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright...

SQL Server 2008 : SQL Server 2008 - General

Log shipping: New Index Not carried over - I have a few databases that are log shipping from ServerA to ServerB where they are available as a Standby/Read...

using the default trace - Hi Late in the afternoon i had a support ticket raised for 'the app'. It was running slow around 9.30am untill...

capture currently logged in users from sql - I want to capture users logged int o my database from 9-5 and then get the average per day. can i...

Join of 2 subqueries - Hi All, I've been trying to do a join of 2 subqueries, but haven't been having much luck and keep getting...

parsing data in the middle of a field?? - Hi I have a field with a data string similar to ""....@@T_700_ = "text goes here"@@T_301_ = "06/15/2013"@@T_069_ =..... I need to pickup...

Autogrowth of database with it's file name - I use below query to get auto-growth event occurred to databases in a sql server. [code="sql"] DECLARE @trcfilename VARCHAR(1000); SELECT @trcfilename = path FROM...

Database Mirror Login SID for ##MS_PolicyEventProcessingLogin## - In William Thier's excellent SSC article "Configuring Database Mirroring" ( http://www.sqlservercentral.com/articles/Database+Mirroring/72009/ ) he mentions... "[i]If the mirrored database contains non domain users,...

create proc - create procedure insyenkcek @phone nvarchar(20),@SertiNom nvarchar(50),@ASA nvarchar(100),@telUnvan nvarchar(100),@kateqoriya nvarchar(100) ,@SHesab nvarchar(20),@Alam nvarchar(60),@IDCDMAalam nvarchar(30),@TelTarix nvarchar(50),@MuqBasTar nvarchar(50) ,@MuqSonTar nvarchar(50),@Milliyet nvarchar(60),@Cinsi nvarchar(50),@DoYer nvarchar(100),@DoTarix nvarchar(50), @SexVes nvarchar(60),@Elaqe nva

Find the host name - Dear, I require to know the host name from which my database has been accessed I mean performed DDL,DML operations within...

PAE - can we use both \3GB and PAE together ?

SQL - I searched in sites but unable to find the exact document on sql architecture , can any one send the architecture...

Time-Out Occured while estimating the compress savings with Huge Table (100Gigs) - Hi, While checking the estimated compression saving with one of our huge table with size 100 Gigs+, I ran into Time-Out...

looping through all user databases - Hi Guys, Quite new with SQL Server commands.. How can i enhance the below script so that it will run against all...

Doing Insert/Update/Delete from Oracle Source to SQL Server Dest. - Hello, I have an Oracle database located on the remote machine and can conenct thru ODBC conenction and I have a...

Issue with DATEDIFF returning Negative Values - I have written the following query and it is returning negative values for some records when calculating the number of...

Query The start up type of a service - I am just putting together a list of security checks which will eventually have a front end to them for...

dynamic index rebuild based on fragmentation level - Hi Guys, Anyone have a dynamic script which will list and rebuild indexes > 30% avg fragmentation. Seen it somewhere but can't...

create linked server using windows authentication - Hi, I have a peculiar requirement but was not able to go much ahead. Setup a linked server on InstA(mixed...

DATABASE BACK UP PROBLEM - Correct me ,, if i am posting my problem in a wrong forum. Well,,, Here i in my company i am using full...

Truncating data on a remote Server - Hello, I am trying to truncate data from one server to the other (remote server) [u][b]it works from query analyzer like this:[/b][/u] exec...

Selecting records in table only when ALL related records in other table satisfy multiple conditions - Hello and thank you for your time. I feel like this should be simple but I can’t seem to work...

How to get the month wise row of record if transaction present or not - Hi, Is that possible to write in single query to get the below results - I need to get the month wise...

How to take backup of Single table and how to restore? - Hi... How to take backup of Single table and how to restore? is there any query like database backup? shivakumar...

Insert bulk failed due to a schema change of the target table. - Hello Expert. First time I used sqlbulkcopy its performance is impressive, however my application threw a SQL exception after processed about...

How to create database from .mdf file only - Hi, I have installed SQL Server 2012 and downloaded sanple database from the below link, which has AdventureWorks2008R2_Data.mdf for download. http://msftdbprodsamples.codeplex.com/releases/view/55330 Now, how...

Shrink database while restoring - Can we shrink the database files while restoring from backup?

SQL Server 2008 : T-SQL (SS2K8)

Need help with Select Where clause using parameter equal blank or in a list - I have a stored procedure that passes in several parameters that can be blank or a list of selected filter...

Query processor ran out of internal resources and could not produce a query plan - Hello, I'm having the following error when running a query : Msg 8623, Level 16, State 1, Line 1 The query processor ran...

Index and Table Size - Hello Everyone Happy hump day to all. I am working on gather some stats for each table in a database. I am...

check if index exists - hi i am creating script for non clustered , i need to see of particular index on column on particular table exists...

How to get the first date of my table? - Hai friends, i ve the table like below create table student ( class_atttend datetime, name varchar(20) ) insert into student values ('02-07-2013', 'A') insert into...

Select All Records from Temporary Table and Assign to VARCHAR? - Hello! I am new to TSQL and require some help with a problem I'm having. I have a stored procedure where...

Unexpected Behaviour With SQL Server :,( - There is a SP which usually takes around 3 minutes to execute. Since last few days it is taking around...

error - hi select * from tableA with(nolock) a join tableB with(nolock) b on a.id = b.id where a.date > getdate() i am getting error incorrect syntax near a

delete rows - hi i need to move data to another table and then remove from old one ,which i needs to delete 30...

Problem with FOR XML EXPLICIT - Hello everybody! I'm new to FOR XML... So here is my problem: I've got a query that returns the correct result regarding rows,...

Help needed for Select Query - [b]TableName:Customer[/b] --------------------------------------------------------------------------------- CustomerId CustomerName Location City District PinCode Status --------------------------------------------------------------------------------- 4 Pavan HitechCity Hyd WG 7687 1 5 Kalyan CinemaStreet Tuni EG 1234 1 7 MVRao LBNagar Kkd GG 123 0 8 MMRao Pathape

SQL Server 2008 : SQL Server Newbies

SQl 2008 R2 - Maximum memory - Hi All I am using sql 2008 R2 DB. As per the msdn document max memory that can be allocated to...

Prev and Next Row Without RowNumber - Hello All, Can anyone help me with this one. here is the table sample. [code="sql"] --------------------------------------------------------------- CREATE TABLE [dbo].[Invoice_t]( [Cost_Center_code] [int] NOT NULL, [Payment_code] [int] NOT NULL, [INV_No]...

Stupid Question: Return Object Explorer to It's original position - Stupid question but I accidentally moved object explorer from it's original default position on SSMS. By default, object explorer is...

SQL Server 2008 : Security (SS2K8)

User with database role of "NULL" - So I have a query that I use to get a list of database users, and the role(s) they belong...

SQL Server 2008 : SQL Server 2008 Administration

SQl 2008 R2 enterprise edition compressedn backup to be restored Standard edition - Hi I have a SQL 2008 R2 enterprise edition compressedn backup which is to be restored on SQl 2008 R2 Standard...

Full backups on any database, will it affect the LSN chain ? - Hi All, Have one situation... If we take full backup .. will it be affect the LSN Chain. Please reply me

Understanding minimal logging using INSERT... SELECT - Hi All, I'm trying to understand more about minimal logging for the INSERT... SELECT operation in SQL Server. I have a database...

Will Transactional Log Backups slow the growth of Database Log file - Could somebody please clear up the confusion I'm having. Is it correct to say that if I do transactional log backups...

SQL Server 2008 R2 to SQL Server 2008 R2 Linked Server Issues - Greetings, I'm trying to establish a linked-server connection from our Regional SQL Server 2008 R2 (R1) to the Division SQL Server...

Please share the adventurenetworks database link for downloading - Hi all Please share the adventure networks database link for downloading

Data Base File Swap - Hi All, We have a huge load scheduled every day during that time we have no access / data for end user...

Right click on a Database, select properties Error, cannot show requested dialog. - I right click on a Database, select properties Error, cannot show requested dialog. The error reads: cannot show requested dialog (SqlMgmt) Property Size...

Career : Certification

Can I able to write 70-448 after JULY 2013 - Hi Folks, I have Passed 70-432 and 70-433 MCTS Exams. Also I have passed 70-451 (MCITP). Now am planning to write 70-448...

Passed 70-448! - I passed the 70-448 exam for the [url=http://www.microsoft.com/learning/en/us/exams/70-448.mspx]MCTS: Microsoft SQL Server 2008 Business Intelligence Development and Maintenance [/url]certification this weekend....

SQLServerCentral.com : Anything that is NOT about SQL!

New kid on the block - I came over here when the NNTP bridge for the MSDN forums stopped working, and I've only been here for...

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

Reporting Services : Reporting Services

Deadlock - Hi, I've been doing some monitoring on one of our SSRS servers and have picked up a dead lock that occurs...

Database Design : Design Ideas and Questions

Is it Better to use Multiple DB than Single DB? - Hi In need to design an Enterprise level solution which will contain around 8 modules (such as Accounting, Human Resource, Inventory,...

Data Warehousing : Integration Services

SSIS Export to Flat File Question - Hello All, I am a noobie. I am using SSIS 2008 R2 to export data from sql server 2008 R2...

Column out of sync error with excel data flow - I am attempting to set a connection string within an excel manager dynamically based on the latest file in a...

Data Warehousing : Analysis Services

Cube processing failures in sql server analysis services 2008 r2 sp2 - Hello all, Does anyone know how to debug cube processing failures in sql server analysis services 2008 r2 sp2? SQL Profiler doesn't...

get an average value with filters - i'm learning 2012 analysis services. i set up a test server with the tabular model. for my first project i have...

Process partition errors after cube migration - Hi, I'm trying to process a partition on a cube I've migrated from SQL2000 to SQL2008 R2 (both the DB...

Microsoft Access : Microsoft Access

Update Field to current logged in user ID with new record command button - Hello all, I have an access front end that uses a sql backend. We want to add a field in...

Access Query ported to SQL - Here is the "inner" part of a query in Access. UPDATE [Vehicle Detail] SET [Vehicle Detail].ReturnDate = #4/29/2013#, [Vehicle Detail].ReturnSource = 'ReturnProcess' WHERE ((([Vehicle...

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