SQL Server database corruption is troublesome for DBAs, particularly if the situation arrives suddenly and there is no backup. This situation can lead to prolonged downtime and permanent data loss in ...
The first installment of this TechRepublic series focused on C# developer interview questions. It generated a lively discussion on the merits of such questions and the different approaches to ...
When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...
In the world of SQL Server management, page-level corruption is an issue that can strike fear into the hearts of even the most experienced database administrators. When an 8 KB unit of data storage, ...
I had the pleasure to spend some time with my old friend at Microsoft, Mark Souza, while speaking at the SQL Saturday event in Dublin, Ireland. Now keep in mind that Mark and I have known each other ...