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

SQL security scripting - TSQL

SQL DBA often needs to script SQL Logins,Server roles,database users and Roles. Although its easy to script login,roles and users with...

SQL Server : Fixing the Orphaned Users

In my last post , we have discussed about orphaned uses and how to find out the orphaned users. In this...

SQL Server 2012 – Enter the EOMONTH Function

In this blog post, I will be sharing a new date feature in SQL Server 2012 called the EOMONTH (End...

SQL Server:Finding the Orphaned Users

Orphaned user is a common problem in SQL server world.When I was working on internal security audit of our production...

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

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

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

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

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