Active August #2
Hrmmm… 198. Up four pounds. That just doesn’t seem possible. I did a tabata on Monday. I did have a...
2009-08-08
530 reads
The Scary DBA
Presenting “Understanding Execution Plans”
The PASS Application Development SIG is hosting a web cast next week on Tuesday where I’ll be presenting Understanding Execution...
2009-08-07
818 reads
Pain of the Week Webcast
Thursday this week I get to hang out, virtually, with some of the heavy hitters of the industry, Brent Ozar,...
2009-08-03
515 reads
SQL Server Standard
PASS is relaunching the SQL Server Standard with a wholly new approach and format. I’ll put more out about it...
2009-08-03
705 reads
24 Hours of PASS
I’m fairly certain Jack Bauer isn’t involved with this new initiative from PASS. Just as I’m also certain I won’t...
2009-08-03
727 reads
Active August #1
I like to blog about technical topics and community, not personal stuff. However, this is a community post. A number...
2009-08-01
618 reads
PASS & SQL Bloggers
PASS is trying to find better ways to reach out to SQL Bloggers. They’re going to experiment with taking advantage...
2009-07-31
1,306 reads
No really. When did this statement start?
I thought I had an interesting answer to the question. Unfortunately Adam Machanic, who has been working in this specific...
2009-07-31
1,305 reads
When did this statement start?
UPDATE: This post is incorrect. Adam nailed it in the comments. I explain my mistake here.
A question came up over...
2009-07-28
1,870 reads
Attache/Brief Case Review
Steve Jones, through a series of comments, emails, blackmail, back-alley deals & tons of whining, agreed to let me review a...
2009-07-24
565 reads
Blogs
How to Learn SQL Without Quitting Your Day Job
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...
SQL Server 2025
By Vinay Thakur
Microsoft announced on November 2024 a preview for SQL Server 2025 another major release...
Advice I Like: Apologies
By Steve Jones
How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...
Forums
SQL Clustered Resource in online pending for about 3-5 mins before coming online
Hello! SQL Clustered resource used to come online during manual or automatic failover in...
SQL Query to use in MS SSRS server to give you your report structure.
Code that can be used in order to create dashboard or SSRS report on...
Temp table security
So, I have an interesting situation that I need a double-check on. One of...
Question of the Day
Escaping Like I
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