Office Hours in Sofia Bulgaria

############################# Video Source: www.youtube.com/watch?v=xn2afGkPcmo

I was honored to speak at the Present to Succeed conference in Sofia, Bulgaria, run by a former SQL Server MCM. Sofia is a beautiful city, and the gorgeous Patriarchal Cathedral of St. Alexander Nevsky (Wikipedia) was close to my hotel, so I dragged my tripod over there for an Office Hours session to take your top-voted questions from https://pollgab.com/room/brento. Here's what we covered: • 00:00 Start • 01:19 Live is Life: After a migration to a new db, the old 3TB db is now read only. My friend is enabling row compression on the biggest tables/indexes and already got down to 1,5TB. The goal is to get faster reads and a smaller db. What are your thoughts about this? Is there a better way? • 02:40 MyTeaGotCold: Is Enterprise Edition generally seen as the norm? Blogs and particularly the official docs rarely point out that something isn't available in Standard, but I've gone my entire career without seeing it. • 03:20 EthicalDBA: Hey Brent, have you ever faced any moral/ethical issues in your DBA career that caused you to really question the task you were working on? • 04:35 With NeinLock: Greetings! As someone who is a household name when it comes to the SQL Server community, have you noticed members of the younger generation joining the community to give back and share knowledge? If yes, are there any you recommend following? • 08:22 Roger ap Gwilliam: What's the scariest RDBMS you have worked with? • 08:58 DT_DBA: Do you think using the FORCESEEK hint everywhere is okay? (same as how some people use NOLOCK). I have a client that has started doing this. They aren't specifying which index to use, just doing things like select * from table WITH (FORCESEEK) join view WITH (FORCESEEK) ... • 09:40 handysql: Helmet on the shelf. Is that for show or do you have a harley/rocket in the garage? • 11:35 Mike: Is there a good criteria that can be used to tell if a query is OLTP or OLAP query ? Is it number of seconds (duration, or cpu time), or number of logical reads, or something else ? • 12:48 VegasDBA: Hi Brent! Ever do any big physical to virtual conversions? I've been tasked with a very aggressive timeline to convert several physical SQL AGs to VMs. I was considering using AGs or distributed AGs to fail them over. Was curious of your thoughts and opinions. • 13:46 Mike: Is there a good up-to-date article that describes differences between Junior, Middle and Senior DBA in SQL Server (and maybe Azure SQL ?). And where can you develop next after becoming Senior ? • 15:53 Davros: When a traditional clustered index table starts to having too many indexes is this an indication that the table should be using column store?

#############################

New on site