-->
Click here to monitor SSC
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.

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

0 comments, 409 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, 804 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, 60 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, 72 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, 52 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, 33 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, 40 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, 33 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, 27 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, 42 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, 36 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, 35 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, 495 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,119 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, 117 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, 223 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, 126 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, 472 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, 323 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,680 reads

Posted in Guy Glantser on 10 December 2015

Older posts