Why does SharePoint stop working after you rename the SQL Server? The old name is still inside SQL Server. How to fix it, and what else holds it.
SQLAuthority Author Visit – Microsoft Student Partner Conference
On August 30, 2008 I presented a technical session at the Microsoft Student Partner conference in my city, and I explain what the MSP program offers students.
SQL SERVER – Difference Between DBMS and RDBMS
What is the difference between DBMS and RDBMS? An RDBMS adds tables with enforced relationships, plus the constraints and security a plain DBMS lacks.
SQLAuthority News – 3 Million Readers and Continuing Journey
SQLAuthority passed 3 Million readers. Thank you for your active participation. Here are my best and favorite articles if you want to keep reading.
SQLAuthority News – SQL SERVER Database Administrator Job Description
An updated SQL Server Database Administrator Job Description: support for the database environment, new technology, reliability and long-term planning.
SQL SERVER – Four Basic SQL Statements – SQL Operations
The four basic SQL statements are SELECT, UPDATE, INSERT and DELETE. A short note on what each one does, with a link to my one page FAQ sheet for full syntax.
SQL SERVER – Introduction to Live Lock – What is Live Lock?
What is Live Lock in SQL Server? How a write request can keep waiting behind a stream of reads, how it differs from a deadlock and how to reduce it.