It’s interesting how an OR short circuits.
I recently did a post on the case expression short circuting and received a very very interesting comment from Chad ... Continue reading
2019-06-27 (first published: 2019-06-17)
875 reads
Blog Posts
Simulating Load
I needed to generate some load for a demo and wasn’t looking forward to doing it. I was in a hurry, and didn’t want to deal with a lot...
2019-06-27 (first published: 2019-06-12)
472 reads
Leadership Part 2: Talent acquisition and Employee Retention
The two most costly human capital expenses an organization will have is the onboarding and offboarding of staff. Just take a moment to think about that and if your...
2019-06-26 (first published: 2019-06-12)
409 reads
Query machine name of the sql server instance - the hard or the harder way
I was at a client where they are using non-Microsoft clustering technology to achieve the high availability of SQL Server instances....
2019-06-26 (first published: 2019-06-13)
1,732 reads
SQL Server 2008 and 2008 R2 is end of life on 9 July 2019
Next month, Microsoft is ending five years of extended support on SQL Server 2008 and SQL Server 2008 R2. This follows five years of mainstream support before that. You...
2019-06-26
42 reads
Database File Changes
Data professionals around the globe are frequently finding themselves occupied with figuring out why and when a file (data or log) for a database has changed in size. Whether...
2019-06-25
156 reads
From Evangelist to Advocate
It’s time for a little bit of change to occur. I am no longer a Product Evangelist for Redgate Software. No, they haven’t fired me and I haven’t quit....
2019-06-25
27 reads
Joker’s Wild
This past weekend I had a blast presenting Joker’s Wild with Erin Stellato (blog|twitter), Andy Mallon (blog|twitter), and Drew Furgiuele (blog|twitter). Watch it here! Table of contents: What is...
2019-06-25 (first published: 2019-06-11)
450 reads
Managing Cross-Database Dependencies in Builds (Redgate video)
Building your database code is an essential practice to ensure that it compiles from source and that dependencies are met. But things can get tricky when you have objects...
2019-06-25
6 reads
Multiple Identity Inserts
Watch this week's video on YouTube
This week I want to share something that surprised me about using SQL Server's SET IDENTITY_INSERT statement.
I started with two tables with identity columns...
2019-06-25
7 reads
Blogs
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,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
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...
What's the Date?
Comments posted to this topic are about the item What's the Date?
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