For better Sql code use fake tables
When unit testing code there is a really powerful feature that is either called mocking or faking or sometimes using...
2014-11-18
51 reads
Blog Posts
For better Sql code use fake tables
When unit testing code there is a really powerful feature that is either called mocking or faking or sometimes using stubs and what these mean is creating objects that...
2014-11-18
9 reads
MDX #42–IsEmpty? or = 0 ? or IS NULL?
In SQL, NULL means undefined value
Any SQL programmer can tell you that zero is not NULL, NULL is not zero, and...
2014-11-18 (first published: 2014-11-12)
22,719 reads
More on that Cyberwar
As a follow-up to my post on being at war, cyberwar:
State Department Hacked
If the experts are correct, this trend is...
2014-11-18
578 reads
Thoughts On A State of the Chapter Statement (and Doing More)
This is a follow up to a thought I voiced on Twitter last week – the value of a once a...
2014-11-18
567 reads
What Are You Thankful For
Bob Pusateri (B | T) wrote a blog post yesterday for anyone who was interested on sharing what they were thankful...
2014-11-18
520 reads
2014 PASS Summit 2014 Board Q&A Notes
As has occurred in previous years at the PASS Summit the PASS Board of Directors held an open Q&A session...
2014-11-17
693 reads
Essentialism: The Disciplined Pursuit of Less by Greg McKeown
While on my trip to PASS Summit 2014, I have selected one more book to read on the long flights...
2014-11-17
447 reads
How To Use the Unpivot Transform in SSIS
Moving data from columns to rows can be a tricky task and accomplished in a variety of ways. That may be...
2014-11-17 (first published: 2014-11-11)
7,981 reads
Interview Questions on SQL Server Database Mirroring
1) What is default port of Database Mirroring Endpoint?
Ans : 5022
2) Database Mirroring comes with which edition?
Ans: SQL Server 2005 SP1....
2014-11-17
20,511 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