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

The 2013 Tribal Awards

We're the #sqlfamily on Twitter, and often in person where we often get together for a #sqlrun in the morning and a bit of #sqlkaraoke at night. In some sense, we are a tribe within the larger technology community, focused on our common work with SQL Server. I thought the title for  was fantastic, bringing together new authors to share their knowledge, and raise money for a charity.

At SQLServerCentral and Simple Talk, with the sponsorship of Red Gate Software, we decided to create some end of year awards in various categories, based on the community, not companies or products. We kick off our nominations today in a number of categories, including Advice that saved my bacon in 2013, Best Speaker, Best Outfit, and more. You can read more about the categories in today's announcement.

The idea is that the community can recognize others in the community with a nomination, and some supporting material that encourages others to nominate the same individual, and vote for the winner. The top five with the most nominations will get voted on over the holidays with awards presented in January.

I hope you have fun with this, and think back to those people and events that stand out in your mind in 2013.  Nominate them, give a few reasons, and celebrate the help that each of us gives each other as a part of the SQL Server tribe.

PS: we had a great #sqlski last year for SQL Saturday in Albuquerque and we're doing it again this year. Feel free to join us at Taos on Friday, January 24th, right before SQL Saturday #271 in Albuquerque on Jan 25, 2014.

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

MP4 iPod Video ( 18.5MB) feed

MP3 Audio ( 3.7MB) feed

Feeds are available at iTunes and Mevio

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

SQL Doc 3

New! SQL Doc 3

Rapidly documenting your entire database schema just became even easier with SQL Doc 3. Includes a new UI, documentation of database- and server-level properties, and greater customization control. Download a free trial now.

SQL Monitor Hosted

Try new SQL Monitor Hosted

Get real-time server performance updates and instant access to the data you need to fix the problem, whilst we take care of the monitoring software. Get started now.

SQL Source Control

Get your SQL Server database under version control now!

Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out…

Featured Contents


A few reflections on RBAR by a weary application developer

George Copeland from SQLServerCentral.com

Follow the guidance of your DBA, but remember, he or she is from another land. More »


SQL Server Database Backup and Restore with Windows Azure Blob Storage Cloud Services using T-SQL Commands

Additional Articles from MSSQLTips.com

SQL Server 2012 introduces a new feature to issues backups on the Windows Azure Blob Storage service directly and restore from there when needed. But how does it work and how to get started using T-SQL commands for backup and restore operation? More »


Nominations open for the 2013 Tribal Awards

Press Release from SQLServerCentral.com

SQLServerCentral and Simple-Talk are co-hosting the Tribal Awards. Nominations open today for each of the 11 categories which recognize technical excellence, willingness to help the wider community, and exceptional SQL Karaoke skills. More »


From the SQLServerCentral Blogs - Finding active DTS packages

Kenneth Fisher from SQLServerCentral Blogs

DTS is dead, long live SSIS. Way back when SQL 2005 was announced then released DTS was pronounced DOA. SSIS... More »

Question of the Day

Today's Question (by Steve Jones):

In the windowing clause for T-SQL analytic functions, after the PARTITION BY and ORDER BY clauses, what are the two types of ways in which you can choose what sets of rows are included? Choose 2

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

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


SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach

SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

In SQL Server 2014, the technology code named "Hekaton" refers to what?

Answer: Memory-Optimized Tables


Hekaton is the code name for the technology behind memory-optimized tables in SQL Server 2014.

Ref: In-Memory OLTP - http://msdn.microsoft.com/en-us/library/dn133186%28v=sql.120%29.aspx

» Discuss this question and answer on the forums

Featured Script

How we can move the login which has Sysadmin role.

Rajib Kundu from SQLServerCentral.com

We are using sp_help_revlogin to make login script, but it doesn't enable the login which has sysadmin role. It is very common problem during server migration. We use the this technique to solve the issue.

Workaround:  How you can enable the sysadmin role correctly for all the login which has sysadmin role.

This script creates the command in old server which need to execute to the new server.

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 : Development - SQL Server 2014

Linked Server to File Folder Security Issue - Here is my Problem: 1. I have sql 2008 R2 running on my LocalHost. 2. Created Data Base [Customer]. 3. Created Linked Server...

SQL Server 2012 : SQL 2012 - General

not able to connect to server from different domain - remote connection is turned on that sql server. also it is from trusted domain. In server name if I give domain\servername...

What is the full form of mdf, ldf and ndf ??? - :-)

SQL Server 2008 : SQL Server 2008 - General

How to re-write the query - Hi All, Can someone help me to re-write this query to use one single coordinators table. SELECT * FROM personnel WHERE Office IN ( SELECT...

replace in xml type - hello all. I have one xml column in my tables: and it's xml: <SystemProfile> <CardTable> <Reminder TimeOut="300" isActive="1" /> <Recycle RemovePeriodTime="60" /> <Message...

How the grouping set works in Sql2008 - Can anyone tell me how exactly grouping set works in sql 2008.how it is different from group by clause.

Restore Only .mdf file from .Bak file - How Can Restore Only .mdf file from .Bak file in Sql server 2008.we have only .bak file (large size)

Does update statistics on a table, updates index statistics? - Hi, Does update statistics on a table, updates index statistics? Thanks, Regards, Ami

SQL Server 2008 : T-SQL (SS2K8)

need to create an excel sheet without any data in it - Hi, I need to create an empty excel sheet using T-SQL. Can any one help me out in this? Thanks in advance

SQL Server 2008 : SQL Server Newbies

Tabledesign (newbie) - Hello, I am creating a simple database to log the number of visits from clients. The table is as follows : tbl_statistics -------------------------------------------------- p_key...

SQL Server 2008 : SQL Server 2008 High Availability

updating clients database like a antivirus - I am using SQL server 2008 with C# / Visual Studio 2008 (desktop application with SQL Compact Edition or SQLite that...

SQL Server 2008 : SQL Server 2008 Administration

how to get the Last 10 Run Status of a Stored Procedure - Hi All, Good Day...! We are using BODS for triggering a Stored procedure to execute a SQL Code. As BODS can not capture...

What is the benefit of Database Snapshots ? - What is the benefit of Database Snapshots , also are every DBA should deal with it daily , please explain in simple...

SQL Server 2005 : Backups

Backup Size - Hi, My one of database size around 5GB (data file 4.5 & log 500 MB) once i took the complete full backup...

SQL Server 2005 : SQL Server 2005 General Discussion

Finding tempdb contention - I am having tempdb issue on my server. Everytime it happens, I need to restart the service. Is there a...

SQL Server 2005 : T-SQL (SS2K5)

How to duplicate existing rows? - I have difficulties solving a problem. I'll try to explain the problem the best I can. I got two tables:...

Programming : General

Convert SQL Views to SQLite - What i want to do is migrate my SQL Views to SQLite. I have tried the following tools: http://www.codeproject.com/Articles/26932/Convert-SQL-Server-DB-to-SQLite-DB http://convertdb.com/views_translation But those tools seem...

SQLServerCentral.com : Anything that is NOT about SQL!

Articles and IP Protection - I have some articles I'd like to submit to sites for publishing. One of them is a position paper on...

Fantasy football 2013 - I renewed the league, you should be getting an email soon. At the moment, there are no open spots, but...

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

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 ©2013 Red Gate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com