Microsoft SQL Server is a feature rich database management system product, with an enormous number of T-SQL commands. With each feature supporting its own list of commands, it can be difficult to remember them all. MAK shares his top 10 T-SQL statements that a DBA should know.
Did you know that commuting can actually affect your health? Steve Jones talks about an IBM study on this and suggests you talk to your boss about telecommuting or remote work. The option to do so just might be beneficial for your long term health.
There was a conversation on Twitter recently (with the #sqlhelp hashtag) about whether it was completely safe to run the...
On February 18, Franck Delattre released version 1.57 of the very useful CPU-Z Utility. Here is a list of the...
We ran into a case recently where we had the logins and users scripted out on my SQL Server instances, but we didn't have the fixed database roles for a critical database. As a result, our recovery efforts were only partially successful. We ended up trying to figure out what the database role memberships were for that database we recovered but we'd like not to be in that situation again. Is there an easy way to do this?
We have recently found an elegant way to reduce the time, and disk space required for SharePoint administrators who need to perform granular recovery operations out of their SQL Server backup files. I used to get customer calls that would go something like this:
How do you decide what to archive? Steve Jones says that you need to come up with a method as our data sizes grow larger and larger all the time.
The Spring 24Hours of PASS: Celebrating Women in Technology will be broadcast live on the intertubez on March 15 and 16...
Arshad Ali demonstrates how to verify the SQL Server Service Broker (SSBS) configuration when both the Initiator and Target are in different SQL Server instances, how to communicate between them and how to monitor the conversation.
Now that the Denali CTP has been out for several months, Brad asks how you're planning on getting up to speed on the latest version of SQL Server
By Arun Sirpal
As part of my wider work exploring Claude Code and AI-assisted database engineering, I...
By Bert Wagner
Train Wreck The last time I watched a high school band nearly fall apart mid-performance...
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
Comments posted to this topic are about the item Why Your Index Isn't Being...
Comments posted to this topic are about the item Distance Metric Algorithms
Comments posted to this topic are about the item What Can AI Really Do?
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers