The Pros and Cons of Stored Procedures
I saw this mentioned on Twitter, and watched it while doing some light editing and scheduling. It’s from TechEd 2009...
2009-05-20
4,899 reads
Blog Posts
DBA's Delight
Tto the beat of “Rapper’s Delight”
“Now what you hear is not a parse
I'm rapping to the code
'cause me, my tweeps,...
2009-05-19
1,525 reads
Denver SQL Server User's Group
I'm planning on attending the Thur meeting of the Denver SQL Server Users's Group this Thursday, May 21, 2009. If...
2009-05-19
1,134 reads
PASS Connector Editorial for May 6, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-05-19
744 reads
Sick? Stay home!
Yesterday I did something I wouldn't have thought of doing a year ago: I stayed home. When I woke up,...
2009-05-19
854 reads
Sometimes, code comments are informative and helpful
... and other times, they are stop-you-in-your-tracks funny. Here's an example of the latter:
http://msmvps.com/blogs/brianmadsen/archive/2009/04/21/funniest-code-comment-ever.aspx
2009-05-19
714 reads
SQLSaturday Orlando Planning Meeting on May 23, 2009
We'll be meeting at Chipotle in Altamonte Springs on May 23, 2009 at 11:30 am to discuss plans for the...
2009-05-19
557 reads
Transaction isolation level
Transaction isolation level:1. Uncommitted Read (NoLock)2. Committed Read (blocking)3. Repeatable Read (phantom)4. Snapshot (no blocking)5. Serializable (no blocking)Dirty Read:(DR)Non Repeatable Read:(NRR)Phantom:(P)Great...
2009-05-19
1,153 reads
Finding a New Laptop Bag
For the past couple years I've been using a Targus (I think the model 300 right now) and they've been...
2009-05-18
892 reads
Larger & Cheap(er?) Monitors
I stopped by Compusa on the way home to pick up a package of blank DVD's and did the 10...
2009-05-18
783 reads
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers