A Little Azure Fun on Friday
You know how we’ve always heard that sp_msforeachtable and other similar undocumented functions may not be supported in future versions...
2013-05-24
724 reads
The Scary DBA
PASS Summit 2013 is Looking Cloudy
No, this isn’t some complaint about PASS or the Summit. This is an announcement that not only will I be...
2013-05-22
634 reads
Microsoft Lync Through the Web
Get an invite to a Microsoft meeting? Are they using the new Lync interface? And, you don’t have a paid...
2013-05-21
780 reads
Azure does Powershell too
Or, I guess it might be more appropriate to say that Powershell does Azure. Regardless, there are a set of...
2013-05-23 (first published: 2013-05-20)
1,928 reads
Book Review: Business in the Trenches
I’m trying to improve.
That’s at just about everything too. I know I don’t know enough or have enough skills to...
2013-05-09
729 reads
How to Tell Your Windows Azure SQL Database Moved
The very concept of the Windows Azure SQL Database (WASD) is predicated on the up-time created by having three active copies...
2013-05-13 (first published: 2013-05-07)
1,575 reads
Windows Azure SQL Database Backups
You can get backups of your WASD databases. But, if you want them to be transactionally consistent, you need to...
2013-04-04
918 reads
Execution Plans in Azure SQL Database
Microsoft has stated pretty clearly that they’re putting code on Azure first, ahead of the desktop. Which makes one wonder...
2013-03-27 (first published: 2013-03-25)
3,627 reads
Laws You Break at Your Peril
Laws of Thermodynamics
TANSTAAFL
Gods of the Copybook Headings
All magic comes with a price
Winter Is Coming
My adult years started with a pretty...
2013-03-20
856 reads
Star Trek and the Death of IT
GAAAAAAAHHHHH!!!!
I feel slightly better, but only slightly.
I started watching Star Trek: The Next Generation on Netflix just to unwind my...
2013-03-18
1,123 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