Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

Smart Moves with SQL Server VMs – Data Movement

Today marks another installment in my ‘Smart Moves with SQL Server VMs’ blog post series. Today we are going to help stretch the minds a bit farther and talk about another way to help SQL Server DBAs move large quantities of data between VMs in an extremely rapid manner. 

Last… Read more

0 comments, 128 reads

Posted in Technobabble by Klee from @kleegeek on 10 April 2014

I’m a Traveling Man

We are coming into quite a busy time for my speaking schedule. I’m hitting the road. It does one thing for me that I truly love, I get to talk to people. So, if you have questions, want to chat, need to call me a pompous know-it-all to my face,… Read more

0 comments, 83 reads

Posted in The Scary DBA on 10 April 2014

Collation: Correction -> Expression, Column, Database

I had a recent run in with collation problems and it got me started reading about them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

You’ve… Read more

0 comments, 85 reads

Posted in SQLStudies on 10 April 2014

Rolling back transactions with cursors and local variables.

I’ve been doing some work on a credit card payment system lately. Obviously this needs to be robust and consistent so I’ve been working on error handling and “transactionalising” certain parts of the process.

I needed to answer a couple of questions that I had along the way. What happens… Read more

0 comments, 72 reads

Posted in Ctrl-alt-geek on 10 April 2014

Alter Table Not Permitted

By David Postlethwaite

At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover.

You may have come across this error message when using SQL Server Management Studio

It’s new in…

Read more

0 comments, 70 reads

Posted in The SQL DBA in the UK on 10 April 2014

this isn’t thunderdome

When I received my first MVP award for SQL Server it was fairly abstract to me until I went to my first TechEd conference after being awarded. There it got real. At that year’s TechEd I recall sitting in the SQL “Birds of a Feather” area with my late friend… Read more

0 comments, 191 reads

Posted in @chuckboycejr on 9 April 2014

Vote for me at SQLBits

SQL Bits XII is coming this July to Telford in the UK and voting is underway for sessions. I’ve submitted a few and am hoping to get accepted to go back. You can help.

You can log into the site and vote for the sessions you’d like to see. I’d… Read more

0 comments, 81 reads

Posted in The Voice of the DBA on 9 April 2014

Top 10 DBA Mistakes on SQL Server (Now with Prizes!)


Hear one of my most popular session via streaming media at SQLSentry.TV!

Microsoft SQL Server is easier to administrate than any other relational database on the market.  But “easier than everyone else” doesn’t mean it’s easy.  And it doesn’t mean that database administration on SQL Server is problem free.… Read more

2 comments, 122 reads

Posted in Kevin E. Kline on 9 April 2014

Webcast Follow-Up: Introduction to Clustered Indexes and Heaps

Last month, I presented a session for Pragmatic Works Training on the T’s titled Introduction to Clustered Indexes and Heaps.  I’d meant to get the Q&A and session materials posted earlier, but somehow getting this post out got a bit “corrupted”, but at least it is finally coming out.… Read more

0 comments, 71 reads

Posted in StrateSQL on 9 April 2014

Dedicated Administrator Connection

By David Postlethwaite

At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover.

If a SQL instance isn’t responding or you can’t login for some reason then SSMS has a…

Read more

0 comments, 87 reads

Posted in The SQL DBA in the UK on 9 April 2014

Colorado SQL Events for April 2014

SQL Meetings are training events for SQL Server professionals and those wanting to learn about SQL Server. Please note that in order to attend one of these event, you must register. Please register soon as seating is limited, and let friends and colleagues know about the event. Most events are… Read more

0 comments, 5 reads

Posted in Marc Beacom on 8 April 2014

T-SQL Tuesday #53 – Work Hard, Play Hard, Joke Hard

It is April and April Fools has only just begun.  Well, or so Matt Velic (blog | twitter) would have us believe.

Matt decided that this month for TSQL Tuesday, he would pull out all stops to help us break out the inner prankster in ourselves.

You can… Read more

2 comments, 102 reads

Posted in SQL RNNR on 8 April 2014

T-SQL Tuesday #53–Why So Serious?

It’s an interesting topic this month for T-SQL Tuesday #53. When I read Matt Velic’s invitation, I became intrigued. I like jokes. I like messing with people, and I was thinking about the recent April Fool’s jokes I’d written and those in the past that have been fun. I’m… Read more

0 comments, 100 reads

Posted in The Voice of the DBA on 8 April 2014

Currys having apostrophe trouble

Before I start I just want to say that much of this post is mere speculation on my part and not specifically targetted at Currys. They just happen to be the catalyst and example for this post.

A few months back I ordered a new tumble drier online from Currys… Read more

0 comments, 83 reads

Posted in SQL Server Rocks! on 8 April 2014

Question of the Week -08/04/2014

Suppose we need to find out the name of all the months in a given year (Year will be given as an input parameter) where first day of the month falls on weekend (Saturday or Sunday). 

So what should be the query/stored procedure to get the above result?

Read more

4 comments, 103 reads

Posted in Vivek's SQL Notes on 8 April 2014

Answer - Objective Question (How many Null values in an unique constraint can be inserted in SQL Server)

Question:- How many NULL value allowed in a column in which Unique constraint is defined in SQL Server?


a) 1

b) 2

c) More than 1

Answer :- Option a) 1

In SQL Server, we can Insert only one null value in a column where we have defined the…

Read more

0 comments, 107 reads

Posted in Vivek's SQL Notes on 8 April 2014

[SQL Snacks Video] SQL Server Table Partitioning 101

I hope you’re hungry for another SQL Snack! In fact, this will be one of a series of snacks (dare I call it a SQL Snack pack?). Table partitioning is a fantastic feature that is easy to learn and can significantly improve your OLTP and Data-warehouse environments. It can be…

Read more

0 comments, 140 reads

Posted in - Ayman El-Ghazali on 8 April 2014

T-SQL Tuesday #53 Why So Serious

This month’s T-SQL Tuesday which is now at a staggering number 53, can it really have been going that long? Is hosted by the awesome Matt Velic. Matt posted this invitation T-SQL Tuesday #53 – Why So Serious? (Announcement) on April Fools Day and so the subject is that of… Read more

0 comments, 82 reads

Posted in Richard Douglas on 8 April 2014

Curation and Performance

I’m trying out a new web site from Microsoft called Curah! that is all about curation. Curation is basically what blogging started out as. Blogs, short for Web Log, was really just a collection of links you’d visited recently and what you thought about them. But it’s grown into all… Read more

6 comments, 102 reads

Posted in The Scary DBA on 8 April 2014

Read Flat File Contents to Variable – Write Variable Value to Flat File

When working with SSIS, you’ll often find the need to read the contents of a flat file to a variable, and write the value of a variable to a flat file. A script task can be used to accomplish both of these.


0 comments, 98 reads

Posted in Sam Vanga on 8 April 2014

Newer posts

Older posts