Power Query load settings
One point of confusion I see with Power Query is some people believe Power Query adheres to the Excel limit...
2013-12-23
1,394 reads
James Serra's Blog
I’m presenting at the PASS Business Analytics Conference
I am fortunate enough to have been selected to give a presentation at the PASS Business Analytics Conference in San Jose, CA...
2013-12-19
648 reads
Power Query Preview December Update
Microsoft keep turning out updates to Power Query. For December, some of the new features (download):
Connection to three more data...
2013-12-17
949 reads
Power BI for Office 365 FAQ
As I have been giving demos on Power BI for Office 365, I have received a tremendous amount of positive feedback,...
2013-12-12
1,774 reads
Certification Updates for SQL Server 2014
Info from Microsoft on how the MCSA and MCSE certifications will be altered for SQL Server 2014:
In reviewing the SQL...
2013-12-10
5,406 reads
Power Query Preview November Update
As I mentioned in my previous post (see Power BI first impressions), Power Query is a great new tool and Microsoft...
2013-12-05
1,503 reads
Power BI for Office 365 requirements
“Power BI” is an umbrella name for a lot of products, which I explain at Power BI first impressions (also I have...
2013-12-12 (first published: 2013-12-03)
3,453 reads
SQL Server Data Tools (SSDT) – October 2013 update
Since my last post about the SSDT update for August, there have been two updates, each containing one fix:
The September...
2013-11-26
1,192 reads
Power BI for Office 365 video
A demonstration of Power BI for Office 365, showing you how all the various tools and technologies work together: Power...
2013-11-28 (first published: 2013-11-21)
2,053 reads
Create video presentations
I recorded my first video presentation and demo using the screen recording and video editing software called Camtasia Studio for Windows.
It’s...
2013-11-19
570 reads
Blogs
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Back at Small Data SF in 2025
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers