SQLServerDBA News - 2011 Review for SQLServerDBA
2011 was a great year on a personal and professional level
1) Completed the Brighton Marathon in 4hrs 36 secs
2) Blogged...
2011-12-31
1,578 reads
Good Bye 2011
Good Bye 2011
Hey there, this year is going to an end and just want to recall what all happened this...
2011-12-31
1,300 reads
Thoughts on SSSOLV December Meeting
This is very late – I know. The meeting was held on December 8, 2011 and I haven’t yet shared my recap/thoughts about the meeting. We hold the SQL...
2011-12-30
16 reads
Thoughts on SSSOLV December Meeting
This is very late – I know. The meeting was held on December 8, 2011 and I haven’t yet shared my...
2011-12-30
1,479 reads
Estimated Completion Time for Backups and Restores
I’m in the middle of a database migration and thought I’d quickly share a script I threw together to show...
2012-01-03 (first published: 2011-12-30)
82,529 reads
SSIS Community Tasks and Components
Do you know there are hundreds of additional tasks, tools, and components for SSIS, many which are free? Why re-invent...
2012-01-04 (first published: 2011-12-30)
3,097 reads
Re-blog – December 23 – December 29
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2011-12-30
1,446 reads
Increase SQL Server Error Log Files
Recently I learned that you can and probably should increase the number of SQL Server Error logs that your instance...
2012-01-04 (first published: 2011-12-30)
4,134 reads
January 2012 Las Vegas SQL UG
This month I am attempting to get a jump on things a bit. I am hoping to get the info out in a more timely fashion throughout this new...
2011-12-30
15 reads
January 2012 Las Vegas SQL UG
This month I am attempting to get a jump on things a bit. I am hoping to get the info...
2011-12-30
1,696 reads
Blogs
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers