SQL Server Radio

Did you know SSMS can make sounds? We start the show with some interesting things you might do with it.

In addition, we talk about:

• SQL Server on Linux
• Hadoop fundamentals
• SQL Server 2016 eBook
• Changes to auto update statistics in SQL Server 2016
• New SQL Server 2016 database level configurations
• Distributed Availability Groups - what is it and use cases
• How AWS storage works

Items mentioned in the show:

• Guy Glantser - Hadoop Fundamentals
• Denny Cherry - How to make SSMS beep when a query is done?
• Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview 2
• Erik Darling - Changes to auto update stats thresholds in SQL Server 2016
• Brent Ozar - SQL Server 2016: The Death of the Trace Flag
• Distributed Availability Groups

Download Episode (mp3)

In this show, we talk about a few projects we took part in and we're proud of.

In this show, we talk about a few projects we took part in and we're proud of.

Download Episode (mp3)

In today's world where deployments to production are very frequent, continuous integration and testing code become more important than ever.

In this show, we talk to Steve Jones (Blog | Twitter), the editor of SQLServerCentral.com about how to do it.

Among other topics, we talk to Steve about:

* His work at SQLServerCentral and his favorite parts over the years

* What he's looking for in SQL Server 2016

* What is continuous integration and how it can be done with SQL Server

* How to test your database code before it gets to production

* Data Quality Services and Master Data Services

Items mentioned in the show:

* SQLServerCentral

* Steve's Blog - Voice of the DBA

* Voice of the DBA podcast

* DBA Team - Steve on a horse

* Steve Jones - 100 Hours

* Josh Kaufman - The first 20 hours (TEDxCSU)

* tSQLt

* SQL Server Radio show 38 - DevOps, Cloud and Podcasting with Richard Campbell

* Practical Refactoring

* Redgate SQL Release

About Steve

Steve has been working with SQL Server since 1991, when he became the accidental DBA for a SQL Server v4.2 system running on OS/2 1.3.

Since that time Steve has worked with all versions of SQL Server at various jobs.

In 2001, Steve founded SQLServerCentral.com with Brian Knight, Andy Warren, and three other partners that were bought out the next year. In 2002, Steve left his job with Peoplesoft to manage SQLServerCentral full time as editor, publisher, and writer. Andy, Brian, and Steve continued to manage and grow SQLServerCentral until 2007 when it was sold to Red Gate Software along with Database Weekly (then Database Daily). At that time Steve went to work for Red Gate and has continued his work with SQLServerCentral and Red Gate since that time.

Steve regularly speaks at SQL Saturday and other technical events on career and technical topics, and enjoys meeting and interacting with the SQL Server community. If you are interested in inviting him come speak at your event, please feel free to contact him through email, Twitter, or Facebook. You can also get the text of his keynote talks.

Steve was first awarded the Microsoft MVP award in 2008 and has been renewed 3 times for his many contributions to the community. Steve holds an MCSE from NT 4.0, an MSITPro in SQL Server, and numerous other MCP certifications in SQL Server. He also has an undergraduate degree from the University of Virginia in Economics.

In today's world where deployments to production are very frequent, continuous integration and testing code become more important than ever.

In this show, we talk to Steve Jones (Blog | Twitter), the editor of SQLServerCentral.com about how to do it.

Among other topics, we talk to Steve about:

• His work at SQLServerCentral and his favorite parts over the years
• What he's looking for in SQL Server 2016
• What is continuous integration and how it can be done with SQL Server
• How to test your database code before it gets to production
• Data Quality Services and Master Data Services

Items mentioned in the show:

• SQLServerCentral
• Steve's Blog - Voice of the DBA
• Voice of the DBA podcast
• DBA Team - Steve on a horse
• Steve Jones - 100 Hours
• Josh Kaufman - The first 20 hours (TEDxCSU)
• tSQLt
• SQL Server Radio show 38 - DevOps, Cloud and Podcasting with Richard Campbell
• Practical Refactoring
• Redgate SQL Release

About Steve

Steve has been working with SQL Server since 1991, when he became the accidental DBA for a SQL Server v4.2 system running on OS/2 1.3.Since that time Steve has worked with all versions of SQL Server at various jobs.

In 2001, Steve founded SQLServerCentral.com with Brian Knight, Andy Warren, and three other partners that were bought out the next year. In 2002, Steve left his job with Peoplesoft to manage SQLServerCentral full time as editor, publisher, and writer. Andy, Brian, and Steve continued to manage and grow SQLServerCentral until 2007 when it was sold to Red Gate Software along with Database Weekly (then Database Daily). At that time Steve went to work for Red Gate and has continued his work with SQLServerCentral and Red Gate since that time.

Steve regularly speaks at SQL Saturday and other technical events on career and technical topics, and enjoys meeting and interacting with the SQL Server community. If you are interested in inviting him come speak at your event, please feel free to contact him through email, Twitter, or Facebook. You can also get the text of his keynote talks.

Steve was first awarded the Microsoft MVP award in 2008 and has been renewed 3 times for his many contributions to the community. Steve holds an MCSE from NT 4.0, an MSITPro in SQL Server, and numerous other MCP certifications in SQL Server. He also has an undergraduate degree from the University of Virginia in Economics.

Download Episode (mp3)

In this show, we talk about:

* External deadlines

* The RS.EXE utility and what it is used for

* Why you shouldn't use Task Manager to check how much memory SQL Server consumes

* The Lock Pages in Memory option

* Stored procedure execution options under Transactional Replication

* Instant File Initialization checkbox in SQL Server 2016 setup

* SQL Server Agent job history

* Fixed server roles and how to correctly configure logins in SQL Server

Items mentioned in the show:

* Scott Murray - SQL Server Reporting Services RS.EXE Utility

* Gail Shaw - Stop using Task Manager to check SQL’s memory usage!

* SQLSaturday Israel

* Guy's Big Data seminar at SQLBits

In this show, we talk about:

• External deadlines
• The RS.EXE utility and what it is used for
• Why you shouldn't use Task Manager to check how much memory SQL Server consumes
• The Lock Pages in Memory option
• Stored procedure execution options under Transactional Replication
• Instant File Initialization checkbox in SQL Server 2016 setup
• SQL Server Agent job history
• Fixed server roles and how to correctly configure logins in SQL Server

Items mentioned in the show:

• Scott Murray - SQL Server Reporting Services RS.EXE Utility
• Gail Shaw - Stop using Task Manager to check SQL’s memory usage!
• SQLSaturday Israel
• Guy's Big Data seminar at SQLBits

Download Episode

Another two weeks have passed, and another show is live.

Today on the show:

* Error handling in SSIS

* Why Big Data systems use ELT and not ETL

* What Data Scientists do

* What Data Analysts do and why they need to know SQL well

* Azure Data Factory and Azure Data Catalog

* Compressing and decompressing data in SQL Server 2016

* Configuration options for high-end SQL Server systems

* More SQL Server setup tips

Items mentioned in the show:

* Guy's SQLBits precon - Big Data Made Simple

* Jeff Smith - They Just Write SQL Statements

* Recommended updates and configuration options for SQL Server 2012 and later versions with high-performance workloads 

* Built-in functions for compression/decompression in SQL Server 2016

Another two weeks have passed, and another show is live.

Today on the show:

• Error handling in SSIS
• Why Big Data systems use ELT and not ETL
• What Data Scientists do
• What Data Analysts do and why they need to know SQL well
• Azure Data Factory and Azure Data Catalog
• Compressing and decompressing data in SQL Server 2016
• Configuration options for high-end SQL Server systems
• More SQL Server setup tips

Items mentioned in the show:

• Guy's SQLBits precon - Big Data Made Simple
• Jeff Smith - They Just Write SQL Statements
• Recommended updates and configuration options for SQL Server 2012 and later versions with high-performance workloads
• Built-in functions for compression/decompression in SQL Server 2016

Download Episode (mp3)

In this show, we talk to William Durkin (Blog | Twitter), an Englishman "stuck in Germany".

William just switched to being an independent SQL Server consultant, and we talk to him about going independent, how to price yourself the right way, and about many good SQL Server tips.

Specifically, we talk about:

* His way for becoming an independent consultant

* How to price yourself by value and not by time

* SQL Server Replication tips

* Tips for upgrading SQL Server with minimal downtime

* What is the meaning of 5 nines and how much technical and financial investments it requires

* When and how to use DNS aliases with your SQL Servers

* Dynamic Data Masking use cases

* Linked Servers performance tips

Items mentioned in the show:

* Double Your Freelancing - Student Success Story with William Durkin

* Global Azure Bootcamp

* SQLKonferenz

About William

William is an independent SQL Server consultant from England (now in Germany). He has experience as a DBA in large multi-national SQL Server environments and is a regular speaker around Europe.