SQL Saturday #28 (Baton Rouge) Announcements
Register: Click Here
Submitted Sessions: Click Here
Twitter: @SQLSatBR
On August 14, 2010 at Louisiana State University SQL Saturday #28 will be held. ...
2010-06-22
500 reads
SQLDownSouth
SSRS R2 - Naming Excel Worksheet Tabs
I was recently asked if it was possible to name an excel tab based on a page in a reporting...
2010-06-21
2,707 reads
Insert Unknown Row to Dimension Table
When building a warehouse there is a common practice of adding an Unknown row to the Dimension tables. For me,...
2010-06-15
1,419 reads
Parameterized Report using a Stored Procedure
Download Sample Project: Parameterized Report
In a recent forum post on BIDN.com a person asked how to filter the result on...
2010-06-13
2,266 reads
Upcoming SQL Lunch Events
We are scheduling more and more events daily on the SQL Lunch. Just as a reminder here are a few...
2010-06-10
520 reads
SQL Saturday #22 Pensacola Recap
Saturday I drove up to Pensacola for SQL Saturday #22. Me and several others from Baton Rouge, including my two...
2010-06-08
701 reads
Speaking at SQL Saturday #22 - Pensacola, FL
If you are near Pensacola, FL this weekend, I will be speaking at their SQL Saturday on June 5th, 2010. I will...
2010-06-02
751 reads
Inventory SQL Servers with CLR Function
In an enterprise with several SQL Server instances it is pivotal that you keep track of each instance and its...
2010-06-02
724 reads
SQL Lunch Call for Speakers – Quarter 3
One of my quarterly goals is to get speakers for the SQL Lunch webcasts. Q1 and Q2 of 2010 are...
2010-06-01
483 reads
Connecting to DB2 using SSIS
To start, first download and install the Microsoft OLE DB Provider for DB2. Click here to download. After it is...
2010-05-26
21,787 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers