So I’m hosting T-SQL Tuesday this month and decided that since security is something everyone has to deal with it...
2015-02-19 (first published: 2015-02-10)
7,222 reads
This isn’t so much of a best practice, it comes more under the heading of being careful. Let’s say you...
2015-02-18
2,226 reads
T-SQL is not the best language in the world for formatting strings. It can be done, but typically you are...
2015-02-16 (first published: 2015-02-05)
6,283 reads
When I decided on security as my topic for February’s T-SQL Tuesday blog party my thought was that security was...
2015-02-12
922 reads
Back in December I had the thought that it would be fun to do an email interview with someone. As...
2015-02-06 (first published: 2015-01-28)
6,820 reads
Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought...
2015-02-03
928 reads
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...
2015-01-29 (first published: 2015-01-26)
6,302 reads
EXCEPT and INTERSECT are two uncommon commands. Not that they do anything odd but they aren’t exactly well known in...
2015-01-23 (first published: 2015-01-19)
8,571 reads
It amazes me how much easier certain tasks have gotten in SQL Server. I was watching the Nov 2014 SQL...
2015-01-22 (first published: 2015-01-15)
8,829 reads
Have you ever seen a constraint with a name like PK__TableNam__EA185FBF8FF1529D? It’s kind of funny looking right? I mean it...
2015-01-21
1,927 reads
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Prepare for 2026 with this essential multi-state payroll tax issues 2026 webinar from Professionals...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers