SQL Vulnerability Assessment
Vulnerability assessment is probably one of the most underrated new security features in SSMS 17. This feature is not new...
2018-05-21
135 reads
Blog Posts
SQLpassion Online Trainings in June 2018
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-05-21
359 reads
Tactics to Find Outdated Statistics in SQL Server
Statistics in SQL Server are used to identify the type of plan that needs to be executed for a query. SQL Server is pretty good in estimating the statistics....
2018-05-21
13 reads
Tactics to Find Outdated Statistics in SQL Server
Statistics in SQL Server are used to identify the type of plan that needs to be executed for a query....
2018-05-21
2,100 reads
What are the system databases?
I get to help with technical interviews every now and again, and one of the questions we always ask is...
2018-05-21
513 reads
Why PASS?
In case this is your first time hearing of it, PASS is the single largest community of Microsoft Data Platform...
2018-05-21
713 reads
C# – Read emails from exchange online mailbox (Office 365) into SQL Server
You have an Office 365 mailbox. You want to use C# to read those mails and save them to SQLServer.
The...
2018-05-20
1,768 reads
SQL Server Error Handling In Depth
TRY/CATCH RAISERROR Pre SQL Server 2012 Since SQL Server 2005 we’ve had TRY CATCH syntax in SQL Server handle errors....
2018-05-20
98 reads
SQL Server Error Handling In Depth
TRY/CATCH RAISERROR Pre SQL Server 2012
Since SQL Server 2005 we’ve had TRY CATCH syntax in SQL Server handle errors. If...
2018-05-20
123 reads
Thanks for joining us at SQLSat Dallas!
Engaged crowds and great questions at both my morning sessions on Saturday morning at SQLSat Dallas, an event put together by a team of expert SQLSat organizers, including SQL...
2018-05-20
7 reads
Blogs
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...
PowerShell Newbie – Variables
By gbargsley
This is Week 2 of PowerShell Strikes Back – a four-week May series for...
Forums
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
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
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