Generating lift reports using Reporting Services - Part 1
This tip explores a DMX extension introduced in SQL Server 2005 SP2 that can be used to render lift reports directly in Reporting Services.
2007-05-24
3,491 reads
Articles
Career Book Reviews
Working in the corporate world can be a challenge and most of us muddle through our careers without really having any formal training. Andy Warren has spent time proactively working on his career and learned a great many tips and tricks for succeeeding as an employee and a manager. He brings us a few book reviews that might help you cope with the strange corporate world in which so many of us work.
2007-05-23
2,578 reads
2007-05-23
3,524 reads
Conditional Formatting in the Analysis Services Layer
Support conditional formatting for enterprise reports from the Analysis Services layer of the integrated Microsoft business intelligence solution.
2007-05-23
1,891 reads
Implementing Real-World Data Input Validation using Regular Expression
Francis Norton shows how to use regular expressions to fulfil some real world data validation requirements, demonstrating techniques ranging from simple number format checks, to complex string validation that requires use of regex's powerful "lookahead" feature.
2007-05-22
3,865 reads
SQLChess - A tutorial on thinking in sets
Chess makes a fantastic game for programming examples. You will find hundreds of examples on the internet. Some dedicated to OO patterns, others to algorithms and so forth. Unfortunately, most of these examples do not use a database or if they do, treat the database as nothing more than a storage repository. In this series of articles we will use SQL Server and T-SQL to implement the game of chess with an emphasis on thinking in sets.
2007-05-21
5,228 reads
SQL Server Grouping Workbench
Robyn Page and Phil Factor take on GROUP BY queries in SQL server, starting on the nursery slopes but finishing with a wild ride off-piste.
2007-05-18
2,426 reads
SQL Server 2005 Integration Services - Part 48
Maintenance Plan Designer gives you access to 11 tasks, which allow you to perform a variety of database management activities. This article provides a brief overview of each of them, focusing on their recent improvements.
2007-05-17
2,903 reads
Returning a week number for any given date and starting fiscal month
Sql Server comes with a host of built in functions such as ISNULL, CONVERT and CAST. Now if that wasn't enough rope to hang ourselves with, as of Sql Server 2000 we gained the ability to create our own user defined functions. In this article I will be looking at the three main date functions DATEADD, DATEPART and DATEDIFF (there is a fourth called DATENAME but I want to get to the end of this article before you fall asleep so I decided to leave it for another date and time! And no it doesn't foretell the name of your future blind date so it's not as interesting as it sounds anyway) Then I will be combining all three in a user defined function of our own by which time our necks will be well and truly stretched
2007-05-15
2,831 reads
Send SQL Server Data to Exchange
An updated version of xp_sql2exchange is now available, enabling you to publish SQL Server data easily to an exchange server. Read about this very cool extended stored procedure from author Steve Boriotti.
2007-05-14
12,030 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers