Why Separate Your Compute From Your Storage
There are many advantages to using Microsoft Azure. One big reason people look at Azure is the ability to separate...
2018-09-04
393 reads
There are many advantages to using Microsoft Azure. One big reason people look at Azure is the ability to separate...
2018-09-04
393 reads
When Azure Resource Manager (ARM) was created back in 2014, I (like many) thought, “What does that mean?” Up until...
2018-08-30
297 reads
So, your boss says, ‘Let’s do big data!’ And you think: ‘I don’t even know what that means or what...
2018-08-29
972 reads
Azure accounts vs. Azure subscriptions – often a topic that brings some confusion to Azure newbies. Are they the same? What’s...
2018-08-28
200 reads
Are you just starting out with Azure and wonder: What is Azure Resource Manager (ARM) Deployment Model? Or what’s the...
2018-08-27
255 reads
As you likely know, I am a Principal Consultant at Pragmatic Works. This year we have been doing some great...
2018-08-25
381 reads
Power BI Report Server was released as a way to host reports on premises. It was one of the highest...
2018-05-31
517 reads
Cosmos DB is one of the fastest growing Azure services in 2018. As its popularity grows, data professionals are faced...
2018-05-24 (first published: 2018-05-16)
2,835 reads
The following has been reposted with permission from Steve Howard a.k.a. @AngryAnalytics. I have made some formatting changes but the...
2018-05-24
427 reads
I was able to present at SQL Saturday Dallas this year. Thanks to those of you who were able to...
2018-05-22
199 reads
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
I just learned that my database was created on my C:\ drive in the...
I am needing to migrate a MSSQL db to MySQL, on a different server...
Hi we run 2019 ssas std. Yesterday i imported my tabular project to vs...
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 GOSee possible answers