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,154 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,446 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,753 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,080 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
840 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,569 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,254 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
850 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,288 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,987 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers