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.

Partition to Filegroup Mapping in SQL Server

Suppose you have a partition function and a corresponding partition scheme in SQL Server. The partition scheme maps each partition to a filegroup. It also indicates the next used filegroup if one was specified. Sometimes it is useful to know which partition maps to which filegroup as well as which… Read more

0 comments, 2,253 reads

Posted in Guy Glantser on 25 April 2016

How to Use Parameters Like a Pro and Boost Performance

Yesterday I presented my favorite session “How to Use Parameters Like a Pro and Boost Performance” in the DBA Fundamentals PASS Virtual Chapter. I love this session, because it’s based on my experience with so many clients in so many cases. I see the same mistakes that developers do… Read more

0 comments, 188 reads

Posted in Guy Glantser on 1 March 2016

From XML to JSON – script

Last Thursday I presented my session “From XML to JSON” in the Application Development PASS Virtual Chapter. The session is about XML and JSON, two widely used markup languages, shared by many applications and data platforms. XML has been natively supported in SQL Server since 2005, and JSON is… Read more

0 comments, 389 reads

Posted in Guy Glantser on 28 February 2016

Introduction to Big Data

So you’ve been working as a DBA or a BI developer for several years now. You know your stuff very well, and you consider yourself an expert in your field. And now there is this trend called “Big Data” that everyone seems to talk about. You’ve heard this term many… Read more

0 comments, 216 reads

Posted in Guy Glantser on 21 February 2016

Hadoop Fundamentals – The Presentation

Few days ago (28/12) I delivered a full-day seminar about Hadoop Fundamentals. It was part of the Expert Days 2015 event, which is running the whole week. The venue was… how should I put it? It was different… We spent the whole day in a VIP cinema hall, which was… Read more

2 comments, 663 reads

Posted in Guy Glantser on 30 December 2015

How to Compare Tables in SQL Server

One of our customers has recently asked me the following question (I changed just the business case):

The Problem

“I have a “MemberSessions” table, which stores web sessions made by members. The table contains the “MemberId” column, as well as other columns that describe the session, such as “LoginDateTime”. I… Read more

0 comments, 411 reads

Posted in Guy Glantser on 22 December 2015

Hadoop Fundamentals

Have you heard about Hadoop, but never really understood what it’s all about?

Do you need to learn about Hadoop, either for your current job or for getting a new job?

If you are new to Hadoop, and you want to have a solid understanding of this framework, then this… Read more

0 comments, 2,968 reads

Posted in Guy Glantser on 10 December 2015

The Power of Data in the Cloud

Today we had a full-day event in Microsoft about the data offerings and possibilities in the Microsoft cloud platform – Azure. We invited our customers as well as many other companies. 22 people attended the event, and it was very successful.

First, we presented our team and our solutions. We… Read more

0 comments, 571 reads

Posted in Guy Glantser on 19 November 2015

From PASS Summit to MVP Summit

This was a really great week!

So many sessions by great speakers, lots of community events, parties and fun. I met a lot of people, some are old friends and some are new friends that I hope to keep in touch with. I also learned a lot. My personal interest… Read more

0 comments, 651 reads

Posted in Guy Glantser on 30 October 2015

My PASS Summit 2015 Presentation

I’m going to present my session about working with parameters in PASS Summit on Thursday at 03:15pm. The title of the session is “How to Use Parameters Like a Pro and Boost Performance”. I love this session. I cover a lot of important tips, which in many cases can turn… Read more

0 comments, 557 reads

Posted in Guy Glantser on 29 October 2015

PASS Summit 2015 – Here We Go

Yes, it’s this time of the year again, and I’m very excited about it. Once a year, PASS holds the largest and coolest event in the world for SQL Server and BI professionals. More than 5,000 people from more than 2,000 companies and more than 50 countries are attending the… Read more

0 comments, 344 reads

Posted in Guy Glantser on 28 October 2015

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, 491 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, 519 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, 724 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, 381 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,869 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, 519 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, 531 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, 7,886 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, 454 reads

Posted in Guy Glantser on 28 January 2015

Newer posts

Older posts