In this article, I will cover a bit about the LIKE operator, including how it works, and a bit of history about why it is like it is. After establishing this, I will discuss a bit about how you can (and should) use the LIKE operator in your CHECK constraints to strengthen your data integrity.
2024-09-13
2024-09-02
394 reads
I'm a little excited because tomorrow I'm going to my first maker's faire. I'll be volunteering with our local radio club (100 year old, W5IAS, oldest radio club in Oklahoma). In addition, I'll be showing off a few controller chips & Raspberry Pis that I use with my radios for APRS, satellite tracking, and digital […]
2024-08-24
57 reads
Learn how you can recover a database that is in suspect mode.
2024-08-16
2,719 reads
You know I have to say something about Crowdstrike. How could I not? Recovery for most people seems to be well in hand, but there are still places dealing with it. I was personally impacted because I was trying to fly home last Friday. While my airline and the airports I was flying through were […]
2024-07-27
130 reads
2024-07-26
321 reads
Steve is thinking about technology today, inspired by a developer/architect that asks some philosophical and moral questions of software.
2024-07-24
142 reads
This article examines whether creating indexes can help when deleting data from a SQL Server table.
2024-07-12
2024-07-05
540 reads
I was at a customer this week (sorry, can't share who). I spent the day talking about Redgate Monitor and how it can help with query tuning, server management, and estate management. Through the day, the data pros at the company were sharing how they were managing hundreds of servers and several thousand databases. They […]
2024-06-29
101 reads
By DataOnWheels
Hey data friends! This one comes from my personal vault (aka backlog of drafts...
Data's the new oil, and SQL is your refinery. It's still the go-to language...
You can’t just exec DROP ROLE your_role_name; if it’s granted perms or other roles...
Comments posted to this topic are about the item Why you should avoid Implicit...
Comments posted to this topic are about the item Creating a Linked Server in...
Comments posted to this topic are about the item Dates and Languages
The string, listopad, translates to a month name in different languages. If I were to run this code, what values are returned?
DECLARE @yourInputDate NVARCHAR(32) = '28 listopad 2018'; SET LANGUAGE Polish; SELECT CONVERT(DATE, @yourInputDate) AS [SL_Polish]; SET LANGUAGE Croatian; SELECT CONVERT(DATE, @yourInputDate) AS [SL_Croatian]; SET LANGUAGE English;See possible answers