August 2012 S3OLV Meeting
Well well well. It has certainly been a long time between announcements on the blog about meetings for the Las Vegas SQL Server Users Group. We have had to...
2012-07-30
5 reads
Blog Posts
August 2012 S3OLV Meeting
Well well well. It has certainly been a long time between announcements on the blog about meetings for the Las...
2012-07-30
1,595 reads
PASS Is Hiring Another Evangelist–Could It Be You?
Just about a year ago PASS hired Karla Landrum to fill the vacancy of the Community Evangelist and that marked...
2012-07-30 (first published: 2012-07-25)
999 reads
SQL Server Orphanage – Using sp_change_users_login to find and fix all orphaned SQL users
Every wonder who all your orphaned SQL Server users are on your server? Just run the script below and copy...
2012-07-30
1,426 reads
SQLSaturday #171 Pittsburgh Prep Continues
Hey, did I mention that Pittsburgh is having a SQLSaturday this year?
Pittsburgh, Pennsylvania. Photo:Herbert Spencer, used under Creative Commons...
2012-07-30
1,558 reads
Stop Storing Unencrypted Passwords!
I was called over today by a person doing application support to help troubleshoot a database connectivity issue. This isn't a...
2012-07-30 (first published: 2012-07-26)
2,746 reads
Syncing your contacts
In the same vein as my blog post about Syncing your calendars, I wanted to post how to sync your contacts...
2012-07-30
1,978 reads
Video Enable PowerPivot Add-in
This is one of our first PowerPivot video tutorials and this short 1 minute tutorial we show how to enable...
2012-07-30
1,628 reads
How to move master and resource system databases?
I received an phone call from a friend today asking how to move master and resource system databases in Microsoft...
2012-07-29
6,875 reads
The effects of an SSD on SQL Server Performance
I. Introduction A little while ago, my wonderful wife Renee got a Solid State Drive (SSD) for me. Being a...
2012-07-29
5,685 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