Generate RPC:Completed Event
I was doing a research on SQL trace regarding RPC:Completed event. So I need to generate a RPC:Completed event first...
2007-11-14
1,731 reads
DBA Philosophy
save disk when doing backup
As a DBA, most of us will also take care of test environment. However test servers usually cannot afford to...
2007-11-11
376 reads
Let database work for your daily life
I know there are many off-shelf stuff, like MS Money, that can help you organize your personal financial things, but...
2005-09-11
1,337 reads
about xp_sendmail
I got a very interesting issue, I may guess the reason but not sure why it is this way.
Symptom: Logon to...
2005-09-09
1,374 reads
one issue about SQL 2000 BOL
This is my first post, congrats to myself. 🙂
DTS Connection object does not list "UseTrustedConnection" property
I am working on a...
2005-09-08
1,346 reads
Blogs
Happy Thanksgiving! (USA Holiday)
By Brian Kelley
In the United States, today is Thanksgiving. The intent behind the holiday is to...
Getting SQL Server 2025 RTM Running in Containers on macOS
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you...
The PASS Data Community Summit 2025 Recap
By Steve Jones
It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m...
Forums
SQl Server 2014 linked server remote server
Hello all, I have a linked server created on an instance which only has...
Find all the tables in a database containing particular column value
Hi, I want to find all the tables name under a database where tables...
The Ending Substring
Comments posted to this topic are about the item The Ending Substring
Question of the Day
The Ending Substring
In Azure SQL Database and SQL Server 2025, if I run this, what is returned?
SELECT '[' + SUBSTRING('Steve Jones', 7) + ']' See possible answers