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,532 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
585 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,165 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,575 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,888 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
680 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,493 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,334 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
800 reads
Factors that can delay Log Truncation – LOG BACKUP
When log records remain active for a long time – truncation can be delayed. The delays can cause the transaction logs...
2012-03-12
1,286 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers