SQLServerCentral Article

Revenge of the BLOB

Working with large images or other BLOB data can be a challenge for many DBAs. Andrew Sears brings us some code that can help you extract some of that data out of BLOBs and get it back into a more easy-to-work-with format.

Technical Article

Object Dependencies in SQL Server

In this video, Randy Dyess shows you how important SQL Server dependencies are and some of the faults with SQL Server 2005 with these. For example, SQL Server will allow you to create a stored procedure that points to a table that doesn't exist. He also shows you how this problem has been corrected in SQL Server 2008.

Blogs

Walking Through a Planned Failover: SQL Server Availability Groups on Kubernetes

By

When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...

Reading SQL Server File Headers with DBCC FILEHEADER

By

I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...

T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP

By

Thanks to everyone who joined the blog party this month. I noticed three themes...

Read the latest Blogs

Forums

The Vector Data Type

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Vector Data Type

What Power BI DirectQuery does to your SQL Server (and how to fix it)

By kat.korson@redeagle.tech

Comments posted to this topic are about the item What Power BI DirectQuery does...

The New OS Wars

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The New OS Wars

Visit the forum

Question of the Day

The Vector Data Type

What is the vector data type in SQL Server?

See possible answers