SQL Server Compact Edition is for mobile apps and embedded systems, while Express Edition is a light, limited SQL Server. A feature by feature comparison.
SQL SERVER – What is Cloud Computing – Introduction to Cloud Computing
What is cloud computing? A plain answer for SQL Server people, the three service models, and what to check before you move a database there.
Giving an Application Account Only What It Needs
Apply least privilege SQL Server access with separate runtime and deployment roles, narrow permissions, and tests of allowed and denied actions.
SQL SERVER – Fix : SQL Server 2008 Developer Edition Install fail due to .NET Framework 3.5 missing
SQL Server 2008 Developer Edition setup failed with .NET Framework 3.5 missing, even though Visual Studio 2008 ran fine. Here is the link that explained why.
What Is the Transaction Log and Why Does It Keep Growing?
The transaction log records every change before it reaches the data file. Why it grows, what log_reuse_wait_desc is telling you, how the recovery model decides everything, and the one fair reason to shrink it.
SQLAuthority News – Authors Website Redesigned – http://www.pinaldave.com – Feedback Requested
I have my personal website redesigned: pinaldave.com has a complete makeover, with a new layout and fresh content. Please take a look and share your feedback.
Preparing for a Microsoft Data Certification
Prepare for a Microsoft data certification by matching an exam to your role, using its current study guide, practicing, and judging its value.