This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL SERVER - Difference Between SQL Server Compact Edition (CE) and SQL Server Express Edition

SQL SERVER – Difference Between SQL Server Compact Edition (CE) and SQL Server Express Edition

April 22, 2009
Pinal Dave
SQL Tips and Tricks
Database, SQL Server Express

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.

Read More
SQL SERVER - What is Cloud Computing - Introduction to Cloud Computing

SQL SERVER – What is Cloud Computing – Introduction to Cloud Computing

April 21, 2009
Pinal Dave
SQL Tips and Tricks
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.

Read More
A single plain brass key beside one small closed wooden drawer on a softly lit table.

Giving an Application Account Only What It Needs

April 20, 2009
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Security

Apply least privilege SQL Server access with separate runtime and deployment roles, narrow permissions, and tests of allowed and denied actions.

Read More
A flat-pack assembly laid out on a wooden floor in a neat row, with one bracket missing from the line and an empty outline where it should be.

SQL SERVER – Fix : SQL Server 2008 Developer Edition Install fail due to .NET Framework 3.5 missing

April 19, 2009
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server

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.

Read More
A paper till roll unspooling from a machine and coiling into a long heap across the floor of a back office.

What Is the Transaction Log and Why Does It Keep Growing?

April 18, 2009
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Backup and Restore, SQL Server

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.

Read More
SQLAuthority News - Authors Website Redesigned - http://www.pinaldave.com - Feedback Requested

SQLAuthority News – Authors Website Redesigned – http://www.pinaldave.com – Feedback Requested

April 17, 2009
Pinal Dave
SQLAuthority News
Database

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.

Read More
Worn, muddy running shoes by a front door with a plain finisher's medal hanging on a hook above them.

Preparing for a Microsoft Data Certification

April 16, 2009
Pinal Dave
SQL Tips and Tricks
Career Advice, Microsoft Certifications, Professional Development, SQL Training

Prepare for a Microsoft data certification by matching an exam to your role, using its current study guide, practicing, and judging its value.

Read More
Previous 1 … 35 36 37 38 39 40 41 … 55 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com