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,393 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
947 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,767 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,404 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,500 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,451 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,190 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,052 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
Azure SQL offerings
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
A Little Brainstorming with an AI
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Forums
MEMORYBROKER_FOR_RESERVE experience
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
Moving Database Files
I just learned that my database was created on my C:\ drive in the...
Migrate MSSQL to MYSQL - Different Servers
I am needing to migrate a MSSQL db to MySQL, on a different server...
Question of the Day
Mixed Backups
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers