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

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, 290 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, 142 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, 191 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, 146 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, 130 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, 91 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,044 reads

Posted in Guy Glantser on 8 May 2016

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,279 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, 204 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, 413 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, 230 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, 683 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, 428 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

2 comments, 3,018 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, 594 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, 678 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, 585 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, 356 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, 508 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, 536 reads

Posted in Guy Glantser on 12 August 2015

Newer posts

Older posts