Episode 69: Our SQL Server Setup Checklist

Episode 69: Our SQL Server Setup Checklist

We have all been there–next, next, next–let's just get this install done. While there are many ways to get SQL Server installed on a server, the real impact is in the way we administer the database and when we want to get good performance. Listener James Youkhanis asked us about our install checklist and Steve and I realized we hadn't made one public before. In this episode of the SQL Data Partners podcast, we talk about some of the settings we are looking for when we set up a server. We don't have time to reference every single item, but hit some highlights. Your list might differ slightly, but our list has been built from the experiences we have seen over time from various installations. We love to other opinions, so give us your thoughts!

The show notes for today's episode and the install checklist are available at http://sqldatapartners.com/2016/11/09/sql-server-install-checklist/. Have fun on the SQL trail compañeros!

Episoder(287)

Episode 279: SQL Server Migrations Demystified

Episode 279: SQL Server Migrations Demystified

If you use SQL Server, you will eventually have to migrate that instance somewhere – to a new version, a new server, the cloud . . . somewhere. Or perhaps you'll find yourself migrating from another d...

20 Sep 20241h 3min

Episode 278: Running SQL Server on Azure VMs

Episode 278: Running SQL Server on Azure VMs

Can you run SQL Server on Azure VM? Which VM is best? Is running SQL Server on a VM in Azure the right choice? Find out in this insightful episode with Anders Pedersen! With over 10 different SQL Serv...

30 Jul 20241h 4min

Episode 277: PostgreSQL for the SQL Server Crowd

Episode 277: PostgreSQL for the SQL Server Crowd

Is testing out pgAdmin on your to-do list? In this episode of the podcast, we chat with Ryan Booz, a PostgreSQL advocate at Redgate, about how a SQL Server professional might begin a dive into Postgre...

15 Jul 20241h 2min

Episode 276: Dynamic SQL and Testing in Isolation

Episode 276: Dynamic SQL and Testing in Isolation

Listener beware! This episode is full of danger as we tackle an interesting use case for Dynamic SQL. Dynamic SQL generally has a bad reputation in SQL Server circles, and with good reason. Dynamic SQ...

21 Mai 202441min

Episode 275: Machine Learning and Power BI

Episode 275: Machine Learning and Power BI

What kinds of problems are organizations solving with Machine Learning? In this episode, we explore a situation where a public works department was looking for more accurate information to predict fut...

16 Apr 202444min

Episode 274: A CMM Case Study

Episode 274: A CMM Case Study

After discussing the Capabilities Maturity Model in our last episode, it was fate when Andy Levy reached out and suggested a topic which sounds like a case study about his experience with CMM. As the ...

22 Feb 202451min

Episode 273: The Capability Maturity Model for Data Professionals

Episode 273: The Capability Maturity Model for Data Professionals

Have you ever felt stuck in a rut, repeating the same tasks, while knowing there is room for improvement? The Capability Maturity Model may be a way for you to start contributing to those improvements...

2 Feb 202455min

Episode 272: Performance Tuning Scripts

Episode 272: Performance Tuning Scripts

Do you find yourself repeating the same actions when pulling SQL Server performance metrics? Performance tuning a troublesome SQL Server can be a challenge. Luckily the community continues to produce...

10 Jan 202450min

Populært innen Fakta

fastlegen
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
treningspodden
foreldreradet
rss-strid-de-norske-borgerkrigene
jakt-og-fiskepodden
rss-sunn-okonomi
takk-og-lov-med-anine-kierulf
merry-quizmas
sinnsyn
rss-kunsten-a-leve
lederskap-nhhs-podkast-om-ledelse
gravid-uke-for-uke
smart-forklart
hverdagspsyken
level-up-med-anniken-binz
hagespiren-podcast
fryktlos
rss-kull