Use SQL 2008 Express As A Central Management Server
I had the chance to catch Brent Ozar's webcast last week on creating a poor man's CMDB. In it he...
2009-04-20
891 reads
Kendal Van Dyke
Full Text Catalog Scripting "Gotcha" in SSMS 2008
With every new version of SQL Server comes a set of deprecated features. Usually Microsoft gives fair warning that these...
2009-04-15
582 reads
Undocumented Trace Flag Improves Performance By Up To 25%
As a production DBA I love to tweak things to optimal perfection. After all, if I paid for the hardware...
2009-04-01
539 reads
Orlando .NET Code Camp 2009 Recap
On Saturday, 3/28, I presented Useful T-SQL Statements You May Not Be Aware Of at the 2009 Orlando .NET Code...
2009-03-31
1,436 reads
Launch Replication Monitor Without SSMS
I manage a lot of replication publications\subscriptions and when I get a latency or agent failure alert it always bugs...
2009-03-25
847 reads
Ada Lovelace Day – Celebrating Women In Technology
Today is Ada Lovelace Day, an international day of blogging to draw attention to women excelling in technology. I don't...
2009-03-24
740 reads
Data Mining With Google Insights For Search
I recently read a NYT article that highlighted how Google search data is being used to predict flu outbreaks at...
2009-03-23
848 reads
Upcoming Speaking Engagements
I've got three speaking engagements lined up in next two months:
Wed, March 11 @ oPASS: The Truth About Disk Performance & Configuration....
2009-02-26
1,407 reads
Blogs
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
Forums
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
The Distance Metric
Comments posted to this topic are about the item The Distance Metric
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers