SQL Server Magazine August 2003
[Focus]
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 Geoff Craig
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.
By Ron Ben-Natan
[Features]
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 Vikash K. Agarwal
[SQL Server Savvy]
Several attacks have exploited well-known vulnerabilities related to UDP port 1434, so having the option of keeping it closed is valuable.
By Brian Moran
The LEN() function will ignore trailing blanks, to count blank spaces, use the DATALENGTH() function instead.
By Brian Moran
Registering the same physical instance of SQL Server more than once might be convenient sometimes.
By Brian Moran
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.
By Brian Moran
When seemingly similar, or identical queries perform differently you need to compare the queries' execution plans to solve the mystery.
By Brian Moran
[Editorial]
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 Michael Otey
[SQL Seven]
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.
By Michael Otey
[Inside SQL Server]
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.
By Kalen Delaney
[Mastering Analysis]
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 Russ Whitney
[T-SQL Black Belt]
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.
By Itzik Ben-Gan
[Answers from Microsoft]
Learn how to delete multiple records from a table by using a view as the filter.
By Microsoft's SQL Server Development Team
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 Microsoft's SQL Server Development Team
[Exploring XML]
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 Rich Rollman
[Letters]
Readers write in about when the Simple Recovery model is appropriate and OLAP's compelling performance advantages over relational reporting.
By Various Authors
[New Products]
Check out the latest SQL Server-related new and improved products.
By Carolyn Mader
|
