The Importance of a Full Backup in SQL Server
This is the first of 12 posts this year in support of Tim Ford’s #iwanttohelp initiative. These will be completely...
2016-01-27
497 reads
This is the first of 12 posts this year in support of Tim Ford’s #iwanttohelp initiative. These will be completely...
2016-01-27
497 reads
While setting up example code for my presentation at SQL Cruise (which is going to be a fantastic event), I...
2016-01-18
530 reads
One of the many small things you don’t have to worry about any more when working with Azure SQL Database...
2016-01-18 (first published: 2016-01-11)
1,391 reads
I’ve been using a series of web sites while I was starting the process of learning R. I’ve highlighted several...
2016-01-13
580 reads
Quick little post. I just wanted to share how happy I am with the new “THIS TOPIC APPLIES TO” infographic....
2016-01-12
433 reads
I spend a lot of time talking about the need for automation within your databases, especially in support of development,...
2015-12-22 (first published: 2015-12-15)
1,744 reads
I’ve always found the best way to learn a new programming language is to start building stuff, solving problems, using...
2015-12-21
962 reads
Remember that post I wrote about taking on SQLSaturday events as my new PASS portfolio?
Never mind.*
Instead, it seems I’ll be...
2015-12-18 (first published: 2015-12-14)
1,244 reads
The hardest presentations I’ve ever given in my life were not to large audiences or in big rooms. They weren’t...
2015-12-18
452 reads
When I present at any given event, I generally assume that the people attending have heard of the event that...
2015-12-10
478 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 GOSee possible answers