The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Protect your data access processes from SQL injection attacks. William Sheldon uses best practices and examples based on Windows Forms and ASP.NET to illustrate the concept of data binding.
By John Bowen
SQL Server Reporting Services (SSRS) has some built-in features for generating and exporting reports, but these third-party utilities expand those capabilities and target end-user rather than just developer reporting.
By Michelle A. Poolet
Find out how conformed dimensions and facts make up an enterprise data warehouse.
By Itzik Ben-Gan
Get the solution to October's puzzle "Two Mathematicians," and prepare your mind for November's puzzle, which involves an insane number sequence.
As you dive deeper into SQL Server 2008's grouping-sets features and learn about the new CUBE and ROLLUP options and the GROUPING_ID function, you'll experience better performance and need to work with less code.
By Stacia Misner
Deploy SSRS and MOSS 2007’s information-integration features to help business users find what they need, analyze results, and share their insights for better decision making.
By William Sheldon
There are commonalities between the different forms of data binding. This article's focus on simple Windows Forms and ASP.NET examples provides a great introduction to data binding while running through some best practices.
By Pinalkumar Dave
Learn the difference between UNION and UNION ALL; INNER JOIN and OUTER JOIN; DISTINCT and GROUP BY; NVARCHAR, VARCHAR, and CHAR; and timestamp and GETDATE().
By
If you've ever come across the problem of hitting the 900-bytes limitation for unique constraints, you'll want to check out this simple solution.
By Andrew J. Kelly
Learn when and how to use SQL Server's parallel-processing settings, and you'll be able to achieve the best balance between concurrency and speed for your unique environment.
By Bill McEvoy
Here's a stored procedure that consolidates the basic functions of osql and bcp. Switching between these utilities' output is simply a matter of changing the value of an input parameter.
By Kevin Kline
Reporting Services Scripter's three modes of operation let you run scripts that you've created, move scripts between folders and servers, and generate scripts for reports already in SSRS.
By Anne Grubb
If you couldn't attend PASS 2007 in September, the next best thing is reading our online conference highlights. And get a sneak preview of the January "reader solutions" issue, inspired in part by the active SQL Server Magazine online community.
By Douglas McDowell
Maybe it’s not too soon for SQL Server 2008, especially when you consider how 2008 offers strong BI enhancements in three key areas: Reporting Services, Database Services, and operational management.
By Michael Otey
Microsoft's new MODL training is where Second Life meets traditional classroom training. The result: an entirely new training environment that provides a fun, life-like training program that you can follow at your own pace.
Now that Microsoft has released several different service packs for SQL Server 2005, chances are you're running multiple versions. Here's an easy way to see what you're running.
By Eli Leiba
To determine the number of occurrences of a substring within a string, a user-defined function (UDF) performs a simple arithmetic calculation.
advertisement