This summit was my first summit ever, and I enjoyed the conference so much, Quality of presentations and session was high as I expected that. I’ve met lots of MVPs, Speakers, Blog and Book Authors, and SQL Server geeks that I knew online, but hadn’t chance to meet them in person. I’ve met Andy Leonard, Read more about PASS Summit 2013 – my first PASS Summit experience[…]
One of the most common errors that you might face in join statements is this error: Msg 4104, Level 16, State 1, Line … The multi-part identifier …… could not be bound. The main reason for this error is that the source table cannot be found, for example if you have statement such as Table1.OrderDate, Read more about Fixing the error: The multi-part identifier … could not be bound in Join statements[…]
SQL Server 2012 has a set of useful functions to work in T-SQL environment. Lead and Lag are one of the most useful functions introduced in 2012. Lag function helps to access values from previous records, and Lead function helps to access values from next records in the data set. structure of working with these Read more about Lag and Lead Functions in SQL Server 2012[…]
Previously I’ve wrote about design and implementation an UPSERT with SSIS. UPSERT is about Update existing records, and Insert new records. Today I want to extend this to cover DELETED records as well. So method used in this post can be used to find INSERTED / UPDATED / DELETED records from the source table and Read more about Insert, Update, and Delete Destination table with SSIS[…]
Hi folks, I proud to announce that I will speak in the SQL Saturday #237 Charlotte BI Edition Which will run in 19th of October 2013 in Charlotte, North Carolina In this session I will speak on one of my favorite topics which is Design and implementation architecture for Inferred Dimension Members with SSIS and Read more about Speaking about Inferred Dimension Members with SSIS and MDS: Charlotte SQL Saturday[…]
Thanks for all attendees of today’s webinar about Error Handling in SSIS. turnout was good, and good questions asked and responded. Here are topics that covered in this session: Error handling in SSIS Data Taps Logging SSIS Catalog stored procedures for Logging and execution Debugging and Troubleshooting SSIS packages some live demos about error handling, Read more about Error Handling in SSIS; Download presentation materials and recording[…]
Today I’ve wrote a simple script to get number of records for all tables in a database and fetch those tables that contains at least one record. This picture shows an example of result set: Here is the script: declare @tempTable table(tablename varchar(max), rowscount int,processed bit) insert into @tempTable select TABLE_NAME,0,0 from INFORMATION_SCHEMA.TABLES where TABLE_CATALOG=‘DEMO’ Read more about T-SQL Script to get row count of all tables in the database[…]
Master Data Services provides data governance and reference data management as part of SQL Server product. There is a security mechanism in MDS that provides robust role based security and authorization for domain accounts and groups. Security on data also can be applied on Model level, entity, or even in row level. Security in MDS Read more about Deep Dive into Security Schema of Master Data Services Database[…]
Thanks for attending in my session at Pass DWBIVC today, it was my pleasure to see you there. Today’s talk was about; Effective Control Flow Execution with 7 Different Types of Foreach Loop Enumerators in SSIS Session description: Controlling execution of tasks in Control Flow tab of SSIS package can be much easier with getting Read more about Effective Control Flow Execution with 7 Different Types of Foreach Loop Enumerators[…]
Today I’ve found a bug in SSIS Pivot Transform component reported as a question in TechNet forums here. Reported issue was related to pivoting some records based, result of PIVOT transformation in SSIS was not as expected to be. read below for detailed explanation; Scenario Explanation: This is a sample of incoming data set: The Read more about PIVOT Transformation Issue in SSIS[…]