Tinkering with a local queue
I've been toying with the idea of using a file as a queue instead of a database table for use with my Enhanced Threading Framework. This has been challenging...
2010-07-06
2 reads
Blog Posts
Tinkering with a local queue
I've been toying with the idea of using a file as a queue instead of a database table for use with my Enhanced Threading Framework. This has been challenging...
2010-07-06
5 reads
Upcoming Speaking Engagements
I have few speaking engagements this month that I want to let you know about:
Thursday, July 8 6:00 PM PST...
2010-07-06
592 reads
Webcast Today – Performance Impacts Related to Different Function Types
I’ll be speaking for the SQL PASSPerformance Virtual Chapter later today starting at 12 PM Eastern time. The topic will...
2010-07-06
445 reads
Degree Seeker Week at SQL University, Lesson 1
Degree Seeker Week at SQL University, Lesson 1
Welcome eager learners to Lesson 1 of Degree Seeker Week at SQL University....
2010-07-05
2,626 reads
Making a Little Effort at Networking - Part 2
I wrote recently about my efforts to network a bit more at events. Part 1 was to spend more time...
2010-07-05
316 reads
Bin the unwanted to reap the rewards !
Looking through some of my databases this past week, theres a lot of data there which over time has become...
2010-07-04
433 reads
Mix & Match – Day 1
I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have...
2010-07-04
493 reads
T-SQL Tuesday #008: Gettin’ Schooled
T-SQL Tuesday #008: Gettin’ Schooled
“Thank you fans and friends & odds and ends. And now for you gals and guys, a...
2010-07-04
9,227 reads
A Special Belated Happy Canada Day to Leader of the Official Opposition
Dearest Michael Ignatieff, Leader of the Liberal Party of Canada, Official Leader of the Opposition,
First of all, 'appy appy Birthday...
2010-07-03
1,309 reads
Blogs
macOS Tahoe breaks SQL Server on Docker containers on Apple silicon
The honeymoon is over, and macOS 26 Tahoe broke the Rosetta 2 emulation layer...
From Firefighting to Future‑Building: SQL Server 2025 and the New DataOps Mindset
By Chris Yates
There are moments in technology when the ground shifts beneath our feet. Moments when...
Why Developers Shouldn’t Have sysadmin access in SQL Server
Why Developers Shouldn’t Have sysadmin access in SQL Server 7 reasons—and exactly what to do instead It...
Forums
sp_prepare and sp_execute vs sp_executesql
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
Find Invalid Objects in SQL Server
Comments posted to this topic are about the item Find Invalid Objects in SQL...
Question of the Day
Who am I?
If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?
create procedure AddNewCustomer
@customername varchar(200)
AS
BEGIN
DECLARE @added VARCHAR(100)
SELECT @added = xxx
IF @customername IS NOT NULL
INSERT dbo.Customer
(
CustomerName,
AddedBy
)
VALUES
(@customername, @added)
END See possible answers