SQL Saturday #90 OKC
This past Saturday, I made the relatively short (3 hour) drive north to Oklahoma City to participate in their first...
2011-08-29
829 reads
Blog Posts
SQL Saturday #90–Oklahoma City recap as chauffeur and speaker
I’d never been to Oklahoma City, and when Kristin Ferrier asked me to come to SQL Saturday #90 and do...
2011-08-29
922 reads
SQL Server Hardware Choices Made Easy
Redgate has released a free eBook that I wrote called SQL Server Hardware Choices Made Easy. This is basically a...
2011-08-29
1,968 reads
SSIS For Each Loop over files with Date in Name
A common request I have received over the years is to move or copy files from one directory to another...
2011-08-29
10,547 reads
The Basic Security Model in SQL Server – Skill #3
This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for...
2011-08-29
3,459 reads
Time Flies When You're Having Fun
I've done it; I've violated one of the rules I give to people who are interested in blogging: I went...
2011-08-29
767 reads
When to use T-SQL or SSIS for ETL
When doing ETL, you have the choice of using T-SQL or SSIS. What things should you consider when deciding which...
2011-08-29
10,256 reads
Answer to the Quiz
Hi Everybody,
Congratulation to Yair Gutman who won a free ticket to the Advanced Programming in SQL Server 2008 R2 Course...
2011-08-28
324 reads
How to write data from user-defined function
Writing data from within user-defined function is not permitted. You cannot use any INSERT/UPDATE/DELETE/MERGE statement because they’re “side-effecting” for SQL...
2011-08-28
1,239 reads
JAX Code Camp 2011 Review and Slide Deck
Yesterday, my wife (twitter: @sherrilmcdonald) and I spoke at JAX Code Camp 2011 in Jacksonville, Florida. The event was well...
2011-08-28
917 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