Say Hi to the Dimension Merge SCD Component
Last week was a great week all around. It started with Canada's first SQL Saturday in Vancouver - packed with over 300 attendees watching five tracks of local speakers...
2011-03-09
12 reads
SQL Saturday 67 Chicago Pre-con Double Down
Yes, this looks familiar. Didn’t I write this last week? Well it’s new and the same. We have another pre-con available on the Friday, 3/25, before SQL Saturday 67....
2011-03-09
14 reads
SQL Saturday 67 Chicago Pre-con Double Down
Yes, this looks familiar. Didn’t I write this last week? Well it’s new and the same. We have another pre-con...
2011-03-09
965 reads
Say Hi to the Dimension Merge SCD Component
Last week was a great week all around. It started with Canada's first SQL Saturday in Vancouver - packed with over...
2011-03-09
1,038 reads
[OFF-TOPIC] Make a difference
I follow the blog of Johnny Long (twitter) from time-to-time, especially as he chronicled his work in Uganda. I know...
2011-03-09
806 reads
T-SQL Tuesday #016: Aggregates and Statistics
For my data analysis and trending, I wanted to find a simple distribution across quartiles.
Related Posts:
T-SQL Tuesday 109: Influence Somebody Invite December 4, 2018
T-SQL Tuesday Participation Over the...
2011-03-08
9 reads
T-SQL Tuesday #016: Aggregates and Statistics
Data Size Collection and Analysis
By now you should be well acquainted with this phenomenon we call TSQL Tuesday. This party...
2011-03-08
680 reads
Visual Studio 2010 SP1 Released
Microsoft has released the RTM version of Visual Studio 2010 SP1, which is available on the MSDN Subscribers web site.
Microsoft’s...
2011-03-08
755 reads
Full backups, the log chain and the COPY_ONLY option.
There have been a large number of posts made regarding the interaction between full database backups and the log chain...
2011-03-08
1,345 reads
An Overview of SQL Server AlwaysOn
One of the changes coming in SQL Server v11 (not sure what the name will actually be), also known as...
2011-03-08
921 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
Return all intermediate members of a recursive CTE?
I wrote a recursive CTE to determine employee levels... but what if I wanted...
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers