SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

The Voice of the DBA

The Desktop

Lots of IT professionals I know have moved to laptops for their daily work. This allows them to keep their work handy, no matter where they are. If they need to work from home, or on a trip, they have their tools with them. It's a good move for many people, but I wonder if it's what the majority of professionals want. As a side note, if you have a work laptop, with work data, you ought to be using whole disk encryption.

When I worked as a production DBA, it was handy to have a laptop to connect to work from home and check on things. However I felt this was a double edged sword, with the responsibility of carrying the laptop with me, and the expectations of management that I would be "more available" than if I didn't have a portable work machine.

Recently I thought about this when I saw a release for a new desktop PC that is "no wider than a golf ball", the new ThinkCentre M93 from  Lenovo. It's small, and powerful, with enough power for many developers and administrators that might work in the technology area. It's also one of those machines that I might consider portable.

To me this might be the best of both worlds. Something that's a desktop, removing me from the responsibility and obligation to take it home with me every night. However small enough that if I did need to work at home, to monitor a process, or get something done away from the office, I could pack it up and use it at home.

I wonder how many of you have laptops from work, or desktops, and if you prefer one or the other. I used to appreciate an employer picking up the expense of a laptop, but these days I'd prefer to buy my own and let the employer keep their equipment in the office, and out of the rest of my life.

Steve Jones from SQLServerCentral.com

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

The Voice of the DBA Podcasts

We publish three versions of the podcast each day for you to enjoy.

Everyday Jones

The podcast feeds are available at sqlservercentral.mevio.com with  comments definitely appreciated. Overall RSS Feeds:  

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.

 You can also follow Steve Jones on Twitter and find links and database related items and announcements.

SQL Backup Pro

Try new SQL Backup Pro 7.4 today

Check out the latest version - and you can still get 5GB free storage in the cloud when using the new hosted backup features. Find out more.


Hate explaining your database in meetings?

SQL Doc quickly documents your entire database schema so that you can easily present it to others. "This tool is embarrassingly easy to use." David Hayden, DavidHayden.com. Download a free trial now.

SQL DBA Bundle

Top 5 Hard-earned Lessons of a DBA

‘10 Tips for Efficient Disaster Recovery’ by Steve Jones. Prepare for any future disaster by reading Steve’s tips today.

Featured Contents


Parameter Sniffing and Sniffing Memory

SQLSACT from SQLServerCentral.com

This article aims to demonstrate bad parameter sniffing and its effects on memory grants. More »


Using DAX to retrieve tabular data

Additional Articles from SimpleTalk

Data Analysis Expressions (DAX), originally the formula language for PowerPivot workbooks, can also be used within the MDX query window of SSMS to directly access data from a tabular SSAS database, an in-memory database that uses the xVelocity analytics engine and compression. Robert Sheldon shows how easy it is to retrieve data from a tabular database. More »


From the SQLServerCentral Blogs - Ordering steps in a SQL Agent job

Kenneth Fisher from SQLServerCentral.com

Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is... More »

Question of the Day

Today's Question (by pramod singla):

Create table test(a int)

insert into test values (null)
insert into test values (2)
insert into test values (3)
insert into test values (1)
insert into test values (null)

select *from test
order by a

What will be the order of null values?

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: T-SQL.

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


SQL Server Execution Plans

SQL Server Execution Plans shows you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including: Which indexes are being used, and where no indexes are being used at all. How the data is being retrieved, and joined, from the tables defined in your query. How aggregations in GROUP BY queries are put together. Grab your copy today from Amazon!

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

You have enabled TDE on an important database in your organization. While preparing your DR plan, you realize that you need to make backups of certain objects in order to be able to restore your TDE database on a new instance at your remote location. Which objects do you need to back up?

Answer: the certificate that protects the DEK

Explanation: The only object you need is the certificate protecting the TDE Database Encryption Key (DEK). The DEK is inside the backup, and the master key in the master database is not required.

Ref: http://msdn.microsoft.com/en-us/library/ff773063.aspx

» Discuss this question and answer on the forums


SQL Server 2012 Data Integration Recipes

SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You'll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more.

Get your copy from Amazon today.

Featured Script

List orphaned users from all databases

James Howard from SQLServerCentral.com

The following script will interrogate the orphaned users in each database on a particular server. All records from sysusers where the record contains a SID are selected, before using suser_sname(SID), which returns the login name associated with a security identification number (SID). If the returned value is null, the database user is not attached to a valid login.

Various filters are subsequently applied to exclude rows not required eg database and application roles.

A temporary table is then populated with data from each database using the sp_MSforeachdb procedure.

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

Best Index Rebuild/Reorganize and Update Statistics Strategy - I have a several databases in full recovery model around 200 GB. As soon I run maintenace plan, log fills...

SQL Server connectivity Issue - I am able to connect the server but not to the SSMS. getting the below error: " The client was unable to...

SQL Server 2005 : Business Intelligence

Execute Child packages parallel in loop - hi , I have a master package which calls the child packages from a folder dynamically, when i tried this with...

SQL Server 2005 : Development

Downgrade INSERT with OUTPUT to Sql Server 2000 - How do I convert the following Sql script so that it will run on Sql Server 2000 (which does not...

Convert scalar function to Table Valued func - How can I convert the below function to return table. I am thinking of putting in cross apply rather than...

getting eroor during odbc connectivity in mysql 5.6 - i am getting following error during the odbc connection please help me everything i fed correctly in connector odbc [hy000][mysql][odbc 5.2(a) driver]access...

SQL Server 2005 : SQL Server 2005 General Discussion

Query Help V2 - I posted a question a few weeks ago, and due to a external influence i managed to confuse the whole...

How to maintain an incrementing row id - This problem is so fundamental, I'm hesitant to ask it, but here goes. I have a table with a primary key...

SQL SERVER 2005 sample databases - i have been trying to download and install 'AdventureWorksDB' for SQL server 2005. the microsoft download center routed me to...

SQL Server 2005 : SQL Server Express

database 'master' is not valid 9003 error Help!!! - I ve just rebooted the server. After it reboots SQL Services not started and i got these errors on the...

SQL Server 2005 : SQL Server 2005 Integration Services

Logon failure: unknown user name or bad password - Hi, I'm completely lost here... I have a SQL Server Agent job that execute a SSIS package. The same job...

SQL Server 7,2000 : Administration

Boxes symbol in query output - 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

Clustered Index Ordering & Insert Speeds - Hi, We used to have a clustered index which consisted of 5 fields, this was ordered incorrectly which meant new inserts...

restoring databae to setup Mirroring - i have 123Gig of database, i am trying to setup mirroring for it. we take full backup every week and diff backup...

Restoring diff backup problem - i am trying to mirror the database, i have restored the full database backuop now i need to restore diff back and...

SQL 2000 - Maintenance Plan - In SQL 2000 while creating maintenance plan, there was Optimizations which REORGANIZED the data and indexes. What it does really?...

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

Find The Similar Matching String - Dear, I have a customer table containing many duplicate names and custid is the unique key. But the customer names are...

what is database refresh? - hi... How to Refresh database in sqlserver 2008? database refresh or rebuild both r same or not?

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

Will the mirroring will be able to work properly if restricted growth or change the setting of max size of database - I have a mirror database. they are set to unrestricted growth. As per company policy the database should be in restricted...

Sending mail from On Prem server to Off prem exchange - Im having some troubles getting my SQL mail setup using an off premise exchange with office 365. I can get...

SSIS in cluster - I have two nodes nodeA and nodeB on a sql server on a fail over clustered environment. Each of these...

Filegroup - Hi All, Please let me know whether it is possible to use the same secondary filegroup for 2 different databases. I tried...

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

SQL Server 2008 : T-SQL (SS2K8)

previous week query 0700 - 0700 - HI all I have been asked to generate reports from my c# package I have created every Monday at 0700hrs,...

complex joins retrive the echivalent results - Hello I have a problem on doing an complex join between multiple tables : Here is my tables [code="sql"]GLCMS IDN KMSO KCVA FSCVA ----...

SQL Server 2008 : SQL Server 2008 Administration

Receive notifications that the Transaction Log Backup has failed when it has succeeded. - Receive notifications that the Transaction Log Backup has failed when it has succeeded. I have been receiving notifications that the Transaction...

SQL Server on Windows Server 2012 essentials - Admin Help - I have just installed Windows Server 2012 essentials on my HP Mediasmart server. I am going to be using server...

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

PREEMPTIVE_COM_GETDATA - We are running SQL2008R2 64 bit standard version. One of the application encountered (via Tomcat service) error " database.pool.ConnectionPool Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The...

Programming : General

Spliting a comma delimited parameter from Crystal - Hi there, I'm new to SQL and to Crystal reports. I know that to pass a multiple value parameter to a...

Trouble with date conversion - I want to match the year field in a table and pull out all that are a year old. I'm...

SQLServerCentral.com : Anything that is NOT about SQL!

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

Data Warehousing : Analysis Services

Count Columns - Hi hi have a follow result on my mdx query groupA | groupB | groupC | TOTAL 100 200 400 3 ihi already made the groups,...

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