|
|
-
|
|
As a DBA, disk space is an important factor for daily monitoring and I encountered one issue for same for disk space. I found it based on disk space statistics report from all servers. I investigated disk space usage of all databases and found msdb sys...
|
|
-
|
|
Recently we have seen the post for database size information and script used for the same too. Hope you liked that post. Sometime we need to have details like database size for growth and disk planning as we viewed in earlier post, same way i am repeati...
|
|
-
|
|
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...
|
|
-
|
|
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...
|
|
-
|
|
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 ...
|
|
-
|
|
We have seen example of Changing Rows to Columns Using PIVOT. Hope you liked that post and you enjoyed a lot also. As we know that we need to hard-code the values for pivoting which we have did for color values. for the values updates in table or whenev...
|
|
-
|
|
Recently i was asked by my friends to delete the files bases on number of files, not based on days. Such a way we can keep number of files every time and rest files get archived. I will give you an example here as i have three folders and want to keep different number of files in each folders only....
|
|
-
|
|
In last post we have seen custom database roles as how can we create it and assign required access to users. We also noticed that we can add multiple members with same role. That was the security with database roles and members comes into the picture. Now here we will study of Application Role. Th......
|
|