Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Matan Yungman

Matan Yungman is a Technical Evangelist and senior consultant at Madeira SQL Server Services. His job is to get the word out about SQL Server. He speaks, lectures, writes, teaches and consults about SQL Server, focusing mainly on performance tuning, database development, high availability and database design. He’s passionate about SQL Server, technology and the SQL Server community.

Performance-Oriented SQL Server Development – The Scripts

Last Thursday, I delivered my seminar, Performance-Oriented SQL Server Development at the Expert Days conference in Israel.

It was a great experience, and I’d like to thank everyone who attended.

The scripts from the seminar can be downloaded from here.

 

 

The post Performance-Oriented SQL Server Development –… Read more

0 comments, 288 reads

Posted in Matan Yungman on 30 December 2016

Performance-Oriented T-SQL Development in Belgium

On October 10, I will come back to present in one of my favorite SQL Server conferences – SQL Server Days in Belgium, and this time it’s for a pre-conference session.

This full day seminar is called Performance-Oriented T-SQL Development, and it will focus on solving real world problems… Read more

0 comments, 19 reads

Posted in Matan Yungman on 29 September 2016

If You Need to Think, You’re Doing It Wrong

A month ago, my wife and I were in Barcelona for a short vacation.

In one of the days, we entered a small place called Wok to Walk for dinner. The concept is simple: You build your dish by choosing your base (the type of noodles or rice), then your… Read more

0 comments, 18 reads

Posted in Matan Yungman on 29 June 2016

My PASS Summit 2016 Session Submissions Feedback

I’m excited to say that I will be delivering a session in this year’s PASS Summit in Seattle later this year! The session is called “MongoDB for the SQL Server Professional”.

More about the session in the future. For now, after Brent Ozar and Steph Locke published their abstract review… Read more

1 comments, 12 reads

Posted in Matan Yungman on 24 June 2016

Columnstore Index Enhancements in SQL Server 2016

One of my most favorite technologies is Columnstore. Thankfully, the guys at Microsoft seem to agree with me, because they continue developing this technology and make it faster and faster.

In a nutshell, as oppose to what we’re used to today, a Columnstore index keeps our data at the column-level… Read more

0 comments, 2,784 reads

Posted in Matan Yungman on 27 April 2016

How to Grant Permissions Only on the Replica in Database Mirroring and AlwaysOn AG

You work with Database Mirroring or AlwaysOn AG, and you want to make sure your end users work only on the secondary server. How should you do that?

Scenario A: All databases are mirrored and should be accessed from the secondary

  1. Make sure the login(s) exists both on the primary…

Read more

2 comments, 76 reads

Posted in Matan Yungman on 3 March 2016

Things I learned in 2015

Happy 2016!

I continue my tradition of summarizing the things I learned in the past year (as a reminder, here’s what I learned in 2013 and 2014). Here’s some of the things I learned in 2015.

Technical stuff:

  • Big Data is here, and it’s not only a buzzword or…

Read more

0 comments, 265 reads

Posted in Matan Yungman on 25 January 2016

How to Solve the Tail Insert Problem

In the previous post, we talked about when you should use identity/sequence as a clustered index key and when it’s problematic.

 

In a nutshell, since traditionally we want our clustered index key to be narrow, static and ever-increasing, Identity is in many cases a very good choice. But… Read more

1 comments, 378 reads

Posted in Matan Yungman on 19 January 2016

When Should You Use Identity as a Clustered Index Key?

A few days ago, while delivering my session, The Data-Loading Performance Presentation, I was asked when, performance-wise, Identity should be used as the clustered index key, and when it shouldn’t.

So first, starting SQL Server 2012, a Sequence is actually a better choice than identity. It’s more flexible, more… Read more

10 comments, 3,203 reads

Posted in Matan Yungman on 16 December 2015

My PASS Summit 2015 Recap

A few days ago I returned from PASS Summit 2015 (and a vacation I took afterwards). Here’s my recap: I opened the week with a FreeCon Brent Ozar and Kendra Little hosted. The day focused on personal branding and the learning and sharing paths that are derived from it. In… Read more

4 comments, 369 reads

Posted in Matan Yungman on 22 November 2015

Scripts and Slide Deck: The Data Loading Performance Presentation at PASS Summit

I have just finished delivering my session, The Data Loading Performance Presentation at PASS Summit 2015. It went very well, and I’d like to thanks anyone who attended.

Here’s a glimpse at the start of the session:

The scripts and slide deck can be downloaded from here.

Stay tuned… Read more

2 comments, 498 reads

Posted in Matan Yungman on 30 October 2015

Things You Need To Know about Nolock

Nolock is not the Satan, but no an angel too

Surfing the web you will find articles saying that Nolock is dangerous and shouldn’t be used, and articles stating that it’s THE solution for many problems. The truth, as in many cases, lies in the middle.

If you have a… Read more

0 comments, 300 reads

Posted in Matan Yungman on 26 October 2015

Database Mirroring Isn’t Going Anywhere

AlwaysOn Availability Groups is a great technology that centralizes the management of High Availability, Disaster Recovery and Scale-Out. However, in many cases, the good old Database Mirroring is just good enough (and in some cases, better):

Database Mirroring can work in Standard Edition

Database Mirroring is supported in both… Read more

5 comments, 950 reads

Posted in Matan Yungman on 24 September 2015

Speaking at SQLSaturday Oslo

This weekend, I’ll hop on a plane and fly over to Norway for SQLSaturday Oslo.

I’ll be delivering a session I like a lot: The Data Loading Performance Presentation.

Among other topics, we will talk about the #1 enemy of high performance data loading, Minimal Logging and Bulk… Read more

0 comments, 485 reads

Posted in Matan Yungman on 26 August 2015

Why You Should Care About Microsoft APS and Azure SQL Data Warehouse

Last week, I gave a presentation about SQL Server’s data warehouse capabilities, and specifically about APS (Analytics Platform System) and Azure SQL Data Warehouse.

The best way to learn about a subject is to teach it, and indeed, I learned a lot. Let’s talk about it a bit.

Architecture

APS… Read more

2 comments, 738 reads

Posted in Matan Yungman on 19 August 2015

Indexes on GUIDs – Not Only Fragmentation

A client called us with the following issue:

He had a table of a few dozen million rows. The table had a few GUID columns that had to be indexed.

He had an ETL process that inserted a few thousand rows every few minutes. When the table had only a… Read more

7 comments, 2,501 reads

Posted in Matan Yungman on 27 July 2015

Columnstore Indexes at PASS Performance Palooza: Recording and Materials

Yesterday I participated in PASS Performance Palooza.

I had a lot of fun delivering my session Columnstore Indexes – Questions and Answers.

The recording is already up:

 

The scripts and slide deck can be downloaded from here.

The post Columnstore Indexes at PASS Performance Palooza: Recording and Materials Read more

0 comments, 398 reads

Posted in Matan Yungman on 24 July 2015

Speaking about Columnstore Indexes at PASS Performance Palooza

The PASS Performance Virtual Chapter has a tradition of yearly “Palooza events”, in which there are a few back-to-back online performance sessions by great speakers from all around the world.

I have the honor to speak in this year’s Performance Palooza, which will take place this Thursday, July 23.

I… Read more

0 comments, 315 reads

Posted in Matan Yungman on 21 July 2015

24 Hours of PASS: The Data Loading Performance Presentation – Slide Deck and Scripts

Thanks to everyone who attended my 24 Hours of PASS session, The Data Loading Performance Presentation.

It was a lot of fun taking part in such a special event.

The slide deck and scripts I used in the session can be downloaded here.

The post 24 Hours of PASS:… Read more

0 comments, 431 reads

Posted in Matan Yungman on 25 June 2015

Speaking at 24 Hours of PASS: Growing Our Community

24 Hours of PASS is just around the corner, and I’m happy to say that this time I’ll be speaking there.

24 Hours of PASS is a virtual event of 24 consecutive hourly sessions of speakers from all over the world. The theme this time is “growing our community”, and… Read more

0 comments, 448 reads

Posted in Matan Yungman on 18 June 2015

Older posts