Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – FIX : Error: 18486 Login failed for user ‘sa’ because the account is currently locked out. The system administrator can unlock it. – Unlock SA Login

April 23, 2009

SQL Error Messages, SQL Scripts, SQL Server Security

Today, we will riffle through a very simple, yet common issue – How to unlock a locked “sa” login? It is quite a common practice that SQL Server is hosted on a separate server than application server. In most cases, SQL Server ports or IP are exposed to the web,…

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

April 22, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Server Express

I often received question regarding what are difference between SQL Server Compact Edition (CE) and SQL Server Express Edition. In one line – SQL Server CE is for mobile application and embaded systems where as SQL Server Express Edition is limited feature light version of SQL Server Standard. SQL Server…

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

April 21, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Cloud Computing

“Cloud Computing,” to put it simply, means “Internet Computing.” The Internet is commonly visualized as clouds; hence the term “cloud computing” for computation done through the Internet. With Cloud Computing users can access database resources via the Internet from anywhere, for as long as they need, without worrying about any…

SQLAuthority Book Review – Pro T-SQL 2008 Programmer’s Guide by Michael Coles

April 20, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, SQLAuthority Book Review

Pro T-SQL 2008 Programmer’s Guide by Michael Coles Link to Amazon Short Summary: Pro T-SQL 2008 Programmer’s Guide examines SQL Server 2008 T-SQL from a developer’s perspective. This information-rich book covers a wide array of developer-specific topics in SQL Server 2008. In addition, it provides in-depth knowledge of various newly…

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

April 19, 2009

Pinal Dave

SQL

SQL Error Messages, SQL Server

It goes without saying that computer running slow is a common problem we all face, a pestering one indeed! Last week, I had to format my computer as it was running at an annoyingly tortoise pace. After formatting it, I installed Visual Studio 2008. When tested Visual Studio 2008 worked all fine. However, when I attempted to install SQL Server 2008, I was confronted with an error about NET Framework 3.5 missing.

SQLAuthority News – Troubleshooting Performance Problems in SQL Server 2008

April 18, 2009

Pinal Dave

SQLAuthority News

SQL Download, SQL Server, SQL White Papers

Troubleshooting Performance Problems in SQL Server 2008
SQL Server Technical Article
Writers: Sunil Agarwal, Boris Baryshnikov, Keith Elmore, Juergen Thomas, Kun Cheng, Burzin Patel
Technical Reviewers: Jerome Halmans, Fabricio Voznika, George Reynya
Published: March 2009

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

April 17, 2009

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database

I’m pleased to inform you all that I’ve recently launched my personal website. It’s been a long time since I’ve been writing on my blog https://blog.sqlauthority.com, but I’ve been keeping my personal notes at my homepage http://www.pinaldave.com. I’ve completely rehauled the website to give it the much-needed makeover, right from…