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

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

spid in Killed/Rollback cannot kill

We come across a situation where we have to kill one spid which was running for quite some time, so...

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

Configuring and monitoring transactional replication between two SQL Server 2005 instances…

Replication often plays an important part in your database management strategy. An organization may use database replication for load balancing,...