SQL Server – Changing Ownership for All the User Databases to “sa” Account
Most people prefer to have “sa” account as the database owner, primary reason being sa login cannot be removed/deleted unlike any...
2015-05-05
387 reads
Blog Posts
SQL Server 2016 Preview this Year
Quick, short and sharp blog post for those interested in the latest and greatest that the SQL Server mothership has to offer… It was announced by the Microsoft CEO...
2015-05-05
4 reads
SQL Server 2016 Preview this Year
Quick, short and sharp blog post for those interested in the latest and greatest that the SQL Server mothership has...
2015-05-05
551 reads
SQL Server 2016 Preview...Coming this Summer
It was announced yesterday at the Ignite conference that we’ll be getting a summer preview of SQL Server 2016. With...
2015-05-05
678 reads
SQL Server Migration Plan
As a DBA , migration of database is a part of day to day activities. sometime its a quite hectic task...
2015-05-05
16,742 reads
SSRS Utility Reports: Subscription Inventory, Failed Subscriptions
When delivering a SQL Server Reporting Services (SSRS) solution with lots of subscriptions, it's helpful to also include some utility...
2015-05-05
1,305 reads
How to hide my SQL Server instance in network ? TIP #99
In TIP #70 we saw how to find all the running SQL SERVER instance in a network or a machine....
2015-05-04
668 reads
Make Sure to Schedule Your SQL Server Replication Jobs
You setup SQL Server Replication and everything looks fine. Rows are flowing between the servers and you think you’re done.
Right? Wrong..
At...
2015-05-04 (first published: 2015-04-22)
5,387 reads
Monday Morning SQL Break – May 4, 2015
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you don’t already, follow me on...
2015-05-04
731 reads
Ruminations on Writing Great T-SQL
Today we’re going to try to extend some advice that I once heard from SQL MVP Jeff Moden, which I...
2015-05-04 (first published: 2015-04-23)
9,230 reads
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers