TSQLCircleLive: What will be the result of the query below? Explai...
TSQLCircleLive: What will be the result of the query below? Explai...: select case when null = null then 'True' else 'False'...
2016-09-27
354 reads
Blog Posts
A Goal of Speaking at PASS Summit
Everyone has goals or at least they should have goals. As a young professional out of college, I had plenty...
2016-09-26
572 reads
Different types of ANSI standard joins
INNER JOIN (SIMPLE JOIN): This returns all rows for which there is at least one match in BOTH tables. This is...
2016-09-26
287 reads
Future DBA – Hadoop Big Data 1
In our last blog on Hadoop Big Data we have discussed about Hadoop and its tools/utility to connect to HDFS. on...
2016-09-26
605 reads
Nil to Speaker: Improving your PowerPoint skills
As I work on my speaking skills one of my tasks is improve my PowerPoint presentations. To that end I’ve...
2016-09-26
610 reads
Setting DBCC 1222 on startup
The following command is run to gain details on deadlocks.
DBCC TRACEON (1222,-1)
However, once the SQL instance is restarted this...
2016-09-26 (first published: 2016-09-19)
1,763 reads
Using an ORDER BY in a view
For many years it’s been a best practice to never put an ORDER BY in a view. The idea is...
2016-09-26 (first published: 2016-09-19)
3,823 reads
What does UNION do or what result set UNION return ? What is the difference between UNION and UNION ALL?
UNION merges the contents of two structurally-compatible tables into a single combined table. This return unique records from all the...
2016-09-26
184 reads
What will be the result of the query below? Explain your answer?
select case when null = null then 'True' else 'False' end as ResultSet;
2016-09-26
149 reads
Order by Month Number and Show Month Name
This may feel very
simple to many developers and yes it is, but I saw this request somewhere in community
website.So thought...
2016-09-24
938 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers