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

Guy Glantser

Guy Glantser is the CEO of Madeira SQL Server Services and the leader of the Israeli PASS chapter. His career has been focused on SQL Server for the past 17 years, performing various database roles as either an on-site DBA, an external consultant or an instructor. Guy is involved in many activities in the SQL Server community. He occasionally speaks at community events, such as Tech-Ed, product launches and user groups around the world. He also co-hosts the Israeli SQL Server radio show.

My Visit to WPC 2014

Last week I attended WPC. This is an annual event organized by Microsoft for its partners around the world. WPC stands for “Worldwide Partner Conference”, and this is exactly what it is. Last week it was held in Washington D.C, and there were 16,000 people in this event from over… Read more

0 comments, 65 reads

Posted in Guy Glantser on 24 July 2014

My Visit to Redmond

Last week, I had the pleasure of attending the EBC in Redmond. If you don’t know what EBC is, that’s OK. I didn’t know either until Microsoft invited me there a couple of months ago. EBC stands for “Executive Briefing Center”. It’s a building in Redmond designated to host customer… Read more

0 comments, 33 reads

Posted in Guy Glantser on 23 July 2014

Track Incomplete Statements

What about when statements are sitting in your server, uncompleted and not moving, just hogging resources? Use this script for Extended Events to hunt them down.

The post Track Incomplete Statements appeared first on SQL Server Services.

Read more

0 comments, 2 reads

Posted in Guy Glantser on 16 July 2014

Space Used by Database Files

Retrieve data about size and space used for all the files in the current database with this script.
 
Some tips on database file size management:

  • Make sure there is enough unallocated space for future growth.
  • If the value of “UnallocatedSpace_Percent” is low, consider allocating more space in the next…

Read more

0 comments, 3 reads

Posted in Guy Glantser on 24 June 2014

What I Love About SQL Server

Well, there are many things I love about SQL Server. Otherwise, I wouldn’t spend my whole career around it, would I? I can talk about the powerful and easy-to-use client tools, or about the excellent high availability and disaster recovery features (aka “AlwaysOn”), or about the powerful ETL platform known… Read more

0 comments, 2 reads

Posted in Guy Glantser on 16 June 2014

Last Backup Times per Database and Backup Type

This script displays the last date and time of each backup type for each database.

It’s useful when you need to know quickly when a database had its last backup.

The post Last Backup Times per Database and Backup Type appeared first on SQL Server Services.

Read more

0 comments, 0 reads

Posted in Guy Glantser on 26 February 2014

How to Load Data from Excel in SSIS – 32-bit vs. 64-bit

Let's say you are developing an SSIS package on your dev box to load data from an Excel file to SQL Server. For this example, let's assume your dev box is Windows 7 64-bit with SQL Server 2012, and the Excel version is above 2007 (meaning you're using an "xlsx"… Read more

1 comments, 41 reads

Posted in Guy Glantser on 25 February 2014

How to Load Data from Excel in SSIS – 32-bit vs. 64-bit

Let’s say you are developing an SSIS package on your dev box to load data from an Excel file to SQL Server. For this example, let’s assume your dev box is Windows 7 64-bit with SQL Server 2012, and the Excel version is above 2007 (meaning you’re using an “xlsx”… Read more

0 comments, 0 reads

Posted in Guy Glantser on 25 February 2014

Forty Things You Didn’t Know About SQL Server

Last week I delivered a seminar at the Expert Days 2013 event by the name of 40 Things You Didn’t Know about SQL Server. The seminar was divided into four categories: configuration, database design, programming, and troubleshooting. I presented 10 topics in each category. We covered things like file… Read more

0 comments, 25 reads

Posted in Guy Glantser on 16 December 2013

PASS Summit 2013 – Day 5: SQL Server Internals Day

This is a summary of my last day in the PASS Summit. I have already written about my first, second, third and fourth days. Today was a very intensive day with some really great sessions. I learned so much today…

The day began with Rob Farley (Blog Read more

1 comments, 16 reads

Posted in Guy Glantser on 19 October 2013

PASS Summit 2013 – Day 5: SQL Server Internals Day

This is a summary of my last day in the PASS Summit. I have already written about my first, second, third and fourth days. Today was a very intensive day with some really great sessions. I learned so much today…

The day began with Rob Farley (Blog Read more

0 comments, 0 reads

Posted in Guy Glantser on 19 October 2013

PASS Summit 2013 – Day 4: SQLskills Day

This is my fourth day in the PASS Summit. I have already written about my first, second and third days.

The day started with another keynote session with Thomas LaRock (Blog | Twitter), vice president of marketing at PASS, and David DeWitt, director at Microsoft. David presented… Read more

0 comments, 23 reads

Posted in Guy Glantser on 18 October 2013

PASS Summit 2013 – Day 4: SQLskills Day

This is my fourth day in the PASS Summit. I have already written about my first, second and third days.

The day started with another keynote session with Thomas LaRock (Blog | Twitter), vice president of marketing at PASS, and David DeWitt, director at Microsoft. David presented… Read more

0 comments, 0 reads

Posted in Guy Glantser on 18 October 2013

PASS Summit 2013 – Day 3: Query Tuning, Memory Internals, SSIS and PowerShell

This is actually the first formal day of the PASS Summit, but it's my third day here. I have already written about my experience in my first and second days, so this is a summary of my third day.

This day started with a keynote session with Bill Graziano ( Read more

0 comments, 19 reads

Posted in Guy Glantser on 17 October 2013

PASS Summit 2013 – Day 3: Query Tuning, Memory Internals, SSIS and PowerShell

This is actually the first formal day of the PASS Summit, but it’s my third day here. I have already written about my experience in my first and second days, so this is a summary of my third day.

This day started with a keynote session with Bill Graziano ( Read more

0 comments, 0 reads

Posted in Guy Glantser on 17 October 2013

PASS Summit 2013 – Day 2: The PASS Spirit

This is my second day into the PASS Summit 2013, and the excitement is still rising. My first day was great, but it was mainly about execution plans and optimizer stuff. Today I haven't learned anything about SQL Server, but I have learned a lot about PASS and about the… Read more

2 comments, 16 reads

Posted in Guy Glantser on 16 October 2013

PASS Summit 2013 – My First Day and Paul White

This is my first time to attend the PASS Summit. I was very excited about it, and I planned to learn a lot and to meet a lot of interesting people. The summit actually begins tomorrow evening (October 15th) with the welcome reception, and then there are 3 days of… Read more

6 comments, 30 reads

Posted in Guy Glantser on 15 October 2013

How Much Unallocated Space do I Have in My Database Files

In a previous post, I wrote about when and how to shrink your database files. The bottom line was that you shouldn't shrink your files, unless you really have to, and if you really have to, then you should do it during low or no activity time and in… Read more

0 comments, 25 reads

Posted in Guy Glantser on 13 August 2013

My Summary of 24 Hours of PASS

Once a year, just before the annual PASS Summit, there is a promotional event called 24 Hours of PASS. The idea is to gather together 24 consecutive one-hour webcasts by the top speakers in the PASS Summit. The event is free, and all the webcasts are recorded and… Read more

0 comments, 27 reads

Posted in Guy Glantser on 5 August 2013

When and How to Shrink Your Database

Most DBAs know that shrinking a database is a bad thing. But in many cases, there is no DBA around, and either a developer or someone else in the organization is responsible for maintaining the database. And I still see from time to time one of the following two disasters:… Read more

3 comments, 25 reads

Posted in Guy Glantser on 1 August 2013