by K. Brian Kelley – While there are a lot of books that offer a chapter or two on how to use Performance Monitor (System Monitor) or Profiler to help tune SQL Server, it is hard to find in-depth information on this topic, that is, until now.

By Vyas Kondreddi – This article shows you how to design the storage for email addresses, how to validate email addresses, how to write different types of queries on email addresses efficiently, using computed columns and indexes. It also covers the security aspect of dealing with email addresses.

From SQLTeam – Which is probably one of the oddest titled articles on the site. And after working on a solution myself and reviewing the ones submitted I know why Rob didn’t want to write these articles. We have some devious, creative SQL coders out there.

To efficiently handle queries and good database design, you must have a good understanding of SQL join statements. Beyond the logistics of basic syntax, there are several concepts that will round out your knowledge of joins and facilitate data referencing, such as aliasing, self joins, and ON clause

Think malicious users need sophisticated tools to attack a Web site? Think again. All they really need is a Web browser and basic knowledge of SQL or another scripting language. Sometimes all malicious users do is place a script inside the username, address, or search query field on a We

If you’re new to SQL, joins can be a daunting concept. There are many different types of joins and seemingly little information available that explains and compares them. But after you digest a few basic concepts, the practice of joins actually isn’t very difficult. Let’s look at the fund

Would you and others in your company like to make better decisions faster? Would your company like to capitalize on information assets to thrive in a competitive marketplace? The Microsoft SQL Server Accelerator for Business Intelligence (BI), a free tool that helps you quickly get BI solutions in p

New Record SAP R/3 4.6C Sales and Distribution Two-Tier Results The HP server rx5670 produced the world’s best four-way system performance result on the SAP R/3 4.6C Sales and Distribution (SD) two-tier benchmark, supporting 470 SD benchmark users at an average response time of 1.97 secon

All security operations in SQL Server depend on the twin processes of authentication and authorization. If the server doesn’t have total confidence in the user’s identity and, thus, can’t be sure of the permissions a user has, all attempts to control access to data fail. Microsoft has long preferred

Trace flags are used to temporarily enable or disable specific SQL Server database functions, allowing you to change default database behavior or to observe hidden database behavior, and will remain in effect until they are either manually turned off or SQL Server is restarted. Keep in mind that mos