IN vs UNION ALL
Watch this week's video on YouTube
When you need to filter query results on multiple values, you probably use an IN() statement or multiple predicates separated by ORs:
WHERE Col1 IN...
2019-04-30
13 reads
Blog Posts
It’s Been a While …
Last Post – SQL Saturday MN 2018 When last I wrote, it was after I spoke at SQL Saturday in Minnesota. I co-presented a pre-con with Josh Owen. Prior...
2019-04-30
18 reads
Know How to Repair SQL Database Marked as Suspect Mode in SQL Server
Repair SQL Database Marked as Suspect Mode MS SQL server is a widely used relational database management system developed by Microsoft. It is a software product which primarily helps...
2019-04-30
44 reads
Know How to Repair SQL Database Marked as Suspect Mode in SQL Server
Repair SQL Database Marked as Suspect Mode MS SQL server is a widely used relational database management system developed by Microsoft. It is a software product which primarily helps...
2019-04-30
8 reads
Lengthen a Primary Key–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a post recently where someone needed...
2019-04-30 (first published: 2019-04-17)
449 reads
Setup SQL Server Alert to get automatically notified of database blockings
Suppose you want to or need to know anytime your SQL Server is experiencing blocking where queries are being blocked and it may or may not escalate to a...
2019-04-30 (first published: 2019-04-17)
1,676 reads
Four Data Integration Design Questions to Ask
We get requests to move data between custom systems regularly, even within systems. I was advising a client on something fairly simple—a collection of tables out of one vendor...
2019-04-29
5 reads
It’s all just data.
Tables, stored procedures, views, logins, constraints, etc, etc. It’s all just data. In every database system I’ve ever worked on ... Continue reading
2019-04-29 (first published: 2019-04-17)
492 reads
More Software Quality with DevOps and CD
Tomorrow is the SQL in the City Summit in London. Right now I’m in a Heathrow airport hotel, finalizing some prep for the event. I have to run a...
2019-04-29
7 reads
Speaking at PowerShell Summit 2019
Speaking at PowerShell Summit 2019! I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2019 the conference runs from April 29th 2018 through...
2019-04-29
18 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Solutions for Environmental and Pollution Testing | Fare Labs Pvt. Ltd.
The state-of-the-art FARE Labs Environmental Testing Laboratory provides a broad range of testing services...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers