Warning: Not a valid checkpoint file name
One of the other DBAs I work with noticed a warning message that was flooding the log files on one...
2017-01-30
1,882 reads
Azure quick start
In case you hadn’t noticed, I love built in help. DBCC HELP, the script button in SSMS, even BOL. Well...
2017-01-30
686 reads
Altering Data Length of a Primary Key Column
This is not an article or a script. I am posting this just to share my experience and I feel...
2017-01-30
955 reads
Monday Coffee 2017-01-30
Wow, what a week last week was.
The biggest thing that happened was that I got a session at SQL Saturday...
2017-01-30
577 reads
Enabling Remote Access to the Dedicated Admin Connection
Recently I was running a health check on one of my clients SQL Servers and I noticed that access to...
2017-01-30
3,076 reads
How to compare two SSAS databases with a custom MDX query
[2017-Jan-29] It came as a request from one of my customers where I had worked as a consultant to quickly compare...
2017-01-29
2,772 reads
Worth Reading – Something I learned while unemployed by Rod Falanga
SQLServerCentral recently published Something I learned while unemployed. Written by Rod Falanga, it has lessons worth learning about making time to...
2017-01-28
829 reads
SQL and the other technologies
Next table shows how SQL stands with the other technologies. The data is taken from StackOverflow.Data charted looks like in the...
2017-01-28
450 reads
SCOPE_IDENTITY() or @@IDENTITY
I’ve seen quite a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from @@IDENTITY can sometimes not be the desired. This...
2017-01-27
7 reads
SCOPE_IDENTITY() or @@IDENTITY
I’ve seen quite a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from @@IDENTITY can sometimes not be the desired. This...
2017-01-27
11 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