SQLServerCentral Article

IT Transparency

How can IT get along better with the rest of the business? Often a SQL Server DBA isn't in charge, but you can influence others and make everything work smoother with a little effort. Andy Warren gives you some tips and tricks that have worked well in the past.

SQLServerCentral Article

I've Got the XML - Now What?

Getting a result set of XML is the easy part, but what about exporting the data in a human readable format? Most DBAs don't
spend a lot of time formatting XML output, but it doesn't hurt to know how. New author David McKinney brings us a technique for generating an XML article and then using SSIS and XSL to transform it into an HTML page.

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