|
|
-
|
|
This is common information which DBA required on daily basis for monitoring or reporting purpose. This is basic details which help us to get the database growth statistics on daily, weekly and monthly basis so we can have idea for the disk space managem...
|
|
-
|
|
I have already post the article previously with my PIVOT. As PIVOT same but working reversely and it is UNPIVOT. I do not want to miss the post using UNPIVOT and enjoyed UNPIVOT too. With PIVOT we can get aggregate data with Rows as Columns and with UNP...
|
|
-
|
|
Last time we seen the issue we faced during setup of replication and it was due to original server name change. We came out from one issue But today I am writing for another issue which I faced for the same for replication configuration. I think this is...
|
|
-
|
|
One day when I was setting up replication in my local machine, when I clicked to create a new publication from replication tab, I faced one error and the details, Error : TITLE: New Publication Wizard ------------------------------SQL Server is un...
|
|
-
|
|
Before so many posts published I posted for the old database backup files archive using TSQL and using SSIS. Hope you visited that post and you liked them. I am repeating the same thing here but it will be with two different methods, first one with FOR...
|
|
-
|
|
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 ...
|
|