2007-12-20
1,893 reads
Editorials
Obfuscation
Test data is critical to being sure your application works, but is production data ok to use in test environments?
2007-12-19
511 reads
Data Ownership
Who owns the data that we generate ourselves? It's not as easy to answer that as you think.
2007-12-18
49 reads
2007-12-17
140 reads
Better Licensing
Licensing SQL Server used to be easy and could be again, though it is still better than licensing Oracle.
2007-12-17
234 reads
What Would You Do?
If someone acts suspicious at work, do you report them? What if it's the CIO? What if data security is involved?
2007-12-14
93 reads
Another Reason to Hate Ads
Malicious code embedded inside advertisements served on the web. What's next?
2007-12-13
62 reads
The Downside of Real Time
Everyone wants real time reporting, or do they? Steve Jones talks about some of the downsides of implementing such a system.
2007-12-12
115 reads
Do We Need a PK?
A primary key is a must for every table. Or is it? Steve Jones examines the question.
2007-12-11
439 reads
Hipp, Hipp, Hooray
In an age where commercial interests seem to trump all, it's nice to see someone delivering content out there for free.
2007-12-10
109 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