September 11 - Never Forget - My story of the tragic day..........
I was sitting going through some of my materials, scripts, emails and news feeds to find a worthy topic for...
2009-09-10
1,320 reads
I was sitting going through some of my materials, scripts, emails and news feeds to find a worthy topic for...
2009-09-10
1,320 reads
Labor Day, which marks the unoffical end of Summer in the U.S., is particularly poignant in light of the news...
2009-09-08
845 reads
Job Market Update and some Job Search Advice…..
Not too long ago, I posted a blog on the possible thawing of...
2009-09-04
1,404 reads
Compression is one of the major features introduced in SQL Server 2008, and one that can significantly reduce disk storage. ...
2009-08-31
9,469 reads
Now that the kids have interest in computers, I sometimes find myself competing with them. I recently purchased a business class...
2009-08-29
1,355 reads
Database Mirroring w/o a Domain, Can be a Pain - but it can be done......
Have you ever had to setup mirroring...
2009-08-25
6,436 reads
As I was going through some of my documentation at past clients, I found my summary of the general SOX...
2009-08-23
2,455 reads
Yesterday, I blogged about basic I/O usage with some useful scripts, DMVs, and links to more in-depth details on examining...
2009-08-19
1,630 reads
I/O I/O - It's why my server's slow.....
Often I've been curious about ways to measure the performance of SQL Server, and...
2009-08-18
4,609 reads
The Fisherman and the "C" ("City")
Ok, I know when most think about NYC, they think latte-sipping wall-street yuppie (I'm...
2009-08-16
560 reads
By James Serra
My previous blog post on this topic was Introduction to OpenAI and LLMs, the...
This one is an oldie in my blog drafts, but a goodie! So, I...
Summer is here, and it's the perfect opportunity to enhance your SQL expertise with...
I've used this function before and I'm sorry I do not recall it's origination. ...
Hello experts, I'm trying to disable (0) Ole Automation Procedures via sp_configure. But each...
Hello, all We have several performance issues, which I think could be mitigated by...
I created this trigger in SQL Server 2022:
CREATE TRIGGER checksteve ON ALL SERVER FOR LOGON AS BEGIN IF ORIGINAL_LOGIN()= N'ARISTOTLE\Steve' PRINT 'Steve logged in' END; GOWhere can I view "Steve logged in"? See possible answers