SQL Server Database Mirroring Tips and Tricks, Part 1
Even though SQL Server Database Mirroring is deprecated in SQL Server 2012, it is still a very useful HA/DR technique...
2012-03-16 (first published: 2012-03-12)
6,700 reads
Data Warehouse Architecture – Kimball and Inmon methodologies
What is the best methodology to use when creating a data warehouse? Well, first off, let’s discuss some of the reasons why...
2012-03-15 (first published: 2012-03-12)
9,537 reads
Done or Not Done
One of the things I hear a lot relating to work big and small is that it is “almost done”,...
2012-03-12
589 reads
SQL Server 2012 AlwaysOn & A Thorough Setup
It’s surprisingly easy to set up the new AlwaysOn features. I’ve done it on VMs running on my laptop, from...
2012-03-14 (first published: 2012-03-12)
3,171 reads
Double-Dash Comments, the Hidden Menace
While writing my last post on cleaning up old maintenance plans, I was reminded of something I heard in a...
2012-03-12
2,590 reads
Last Execution Date Time of a Stored Procedure
On many forums I have found a very basic yet important query - “How can I know when was my Stored...
2012-03-12
21,924 reads
Cleaning up Old Maintenance Plans
This is something I trip over every now and then on systems we inherit from our clients, and I thought...
2012-03-12
691 reads
SQL Server 2012 RTM–Are you waiting for SP1?
As you probably know by now SQL Server 2012 was launched last week, Microsoft had an online launch event that...
2012-03-12
3,495 reads
Synchronizing subscriptions in SQL Server Express
I was recently asked about synchronizing a Merge pull subscription in SQL Server Express using RMO, the lack of a...
2012-03-13 (first published: 2012-03-12)
4,343 reads
Jedi Mind Tricks
Here’s a story from a recent meeting. We were discussing some problems and the team was talking through some options...
2012-03-12
803 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