MSSQLFUN

Blog Post

Happy Anniversary!

Today, http://mssqlfun.com/ completed 2 precious years with your support & acknowledgment. It’s wonderful time enriched with fun & learning.
Please keep liking us...

2014-06-12

758 reads

Blogs

Denver Dev Day – Best Practices for Database Deployments Resources

By

I delivered a talk today on database deployment best practices at the Denver Dev...

A New Word: desanté

By

desanté – n. the brooding delirium of being sick, which makes time slow to...

What happens when we drop a column on a SQL Server table? Where's my space?

By

This article was initially posted on SQLServerCentral @ 2024-04-26. Short answer: The column is marked...

Read the latest Blogs

Forums

Advice: how to script out existing Azure (logical) SQL Server logins

By Stteb

Advice on how to script out existing Azure (logical) SQL Server logins and mapped...

Abort Package after specified timeout project parameter

By Dave

Hi I have a sequence container which contains an execute package task which loads...

JSON escape characters

By Jo Pattyn

Hello, I'm tasked to generate JSON files with the FOR JSON Clause of SQL...

Visit the forum

Question of the Day

Adding Hints with Query Store

I have a query that is being tracked in the SQL Server 2022 Query Store. I want to add a hint to this query to ensure that the MAXDOP for this query is one. How can I do this with minimal code changes

See possible answers