Remember OBJECTPROPERTY(..) when investigating objects.
The object property function appears to be often overlooked.
This function will tell us about any schema scoped object in the...
2011-01-20
1,299 reads
Blog Posts
SSMSDeploy 1.1 Now Available
Fixed a couple of issues and made some GUI tweaks. Please see the download page for the latest version, and...
2011-01-20
710 reads
Tips & Tricks for DBAs Writing Their First Article
I have been writing full or part-time for nearly 30 years, and I have written and edited hundreds of articles....
2011-01-20
1,361 reads
31 Days of SSIS – SQL Server Configuration (18/31)
31 Days of SSIS
The last post in the 31 Days of SSIS talked about the use of environmental variables. As...
2011-01-19
2,205 reads
How to find the SQL server port number
Advertisements
One day I got a call from my junior DBA. She asked me, how can I find out the port...
2011-01-19
574 reads
New Book: Introduction to SQL Server
Last year, Kevin Kline (blog | twitter) introduced me to Oracle and database expert, Bert Scalzo. Bert was looking to take...
2011-01-19
595 reads
New PASS Chapter in Orlando–MagicPASS
Kendal Van Dyke is launching a new PASS Chapter called MagicPASS in Orlando this week, with the first meeting on...
2011-01-19
681 reads
SSMSDeploy Now Available!
I have finished my website, done all my recompilations, checked all my settings, and finally SSMSDeploy is on the internet,...
2011-01-19
601 reads
Time To Get Your #SQLRally Vote On!
It’s week two of voting for the upcoming SQLRally. This week, we are voting for the Database & Application Development sessions...
2011-01-19
452 reads
Un-SQL Friday: Your Tech Giants
This started as just a regular blog…but it’s sparked such a big conversation online, I’ve decided to make it an...
2011-01-19
1,079 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers