Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Gandhinagar SQL Server User Group Meeting April 24, 2009

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
DigiCorp, MVP, SQL User Group
Gandhinagar SQL Server User Group launch event was held on March 27, 2009. This successful, well-attended event received very positive and warm community response. Visit Gandhinagar SQL Server User Group Portal and register yourself now! We are going to meet again this month on April 24, 2009 Friday from 6:30PM…
Read More

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

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
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,…
Read More

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

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…
Read More

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

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…
Read More

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

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…
Read More