(Rohit Garg) I suggest to have regular full backup of your system database along with user database. But if you do not have system database & your MSDB got corrupted then you have to rebuild it. You can do it by instmsdb.sql script comes with installation.
Other News
#0353 – SQL Server – Locate an object in a SQL Server Instance (using documented features)
(Nakul Vachhrajani) A while back, I wrote a post on locating an object in a SQL Server instance (post #351). One of the items I received as part of the feedback was to implement the logic using documented (and therefore supported) features.
The Importance of Caching
(Michael K Campbell) Performance tuning and optimization definitely have their place in minimizing SQL Server Licensing costs – by helping keep CPU utilization low. But it’s important to remember that the fastest and most efficient query possible is the one that you never execute against your SQL Se
Of DB2 Connect ‘Gateway’ Servers and DB2 for z/OS DSNL030I Authentication Messages
(Robert Catterall) A few days ago I received a note in which a DBA reported strange and inconsistent information in some DSNL030I messages that were generated periodically by a DB2 for z/OS subsystem in his charge.
An updated DSNWMSGS file is now available
(Willie Favero) Sometimes I feel like I am a waling advertisement for DB2 maintenance, like it’s the only thing I blog about. Although it may seem like that (and I actually hope it doesn’t), I do try to publish blog entries that cover general information that I think could be of use to the many.
SQL SERVER – How to Bind Resource Governor for InMemory Enabled Databases?
(Pinal Dave) I have done a number of courses for Pluralsight. Last year when SQL Server 2014 was released, I planned to do a session on the same. The course SQL Server 2014 Administration New Features was a lot of hardwork but it did give me a chance to learn something new and share.
Building a Multi-Channel Mobile App with DevExtreme
(Hannes Du Preez) Hello again! A couple of months ago, I explained how to create a basic DevExtreme application, as seen in this link. Today, I will take it a step further and explain how to create a multi-channel application with DevExtreme and Visual Studio.
Support Remote Clients with a Custom Exception Object
(Peter Vogel) The custom Exception class I described in a column earlier this month will work fine … as long as the .NET Framework doesn’t need to serialize your Exception object to return it to a remote client. If you want to make the extra effort, you can add serialization support to your custom E
Roslyn Code Gems – Counting Bits
(K. Scott Allen) Back in the early days of computing, when machines were powered by coal-fired steam boilers the size of Liechtenstein, even the simplest operations were optimized by programmers toiling in the basements of university science buildings around the world. Simple operations like countin
Validating a Form using Angular Validation Directives
(Mahesh Sabnis) This article demonstrates how to use Angular Validation Directives to fulfil validation requirements for a web application.