What is ANSI_NULLS and why will I be glad when it finally goes away?
Recently I wrote about what it means that a value is NULL. Right at the beginning I mentioned ANSI_NULLS and...
2014-08-04 (first published: 2014-07-28)
22,363 reads
Blog Posts
Writing Parametrized MDX for Reporting Services
Writing MDX inside of Reporting Services has been the nemesis for many report writers for far too long. If all...
2014-08-04
553 reads
Building The SQLSaturday Orlando Marketing Plan-Part 29
Received an email from LinkedIn that the ad was approved and so far we’ve spent a whopping 83 cents! Not...
2014-08-03
407 reads
Building the SQLSaturday Orlando Marketing Plan-Part 28
Today at lunch I looked at LinkedIn advertising. I only capture the last part to share here, but you put...
2014-08-01
569 reads
Friday Followup For August 1, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-08-01
308 reads
Lost Administrator SA password SQL server 2012
AdvertisementsThere are many blog posts talking about, how to recover “SysAdmin” password in case if it’s lost OR the server...
2014-08-01 (first published: 2014-07-27)
15,840 reads
Reblog: July 25 to July 31
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-08-01
569 reads
Why do we need UPDATE Locks in SQL Server?
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-08-01 (first published: 2014-07-28)
11,605 reads
An error occurred while executing batch. Error message is: Arithmetic Overflow
Recently an incident came across my desk where an end user was receiving an error trying to retrieve some records...
2014-07-31
2,489 reads
How To Get The Boss To Pay For Training
How do you get the boss to pay for training? In my experience you have to:
Ask. The boss isn’t sitting...
2014-07-31 (first published: 2014-07-24)
8,382 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