Are you allowed to use social networking at Work?

I was reading this article about internet usage by staff who work for local authorities in Wales http://www.bbc.co.uk/news/uk-wales-16394916 The content...

Arithmetic overflow error and isdate sql

Executing a t-sql statement with a convert function
 convert(datetime, my_date_column)            ,           
 threw an arithmetical overflow error with the message :
Message
Arithmetic overflow...

Creating Strong Passwords

I was writing a presentation recently on encryption and one of the important things to show in the presentation is...

Database uplevel Restores

Today I've been reading Paul Randal's collection of Blogs from a series called A SQL Server DBA myth a day....

Q.How Many Weeks in the Year? A.It depends

ISOWEEK 52 Weeks in the Year

Stardate 12:20:2011 Week 51 SSC.Com Web Blog, Planet Earth.  With only approximately two weeks left...

Re-blog – December 30 – January 5

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may...

SQL Server 2012 FileTable – Part 1

In a series of blog posts we will have a look at the new SQL Server 2012 table type called...

SQL Server 2012 Licensing VMs without SA

I ran across a blog talking about Microsoft licensing, and found it very interesting. I learned a few things, and...

What’s Wrong with this Picture: A Database Misconfiguration Well Demonstrated

Recently, I was doing some testing/playing around on a particular database on my home test servers. After I was done,...

LOOP, HASH and MERGE Join Types

Today I’ll talk about the available JOIN operator types in SQL Server (Nested Loops, Hash and Merge Joins), their differences,...