SQL Server Radio

Download Episode (mp3)

The PASS Summit interview series continues, and today we talk to Pieter Vanhove (Blog | Twitter). Pieter is a Premier Field Engineer at Microsoft, and we talk to him about his experience from Microsoft and his previous job. Among other topics, we talk to Pieter about:

* Why you need a morning checklist

* How can you do it better with Policy Based Management and a Central Management Server

* Migrating SQL Server to Azure

* Automation in Azure

Pieter was also the first winner of Speaker Idol and therefore won the prize of presenting a session on this year's PASS Summit. We talk about how he won the contest, and also about how he prepared for presenting a session with another presenter that lives more than 5000 kilometers from him.

Items mentioned in the show:

* Pieter's PASS Summit Session: Run Your DBA Morning Checklist with Policy-Based Management

* Pieter Vanhove - How to perform index maintenance on Azure SQL Database

About Pieter

Pieter Vanhove is a Microsoft Premier Field Engineer in Belgium and has been working with SQL Server since 2000. Performance tuning, SQL audits, migrations and training are part of the job. Pieter has also a profound knowledge in implementing high availability and disaster recovery solutions. Together with the SQLUG in Belgium, he helps organizing SQL Server Days and is also a regular speaker at Belgian and international events.

Download Episode (mp3)

We continue our PASS Summit interview series, and today we talk to Carlos Bossy (Blog | Twitter) about Hadoop, Hive and the Hadoop ecosystem in general.

There are many technologies in the Hadoop zoo, and we explain what those technologies do, how they work compared to SQL Server tools, and when to use which technology.

We also compare R to T-SQL, and even talk a tiny bit about MongoDB.

Items mentioned in the show:

Carlos' PASS Summit Session: Use Hive and Hadoop for High-Performance Data Warehousing

Feodor Georgiev - Using R to Explore Data by Analysis - for SQL Professionals

About Carlos

Carlos Bossy (MCTS, MCP BI, CBIP) is a data and BI architect with 25 years of experience in software and database development. As principal consultant of his company, Carlos focuses on developing BI solutions, including modeling data warehouses and delivering predictive analytics, integration, and reporting. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.

Download Episode (mp3)

Do you know what FOMO means?

It means "Fear of Missing Out", and it's a term used in the startup and venture capital fields. However, it's also relevant for us as DBAs, and we start the show explaining why.

Other than that, we talk about:

* Why you should be careful when using SQL Server's Row Level Security

* Duplicate indexes

* The dangers of Indexed Views

* An important thing you need to know about Filtered Indexes

* Lots of ways to improve your productivity with Management Studio

* Allow Snapshot Isolation and Read Committed Snapshot

Items mentioned in the show:

* Startup podcast

* 356labs

* Matan Yungman - 5 Ways to Improve Your Productivity with SSMS

* Forum discussion: ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT

* MCM readiness videos

Do you know what FOMO means?

It means "Fear of Missing Out", and it's a term used in the startup and venture capital fields. However, it's also relevant for us as DBAs, and we start the show explaining why.

Other than that, we talk about:

• Why you should be careful when using SQL Server's Row Level Security
• Duplicate indexes
• The dangers of Indexed Views
• An important thing you need to know about Filtered Indexes
• Lots of ways to improve your productivity with Management Studio
• Allow Snapshot Isolation and Read Committed Snapshot

Items mentioned in the show:

• Startup podcast
• 356labs
• Matan Yungman – 5 Ways to Improve Your Productivity with SSMS
• Forum discussion: ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT
• MCM readiness videos

Download Episode (mp3)

We start to warm up the engines towards PASS Summit, which will take place in Seattle at the end of October.

Before the summit, we will host a few speakers to talk about their sessions and share some of the stuff you can expect to hear.

In this show, we have Bradley Ball (blog | twitter), Data Platform Management Lead at Pragmatic Works.

Among other topics, we talk to Bradley about:

* What you can expect to hear in Bradley's PASS Summit precon and session

* Data architecture

* What is Microsoft APS and what's important when working with it

* How Azure SQL Datawarehouse took the APS idea a step further

* Message queuing

* Bradley's military career

Items mentioned in the show:

* Bradley's PASS Summit session: Indexing Internals for Developers and DBAs

* Bradley's PASS Summit precon: Optimize “All Data” with a Modern Data Warehouse Solution

* Jason Strate - sp_IndexAnalysis

We also talk about some weird meanings of the acronym "APS".

About Bradley

Bradley Ball is a SQL Server MVP with about 15 years of IT experience. Bradley spent 8 years working as a defense contractor for clients such as the U.S. Army and The Executive Office of the President of the United States. He is the data platform management lead with Pragmatic Works and a Microsoft VTSP. He has presented at SQLSaturday, SSUGs, SQLRally, DevConnections, SQLBits, SQL Live 360, and PASS Summit. Bradley can be found blogging at http://www.SQLBalls.com.

We start to warm up the engines towards PASS Summit, which will take place in Seattle at the end of October.

Before the summit, we will host a few speakers to talk about their sessions and share some of the stuff you can expect to hear.

In this show, we have Bradley Ball (blog | twitter), Data Platform Management Lead at Pragmatic Works.

Among other topics, we talk to Bradley about:

• What you can expect to hear in Bradley's PASS Summit precon and session
• Data architecture
• What is Microsoft APS and what's important when working with it
• How Azure SQL Datawarehouse took the APS idea a step further
• Message queuing
• Bradley's military career

Items mentioned in the show:

• Bradley's PASS Summit session: Indexing Internals for Developers and DBAs
• Bradley's PASS Summit precon: Optimize "All Data" with a Modern Data Warehouse Solution
• Jason Strate – sp_IndexAnalysis

We also talk about some weird meanings of the acronym "APS".

About Bradley

Bradley Ball is a SQL Server MVP with about 15 years of IT experience. Bradley spent 8 years working as a defense contractor for clients such as the U.S. Army and The Executive Office of the President of the United States. He is the data platform management lead with Pragmatic Works and a Microsoft VTSP. He has presented at SQLSaturday, SSUGs, SQLRally, DevConnections, SQLBits, SQL Live 360, and PASS Summit. Bradley can be found blogging at http://www.SQLBalls.com.