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,235 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,235 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,270 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,163 reads
The past couple of months has been very busy at home and at work so I have fallen behind a...
2014-06-18
693 reads
On Tuesday, April 22, I had the opportunity to speak at the Techfuse conference in Minneapolis. I was presenting a...
2014-04-24
674 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,104 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
800 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,735 reads
As you have likely noticed in my series, Oracle Tips for MSBI Devs, I have done a lot of work...
2014-02-24
874 reads
It started as a vision for expanding the reach of the Minnesota SQL Server User Group a year ago. At...
2014-01-23
671 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
How to install mysql-connector-python-8.4.0.zip it does not have setup.py. Checked also: mysql-connector-python-8.4.0.tar.gz
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers