Office Hours: Ask Me Anything About SQL Server

preview_player
Показать описание
October 18th episode of open questions about Microsoft SQL Server and T-SQL.
Рекомендации по теме
Комментарии
Автор

Hello Brent. Always enjoy your content. Dynamic Data Masking (DDM) has a proper application. It is meant for presenting data in the application interface for end-users. For example, a call center interface where someone may have to verify the last 4 digits of a customer's SSN or phone number. That end-user doesn't have direct access to the back-end database and for that reason won't be able to determine DDM'd data by using inference or brute force. Also, if database security is setup properly you can protect against inference or brute force, as well.

bbksvb
Автор

Perhaps this is too broad a question what I'd like to know is what's relevant today (with regards to SQL server) that was relevant 7 years ago with regards to working with SQL Server on a daily basis. Why 7 years? There are a number of excellent PASS videos from 7 years ago by well known industry figures (Glenn Barry, Adam Mechanic, Paul Randal, etc) covering great topics that may or may not still be relevant today. Why kind of topics? Index Fragmentation, Query Tuning, etc. With the move to the cloud both pure cloud and hybrid cloud as well as changes to storage management I have to wonder what may no longer be relevant that was relevant 7 years ago. For example, there is an excellent PASS video titled "SQL Server Index Internals: A Deep Dive
" that dives into Indexes. How true today are the recommendations then with regards to indexes. For example is fragmentation as important today as it was then considering changes in storage. No longer is the DB living on a physical drive on a physical server but is instead part of some VM Ware like manged virtual server so is index fragmentation still important and if so is it handled in the same way? 7 years ago if I had an index with %99 fragmentation I knew it was important to rebuild that but that was when my DB was on a physical drive.server, does the same still apply today? Is rebuilding that index to defrag it as relevant today now that its all on a virtual server?

Thanks

LegoGuru-yvup
Автор

Hi Brent, I'm planning to do always on upgradation from 2016 to 2019 for inplacr upgradtion.. Please give me your comments on this.. Thanks

rajeshraj-rqth
Автор

What is with the cheesy sound effects? Completely out of place and annoying, I thought you were cool, Brent?

ulysses