Generating a restore script
In order to speed up our backups on a large database our team decided to stripe the backup files. In...
2014-08-25 (first published: 2014-08-18)
7,514 reads
In order to speed up our backups on a large database our team decided to stripe the backup files. In...
2014-08-25 (first published: 2014-08-18)
7,514 reads
This is a quick demo of a little “trick” with heaps I’ve known about for a couple of years. However...
2014-08-25
606 reads
Two years ago today I began my blog with a post about the DEFAULT keyword. I set out with the...
2014-08-20
942 reads
If you have worked with SQL Server for very long you have probably run across the extremely useful system function...
2014-08-14
1,488 reads
Quick quiz. Which of these two commands is the opposite of GRANT?
DENYREVOKE
Well lets start with some definitions
GRANT – Grants permissions on...
2014-08-12 (first published: 2014-08-04)
8,494 reads
This month’s T-SQL Tuesday topic is SQL Family and is brought to us by Jeffrey Verheul (b/t). It’s an amazing...
2014-08-12
578 reads
Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes...
2014-08-07 (first published: 2014-07-30)
9,411 reads
What
When you use the SchemaBinding keyword while creating a view or function you bind the structure of any underlying tables...
2014-08-06
1,116 reads
Recently I wrote about what it means that a value is NULL. Right at the beginning I mentioned ANSI_NULLS and...
2014-08-04 (first published: 2014-07-28)
22,315 reads
The DAC is an important tool and several things can go wrong when trying to connect to it.
2014-07-31
3,264 reads
By Steve Jones
I was working with a customer and discussing how to do error handling. This...
By DataOnWheels
The 14th annual Ability Summit is a global event that I attended a few...
By Steve Jones
UPDATE: This moved to Apr 9 Join me Tuesday, Apr 9 for a webinar,...
Someone landed a PowerBI mess in my lap, and near as I can tell,...
I want to have a a secondary ready-only database available for reporting, which is...
How does the Resource database in SQL Server 2022 get backed up?
See possible answers