Testing New Features in SQL Azure Service Update 1
It seems to be SQL Azure night for me tonight… I thought I would try out some of the new...
2010-02-19
704 reads
Glenn Berry
Cumulative Update Package 8 for SQL Server 2005 Service Pack 3
Microsoft has released CU8 for SQL Server 2005 SP3, which you can get here. This is Build 4285. This CU...
2010-02-18
672 reads
Mirroring a Large Number of Databases in a Single SQL Server Instance
Microsoft SQLCAT team members Sanjay Mishra and Prem Mehra have published a new Technical Note called Mirroring a Large Number...
2010-02-17
966 reads
MVP Summit Impressions From Day 1
Well, today was the opening day of the 2010 MVP Global Summit in Bellevue, WA. There were a few “side...
2010-02-17
635 reads
Presenting in Colorado Springs on May 19, 2010
I will presenting at the Colorado Springs SQL Server User’s Group (CSSQLUG) on Wednesday, May 19, 2010. I will be...
2010-02-16
639 reads
SQL Server 2005/2008 Servicing Plans
Microsoft Group Program Manager Matthias Berndt has a post up on the Microsoft SQL Server Release Services blog (which is...
2010-02-13
589 reads
Round Two of Insert Benchmark Tests
After seemingly exhausting my physical file layout and instance configuration options in Round One of testing, I decided to “throw...
2010-02-09
522 reads
Speaking at the Rocky Mountain Tech Trifecta on February 27
I will be giving my Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With...
2010-02-09
501 reads
Some Initial Insert Test Benchmarks on SQL Server 2008 R2
They say that imitation is the sincerest form of flattery. I have been following along as Paul Randal has been...
2010-02-07
4,326 reads
Detecting and Troubleshooting Non-Yielding Worker Threads in SQL Server 2005/2008
I had a little bit of excitement with one of my production servers couple of days ago, that I thought...
2010-02-04
2,878 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