Azure Data Lake enhancements
I first blogged about Microsoft’s new product, the Azure Data Lake, a few months back (here). There are already enhancements, as...
2015-09-29
1,166 reads
James Serra's Blog
Getting data into Azure Blob Storage
If you have on-prem data and want to copy it to Azure Blob Storage in the cloud, what are all...
2015-09-17
1,112 reads
Relational databases vs Non-relational databases
I see a lot of confusion about the place and purpose of the many new database solutions (“NoSQL databases”) compared...
2015-08-27
1,474 reads
Hadoop and Microsoft
In my Introduction to Hadoop I talked about the basics of Hadoop. In this post, I wanted to cover some of...
2015-08-12
3,183 reads
Analytics Platform System (APS) AU4 released
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU4),...
2015-08-06
1,111 reads
Cortana Analytics Suite
Yesterday at the Microsoft World Wide Partner Conference in Orlando Microsoft announced the Cortana Analytics Suite, which is a new package...
2015-07-14
943 reads
Microsoft Azure Data Catalog
Just announced is the Microsoft Azure Data Catalog, which is an enterprise metadata catalog / portal for the self-service discovery of...
2015-07-10
1,015 reads
What is Polyglot Persistence?
Polyglot Persistence is a fancy term to mean that when storing data, it is best to use multiple data storage technologies,...
2015-07-01
1,342 reads
What is Microsoft Azure Stream Analytics?
Microsoft Azure Stream Analytics (ASA) is a fully managed cloud service for real-time processing of streaming data. ASA makes it easy...
2015-06-03
1,078 reads
How an MPP appliance solution can improve your future
Massive parallel processing (MPP) is the future for data warehousing.
So what is MPP? SQL Server is a Symmetric Multiprocessing (SMP) solution, which...
2015-05-27
791 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