SQL Server : Implementation of Table Valued Parameter (TVP)

Some time there will be situation in application , where a
grid is populated with data and user has option to edit...

Prevent wiping out of SSAS partitions

There have been a few times when I have created SSAS partitions outside of BIDS using script code in an...

Set Up SQL Server Mirroring T-SQL Script

T-SQL Script to create a SQL Mirroring:-

The first thing you need to do when setting up Database Mirroring is perform...

Execution Plans … In the Cloud!

If you’re moving to a fully-fledged SQL database as part of Azure you may never even touch SQL Server Management...

Deploying and processing SSAS cubes

In SSAS we build what’s known as a UDM, or Unified Dimensional Model, over the top of a database schema,...

Restores in SQL Server Analysis Services

“You’re only as good as your last restore”
I’ve no idea who originally said that – but it probably qualifies as DBA...

Fully Dynamic Search Conditions vs. SQL Injection

SQL Injection is a widely known issue with databases that work as back-ends for websites and applications. In the most...

SQL Server Quickies – a new way to learn about SQL Server

We are all living in a fast moving world, especially in the IT industry. We have to learn new technologies...

SQL Server Quickies – a new way to learn about SQL Server

We are all living in a fast moving world, especially in the IT industry. We have to
learn new technologies every...

Two New Cumulative Updates for SQL Server 2008

On July 17, Microsoft released two new Cumulative Updates for SQL Server 2008. The first cumulative update is SQL Server...