SQL Server Object Dependency Viewer Revisited
A year ago I blogged about building a SQL Server 2008 Object Dependency Viewer based on a script by PowerShell...
2010-08-07
1,682 reads
Chad Miller
Quickly Script Out Replication Redux
Dave Levy (Blog|Twitter) posted a script in a blog post in which he uses a bit of SQL PowerShell Extensions (SQLPSX)...
2010-08-03
1,402 reads
Making A SQLPS Module
If you’re working with PowerShell and SQL Server one of things you’ll want to to do is load the SQL...
2010-07-10
3,250 reads
Windows Search Enable Your Script Files
At the July 8th Tampa PowerShell User Group meeting, Ed Wilson (blog|twitter) gave a presentation on “PowerShell Best Practices.” One...
2010-07-10
653 reads
Scripting Linked Servers
A co-worked asked me to look at a T-SQL script I had written 8 years ago for scripting out linked...
2010-07-06
3,095 reads
Building A Remote Desktop Manager Cluster List
The Microsoft Clustering and High Availablity bloggers have taken noticed of the Remote Desktop Connection Manager (RDCMan) utility from a...
2010-06-30
1,608 reads
PowerShell ETL Presentation
My thanks to everyone in attendence and PASS AppDev VC for inviting me to speak. I’ll post a link to...
2010-06-23
986 reads
Live Meeting Presentation – ETL with PowerShell
On Tuesday June 22nd 9 PM Eastern I”m presenting ETL with PowerShell for PASS AppDev VC—a virtual chapter of Professional...
2010-06-20
1,026 reads
Building A Remote Desktop Manager Connection List
Remote Desktop Connection Manager or RDCMan is a free download from Microsoft for managing multiple remote desktop connections. The functionality...
2010-06-15
2,298 reads
SQLIse A PowerShell SQL Server Query Tools Gets an Update
After the first release of SQLIse (“SQL Ice”)--a basic IDE for T-SQL that includes ability to edit, execute, parse, format...
2010-06-04
1,588 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