|
|
-
Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence
...
|
|
|
|
|
-
Paresh Prajapati Posted 7 Months ago through Blogs
As a security part, recently I worked with login details and the auditing for the same. I was needed to capture each events for login statistics like login name, the time when logon, the program through established connection, session and host or client...
|
|
|
-
Paresh Prajapati Posted 7 Months ago through Blogs
Recently when I was working database backups copy to external drives or whatever destination , I tried it with new solution using XOPY command. Before that solution I was using XP_CMDSHELL command in SQL Server to copy database backup file to external d...
|
-
Paresh Prajapati Commented 7 Months ago through Blogs
Hi Abhishek,
Yes, it can be with XP_CMDSHELL, but should not use it for security concern, Please see http://beyondrelational.com/modules/2/blogs/88/Posts/17905/sql-server-tablediff-utility-for-multiple-tables-using-ssis.aspx where i created batch an...
|
|
|
-
Paresh Prajapati Posted 7 Months ago through Blogs
As we have seen the last post for the basic concept of tablediff utility. We learned one example using static table, now I would like to go it with ssis package and also using more table comparison. so, lets start it with some demo objects and cre...
|
|
|