Stored Procedure to Get SQL Job Execution Status
Introduction
Ever need a programmatic way to figure out if a SQL Agent job is running? I did. After spending a...
2010-01-31
2,520 reads
Blog Posts
SEO my SQL Server Blog
I was going to spend today finishing off some SQL Server related blog posts, I currently have a list of...
2010-01-30
1,645 reads
Try Catch within an SSIS Script Tasks and Components
Using a Try/Catch/Finally within your Script Components and Script Tasks is just good coding practice. The thing you want to be able to do is push...
2010-01-30
2,561 reads
Book Review: The Breach
The Breach by Patrick Lee ($8 at Amazon) was a gift, and wasn’t quite what I expected based on the...
2010-01-29
1,428 reads
But We Have Always Done It That Way
I recently ran across the following scenario. A SQL Server instance had been upgraded from SQL Server 2005 to SQL...
2010-01-29
1,974 reads
Columbia Code Camp 2010
We're making a final push to let everyone know about the Columbia Code Camp 2010, which happens tomorrow, January 30....
2010-01-29
1,481 reads
Introduction: Developing with SQL Server
As a developer based primarily in the Microsoft world I have over the last 10 years spent time working with...
2010-01-29
1,316 reads
Paul Randal’s Benchmarking Series
Fellow SQL MVP Paul Randal of SQLSkills, (who is also Kimberly Tripp’s husband, and a former long-time Microsoft employee) has...
2010-01-29
2,745 reads
SQLSaturday #30 Rescheduled
Got the email today, SQLSaturday #30 has been rescheduled for April 10, 2010, due to projected bad weather on the...
2010-01-29
1,366 reads
SQLSaturday #41 Announced
Stuart Ainsworth will be coordinating the second SQLSaturday in Atlanta, this time on April 24th, 2010. Registration and call for...
2010-01-29
1,874 reads
Blogs
SQL Saturday Boston Slides and Code
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
Scaling SQL Server 2025 Vector Search with Load-Balanced Ollama Embeddings
SQL Server 2025 introduces native support for vector data types and external AI models....
Advice I Like: Fear and Imagination
By Steve Jones
Fear is fueled by a lack of imagination. The antidote to fear is not...
Forums
How to Use SQL Server Features to Cut Web App Latency in Half
Comments posted to this topic are about the item How to Use SQL Server...
Choosing an AI in Sept 2025
Comments posted to this topic are about the item Choosing an AI in Sept...
The New SQL Server 2025 Data type
Comments posted to this topic are about the item The New SQL Server 2025...
Question of the Day
The New SQL Server 2025 Data type
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers