-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guy Glantser

Guy Glantser, Data Platform MVP, is the leader of the Israeli PASS chapter and also the CEO and founder of Madeira Data Solutions. His career has been focused on the Microsoft Data Platform for the past 20 years, performing various database roles as either an on-site DBA, an external consultant or a speaker. Guy is involved in many activities in the Microsoft Data Platform community. He occasionally speaks at community events, such as PASS Summit, SQLBits, SQL Saturdays and user groups around the world. He also co-hosts the SQL Server Radio podcast.

How to Size Your Database Files?

Let’s say you need to create a new SQL Server database, which is going to grow very fast, but you don’t know how fast. What would be the initial size of the data file?

 

On one hand, you want to make it as large as possible in order to… Read more

0 comments, 196 reads

Posted in Guy Glantser on 8 January 2018

What is Graph Processing in SQL Server 2017?

There is a growing need for Graph Databases in the market. This is a type of database, which is capable of storing, representing and manipulating graphs easily and efficiently. Common use cases for using Graph Databases are social networks and network topologies. In a Graph Database, there are nodes (e.g.… Read more

0 comments, 200 reads

Posted in Guy Glantser on 8 January 2018

What is the Automatic Plan Correction in SQL Server 2017?

SQL Server 2017 brings a new interesting feature, that might be a game changer in some environments. I’m talking about Automatic Plan Correction. This feature automates the on-going tuning process of identifying regressed execution plans and then replacing them with the last known good plan. Let me explain…

 

One… Read more

0 comments, 187 reads

Posted in Guy Glantser on 25 December 2017

SQL Saturday Nepal 2017

 

I had the honor to visit Nepal and participate in SQL Saturday Nepal 2017. You can visit the event website here. I presented a session about “How to Use Parameters Like a Pro and Boost Performance”. From my experience, one of the common reasons for poor performance is… Read more

0 comments, 238 reads

Posted in Guy Glantser on 23 December 2017

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 upload a script with a complete demo of all the possible methods. So here it is.

 

 

The script first… Read more

0 comments, 2,446 reads

Posted in Guy Glantser on 19 November 2017

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 them, and derived some interesting conclusions too. It’s time to share the results!

 

First, the response rate was 16%. We tried to increase the response rate… Read more

0 comments, 197 reads

Posted in Guy Glantser on 18 November 2017

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 (e.g. rows, keys, tables) for read, and the latter is used to lock resources for write operations. The first is called SHARED, because multiple… Read more

1 comments, 248 reads

Posted in Guy Glantser on 18 November 2017

Something Cool We Learned Today!

 

We have many customers, and we work on lots of projects. Each project is different in so many ways: the business environment, the system architecture, the data platform, the people, the challenges…
This is why we get to learn so many new things on a daily basis, which is… Read more

0 comments, 216 reads

Posted in Guy Glantser on 16 November 2017

Can I pause or resume an index rebuild operation?

One of the cool new features in SQL Server 2017 (and currently also in public preview in Azure SQL Database) is the option to pause and resume an online index rebuild operation.

This option can be useful for several use cases. Imagine you have a very large index, which takes… Read more

0 comments, 336 reads

Posted in Guy Glantser on 16 November 2017

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. We collect a lot of data from the servers, analyze it, and produce a list of recommendations.

 

In most cases, this is the entry point… Read more

0 comments, 1,437 reads

Posted in Guy Glantser on 23 October 2017

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 our journey – why we decided to do that, and how we did it…

 

One of our core values is service. We… Read more

0 comments, 306 reads

Posted in Guy Glantser on 1 September 2017

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 was hosted in the PASS Database Administration Virtual Group. You might be surprised, but I was talking about how to work with very large tables… Read more

0 comments, 2,890 reads

Posted in Guy Glantser on 26 July 2017

What Do You Do When Performance Sucks?

 

So you are a SQL Server DBA, and you are responsible for a database, which gives you a hard time. Users constantly complain about poor performance, and the developers blame the database (what else?). It’s time to dig in and do some serious performance tuning once and for all.… Read more

0 comments, 291 reads

Posted in Guy Glantser on 16 May 2017

My Session about SQL Server Parameterization

 

Last month I presented a session in the wonderful GroupBy online conference about SQL Server parameterization. The title of the session was “How to Use Parameters Like a Pro and Boost Performance”.

 

Here is the abstract:

 

“Parameters are a fundamental part of T-SQL programming, whether they are… Read more

2 comments, 318 reads

Posted in Guy Glantser on 10 May 2017

Availability Group on SQL Server 2016

The Challenge

One of our clients in the gaming industry wanted to set up a high availability solution in their data center in the UK. They had a single standalone SQL Server 2014 instance (Enterprise Edition) running on Windows Server 2012 R2, and they wanted to make sure that if… Read more

3 comments, 869 reads

Posted in Guy Glantser on 1 February 2017

DATEDIFF vs. DATEADD

Let’s talk about the DATEDIFF vs. DATEADD functions in SQL Server. Each one performs a different task. The former calculates the differences between two given date & time values based on some date part (day, minute, second, etc.). The latter calculates a date & time value by adding a number… Read more

0 comments, 1,171 reads

Posted in Guy Glantser on 25 January 2017

SQL Server DBA Tips that Can Save Your Ass

On November 9th I presented a session in the PASS Database Administration Virtual Chapter. The title of the session was “SQL Server DBA Tips that Can Save Your Ass”. Sharon Dooley, the virtual chapter leader, kindly modified the last word to “A$$”, but the important thing is what’s… Read more

0 comments, 184 reads

Posted in Guy Glantser on 12 December 2016

A Recap of PASS Summit 2016

Yes, it’s that time of the year again. It’s time for the annual PASS Summit. Just like every year, I had the pleasure of attending Summit – as a data professional, as a speaker and as a volunteer. As always, it was a pleasure. You’ll be surprised to hear that… Read more

0 comments, 450 reads

Posted in Guy Glantser on 31 October 2016

Machine Learning – What is It Good For?

Machine Learning is a very powerful technology used in the field of predictive analytics. As far as I see it, Machine Learning is magic. The idea behind it is quite simple: instead of developing a program that will analyze historical data and predict future behavior, let the machine do it.… Read more

0 comments, 197 reads

Posted in Guy Glantser on 20 October 2016

Recap of My 24HOP Session – From XML to JSON

Yesterday I presented my session From XML to JSON as part of the 24 Hours of PASS online event. There were around 200 attendees in my session. If you are one of them, then thank you for attending my session, and I hope you enjoyed it as much as I… Read more

0 comments, 122 reads

Posted in Guy Glantser on 8 September 2016

Older posts