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

DB NewsFeed

Matan Yungman is a SQL Server DBA at the Microsoft Protection Services operations team. He fell in love with T-SQL in 2003 and since then took part in various challenging projects, focusing mainly on performance tuning, database development, high availability and database design. He is passionate about SQL Server, databases and technology in general.

Webcast – Small Changes Can Make a World of Difference

This Thursday, 10AM GMT, I will be hosted by Dell’s Richard Douglas (blog|twitter) for a webcast. I will present my session called “Small Changes Can Make a World of Difference”, talking about a bunch of “small” features that were introduced in SQL Server 2012 and 2014,… Read more

0 comments, 98 reads

Posted in DB NewsFeed on 18 March 2014

A Community Challenge

Earlier this week, I delivered a presentation called “Query Progress Tracking in SQL Server” to my local user group.

Among other techniques, I showed how you can use CXPacket waits and the new sys.dm_exec_query_profiles DMV to track the progress of your query while it’s running.

The issue is that using… Read more

6 comments, 105 reads

Posted in DB NewsFeed on 5 March 2014

The Strange Story About the MERGE that Killed the Cluster

I don’t like the MERGE statement. The syntax is weird, it’s tricky in terms of locks, and it has a history of weird errors. The other day a developer wanted my help in troubleshooting a MERGE that caused an ACCESS VIOLATION error and a stack dump generation. That… Read more

15 comments, 3,232 reads

Posted in DB NewsFeed on 20 February 2014

Know When it’s Good Enough

Here’s a newsflash: You may not thing so, but you are expensive. There’s no point in endless performance tuning. I love performance tuning a lot, and even more, I love challenges. But sometimes taking a query from the “good enough zone” down to “super-performance zone” will take a lot… Read more

4 comments, 171 reads

Posted in DB NewsFeed on 28 January 2014

Things I Learned in 2013

It’s 2014 now. I hope you had fun in new year’s eve. 

2013 was an amazing and intense year. To recap it, I thought about sharing some of the things I learned:

SQL Server

  • I love Parallelism. Once you get used to look for parallelism options in your queries, and…

Read more

2 comments, 221 reads

Posted in DB NewsFeed on 2 January 2014

T-SQL Tuesday #49: Using CXPacket Waits to Detect Query Bottlenecks

This post is for T-SQL Tuesday #49, the monthly blog party of the community.

This tradition was started by Adam Machanic (blog | @AdamMachanic), and this month’s host is Robert David (blog | @SQLSoldier). This month’s topic is all about waits..

It’s Friday, Friday

It… Read more

6 comments, 438 reads

Posted in DB NewsFeed on 10 December 2013

Interviews with Brent Ozar, Adam Machanic and Denny Cherry for SQL Server Radio

While in SQLRally Amsterdam, I had the honor to interview Brent Ozar (blog | twitter), Adam Machanic (blog | twitter) and Denny Cherry (blog | twitter) to the Israeli SQL Server Radio, the Podcast I co-host with Guy Glantser (blog | twitter Read more

0 comments, 115 reads

Posted in DB NewsFeed on 9 December 2013

My SQLRally Experience

The past week I had the pleasure to attend SQLRally Amsterdam.

I took a flight from Tel-Aviv to Amsterdam and got there on Tuesday morning, which left me a whole day to get around the city. I traveled in the city center, ate a delicious pancake, drank a lot of… Read more

1 comments, 168 reads

Posted in DB NewsFeed on 11 November 2013

How to Limit IO Requests with SQL Server 2014 Resource Governor

Resource Governor was introduced in SQL Server 2008 in order to allow us have better control over our system resource consumption. With Resource Governor, we can divide our users to groups, when each group gets a certain percent of our resources. That way, we can reduce the risk of a… Read more

1 comments, 436 reads

Posted in DB NewsFeed on 9 October 2013

How to Become a Better DBA

Whether you’re just starting out or already a few years in the game, you’re probably wondering how you can become a better DBA.

Here’s what works for me:

1. Learn a Lot…of what you Find Interesting

There are no shortcuts – You have to learn. But it’s a lot easier… Read more

3 comments, 2,488 reads

Posted in DB NewsFeed on 26 August 2013

Using Change Data Capture and CLR to Transfer Data to the Cloud

We were three: A DBA, a developer and a tester.

Our mission: To develop an ongoing process that will transfer one of our biggest and busiest tables to the cloud. Here’s the story of how we did it:

The Requirements

  1. Transfer the table insert and updates to Azure in a…

Read more

3 comments, 341 reads

Posted in DB NewsFeed on 23 July 2013

Best SQL Server Podcast and Video Sites (Hangout)

My friend Boris Hristov (Blog | Twitter) continues his Google Hangouts initiative, and this week he invited me to talk about the best learning resources for SQL Server.

We talked about the best Podcast and video sites out there. Due to some technical issues we couldn’t talk about… Read more

0 comments, 487 reads

Posted in DB NewsFeed on 19 July 2013

New Hebrew SQL Server Podcast

Five months ago, I wrote a post about my love for Podcasts.

At some point, I started to think about starting a Podcast that will be addressed to the Israeli SQL Server community.

I talked about the idea with Guy Glantser (Blog | Twitter), the CEO of… Read more

0 comments, 332 reads

Posted in DB NewsFeed on 15 July 2013

This Can Be the Best Thing in SQL Server 2014

New versions have bombastic and catchy features. But a lot of times, the little, hidden features are the ones that matter the most.

I already wrote in the past about the small changes that make a difference in SQL Server 2012, and yesterday about the maturity of SQL Server 2014 Read more

4 comments, 635 reads

Posted in DB NewsFeed on 26 June 2013

My Thoughts about SQL Server 2014

SQL Server 2014 is coming. Go ahead and download the public CTP.

I’ve just started getting my hands dirty with the new version. Based on that and on the stuff that has already been published, here’s a few thoughts:

SQL Server 2014 is Mature

Microsoft takes care of… Read more

1 comments, 2,191 reads

Posted in DB NewsFeed on 25 June 2013

Nested Loops, Parallelism and Confusion

I’m 30 today.

In addition, it’s been 10 years since I started working with SQL Server.

In my twenties, I fell in love with T-SQL and SQL Server, got to a point I felt I needed a break, and came back fully energized.

One of my favorite parts of being… Read more

5 comments, 347 reads

Posted in DB NewsFeed on 11 June 2013

Hangouts Session with Boris Hristov

I was invited to take part in a new initiative conceived by Boris Hristov (Blog|Twitter).

Boris wants to start using the Google Hangouts video calls in the SQL Server community, and we had a nice chat about where and how this platform can fit between the… Read more

1 comments, 221 reads

Posted in DB NewsFeed on 29 May 2013

Five Ways to Improve Your Productivity with SSMS

For most DBAs, Management Studio is the primary work tool.

That’s why properly using it can save a-lot of time and effort.

Here’s a few tricks that can improve your productivity when working with it:

1. Snippets and Keyboard Shortcuts

The amount of time these two features saved me is… Read more

10 comments, 5,426 reads

Posted in DB NewsFeed on 30 April 2013

Cool Tool – SQL Space Map

I came across a cool open source tool called “SQL Space Map“.

The tool, written by Ryan McCauley, presents a visual representation of table and index sizes:

It can be very handy when you need to quickly understand what are the main tables in a database.

It… Read more

0 comments, 281 reads

Posted in DB NewsFeed on 17 April 2013

Weekly Links – 05/04/2013

I’m starting a new tradition:

Before each weekend, I will post links to the best SQL Server stuff i’ve read, heard and watched, as well as to other interesting stuff. Each category will usually have 3-5 links, depending on my pace and focus on that week.

Below are the links… Read more

0 comments, 321 reads

Posted in DB NewsFeed on 5 April 2013

Older posts