Brent Ozar explains that if you're going to do continuous integration or deployment, you've got a rocky road ahead of you.
Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.
Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.
Phil Factor argues that the ability to write simply and expressively is a much under-valued skill in IT, and explains the main traps to avoid.
Steve asks the question today of how you might measure downtime and the scope you are concerned about.
With SQL Server now supported on Linux, traditional SQL Server DBAs will need to learn how to work with Linux, and Linux administrators will need to learn how to work with SQL Server. Fortunately, there are several tools available to assist. In this article Prashanth Jayaram describes how to work with the DMV tool which treats queries as files.
Learn how you can execute a PowerShell script via the SSIS execute process task.
Today we have a guest editorial from Derik Hammer that reminds us that there isn't one solution that will fit all your solutions.
A myriad of laws regulate data retention and generally compete with each other. William Brewer provides an introduction to the principles, but gives good advice -- leave the details to the specialists.
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...
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
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