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

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