The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Learn how to best secure your SQL Server in a mixed-authentication environment and how SQL firewalls can protect your data. Then, see how to return multiple aggregates by using just one query, how to track down blocking processes, and much more!
By Brian Moran
The LEN() function will ignore trailing blanks, to count blank spaces, use the DATALENGTH() function instead.
By Russ Whitney
Learn how to create two calculated members that solve July's puzzle.
Can you find the top 10 single female customers without listing the other three types of customer--single male, married male, and married female?
When seemingly similar, or identical queries perform differently you need to compare the queries' execution plans to solve the mystery.
By Kalen Delaney
Locks prevent processes from simultaneously modifying data. But if a process holds a lock too long, it blocks other processes. The sysprocesses table can help you track down troublemaker processes so that you can get your queries running smoothly again.
Member properties let you store additional information about dimension members, but they can do much more. Are you getting all you can from your member properties? Here are 10 ways to pump up member-property effectiveness.
By Michael Otey
SQL Server provides a host of useful features that many customers aren’t taking advantage of. And when you need to do more with less, that’s almost as good as money in the bank.
By
Learn how to delete multiple records from a table by using a view as the filter.
By Itzik Ben-Gan
If you think relational division is the answer to a programming challenge, set-based solutions might work--unless the data set is too large. Here are a few alternatives.
You can't execute a stored procedure from a CASE expression, but you can use CASE to return a character string that you can use in the execution of the stored procedure.
By Geoff Craig
Although Windows authentication provides more security, business or application requirements sometimes dictate the use of mixed authentication. If you work in a mixed- authentication environment, take these steps to secure your SQL server.
By Ron Ben-Natan
Here is a sampling of companies that offer SQL firewall products.
By Rich Rollman
XML views let you produce an XML query result from your database, but ADO.NET's DataSet and XMLDataDocument classes also provide this functionality--and more.
By Vikash K. Agarwal
For most simple aggregations, using GROUP BY with an aggregation function returns the information you need. Inline conditional aggregation uses CASE...END to return multiple aggregates from just one query.
By Carolyn Mader
Check out the latest SQL Server-related new and improved products.
Well-written code, intrusion-detection systems, and traditional firewalls guard different aspects of your application systems. But how do you protect your data? Consider an SQL content firewall as your next security layer.
Readers write in about when the Simple Recovery model is appropriate and OLAP's compelling performance advantages over relational reporting.
SQL Server can't differentiate between datetime values that are within a narrow range--you must never use a datetime column as a primary key in SQL Server.
Several attacks have exploited well-known vulnerabilities related to UDP port 1434, so having the option of keeping it closed is valuable.
SQL Server Reporting Services, set for release by the end of the year, will fill the only hole in the SQL Server product--the lack of a built-in reporting component. Here are Reporting Services' seven most important features.
Registering the same physical instance of SQL Server more than once might be convenient sometimes.
Itzik Ben-Gan compares the performance of pure set-based solutions and hybrid set-based and iterative solutions.
advertisement