SQL database Incremental Shrink TSQL

When we shrink a SQL database through GUI we usually find the database never releases all the free space, It...

Performing Unattended Installs of SQL Server 2012

In my post here, I’ve discussed the procedure to perform attended installation of SQL Server 2012 on a Windows Server...

SQLSailor is exploring(Part4) – Basic DML,DDL operations with SQL Databases on Windows Azure

In this post we will review some basic DML,DDL capabilities of SQL Database on windows Azure.
This post is in continuation with my...

SQL Server 2008 R2 Service Pack 2 Cumulative Update 1

Microsoft has released SQL Server 2008 R2 Service Pack 2 Cumulative Update 1, which is Build 10.50.4260.0. This CU has...

Forty Five Minutes

Excellent: Dilbert on data analysts
The best part is the last quote: I like how you punctuate your ignorance with certainty.

Filed...

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