How Resilient Is Your Recovery Plan?
In this modern age of technology DBA’s face an ever increasing demand from businesses; our databases must perform, be secure,...
2012-03-14
627 reads
Happy #Pi Day
Here’s wishing you a Happy Pi Day…
If my picture isn’t good enough, here’s a better representation of pi.
3.14159265358979323846264338327950288419716939937510
Related posts:Happy Pi...
2012-03-14
589 reads
SQL Saturday 103 Recap
SQL Saturday 103 was in Curacao, a beautiful Dutch Island in the Caribbean. I was fortunate enough to be able...
2012-03-14
633 reads
Idera ACE Program
On March 9th a tweet went out by David Fargo announcing the 2012 Idera ACE’s and my twitter handle was...
2012-03-14
621 reads
Table Size and Missing FK Indexes
I am bringing an oldie back with another twist. I recently ran into the need to correlate information between a couple of different queries that I like to use....
2012-03-14
15 reads
Table Size and Missing FK Indexes
I am bringing an oldie back with another twist. I recently ran into the need to correlate information between a...
2012-03-14
1,134 reads
Distinct Count in Analysis Services
Business users are often interested in finding distinct counts in addition to other aggregations. They may want to know the...
2012-03-14
1,277 reads
Looking for a DBA? Looking for a New Job?
Ryan Recruiter meet Dave DBA…
As a contractor and consultant I get to speak to many agents and recruiters and over...
2012-03-14
726 reads
Error 0xC0014062: Unable to complete login process due to delay in opening server connection
Sometimes on a heavy loaded server(many databases/connection). You may get an error log when your backup maintenance plan job gets...
2012-03-14
7,313 reads
SQL Lunch Rescheduled
Due to a few scheduling conflicts the SQL Lunch scheduled for tomorrow as been rescheduled. The event will be on March...
2012-03-14
808 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