SQLMCM Training – Day 11
Today Jonathan presented on Replication and Paul about Database Snapshots, and his
baby called "CHECKDB" – he has been married with CHECKDB...
2011-08-19
921 reads
Klaus Aschenbrenner
SQLMCM Training – Day 10
Today Paul was speaking about Database Mirroring and Jonathan was talking about Failover
Clustering – all in all a very intensive day...
2011-08-18
612 reads
SQL MCM Training – Day 9
Today Jonathan was talking the whole day about Consolidation and Virtualization. There
were again a lot of new concepts, and new...
2011-08-17
955 reads
SQL MCM Training – Day 8
Today Paul talked the whole day about HA DR Strategies and Backup/Restore operations.
I've already known a lot about Backup/Restores, but...
2011-08-16
735 reads
MCM Training – Day 6 & 7
My whole weekend was dedicated to MCM studying, and I've reviewed a lot of stuff that
we have learned through the...
2011-08-15
544 reads
SQL MCM Training – Day 5
Today I've not taken too much notes, because the whole afternoon was about the Management
Data Warehouse and Multi-Instance Management. But...
2011-08-13
1,374 reads
Service Broker sample application from SQLskills Immersion Event
You can find my Service Broker sample application which I presented during the SQLskills
Immersion Event in Bellevue here for download:...
2011-08-12
1,287 reads
SQL MCM Training – Day 4
Today Jonathan has presented on analyzing trace data, and Kimberly has spoken on troubleshooting
Plan Cache Issues and Index Consolidation. It's...
2011-08-12
535 reads
SQL MCM Training – Day 3
Nothing to say about today, Jonathan did really a great job describing Extended Events
and Baselining/Benchmarking to us, and his boss...
2011-08-11
1,057 reads
SQL MCM Training – Day 2
Today's day was Jonathan Kehayias days, and it was pretty impressive. Jonathan covered
the following 3 modules, and he can speak...
2011-08-10
1,035 reads
Blogs
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Keeping MS Docs Up to Date
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
Patch Tuesday – Where to get more information
By Brian Kelley
For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...
Forums
is there a no code way to limit an ssis extract from excel to the 1st 21 rows?
is there a no code way to limit an ssis extract from excel to...
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
any reason to avoid asking ssis to extract files from ftp
hi we have to replace talend which generally was used to move files. talend's...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers