CONCAT() string function–SQL Server 2012

As the name indicates, CONCAT() will concatenate two or more strings. This is one of the two string functions introduced in...

SharePoint Reports and Scorecards on Apple Devices

While some people may consider this topic off limits the fact remains that more and more companies are adopting Apple...

Contracting is business not employment: Read the small print

This post is about a contracting in UK. Some of terms mentioned here will not mean a great deal to...

Read About SQLSatuday #100 & See the Coffee Cup Too!

Here’s a great post from Karla Landrum about her trip (with husband Rodney) to Brazil for the milestone making #100....

Using Dynamic Values in XMLA

Using Dynamic Values in XMLA
XMLA

A question was raised on Twitter today via the #sqlhelp hash tag about passing parameter values...

Undocumented Gotcha in Merge Replication Tracking

In the spirit of Robert Davis's (blog | @SQLSoldier) blog post: Undocumented Gotchas of Transactional Replication, I decided to contribute an...

Undocumented Gotchas of Transactional Replication

Undocumented Gotchas of Transactional Replication
Gotcha - Norelco commercial (1977)
This discussion started on Twitter via the #sqlhelp hash tag. The question that...

Albanian SQL Server Users Group–First Meeting

Today, I’m so excited to announce that we had the first meeting of our Users Group – Albanian SQL Server Users...

Why you may or may not consider using Database Snapshots!

Microsoft introduced database snapshots with SQL Server 2005. A database snapshot is a static, read-only copy of a source database...

Why do I Blog?

Last week I heard about a new blog party/meme coming down the pipe for the #SQLFamily.  This new meme is Meme15 and is the pet project of Jason Strate (Blog|Twitter)....