U-SQL Defined
Azure Data Lake Analytics (ADLA) is a distributed analytics service built on Apache YARN that allows developers to be productive immediately...
2017-03-23
470 reads
James Serra's Blog
PolyBase use cases clarified
I previously talked about PolyBase and its enhancements (see PASS Summit Announcements: PolyBase enhancements). There is some confusion on PolyBase use...
2017-03-15
596 reads
SQL DB now supports 4TB max database size
Azure SQL Database (SQL DB) has increased its max database size from 1TB to 4TB at no additional cost.
Customers using...
2017-03-10
290 reads
Power BI and Excel options for Hadoop
Below I have attempted to list the various options for reporting off of Hadoop (HDInsight, HDP, Cloudera) using Power BI...
2017-03-09
565 reads
Azure Data Factory and SSIS compared
I see a lot of confusion when it comes to Azure Data Factory (ADF) and how it compares to SSIS....
2017-03-01
427 reads
IoT Hub vs. Event Hub
There can sometimes be confusion, in IoT scenarios, between IoT Hub and Event Hub, as they can both be valid...
2017-02-08
331 reads
Microsoft Products vs Hadoop/OSS Products
Microsoft’s end goal is for Azure to become the best cloud platform for customers to run their data workloads. This...
2017-01-18
337 reads
Create quick queries quickly with SSAS in Azure
In a perfect world a data warehouse would always return all queries very quickly, no matter what the size or...
2017-01-04
267 reads
Data gateway confusion
Microsoft has created data gateways as a way that cloud products such as Power BI and Azure Machine Learning can...
2016-12-21
404 reads
What is HTAP?
I have been seeing the term “HTAP” mentioned a lot recently, and I thought I would briefly explain the term....
2016-12-14
312 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