Is your SQL Server environment ready for GDPR? Part 1
Unless you have been living under a rock lately, you have not heard about GDPR. This has been hot topic...
2018-05-25
121 reads
Unless you have been living under a rock lately, you have not heard about GDPR. This has been hot topic...
2018-05-25
121 reads
Vulnerability assessment is probably one of the most underrated new security features in SSMS 17. This feature is not new...
2018-05-21
128 reads
The SQL Server ERROR log is the best source to understand what’s wrong with your SQL Server instance, think this...
2018-05-10
99 reads
In some point of your career as DBA you might have interacted with ITIL or at least your heard about...
2018-04-13
231 reads
In my previous post I did my best explain a little bit what ITIL is and how important is for...
2018-04-13
213 reads
This is probably a very delayed post, but I have been really busy lately.
As mentioned in my previous post, I...
2018-03-23
95 reads
I’m very thrilled to announce that I will be participating as speaker in this year’s SQL Saturday event in Guatemala city!
Here...
2018-01-04
91 reads
Have you ever had problem with your backup jobs taking more time than usual overlapping your maintenance window? It is...
2017-12-01
182 reads
Today’s tip is a very basic functionality that comes with any SSMS (SQL Server Management studio), we are talking about...
2017-11-07
153 reads
By Steve Jones
How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...
Try this step-by-step guide to build and deploy a scalable serverless app that’s accessible...
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Code that can be used in order to create dashboard or SSRS report on...
So, I have an interesting situation that I need a double-check on. One of...
I have this data in a SQL Server 2022 table:
PlayerIDPlayerNamePlayerStatus 1The \%ChampActive 2The ChampActive 3The_ChampionActive 4The__ChampionActive 5The\_ChampActiveHow many rows are returned by this code in SQL Server 2022?
select PlayerName from player where playername like 'The\_C%' escape '\'See possible answers