|
|
-
|
|
We know all the various methods to delete the particular or all files from the specified folder using some of the methods like xp_delete_file, Ole Automation Procedures and with xp_cmdshell command line utility which we used for the old files archive or cleanup purpose.
Here i am going to share......
|
|
-
|
|
Every DBA has a daily activity review or monitor database backups as these database backups used for the restoration at other place and using for the database restore which used for reporting purpose or used in log shipping purpose. Because database backups are most important factor and first opti......
|
|
-
|
|
When we created a new database it will be created with default isolation level and that is "READ COMMITTED". If some update transactions are running in with table rows under READ COMMITTED isolation level, How can we get data from table in another session while running update transaction?
How c......
|
|
-
|
|
You may know how can we register SQL Server instances with Central Management Servers (CMS) and also how can we perform multi server query will all of instances of registered SQL Server instances.
There you can see i have registered one shared SQL Server 2011 instance under CMS and named it Den......
|
|
-
|
|
Recently I have posted some of the articles and some just learned from the month of October. This article just summarize all the posts which recently published. You can find the links below to go in the details.
Blog Posts:
Database Backup Compression, Amazing feature for DBA
Multi Moni......
|
|
-
|
|
Production Database servers may have databases which are heavily in size. For the maintenance of those database backups are very hard and lengthy as the backups of those heavily databases take more tome to execute and very CPU, memory and IO consumptive. And important thing is backups activity sho......
|
|
-
|
|
I have drafted all the new features and enhancements introduced by SQL Server denali CTP1 and CTP3. Multi Monitor Support is the new feature among them.
We can do with this feature:
1. Using this feature we can use multi screen of query analyzer or editor.
2. You can monitor separately it an......
|
|
-
|
|
Recently while working with SQL CLR functionality and created DLL for the SQL CLR.
But while registering this DLL in the database i got one surprised error.
Lt's show you the script so you have more idea. We have a script to register DLL as following,
SP_CONFIGURE 'clr enabled',1
GO
RECON......
|
|
-
|
|
As a best practice, DBA need to verify each database backups are properly done or not, also make sure the backups are OK then is readable and can be restored. Because so many databases are scheduled as FULL and differential backups weekly/daily and transaction log backups on every hours or whatev......
|
|
-
|
|
After posting some snaps to configure transactional replication in sql server having publication server as distributor, i want to share some of the issue which i got during working with it.
You may also faced the same issue and got resolved as well. You can comment if you faced any other replic......
|
|