Reading Excel into SSIS via OpenXML Scripting

Reading Excel data isn't easy.  It should be, but there's a lot of unfortunate barriers in the way that I've...

Replace NOT IN with JOIN

Example of how to replace NOT IN clause with JOIN

/*NOT IN query*/
USEAdventureWorks;GOSELECTProductIDFROMProduction.ProductWHEREProductIDNOTIN(SELECTProductIDFROMProduction.WorkOrder);

/*JOIN Query*/:-
SELECTp.ProductIDFROMProduction.ProductpLEFTJOINProduction.WorkOrderwONp.ProductID=w.ProductIDWHEREw.ProductIDISNULL;

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