Take Advantage of Hard Times
With the economy in a downturn, Steve Jones talks about what you might want to do to be pro-active with your projects.
2009-04-20
75 reads
Articles
Giving Back
Steve Jones takes a minute today to congratulate Brian Knight and the Pragmatic Works Foundation for their efforts in giving back to the community.
2009-04-19
751 reads
Giving Back
Steve Jones takes a minute today to congratulate Brian Knight and the Pragmatic Works Foundation for their efforts in giving back to the community.
2009-04-19
474 reads
Giving Back
Steve Jones takes a minute today to congratulate Brian Knight and the Pragmatic Works Foundation for their efforts in giving back to the community.
2009-04-19
496 reads
Operating system Error 112
The error message pops up when you try to restore the database to a different server or to a desktop or to a FAT32 file system. Learn a couple of ways for dealing with this error.
2009-04-17
5,284 reads
Detach and attach Analysis Service Database using Windows PowerShell and SQL Server 2008 AMO
This installment of our series on " Microsoft Windows PowerShell and SQL Server 2008 AMO" examines the various types of Analysis service database detach and attach methods.
2009-04-17
2,192 reads
How To Read A PayPal Notification Email
Learn how to read information from a PayPal Notification email by using Microsoft Access, Outlook and VBA.
2009-04-17
3,025 reads
Networking = Business Cards
I've been writing a lot about networking lately and my efforts to learn/leverage LinkedIn, and along the way taken a few hits for opening up my Linked In network to include those of you who read my blog regularly and want to connect. The essence ...
2009-04-17
1,523 reads
Introduction to Profiler
This article introduces Profiler presenting what it is, how to use it, and why you might want to use it.
2009-04-16
10,949 reads
Setting Up a Publisher - SQL School Video
Replication can be a complicated undertaking for many people. Learn how to get started by creating a publisher in this SQL School video from MVP Andy Warren.
2009-04-16
2,596 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