Time Zones and Daylight Saving Time
Watch this week's video on YouTube
AT TIME ZONE is great because it makes it easy to perform daylight saving time and time zone conversions in our queries.
However, when using AT...
2019-03-05
7 reads
Invoke-Sqlcmd is Now Available Cross-Platform in the SqlServer module
Invoke-Sqlcmd is Now Available for MacOS & Linux in the SqlServer module. The module has been posted as v21.1.18095-preview which means to download the module you’ll have to add...
2019-03-05
8 reads
Invoke-Sqlcmd is Now Available Cross-Platform in the SqlServer module
Invoke-Sqlcmd is Now Available for MacOS & Linux in the SqlServer module. The module has been posted as v21.1.18095-preview which means to download the module you’ll have to add...
2019-03-05
24 reads
Invoke-Sqlcmd is Now Available Cross-Platform in the SqlServer module
Invoke-Sqlcmd is Now Available for MacOS & Linux in the SqlServer module. The module has been posted as v21.1.18095-preview which means to download the module you’ll have to add...
2019-03-05
46 reads
Invoke-Sqlcmd is Now Available Cross-Platform in the SqlServer module
Invoke-Sqlcmd is Now Available for MacOS & Linux in the SqlServer module. The module has been posted as v21.1.18095-preview which means...
2019-03-19 (first published: 2019-03-05)
2,274 reads
The login is from an untrusted domain and cannot be used with Windows authentication
SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been...
2019-03-18 (first published: 2019-03-05)
16,874 reads
CTRL + F in SSMS execution plans
I just discovered this the other day and I had to share it.
First, we need a query in Management...
2019-03-05
643 reads
Azure SQL Data Warehouse Query Store
I personally think that query store has been a fantastic feature. I find myself using it for query performance troubleshooting...
2019-03-05
625 reads
Informix on Docker
Today we will discuss how to install/configure informix on Docker, >docker run -it –name ifx –privileged -p 9088:9088 -p 9089:9089...
2019-03-04
851 reads
Watch: Kendra Breaks and Fixes SQL Source Control (9 minutes)
I love breaking technology. Well, I love breaking technology on purpose, in a place where it’s not going to slow anyone else down. It’s a great way to learn...
2019-03-04
13 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers