By Stacia Misner, 10/25/2007
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 Itzik Ben-Gan, 10/25/2007
Get the solution to October's puzzle "Two Mathematicians," and prepare your mind for November's puzzle, which involves an insane number sequence.
By Readers, 10/25/2007
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 Michael Otey, 10/25/2007
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 ...
By John Bowen, 10/25/2007
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 ...
By Kevin Kline, 10/25/2007
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 ...
By Bill McEvoy, 10/25/2007
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 ...
By Michael Otey, 10/25/2007
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 Douglas McDowell, 10/25/2007
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 ...
By Itzik Ben-Gan, 10/25/2007
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 ...
By Andrew J. Kelly, 10/25/2007
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 Eli Leiba, 10/25/2007
To determine the number of occurrences of a substring within a string, a user-defined function (UDF) performs a simple arithmetic calculation.
By William Sheldon, 10/25/2007
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 ...
By Michelle A. Poolet, 10/25/2007
Find out how conformed dimensions and facts make up an enterprise data warehouse.
By Anne Grubb, 10/25/2007
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, ...
By Pinalkumar Dave, 10/25/2007
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().