Data Engineering – Learn from the experts
-
SSIS Error Code 0xC02092B4
I was working on a SSIS package in SQL 2014 which was working there without any issues. Due to few factors we need to downgrade to work in SQL Server 2008 R2 for few months. I developed the packages in SQL 2008 BIDS and deployed. No changes done to any of the database objects as…
-
Backup Report
I was working on one the project and they were looking for a backup report which should specify whether it’s physical or logical and few more details. Whatever data I fetched looks good and I felt the same can be helpful for you guys to pull it as a report. If you need any more…
-
SQL Server 2016 – Tempdb Configuration During Installation
After couple of years I’m started playing around the pre release packages. Today I installed Windows Server 2016 Technical preview release 3 and SQL Server 2016 CTP 2.4 in my machine to play around the upcoming release.
-
Identify Orphan Users in All the databases
There are lot of scripts available in the internet to find orphan users across the database. This will be my version fo script to find out orphan users in all the databases excluding system databases.
-
October 2015 CSSUG Meet
After a long break we are back in action . This time we are with two different series. . Hope to you see you all in the meet, please pass this information to all your friends and colleagues so that we can see new faces. All CSSUG members please register at www.sqlpass.org and select Chennai…
Got any recommendations?