T-SQL Window Functions – Part 2: Ranking Functions
This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links...
2014-06-26
1,244 reads
This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links...
2014-06-26
1,244 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2014-06-23 (first published: 2014-06-18)
4,291 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2014-06-19
1,170 reads
The past couple of months has been very busy at home and at work so I have fallen behind a...
2014-06-18
696 reads
On Tuesday, April 22, I had the opportunity to speak at the Techfuse conference in Minneapolis. I was presenting a...
2014-04-24
680 reads
As SQL Server Analysis Services Tabular Models become more popular, models will use Oracle databases as sources. One of the...
2014-04-14
1,113 reads
On March 8, 2014, I reached ten years of service at Magenic Technologies. When I started in 1999 (don’t do...
2014-03-14
806 reads
In my last post, I discussed how to set up Oracle in Windows Azure. During a customer call, there were...
2014-03-12
2,742 reads
As you have likely noticed in my series, Oracle Tips for MSBI Devs, I have done a lot of work...
2014-02-24
884 reads
It started as a vision for expanding the reach of the Minnesota SQL Server User Group a year ago. At...
2014-01-23
674 reads
The setup My day job involves babysitting a lot of Git repositories hosted on...
By John
Recently, the world was reminded of just how fragile the internet can be. Two...
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
Seeing this message repeated every 10 seconds in the RSHostingService_yyyy_mm_dd_hh_mm_ss.log file. Can anyone advise:...
I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...
hi for the 2 years i've been here I believe we've had "encryption" turned...
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers