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,704 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
370 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,329 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,368 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,341 reads
Blogs
A New Word: Ghough
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
T-SQL Tuesday: Encryption and Data Protection
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Parameterize your Databricks notebooks with widgets
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
Forums
Need to output table data into multiple CSV files
Hello, I created the below script to output 999 rows from SQL Server table...
Changing Database page Verify on a Database in an AG
I have a database on SQL 2019 in an Availability Group (AG) and I...
Alwyason availability group can set primary role permanently?
Hi. Two node windows clusters Node1 and Node2 and configured alwayson availability group. Will...
Ask SSC