SQL Tips and Tricks Archives - Page 417 of 536 - SQL Authority with Pinal Dave

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

April 22, 2009

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…

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…

SQLAuthority News – Microsoft Certification Exam – Discount Code

April 16, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, Microsoft Certifications, MVP, SQL Server

Note: I am republishing this blog post as the offer of this code is extended to April 30, 2009. Please note down this important code or share with your colleagues who are keen to take Microsoft Certification Exam. This unique code is only available through Microsoft MVP’s and only published…

SQL SERVER – Poll Result – What is Your Favorite Database?

April 15, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, Poll

I previously posted a Poll about What is Your Favorite Database? I got great response from users. In fact, I received some of the best poll-related comments on this blog and they are worth reading. Let us check the result first. Here are the votes I received on different database.…

SQL SERVER – Check if Current Login is Part of Server Role Member

April 14, 2009

Pinal Dave

SQL Tips and Tricks

, SQL Scripts, SQL Server, SQL Server Security

I often work on consulting projects with umpteen clients from across the globe. The nature of the works I usually receive necessitates me to take on the role of a system admin. Now, this role is trailed by come common issues. This article revolves around one such concern. Let us learn about Server Role Member.