What is the difference between DBMS and RDBMS? An RDBMS adds tables with enforced relationships, plus the constraints and security a plain DBMS lacks.
SQL Authority News – SQL Server Interview Questions – SQL Related Jobs – DBA Job Description
Looking for a job or a candidate? Here are my links to SQL Server interview questions and answers, SQL Server related jobs and a DBA job description.
SQL SERVER – Is Cursor Database Object or Datatype?
Whenever we want to loop something we always look for logic like WHILE LOOP or FOR LOOP. Trust me on my word that both of them are cursor when it is about SQL Server.
SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf)
Can you restore database using corrupt datafiles when there is no full backup and both .mdf and .ldf are damaged? My honest answer and the one thing to try.
SQL SERVER – How to Escape Single Quotes – Fix: Error: 105 Unclosed quotation mark after the character string
Jr. Developer asked me other day how to escape single quote?
User can escape single quote using two single quotes (NOT double quote).
SQL SERVER – Introduction to Aggregate Functions
What are Aggregate Functions in SQL Server? The Books Online definition, the full list, and the NULL and GROUP BY rules that candidates often miss.
SQL SERVER – Most Frequently Asked Generic Interview Questions
A list of the most frequently asked generic interview questions, from why you left your last job to what co-workers say about you. Think through your answers.