Data Engineering – Learn from the experts
-
How Much Memory is Needed Taken for My Database Backup
In this article I will try and cover the concepts in understanding the amount of memory or buffers required for completing a database backup. I would be using a couple of trace flags to get that detail and further discuss two of the parameters MAXTRANSFERSIZE and BUFFERCOUNT in the BACKUP DATABASE TSQL syntax which will…
-
DBCC CHECKDB & READ ONLY DATABASES
DBCC CHECKDB & READ ONLY DATABASES: Can you run a checkdb command on Read-only databases? If yes, does this get logged into boot page of the database? If checkdb finds an error can it fix on a read-only database? These were some of the questions running through my mind as I manage some read-only databases…
-
New SSMS GUI Changes in SQL Server 2011 (Denali)
Im just writing this article to provide you the new changes to SSMS GUI available in SQL Server 2011 aka Denali. This article is not more into techie however it will just visualize you the changes made to SSMS GUI in .SQL 2011 Ill update this article whenever I see a new change in SSMS…
-
Database Documentation
Almost every application DBA would have a need to document the various database objects such as tables, views, stored procedures and functions. I wasn’t an exception and exploring ways to document the 400+ tables we have. Basically, this would serve the following purpose:
-
March 2011 UG Presentation Material
Thanks for all the participants who attended the session and we could see so many new faces this time. We had wonderful time and earned good knowledge on those topics. You can download the presentation and demo scripts to play around the topic. Incase if you have any queries you can directly get in touch…
Got any recommendations?