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-07
3,309 reads
Patrick LeBlanc
SQL Lunch #50 - Solitary Containment (An Overview of SSIS Containers)
Join us tomorrow on the SQL Lunch for a little SSIS.
Topic: #50-Solitary Containment - An Overview of SSIS Containers
If you’ve ever...
2011-03-02
749 reads
I travel, I work, I EAT
As most of you know I am a consultant with Pragmatic Works, which requires me to travel a bit. During...
2011-02-12
643 reads
Presentations: Slides and Demos
Over the past couple of weeks I have given several presentations. At each presentation I have promised to post the...
2011-02-09
655 reads
Second Book Available for Pre-Order
Over the past six months I have writing chapters for my next book. The book is titled SharePoint 2010 Business...
2011-02-07
764 reads
Speaking at the Houston SQL Server Users Group
Since I am working at a client this week in Houston, I begged Nancy Hide Wilson (President Houston SQL Server Users...
2011-02-07
589 reads
SSIS: Custom Folder in your Package Store
Recently at SQL Saturday #57 – Houston I explained how to add a custom folder to your SSIS package store. I...
2011-02-07
1,465 reads
The Many Faces of SQL Server
Well, one of my goals this year was to focus on branding myself a little more. So I decided to...
2011-02-03
443 reads
SQL Lunch - Introduction to Change Data Capture
Join me tomorrow for a little CDC.
#47-Introduction to Change Data Capture
Speaker: Patrick LeBlanc
Add To Outlook: Add To Calendar
Meeting URL:https://www.livemeeting.com/cc/usergroups/join?id=269DRP&role=attend
Date and...
2011-01-31
1,961 reads
SQL Saturday #57 Houston
So you don’t have anything to do this Saturday.Well, if you have an insatiable thirst for SQL knowledge like me,...
2011-01-28
465 reads
Blogs
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Identify Unused Tables in SQL Server and Azure SQL
Comments posted to this topic are about the item Identify Unused Tables in SQL...
SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques
Comments posted to this topic are about the item SQL Server Advanced Troubleshooting and...
Question of the Day
Estimated Rows
I have two calls to the GENERATE_SERIES TVF in this code:
SELECT TOP 10 gs.value FROM GENERATE_SERIES(1, 10) AS gs ORDER BY NEWID () OPTION (RECOMPILE); go DECLARE @a int = 10; SELECT TOP (@a) gs.value FROM GENERATE_SERIES(1, @a) AS gs ORDER BY NEWID () OPTION (RECOMPILE);In the actual query plans, what is the estimated number of rows for each batch? See possible answers