Beware the defaults! (in windowing functions)
Some time ago I was writing some windowing functions on a set of data. Basically I was looking for the...
2014-10-15 (first published: 2014-10-07)
6,628 reads
Blog Posts
Can’t Create A Timeline in Excel on Multidimensional Cube
Excel 2013 - We can’t create a Timeline for this report because it doesn’t have a field formatted as Date.
After getting...
2014-10-15
3,360 reads
Hell No, DMO - DMV is what it shall be!
So, I've finally decided to draw a line in the sand. I've been doing some writing lately. The radio silence...
2014-10-15
1,838 reads
I'm an MVP
Hello Dear Reader! Two weeks ago I was very honored to be named a Microsoft SQL Server MVP. Since then...
2014-10-15
811 reads
Lync 2013 Video Issues on Windows 8
Part of the reason I have a blog is to document issues and resolutions I do not want to forget....
2014-10-15
539 reads
PASS Election Results for 2014
The election results were just posted. Congratulations to James Rowland-Jones, Wendy Pastrick, and Grant Fritchey for earning seats on the...
2014-10-15
904 reads
PASS SQL Saturday Events: November 2014
DateEventNovember 1 SQLSaturday #339 – Shanghai 2014November 1 SQLSaturday #337 – Oregon 2014November 22 SQLSaturday #355 – Parma, Italy 2014November 22 SQLSaturday #353...
2014-10-15
555 reads
SSIS Pivot makes you stronger
At the recent Toronto SQL Server User group meeting Michal J Swart (@MJSwart) gave a good presentation based on 10...
2014-10-15
900 reads
Thank You: #passvotes
The results are in and it seems that I’ve been elected to a place on the PASS Board.
Thank you.
I will...
2014-10-15
490 reads
The full text error and why I was happy to see it.
The Situation: I was recently involved in the migration of a group of core databases from three SQL Server 2005 instances to...
2014-10-15 (first published: 2014-10-07)
6,115 reads
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
Comments posted to this topic are about the item Going Native with Fabric Spark...
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers