In SQL Server you can enable a Trace Flag at session (effective for current session only) level and global level. If you are not sure which Trace Flags have been enabled you can use DBCC TRACESTATUS() command to get a list of enabled Trace Flags. DBCC T...

There is a new CU update for SQL 2012 SP1 and I noticed a very interesting new feature described in the documentation blogged here. This is one of two new improvements and it is described as: You can now directly create a backup to Windows Azure Storage...

There is a new CU update for SQL 2012 SP1 and I noticed a very interesting new feature described in the documentation blogged here. This is one of two new improvements and it is described as: You can now directly create a backup to Windows Azure Storage...

With .NET 3.5 they’ve published two new deployment-methods for the framework: - Full Framework - Client Profile Shortcut: With .NET 4.5 the construct that caused us all a lot of headache is gone. Why all this? The initial idea was to create a tot...

I’ve been very privileged to be able to work alongside Kevin on a few projects during our time together at Quest. To be honest I was a little unsure on how to structure this interview as Kevin has so many strings to his bow. We could talk about being an...

Thanks for agreeing to do this Annette, with your SQL Saturday event only a few weeks away thing must be really hectic. I really do appreciate your time! Before we start on the main part of the interview, tell us all a little about yourself. I’m m...

At times, we have to validate the XML input passed from different sources. In SQL Server, we can use XML Schema Collection to have a schema defined and then use the same for validating corresponding XML inputs which are received. XML Schema declaration ...

Almost every tool we learned has some sort of “Hello World!” tutorial lesson. So here comes the “Hello World!” lesson in MDX. Putting “Hello World!” directly on the X axis doesn’t work You would think this query would work, by putting “Hello World!” dir...

Add stored procedure in transactional replication by script in SQL Server I have already written many articles to cover different area of replication. Few days back I have written how to add articles (Table, View, SP etc.) into replication from GUI and ...

Add table in transactional replication from script in SQL Server I have already written many articles to cover different area of replication. Few days back I have written how to add articles (Table, View, SP etc.) into replication from GUI but today I a...