On the First of June, SQL Server 2016 was officially released. While it is still early days to measure the full impact of the release, the one thing that is exceedingly clear is that this is a very successful software release. There have been very few complaints online beyond the standard heard during any upgrade: […]
2016-06-27
151 reads
Because there’s nothing else I can do at the moment.
The post Because appeared first on Home Of The Scary DBA.
2016-06-14
521 reads
Post #6 of #entrylevel #iwanttohelp in support of Tim Ford’s (b|t) beginner’s initiative.
If you’re just getting started with SQL Server,...
2016-06-13
1,233 reads
The question came up, how do the constructs necessary for Elastic Query within Azure SQL Database affect your ability to...
2016-06-13 (first published: 2016-06-06)
2,129 reads
You want to start working with Azure and the Azure Data Platform, but getting started is not easy. Just knowing...
2016-06-10 (first published: 2016-06-02)
1,510 reads
The Azure Data Platform is taking off. I’m seeing more and more interest on the forums, at conferences and in...
2016-06-01
419 reads
While presenting at SQLDay in Wroclaw, Poland, on the Query Store, I was asked a pretty simple question, which takes...
2016-05-31
938 reads
While this is a personal blog, I try to keep it focused on either technical topics or personal development and...
2016-05-25
485 reads
In just a few weeks I’ll be doing the Buckeye Blitz. That is, a tour of user groups in Ohio...
2016-05-24
535 reads
I didn’t post an update last month, but I did do something more important: I elicited your feedback on a question...
2016-05-23
383 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...
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
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...
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