SQL Saturday 62 – Tampa FL – January 15th 2011
On January 15th, 2011, SQL Saturday is once again coming to Tampa Florida. This is going to be a tremendous...
2010-12-18
1,188 reads
Brian K. McDonald
Two Digit Year Cutoff
I couldn't sleep this morning and decided to wake up and catch up on my email when I noticed a video link...
2010-12-15
1,661 reads
Group Level Page Numbering using Reporting Services 2008 R2
Using SQL Server Reporting Services, we have always had the ability to use the built in fields (the Globals collection)...
2010-12-14
18,061 reads
Adding Existing Reports to Reporting Services Solution
If you’re anything like me, you create a ton of objects and have them in various projects. And sometimes, you...
2010-12-13
541 reads
URL Based Images using SSRS
For header images, I typically embed an image into the report. However, there may be times when you need to...
2010-12-13
812 reads
Automating the Processing of a Measure Groups Index Using SSIS
In a recent post (Processing a Measure Groups Index Using SSMS), I showed you how to utilize SQL Server Management...
2010-12-07
1,006 reads
Processing a Measure Groups Index Using SSMS
As I had mentioned in a previous blog (Creating and processing an Analysis Services partition), instead of processing an entire...
2010-12-02
1,252 reads
SQL Server Magazine’s Favorite Go-To Websites for SQL Server Solutions
While flipping through this month’s SQL Server Magazine (December 2010), I came across what I thought was a very interesting...
2010-11-30
3,958 reads
SSIS Package Annotation in Denali
If you are anything like me, you document your SSIS packages for those who may have to maintain them after...
2010-11-30
3,764 reads
Column Based Indexing in Denali
Recently, I was asked to install Denali for a client because one of the employees attended PASS 2010 and had...
2010-11-24
925 reads
Blogs
Speaking at the NYC Lunch and Learn DevOps Devour Hour
By Steve Jones
This Friday is the NYC DevOps Devour hour, which is actually 3 hours. Plus...
What’s new in SQL Server 2025 CTP 2.0
Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...
Monday Monitor Tips: Beyond SQL Server
By Steve Jones
Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...
Forums
Remove ISNULL FROM left join to make SARGAble
Hi, I'm trying to make the below query SARGable by removing the ISNULL function...
SQL 2022 upgrade issues
We're about to upgrade our SQL 2017 Standard to 2022 standard. We have 1...
Script-Drop Orphan users from SQL Server Database
Comments posted to this topic are about the item Script-Drop Orphan users from SQL...
Question of the Day
The Minimal Linked Server
What is the minimal number of parameters to add a linked server with sp_addlinkedserver?
See possible answers