Comparing an inner join vs a subquery
I was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing...
2013-05-08 (first published: 2013-05-03)
5,923 reads
The Activity Monitor is unable to execute queries against the server !
I’m generally not a great fan of Activity Monitor which is built in with SSMS,however today I wanted to check...
2013-05-02
3,439 reads
Want me to do a presentation?
I greatly enjoy doing presentations on a variety of topics, such as Business Intelligence, SQL Server, and personal development. If you...
2013-05-02
715 reads
PASS Virtual Chapter Events : May 2013
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...
2013-05-02
680 reads
Fix Page Checksum
A checksum value is tagged with every data page in SQL Server. This is used to detect issues on the storage system to ensure what has been read from...
2013-05-02
7 reads
Fix Page Checksum
A checksum value is tagged with every data page in SQL Server. This is used to detect issues on the...
2013-05-02
1,927 reads
PowerSQL - List SQL Server instance configuration details and sending an automated email
Reblogged from Prashanth Jayaram :
This article walks through how to list SQL Server configurable and non-configurable instance settings using PowerShell...
2013-05-01
2,917 reads
PASS SQL Saturday Events : May 2013
PASS SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in...
2013-05-01
545 reads
Calculating the next beginning of month and the current end of month
Handling dates is always a fun challenge in T-SQL! Finding the current end of month and next months beginning of...
2013-05-01
2,228 reads
Well I finally passed the 70-451
So I am now an MCITP Database Developer for SQL 2008. This is a big milestone for me. A few...
2013-05-01
809 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