Tag Archives: sql server

Preparing for SQL DBA Interview

Preparing for SQL DBA Interview This article list out few tips on “Preparing for SQL DBA Interview” If you are reading this article which means you must be a Database Administrator/professional or getting ready for entering into DBA world. In … Continue reading

Posted in Interview Q&A, Miscellaneous, SQL Server DBA | Tagged , , , , , | 18 Comments

Update Without Where Clause

Update Without Where Clause Running Update Without Where Clause might causes a data damage when it is with the critical table that creates a lot of problems and escalations. Recently while working with one of the customer we had a … Continue reading

Posted in SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , | Leave a comment

Script to get row count for all tables in a SQL Server database

Script to get row count for all tables in a SQL Server database This post helps you in writing a Script to get row count for all tables in a SQL Server database. For any database developer or administrator the … Continue reading

Posted in SQL Development, SQL Scripts, SQL Server DBA | Tagged , , , | 5 Comments