SQL Saturday #35 Notes and Observations
First of all, I want to congratulate all the volunteers that made this happen. It was a very well organized...
2010-05-25
1,178 reads
The Power of Regex in PowerShell
PowerShell is probably banned in MLB as a performance enhancing substance. You won’t find red-blooded American baseball player admitting to...
2010-05-25
728 reads
Space Used
At long last I am bringing the next installment in this mini-series. You can find the rest of the articles...
2010-05-25
1,445 reads
Yesterday's Vermont SQL Server User Group Presentation on Database Mirroring (Official PASS Chapter for Vermont)
To celebrate the Victoria Day Holiday in Canada I drove down to the U.S.A. with 'ol Volvo Wagon (not Smart this time, since 3k of...
2010-05-25
1,397 reads
Time Off, Recharge, Rethink
Some of you may have noticed that I haven’t posted for a while. The 12th May was the date of...
2010-05-25
636 reads
Does The Job Matter To You?
Last week I wrote an editorial for SQLServerCentral titled Does The Job Matter To You?, asking how much the type...
2010-05-25
577 reads
SQL Saturday Dallas Top Ten(ish)
So for those of you who attended SQL Saturday Dallas this past weekend, here’s my Top Ten(ish) list from the...
2010-05-25
620 reads
Quick Audits of Schema Changes
I saw someone post a question recently about tracking down who deleted a stored procedure. I suggested the default trace,...
2010-05-25
965 reads
It’s Done - SQLSat35
This is a strange feeling. No frantic deadlines. No daily conference calls with the team. No hurried trips to the...
2010-05-24
643 reads
Content Copy Followup
Last week I posted an article about plagiarism. This is a follow-up to that. After posting that blog article, Steiner...
2010-05-24
967 reads
Blogs
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,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
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