Episode 242: Upgrading Your SQL Server

Episode 242: Upgrading Your SQL Server

SQL Server 2012 is end of life later this year. I feel too young for this to be happening—it seems like only last year SQL Server 2005 came out. In this episode of the podcast, we talk about upgrading your SQL Server. We share some concepts, gotchas, war stories, situations we want to avoid, how to access license keys in Azure, and a few other migration nuggets we've learned along the way.

The show notes and video for today's episode can be found at https://sqldatapartners.com/2022/02/02/episode-242-upgrading-your-sql-server. Have fun on the SQL Trail!

Episoder(287)

Episode 55: The new and improved SQL Server Reporting Services

Episode 55: The new and improved SQL Server Reporting Services

SQL Server reporting services hasn't changed in what seems like 10 years.  The rest of the reporting environment at Microsoft has seen some MEGA changes and it seems like we could use a few updates to...

3 Aug 201641min

Episode 54: An Executive Panel Interview

Episode 54: An Executive Panel Interview

What is the leadership of your company thinking about the future of data and the role you will play?  To help give some insight into that question we have and executive pane on episode 54.  Andrew Ros...

27 Jul 201638min

Episode 53: THE Argenis Fernandez interview on storage

Episode 53: THE Argenis Fernandez interview on storage

In Episode 53 Steve Stedman and I chat with THE Argenis Fernandez, storage guru and PASS Director-at-Large about what else? Storage.  Steve and I learn something new from Argenis every time we talk to...

20 Jul 201646min

Episode 52: Statistics are coming to the DB R you ready?

Episode 52: Statistics are coming to the DB R you ready?

Since Microsoft purchases the R language they have been baking it into their products and SQL Server is on the list.  SQL Server 2016 now has support for R and I know I have had people approach me abo...

13 Jul 201631min

Episode 51: A PowerShell Story

Episode 51: A PowerShell Story

I am always amazed at how people can use technology to solve different problems and in today's episode, my friend Jana shares with us a problem he solved with PowerShell.  The setup of this is differe...

6 Jul 201626min

Episode 50: SQL Server Settings

Episode 50: SQL Server Settings

As database administrators, we want to get as much performance as we can out of our SQL Servers.  Microsoft has provided a few knobs for us to tweak in the Operating System, the local security policy,...

29 Jun 201637min

Epsidode 49: Temp Tables VS Table Variables

Epsidode 49: Temp Tables VS Table Variables

When you code and you need to use a temporary object what do you use in SQL Server--temp tables or a table variable?  There is plenty of conventional wisdom out there and my guest Wayne Sheffield and ...

22 Jun 201635min

Episode 48: Is the Data Warehouse Dead?

Episode 48: Is the Data Warehouse Dead?

Over the last few years we have seen an explosion of new technologies and processes to manage data. Episode 48 asks the question--Is the Data Warehouse dead? I chat with MVP Tim Mitchell about the s...

15 Jun 201633min

Populært innen Fakta

fastlegen
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
foreldreradet
rss-strid-de-norske-borgerkrigene
treningspodden
jakt-og-fiskepodden
rss-sunn-okonomi
sinnsyn
mikkels-paskenotter
takk-og-lov-med-anine-kierulf
hverdagspsyken
gravid-uke-for-uke
rss-kunsten-a-leve
tomprat-med-gunnar-tjomlid
hagespiren-podcast
rss-bisarr-historie
rss-var-forste-kaffe
fryktlos
rss-kull