Rebuild System Databases
Yesterday night one of FB Friend have ping me, he has issue with his local SQL Server instance. Our conversation...
2012-01-29
3,437 reads
Find failed SQL jobs with powershell
This weekend I went to SQL Saturday in Auckland. It was nice to interact with other DBAs again. Kent Chenery...
2012-01-29
12,028 reads
Find Login in Active Directory
Find Login in AD
Many times we require to know if particular login is a part of ad user group. Or...
2012-01-29
873 reads
Creating merge replication conflict alerts
One of the challenges in working with Merge Replication is handling conflicts since writes can occur at any node in...
2012-01-28
1,564 reads
Petitions on Change.org and Thoughts on Changing PASS
I tried this out – Change.org that is – recently as part of a post about PASS and wanted to post a...
2012-01-28
798 reads
January #Meme15 Round-Up
The second round of #meme15 finished up last week and it’s time to see who participated. In total, there were...
2012-01-28
801 reads
Microsoft Data Appliances Help Simplify MSBI Projects
As some of you know, I am really excited about the data appliances Microsoft and HP have released this year. ...
2012-01-27
643 reads
SSAS fact table dilemma
Here is a situation I ran into recently concerning using a fact table in SSAS. This experience may help you out if...
2012-01-27
1,289 reads
Re-blog – January 20 – January 26
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-01-27
548 reads
2012-01-27
715 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