-->
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.

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 really… Read more

0 comments, 121 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, 82 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,364 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, 272 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,814 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, 259 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, 291 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, 808 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,112 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, 159 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, 407 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, 180 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, 108 reads

Posted in Guy Glantser on 8 September 2016

Why Would I Want to Use JSON in SQL Server?

SQL Server 2016 offers built-in support for JSON, in a similar way to the support offered for XML since SQL Server 2000. Both XML and JSON are semi-structured data formats as opposed to the structured relational data format. SQL Server is an RDBMS, which stands for Relational Database Management System.… Read more

0 comments, 260 reads

Posted in Guy Glantser on 4 September 2016

Query Timeout of the Distribution Agent

Last week I got a call from one of our clients. They issued an ALTER TABLE command in order to change the data type of one of the columns from TINYINT to INT. This was a 17GB table, and it was part of a publication in a SQL Server transactional… Read more

0 comments, 116 reads

Posted in Guy Glantser on 22 August 2016

SQL Server 2016 Cumulative Update 1

On July 25th Microsoft released the first cumulative update (#1) for SQL Server 2016. This is a good reason to celebrate. Usually we are not as excited about cumulative updates as we are about service packs, but Microsoft has recently changed its incremental servicing model (ISM) for SQL Server,… Read more

0 comments, 167 reads

Posted in Guy Glantser on 4 August 2016

Who the Hell is Going to Listen to SQL Server on the Radio

About 3 years ago Matan Yungman contacted me and said he has an interesting proposition. We met and talked about all kinds of things, until I lost patience and asked him about his proposition. “What do you think about starting a podcast about SQL Server?” he said. The best response… Read more

0 comments, 121 reads

Posted in Guy Glantser on 21 July 2016

We Must Wait for SP1 before Upgrading to SQL Server 2016

This post is for T-SQL Tuesday, hosted by Michael Swart (blog | twitter). This month’s topic is all about SQL Server 2016

I’ve been working with SQL Server for almost 20 years, since version 6.5, when we used the SQL WWW Page Wizard to publish data on… Read more

2 comments, 113 reads

Posted in Guy Glantser on 14 June 2016

Why I Love SQLBits

Last week I attended SQLBits 2016 in Liverpool. I had such a great time, and I would like to share it with you. I arrived on Tuesday evening, so I had enough time to prepare for my session and get some rest. On Wednesday I presented a precon with the… Read more

0 comments, 82 reads

Posted in Guy Glantser on 8 May 2016

Why I Love SQLBits

Last week I attended SQLBits 2016 in Liverpool. I had such a great time, and I would like to share it with you. I arrived on Tuesday evening, so I had enough time to prepare for my session and get some rest. On Wednesday I presented a precon with the… Read more

0 comments, 1,015 reads

Posted in Guy Glantser on 8 May 2016

Older posts