top of page
How to Update @@SERVERNAME to Actual Machine Name?
The @@SERVERNAME Global Variable The system global variable @@SERVERNAME can be used to return the name of the machine the SQL Server is...
Madeira Team
Dec 7, 20173 min read
Why is the job duration a negative number?
About a month ago I noticed, on one of our clients’ server, a weird duration time for one of the jobs – the job duration was negative. As...
Madeira Team
Dec 2, 20171 min read
How to Calculate Running Totals in SQL Server
In show #84 of the SQL Server Radio Hebrew Edition, Matan and I talked about how to calculate running totals in SQL Server. I promised to...
Madeira Team
Nov 19, 20172 min read
Customer Satisfaction Survey Results
In the last couple of months, we sent our first customer satisfaction survey to all our customers. We collected the responses, analyzed...
Madeira Team
Nov 19, 20173 min read
What is the Role of the UPDATE Lock in SQL Server?
The most common types of locks in SQL Server are the SHARED (S) lock and the EXCLUSIVE (X) lock. The former is used to lock resources...
Madeira Team
Nov 18, 20173 min read
Why I Believe in the Data Architecture Review
We have a solution called Data Architecture Review. With this solution, we conduct a complete review of the customer’s data environment....
Madeira Team
Oct 23, 20175 min read
Customer Satisfaction Survey
We decided to create a customer satisfaction survey and send it to all our customers. The goal of this post is to share the story about...
Madeira Team
Sep 1, 20174 min read
The 10 Basic Concepts of T-SQL
For the end of the latest Basic Querying and Programming in SQL Server course, I prepared a list of the basic concepts I recommend the...
Madeira Team
Aug 29, 20172 min read
Working with Very Large Tables
Recently I presented an online session with the title “Working with Very Large Tables Like a Pro in SQL Server 2016”. The session...
Madeira Team
Jul 26, 20171 min read
Great Minds Think Alike!
השנה Madeira Data Solutions חוגגת עשור! כמה מרגש לחשוב שלפני 10 שנים, ישב בחור צעיר, סביר להניח שבחדר חשוך 🙂 וחלם חלומות גדולים על...
Madeira Team
Jun 19, 20172 min read
bottom of page