SSRS: Shared DataSet, Not So Shared!!!
I was really excited about the concept of Shared DataSets when they were introduced. My excitement diminished a little when...
2011-03-17
1,767 reads
Patrick LeBlanc
SSRS: My Filter is not Working!!!
I rarely use filters in my SSRS reports. However, this was a client requirement. When we attempted to use the...
2011-03-09
2,616 reads
Minimizing Fragmentation when Moving data using a Switch
Yesterday was the first day of the SQL Server 2008 R2 airlift.I attended a great session on Implementing a Fast...
2010-03-23
972 reads
SSRS – KPIs without Analysis Services
During a recent project I was asked if it was possible to simulate Key Performance Indicator (KPI) images in SQL...
2010-03-09
1,684 reads
2010 First Quarter Goals
I have been reading several blog postings about 2010 goals. First, I want to applaud all of you for setting...
2010-01-12
623 reads
SSIS - Single Package Deployment from BIDs
I have read several articles about deploying SSIS packages.Most focus on using the deployment wizard or simply copying the files...
2009-12-28
1,523 reads
Linear Gauge Control: A Practical Use
SQL Server Reporting Services 2008 introduced several new features. One key feature was the inclusion of the Gauge Controls. I...
2009-12-02
5,427 reads
Deploying Reports on Windows 7
Recently I tried to deploy a report to a Report Server on my laptop, which is running Windows 7 Ultimate....
2009-11-27
2,033 reads
How to Create a Reporting Services 2005/2008 Template
At most large companies one business requirement is that all reports have the same look and feel. This may vary...
2009-11-24
5,979 reads
SQL Lunch Recordings Now Available
After several tries I think we finally have it working. If you were unable to attend the last two SQLLunches,...
2009-11-20
1,911 reads
Blogs
Using Data Masker on Chinese Surnames
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
A New Word: Looseleft
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
Using ChatGPT for Writing
By Steve Jones
I have been experimenting more and more with ChatGPT on a regular basis. I’m...
Forums
NOT LIKE Alternatives in WHERE clause
Hello, I need help to improve an existing (hence I cannot change table's structure...
Vulnerability Assessment removed?
In Brent Ozar's list of links today, I learned that Microsoft has removed the...
Advanced SQL query help
Hi, I am looking for some help with two queries using the following table/data....
Ask SSC