MDX Puzzle #4
This puzzle is rather simple, but it does introduce a few new things. Using T-SQL you typically filter queries with...
2010-07-28
551 reads
Blog Posts
PASS 2010 Summit on LinkedIn Event Calendar – Have You RSVP’d?
Happened to notice in my weekly LinkedIn update today that Todd McDermid had signed up for the 2010 Summit event...
2010-07-28
788 reads
PASS Update #38 (SQLSaturday Wiki)
For the past couple years we’ve had a few different documents that covered how to run a SQLSaturday, but as...
2010-07-28
637 reads
Sharing Remote Desktop Sessions
I work for a very large company where divisions are spread out literally all over the world. There are many...
2010-07-28
896 reads
SQL Server 2008 Replication: High Availability Solution Part One – by Abi Chapagai
Introduction
Replication is the process of copying data between two databases on the same server or different servers on the same...
2010-07-28
31,939 reads
SQL University – Disk Capacity Planning
This week at SQL University we are talking about capacity planning. I am the guest lecturer for this topic, and...
2010-07-28
5,039 reads
The Right Level of “Right”
…or, How I Learned to Stop Worrying and Love the Bomb
I had a SQL dev’s dream come to me via...
2010-07-28
904 reads
Webcast Today – Using XML to Query Execution Plans
I’ll be speaking for the SQL PASSDatabase Administration Virtual Chapter today at 12 PM Eastern time. The topic will be...
2010-07-28
587 reads
[OT] Where Ya Been?
Have you heard the sound of silence? Yep, that’s been my blog.
It’s been weeks since I’ve posted anything on here,...
2010-07-27
681 reads
Count(*) or Count(1) ?
Every so often on the on-line forums, the question of : Which is better Count(*) or Count(1) ? will occur. So can...
2010-07-27
1,469 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers