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,734 reads
Trigger Trivia Posted on SSC
A short article but interesting I think, with some good comments already. I think in general triggers are under used,...
2007-11-13
583 reads
A Couple Days With Joe Celko
We were lucky enough to have Joe come to Orlando to speak at SQLSaturday and we also talked him into...
2007-11-12
808 reads
SQLSaturday Orlando 2007 Wrap Up
I'm just finishing up sending out thank you emails to the volunteers, speakers, and sponsors that helped make our first...
2007-11-12
611 reads
Veterans' Day
I'll post Part III of Becoming a DBA tomorrow (meaning there will be two posts). Veterans' Day is typically celebrated...
2007-11-12
618 reads
Session Eval Results for my PASS 2007 Presentation
One of the things I discuss in my Successful Technical Speaking class (it's a
free class, usually once a quarter)...
2007-11-12
611 reads
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
387 reads
Resources: SQL Server 2005 Security
Work responsibilities took up my time on Thursday and Friday, so I never got around to posting. Here's the resources...
2007-11-11
623 reads
bcp Utility
There was a time that I avoided bcp utility like the plague. A few years ago, we needed to set...
2007-11-09
636 reads
Celko on SQL Seminar Orlando - It's Time!
We (End to End Training) will be hosting our Celko on SQL seminar tomorrow (Nov 9th). It's not too late...
2007-11-07
689 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Kontak BCA KCP Semanggi Telp:08218154392
WA CS (08218154392) Wisma GKBI, Jl. Jenderal Sudirman No.28 Suite G 01, RT.14/RW.1, Bend....
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers