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

Archives: February 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 .

Read more

0 comments, 354 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

0 comments, 2,609 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

10 comments, 507 reads

Posted in Guy Glantser on 25 February 2014

SSIS Appetizer

Madeira’s excellent course on SQL Server Integration Services starts in March, but you can get a head start here!  Take a tour through a few articles, specially chosen by us to get you going, from setting up SSIS to creating your very first work there.  Why not check out our… Read more

0 comments, 200 reads

Posted in Guy Glantser on 9 February 2014