|
|
-
|
|
ecurity is the main thing for servers and sql servers and we need to trace it for security management. Have to need track who are using it, what they are doing and when they performed. For SQL Server 2005 and later versions we have some DDL events which...
|
|
-
|
|
Last time we have seen tablediff Utility basis and tablediff utility for multiple tables using SSIS. As you know using ssis package it generated discrepancies log files for database changes which we have to apply on destination servers\databases to mak...
|
|
-
|
|
Recently we done with conversion of the same topic to copy database backup files to external drive using XCOPY only. That script copy database backup files created on current day from source to destination, So we can scheduled that code to run one time ...
|
|
-
|
|
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...
|
|
-
|
|
Recently when I was working database backups copy to external drives or whatever destination , I tried it with new solution using XCOPY command. Before that solution I was using XP_CMDSHELL command in SQL Server to copy database backup file to external ...
|
|
-
|
|
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 SISS package and also using more tables comparison. So, lets start it with some demo objects and created ...
|
|
-
|
|
Earlier when I was working with task to sync data for two tables between to databases, I got the chance to use the tablediff.exe utility provided by SQL server. It used to compare data for two tables which have similar columns and data type structure. A...
|
|
-
|
|
Recently when i was working on tuning of stored procedures and i experienced with one performance issue, that was high Logical Reads. Logical Reads? "Number of pages read from the data cache" - It occurs every time when the database engine request a p...
|
|
-
|
|
I wrote about my previous just learned tips about covering index and will publish my future post for the detail understanding it. We should generate index statistics and index usage report periodically, so we can have more idea of the index utilization....
|
|
-
|
|
Last time I have wrote about pivoting and the next after that post describes for dynamic columns which used for pivoting. We have seen the example and the same example implemented with dynamic columns. You can read both posts which are following, 1. S...
|
|