Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Guy Glantser

Guy Glantser is the CEO of Madeira SQL Server Services and the leader of the Israeli PASS chapter. His career has been focused on SQL Server for the past 17 years, performing various database roles as either an on-site DBA, an external consultant or an instructor. Guy is involved in many activities in the SQL Server community. He occasionally speaks at community events, such as Tech-Ed, product launches and user groups around the world. He also co-hosts the Israeli SQL Server radio show.

The Trouble with Rules

I love running. I wake up at 5am three times a week, run for an hour, and by 6:30am I’m ready to start the day. When I run, sometimes I listen to music, and sometimes I listen to TED Radio Hour. It’s a podcast based on TED talks. I… Read more

0 comments, 206 reads

Posted in Guy Glantser on 16 September 2015

Please Welcome Our New Certified SQL Server DBA’s!

Today we celebrated the last session of one of our Become a SQL Server DBA classes. This course takes people without any relevant experience, but with great skills and a lot of potential, and teaches them everything they need to know in order to become excellent SQL Server DBAs and… Read more

0 comments, 226 reads

Posted in Guy Glantser on 12 August 2015

I’m Speaking at PASS Summit 2015

It’s this time of the year again, when PASS announces the speakers in the biggest SQL Server event in the world – PASS Summit. Like many others, I submitted my abstracts a few months ago and waited with anticipation for the results.

And I’m so proud and excited to say… Read more

0 comments, 209 reads

Posted in Guy Glantser on 29 June 2015

Extended Events to the Rescue

On May 18 I presented a session about Extended Events as part of the Global Hebrew PASS Virtual Chapter. I explained what Extended Events is and why I think every DBA should use it. I showed several demonstrations of monitoring and troubleshooting use cases using Extended Events.

Although Microsoft announced… Read more

0 comments, 190 reads

Posted in Guy Glantser on 19 May 2015

Debug Managed Code and Stored Procedures Seamlessly

Visual Studio is a great tool for developers, and it offers so many great features, such as IntelliSense, unit testing and code analysis. One of the great and very useful features is debugging. It is possible to debug managed code and do things like adding breakpoints, stepping into modules and… Read more

0 comments, 5,137 reads

Posted in Guy Glantser on 6 May 2015

I am a Superhero

Two weeks ago I attended SQLBits in London. This is probably the biggest SQL Server conference in Europe, and this time there were around 1,700 attendees in a special edition of SQLBits – the Superheroes edition.

Between the various sessions and the exhibition hall, I met a lot of people… Read more

0 comments, 251 reads

Posted in Guy Glantser on 25 March 2015

SQLRally Nordic 2015

Last week I attended SQLRally Nordic 2015 in Copenhagen. SQLRally is a regional conference organized by PASS, kind of a mini PASS Summit, if you like. The event last week was 3 days long, and it was the biggest ever – close to 600 people.


I had a great… Read more

0 comments, 282 reads

Posted in Guy Glantser on 10 March 2015

Monitor Query Statistics

One of the most common tasks that DBAs are required to perform is monitoring. This is not just a task. Monitoring is a strategy, and a good DBA should have a well-defined plan for carrying out this strategy. But I’m not here to talk about monitoring as a whole. I… Read more

2 comments, 6,973 reads

Posted in Guy Glantser on 26 February 2015

SQL Saturday 360 in Israel

I had the pleasure to speak at SQL Saturday 360 in Israel. It was such a great event! We had two tracks, one for SQL Server and one for BI. There were more than 160 people who enjoyed free training, great food, networking and fun. There was even a beer… Read more

0 comments, 167 reads

Posted in Guy Glantser on 28 January 2015

I’m a SQL Server MVP!

I have been working with SQL Server for the past 17 years, and in the past few years I have been also very involved in the SQL Server community in Israel and around the world. I love SQL Server, and I also love the community around SQL Server, which is… Read more

0 comments, 184 reads

Posted in Guy Glantser on 12 January 2015

Parameterization Part 7: Summary

This is a summary of the parameterization blog post series. If you read the previous posts in the series, then this summary can be a good way for you to recap what you’ve learned. If you haven’t read the previous posts yet, then this summary can also serve as a… Read more

3 comments, 6,549 reads

Posted in Guy Glantser on 8 January 2015

SQL Server Developer Tips that Can Save Your XXX

Last week I had the honor to present a seminar at Expert Days 2014, which is an annual conference for developers organized by E4D Solutions. I suggested the title “SQL Server Developer Tips that Can Save Your Ass”, but the organizers didn’t like it, so they changed it to… Read more

0 comments, 349 reads

Posted in Guy Glantser on 16 December 2014

How to Handle Dynamic Rowsets

Sometimes you have a stored procedure that returns a rowset, and you need to insert the rowset into a temporary table in order to perform additional processing. That’s easy, right? You can simply create a temporary table and then use the INSERT-EXECUTE statement in order to insert the rowset into… Read more

2 comments, 508 reads

Posted in Guy Glantser on 4 December 2014

Parameterization Part 6: Simple vs. Forced Parameterization

This is the sixth post in the “Parameterization” series. In the previous posts I explained what parameterization is, how plan caching works in SQL Server, what parameter sniffing is, when it’s good and when it’s bad, and also some common mistakes related to parameterization and how to avoid them.

In… Read more

0 comments, 737 reads

Posted in Guy Glantser on 27 November 2014

Working with Very Large Tables Like a Pro in SQL Server 2014

I presented my session – Working with Very Large Tables Like a Pro in SQL Server 2014 – in PASS Summit 2014. The session was also presented live on PASStv. I was very excited and honored to speak in front of people of the SQL Server community from all over… Read more

2 comments, 509 reads

Posted in Guy Glantser on 8 November 2014

Be Careful! Backups Can Bite You!

Here is a riddle for you…

You are requested to move a database from an old server to a new server. As a professional and experienced DBA, you prepare a checklist of actions to take, you script everything, you document your plan, and, of course, you test it before doing… Read more

10 comments, 6,981 reads

Posted in Guy Glantser on 20 October 2014

Parameterization Part 5: Two Common Mistakes

This is the fifth post in my Parameterization series. In previous posts I wrote about parameter sniffing and when it is good or bad, and also about how to work around the problems associated with parameter sniffing when data is not uniformly distributed. In this post I would like… Read more

10 comments, 7,974 reads

Posted in Guy Glantser on 20 September 2014

DBA in the Cloud: Threat or Opportunity?

Five years ago the term “cloud” was still a buzzword, and there was a lot of uncertainty and misconception around it. I remember many DBAs, including myself, asking themselves what this revolution means for them. People asked themselves how a DBA role will look like in five years, or even… Read more

1 comments, 281 reads

Posted in Guy Glantser on 16 September 2014

Parameterization Part 4: Handling Non-Uniform Data Distribution

This is the fourth post in the “Parameterization” series. In the previous post I wrote about parameter sniffing, and I mentioned that this method can be a good thing in some cases, but it can also be quite a bad thing in other cases.

One case in which parameter sniffing… Read more

4 comments, 6,388 reads

Posted in Guy Glantser on 8 September 2014

Parameterization Part 3: Parameter Sniffing

This is the third post in the “Parameterization” series. In the previous post I mentioned parameter sniffing. This is a very important concept in SQL Server, and it certainly deserves a dedicated post. It’s time to dive into all the juicy details about parameter sniffing…

But first, let’s begin with… Read more

8 comments, 660 reads

Posted in Guy Glantser on 1 September 2014

Older posts