Planning to Increase Cost Threshold for Parallelism – Like a Smart Person!
Planning to Increase Cost Threshold for Parallelism
When administrating a SQL Server instance with multiple CPU cores and heavy workload, it’s...
2018-02-27
1,142 reads
Eitan Blumin
- Website: https://www.eitanblumin.com
How to fix Orphaned Users easily
What are Orphaned Users
“Orphaned Users” is a common issue in SQL Server where a Database User is no longer associated...
2018-01-11 (first published: 2018-01-03)
24,404 reads
How to Update @@SERVERNAME to Actual Machine Name?
The @@SERVERNAME Global Variable
The system global variable @@SERVERNAMEcan be used to return the name of the machine the SQL Server...
2017-12-19 (first published: 2017-12-07)
4,710 reads
DocumentDB Tutorial 2 – Working with Documents
Join Eitan Blumin in the next video of his DocumentDB Tutorials. This time learn how to work with the documents...
2016-02-18 (first published: 2016-02-11)
2,073 reads
Meet the Team- Eitan Blumin
When I was about 7 years old and got my first computer during the early nineties,
I said “This is...
2016-01-31
831 reads
Automatic Roll Forward Transaction Log Backups
Performing a transaction log backup every 15 minutes has its advantages. But it also has disadvantages. Ever tried to restore...
2015-09-03 (first published: 2015-08-25)
2,562 reads
Getting Started with Azure DocumentDB Programming
In my previous post in the series, I provided a short explanation on how to register your very first Azure...
2015-07-02 (first published: 2015-06-28)
2,240 reads
My First Azure DocumentDB Account
In my first post in the series, I provided a basic introduction to Microsoft’s new product: Azure DocumentDB, and how...
2015-06-22
839 reads
Introduction to Azure DocumentDB
This is a basic introductory post about Microsoft’s new product: Azure DocumentDB, and how it compares to SQL Server.
What is...
2015-05-11
1,276 reads
Let SQL Server Write Code for You
Introduction
Many times I happen to find myself in a situation where, as a DBA, I need to write some long...
2014-08-11 (first published: 2014-08-04)
10,977 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
Two queries work until compared with EXCEPT statement
I've got multiple databases on 2 SQL 2019 CU32 servers , all using the...
STRING_AGG DISTINCT
Has anyone written a wrapper function (or similar) around STRING_AGG() to allow the retrieval...
In-place OS upgrade or migration to new OS?
Putting this here as we're currently on SQL Server 2019 installed on Windows Server...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers