Resources for Upgrading to SQL Server 2008
Use these resources as aids in upgrading to SQL Server 2008. These references are from the downloadable white paper:
Recharged on the 4th of July
After a week of vacation, Steve Jones feels recharged and ready to head back to work. Today we celebrate the holiday with a blooper reel.
Recharged on the 4th of July
After a week of vacation, Steve Jones feels recharged and ready to head back to work. Today we celebrate the holiday with a blooper reel.
A Generic Process to Convert XML Data - Part 1
Longtime author Leo Peysakhovich brings us a new series on converting XML data into regular data. This article examines validating the XML data against a schema.
The Independence Day Ruckus
Steve is away this Fourth of July, so we asked Brian Donahue, head of the Red Gate product support team, and an American "exiled" in the UK, to reflect on what Independence Day means to him.
Paying for Content - SQL Server Knowledge
Someone asked me recently if I subscribed to any services to keep up with SQL Server content. Meaning did I "pay" for content. I said "no" at first, but wanted to follow up with more details. Since this was across Twitter , 140 characters...
Remote BLOB Store Provider Library Implementation Specification
This is a specification to be used by those creating a storage provider plug-in library for the SQL Server 2008 Remote BLOB Store feature.
Taking Advantage of Sample Reporting Services Reports
Recent installments of our series dedicated to SQL Server 2005 Express Edition have discussed the Reporting Services component. This article provides an overview of sample reports that you can take advantage of in order to familiarize yourself with the more advanced graphical designer features present in SQL Server 2005 Express Edition-based Reporting Services.
Configuring SQL Agent Operators - SQL School Video
Operators in SQL Server work hand in hand to ensure that alerts are sent to the proper person. MVP Andy Warren shows how to set these up in this SQL School video.
Oracle for the SQL Server Guy - Instances and Databases
Many DBAs need to work with multiple platforms. New author Jagan Kumar brings us an article that helps to explain Oracle's architecture for those people used to working with SQL Server.
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