Back to the Future
Steve Jones asks this Friday if there is anything you wish you might have done differently.
Back to the Future
Steve Jones asks this Friday if there is anything you wish you might have done differently.
Back to the Future
Steve Jones asks this Friday if there is anything you wish you might have done differently.
Retrieve List of Databases and their Properties using PowerShell
I would like to translate some of the Transact-SQL scripts that I use every day, starting with the simple ones like retrieving a list of databases and their properties for auditing purposes.
TRY/CATCH - The Great Way to Handle Exceptions in SQL 2005/8
The goal of this post is to explain how to handle errors thanks to a useful T-SQL functionality, available since SQL 2005 onwards, that developers are already used to – and similar to how exceptions are handled in the Visual Studio environment.
Using the FOR XML Clause to Return Query Results as XML
The FOR XML clause in SQL Server causes a lot of difficulty, mainly because it is rather poorly explained in Books-on-Line. We challenged Bob Sheldon to make it seem simple. Here is his sublime response.
Roll Your Own Fuzzy Match / Grouping (Jaro Winkler) - T-SQL
Roll Your Own Fuzzy Match / Grouping (Jaro Winkler) - T-SQL
SQLSaturday #17 Call for Speakers
SQLSaturday #17 will be held Aug 1, 2009 in Baton Rouge, LA. Read more about it.
FILESTREAM Storage in SQL Server 2008
This white paper describes the FILESTREAM feature of SQL Server 2008, which allows storage of and efficient access to BLOB data using a combination of SQL Server 2008 and the NTFS file system. It covers choices for BLOB storage, configuring Windows and SQL Server for using FILESTREAM data, considerations for combining FILESTREAM with other features, and implementation details such as partitioning and performance.
Security Basics: Understanding the Surface Area
When it comes to securing a system, it's important to understand how it might be attacked. That's what surface area is all about. The surface area is the parts of the system which are exposed. For instance, in the case of a default instance of...
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