jobsublimetext2

MalathiMahadevan2018M.
Mahadevan,DataProfessionalsatWork,https://doi.
org/10.
1007/978-1-4842-3967-4AAdamMachanic'ssp_whoisactive,32,54,62,150,157,323,329,336,346AirOntario1363,101Alation,251,254AmazonRedshift,247AmazonWebServices(AWS),222,259AndyLeonardagilemodel,40career,34cloudadoption,40–41datacleansingtools,42datawarehouse,35dataprofession,33–34DBAs,39documentationandcommunication,43favoritebooks,43interviewingstyle,45MySQL,41PASSSummit,46professionalskills,38–39recommendationstonewcomers,35socialmedia,46SSIS,41stressmanagementandwork/lifebalance,44typicalday,36–37AndyMallonagilemethodologies,148career,148cloudadoptions,149communitycontributions,155–156conferences,153costsavings,149dataprofession,147documentation,152favoritebooksandblogs,153funnystory,156–157interviewingstyle,154–155ITcareer,147MVPprogram,156SQLServerfeatures,149stressmanagementandwork/lifebalance,154struggles,151technicalissues,151technologies,150third-partytoolsandtechniques,150Ansible,268ApacheKafkaStreams,71–72ApacheSparkStreaming,71ApacheStorm,43ArgenisFernandezcloudadoption,234communitycontributions,242datamigration,237dataprofession,228–229dataservices,232DBAs,requirements,237documentation,240ETL/SSISprocess,233–234favoritebooksandblogs,240–241garbagecollection,231GDPR,236industrytrends,232interviewingstyle,241–242OLTPsystem,233Index348Indexprincipaldatamanagementarchitect,PureStorage,227procurementpatterns,235–236SANadmins,237–239SQLIO,230SSD,230,232storagefootprint,230storagevalidation,230storagevendors,231stressmanagement,241Vdbench,231virtualizationplatform,239VMs,234–235workloads,231–232Artificialintelligence(AI),189AvailabilityGroupsetupguide,57AzureAutomation,54AzureCLI,268AzureCosmosDB,98AzureDataFactory(ADF),40AzureFunctions,165AzureLogicApps,281AzureSQLDataWarehouse,278,281,286BBrentOzar'sblog,104–105BrentOzar'sFirstResponderKit,150,157BrentOzar'sfreetools,311,315BrentOzar'snewsletter,195BusinessIntelligenceMarkupLanguage(Biml),18,21,47Buzzwordbingo,121Buzzwords,50,83,133,247,276,277CCaptainAmericacomicbooks,47TheChecklistManifesto,166Chef,268Cloudadoption,121,149,161–162,188,201–202,211–212,234,248–249,259,265,278–279,293–294,310,322,337–338Cloudera'sengineeringblog,72CosmosDB,82CuratedSQL,64DDatabaseWeekly,190,195DataCamp,86Datacleansingtools,42DataFlowtask,46DataPropulsionLaboratory(DPL),287,290Datasavvy.
me,84Datascience,81DataScienceCentral.
com,90DaveWaldencareer,264cloudadoption,265cloudarchitect,264cloud-managedservice,267communitycontributions,271conflicts,268–269containerization,268dataprofession,263–264designforavailability,265documentation,271favoritebooksandblogs,269industrytrends,268interviewingstyle,270metrics,267securityfeaturesanddataprotection,265–266sizingsystems,266–267stressmanagementandwork/lifebalance,270tools,268virtualmachine,266–267DBATools,205–206Declarativelanguage,56Digitalmarketing,160DrewFurgiueleagilemethodologies,310career,306cloudadoption,310communitycontributions,314–315dataprofession,303–306ArgenisFernandez(cont.
)349Index"dayjob",306documentation,312favoritebooksandblogs,312HASSP,303,307–309industrytrends,306–307interviewingstyle,314issues,311PowerShell,307seniorDBA,IGS,303stressmanagementandwork/lifebalance,313struggles,311superpower,315toolsandtechniques,310–311workinghours,313–314EEssentialism,59,62Excel,181ExecuteSQLtask,45FFarmCreditServicesofAmerica,208,211GGeneralDataProtectionRegulation(GDPR),212,236GingerGrantagileprojects,84BIprofessional,81–82career,79cloudadoption,88–89communication,86communitycontributions,87CosmosDB,82dataprofession,79–80datavisualization,84datawarehouses,88DBA,80documentation,85funnystory,89interviewingstyle,87PowerBI,86Rcode,83SQLServer,82,83stressmanagementandwork/lifebalance,87typicalday,81GlennBerry'sdiagnosticscripts,323,329GlennBerry'sscripts,205–206GoogleGlass,126Grafana,257HHigh-AltitudeSQLServerProject(HASSP),303,307–309The4-HourWorkweek,7IIDERA'sSQLDiagnosticManager,32Impostersyndrome,2,35,36Infrastructureasaservice(IaaS),265,267IT/DevConnections,75,77,214,217JJasonBrimhallAgileandwaterfallapproaches,120career,120cloudadoption,121communitycontributions,128costsaver,121dataprofession,119documentation,125experiences,120favoritebooksandblogs,125–126interviewingstyle,127ITcareer,119SQLServerfeature,122stressmanagementandwork/lifebalance,127struggles,124technicalissues,124–125third-partytoolsandtechniques,122–123two-terabytedatabase,123–124virtualreality(VR),126JesBorlandbigdata,51–53career,49–50cloudservices,52350Indexcommunitycontributions,60–61dataprofession,49–50DBA,58declarativelanguage,56documentationandcommunication,57favoritebooksandblogs,58–59filesystems,57interviewingstyle,60PowerShell,54softwareupdation,55SQLcommunity,61stressmanagementandwork/lifebalance,61–62typicalday,52JimmyMaycloudadoption,293–294community,298–299dataprofession,288–290documentation,295favoritebooksandblogs,296FlashandS2D,292–293habitsandprocurementpatterns,294–295industrytrends,292interestingstory,300interviewingstyle,298jobsecurity,291May'sI/OMantra,290specialization,291–292SQLServerperformance,291stressmanagementandwork/lifebalance,297–298JohnMorehouseagileanddatabaselifecyclemanagement,210agilewithapplicationdevelopment,209career,208cloudadoption,211–212communitycontributions,215databaseversioncontroltools,209–210dataprofession,208datascience,210DBAs,210–211documentation,212favoritebooksandblogs,213funnystory,215incrementsanddevelopmentprocess,209industrytrends,212interviewingstyle,215ITcareer,207MVPprogram,213SQLcommunity,208SQLServertools,214stressmanagementandwork/lifebalance,214toolsandtechniques,213trainingconferences,214JohnQ.
Martinapplicationsupportteam,198businessintelligencedeveloper,198career,197cloudadoption,201–202community,204conflicts,200–201containers,202dataprofession,197DBA,198desktopsupportrole,198DevOps,198,200effectivecommunication,199,201favoritebooks,blogsandmedia,204funnystory,205industrytrends,202MicrosoftDataPlatform,199MVPprogram,205persuasion,204pragmaticmarketingframework,200productmanager,SentryOne,197productsuccess,203SentryOne,201SQLServertechnologies,198strategy,199stressmanagementandwork/lifebalance,204–205successandvalue,200waterfallandagilemethodologies,201JonathanStewartbusinessintelligenceconsultant,SQLLocksLLC,171career,173communitycontributions,179–180databaseadministrator,172dataprofession,172dataqualityissues,177datavisualization,173–176DBAjob,173JesBorland(cont.
)351Indexdocumentation,178favoritebooksandblogs,178funnystory,180interviewingstyle,179ITcareers,172–173ITtools,177Microsoft,Tableau,andClick,177SQLLOCKS,172storytelling,176stressmanagementandwork/lifebalance,178toolsandtechniques,178trainingprograms,180JosephFlemingagilemethodologies,334–335career,333–334cloudadoption,337–338communitycontributions,343–344databaseproblems,333dataprofession,332documentation,339–340funny/interestingstory,344–345industrytrends,339interviewingstyle,342–343issues,336–337ITcareer,331networkengineers,337stressmanagementandwork/lifebalance,340–342toolsandtechniques,335–336JosephSackadaptivequeryprocessing,187–188artificialintelligence,189cloudadoption,188communitycontributions,192–193conflicts,187contextswitching,191CRMtool,185dataprofession,184datascience,189datavisualization,191favoritebooksandblogs,190feedback,185jobhistory,183overtime,186persuasion,189practices,186principalprogrammanager,Microsoft,183productmanager,186psychologydegree,184–185SQLServerandAzureSQLServerdatabase,186SQLskills,190storytelling,193–194stressmanagementandwork/lifebalance,190visualizationworkshops,191waterfallandagilemethodologies,188JulieSmithagilemodel,16BIbestpractices,15career,13cloudadoption,17Datachixblog,20dataprofession,12datavisualization,15documentationandcommunication,16favoritebooksandblogs,18interviewingstyle,19SSISpackages,14–15stressmanagementandwork/lifebalance,19successfulbusiness,17technologytrends,14theaterdegree,12toolsandtechniques,18typicalday,13K,LKafkaStreams,71–72KathiKellenbergerarticles,222bachelor'sdegree,219career,220careerdecisions,221conferences,224dataprofession,220Developers,SANadmins,andnetworkfolks,223documentation,223editorofSimpleTalk,RedgateSoftware,219education,221favoritebooksandblogs,224funnystory,226jobstruggles,222–223352IndexMVPprogram,225stressmanagementandwork/lifebalance,224–225toolsandtechniques,222T-SQL,222typicalday,221KendraLittleagilemethodologies,111communitycontributions,114–115dataprofession,107documentation,113experiences,108–109favoritebooksandblogs,113founderofSQLWorkbooks,107funny/interestingstory,115–116interviewingstyle,113–114Microsoft,108nontechnicaltraits,114struggles,112suggestions,109teachingandpresentingskills,110tools,112KendraLittle'sSQLWorkbooks,224,226KennethFisheragilemodel,27career,24dataprofession,24DBAbestpractices,26favoritebooksandblogs,29forums,24–25industrytrends,26interviewingstyle,29–30monitoringtools,28ServiceBrokercertification,30stressmanagementandwork/lifebalance,29toolsandtechniques,28typicalday,25–26KevinFeaselanalyticalskills,66ApacheKafkaStreams,71ApacheSparkStreaming,71career,65clouddeployments,68–69datavisualization,70dataprofession,64DBA,64documentationandcommunication,71–72education,63interviewingstyle,73MVPprogram,76OpX,69phasewalking,76scrum,66–67SQLSaturdays,75teammanagement,66typicalday,66Kinesis,69KirstenBenzelagilemethodologiesandbusinessintelligence,248analytics,bigdata,andbuzzwords,247career,246cloudadoption,248–249dataprofession,245dataqualityissues,249datavisualization,247documentation,250–251favoritebooksandblogs,251funnystory,253interviewingstyle,253seniordatabaseengineer,SurveyMonkey,245storytelling,247–248stressmanagementandwork/lifebalance,251–253toolsandtechniques,250Knoldusblog,72MMachineLearningServices,83ManagementInformationSystems(MIS),332ManagingGeeks,44MarlonRibunalagilemethodologies,321–322bestpractices,320career,318–319cloudadoption,322communitycontributions,328dataprofession,318documentation,325favoritebooksandblogs,325–326industrytrends,319–320KathiKellenberger(cont.
)353Indexinterviewingstyle,327–328issues,324–325ITcareer,317stressmanagementandwork/lifebalance,326–327struggles,323–324superpower,328toolsandtechniques,322–323typicalday,319worstpractices,320–321Massiveopenonlinecourse(MOOC),290MattGordonagileandbusinessintelligence,277–278analyticsanddatavisualization,275–276buzzwords,276–277career,274–275cloudadoption,278–279communitycontributions,284dataprofession,273dataqualityissues,280–281DBAs,274documentation,282favoritebooksandblogs,282–283funnystory,284–285interviewingstyle,283–284ITcareer,273OracleandSQLServer,281storytelling,280stressmanagement,283technologicalchallengeandcommunity,279–280technologiesinbigdataBI,281toolsandtechniques,281MicoYuk'sblog,86,90MicrosoftCertifiedDatabaseAdministrator(MCDBA),256MicrosoftCertifiedMaster(MCM),287,296MicrosoftCertifiedSolutionsExpert(MCSE)certification,256MicrosoftCommercialInternetSystem,228MicrosoftConsultingServices(MCS),289MicrosoftMVPGlobalSummit,156–157MicrosoftSQLServerMVP,343MicrosoftStack,167MicrosoftTechnologysolutionsprofessionals(TSPs),343MicrosoftTrustCenter,266MindyCurnuttagileanddatabaseadministration,7career,2–3cloudadoption,6–7databasebestpractices,5–6dataprofession,2–3DBAinterview,8economicsdegree,2favoritebooksandblogs,7–8funnystory,9impostersyndrome,2stressmanagement,8technologytrends,4toolsandtechniques,7typicalday,3–4Minion,32Moore'slaw,235MorningDew,59MSSQLTips,204MVPprogram,76,156,205,225MySQL,41NNetpromoterscore(NPS),98–99NorwegianDevelopersConference(NDC),75Notepad,250Notepad++,214,217OOlaHallengren'smaintenancetools,150,157OlaHallengren'sSQLServerMaintenanceSolution,62"Old-fashioned"penandpaper,181Onlineanalyticalprocessing(OLAP)model,137Onlinetransactionprocessing(OLTP)system,233,290OpX,69Organizedlibrary,6354IndexP,QPascaldatabase,92PASSLinuxmarathon,261PASSSummit,10,32,157,180–181,206–207,214,217,224,260,262,279,333–334,343PaulRandal'sWaitStatistics,323,329Personallyidentifiableinformation(PII),339Phoenix,122,174ThePhoenixProject,166Plant-WideWebs(PWW),38Pluralsight,104,105,259,262PowerBI,15,38–39,47,136,161,171,174–175,177–178,180–181,275,281,286PowerShell,54,62,268,307,310–311ThePracticalDevblogseries,101,105Pragmaticmarketingframework,200Puppet,268PyCon,75,77RRedgatesourcecontrolproduct,210,217RedgateSQLCompare,250,254RemoteDesktopConnectionManager,336,346RemoteDesktopProtocol(RDP),54Restoresystem,5RMLUtilities,205–206SSaaSsoftware,97SANadministrators,211Science,technology,engineering,mathematics(STEM),246Scrum,40,67SentryOne'sPlanExplorer,7,10,122–123,128,150,157,201,205–206,214,217,311,315ServerManagementStudio,74ServiceBrokercertification,30SkypeforBusiness,86Snagit,213,217SofterraLDAPbrowser,250,254SolarWindsDatabasePerformanceAnalyzer(DPA),323,329SparkStreaming,71sp_Blitz,323,329sp_BlitzCache,323sp_BlitzIndex,323TheSpecialSupplementalNutritionProgramforWomen,Infants&Children(WIC),277Spinnakertool,98sp_whoisactive,32,54,62,150,157,323,329,336,346SQLBits,180–181,199,206,224,299SQLMicrosoftCertifiedMaster,188SQLMonitor,323,329SQLPASS,256,299SQLPrompt,122,128,322,329SQLProvision,123,128SQLSaturdays,10,25,32,44,75,77,122,147,153,155–157,171,177,179–181,204,206,207,209,214,215,217,225,229,251,256,260–262,271,279,284,299SQLSearch,214,217SQLServer2017,4SQLServerCentral.
com,90,224,226SQLServercommunity,192SQLServerCustomerAdvisoryTeam(SQLCAT),287,289,293,295SQLServerDataTools,209,217SQLServerExtendedEvents,10SQLServerIntegrationServices(SSIS),14–15,21,41,47SQLServerManagementStudio(SSMS),28,32SQLServer'sTDS,234SQLskills.
com,190,195,224,226,256,262355IndexSSISCatalog,37,42SSMSToolsPack,214,217StealtheShow,8StephLockeagileandbusinessintelligence,164analyticsandvisualization,161burgervan,160businessintelligenceanddatascience,159challengesinanalytics,162–163cloudadoption,161–162communitycontributions,167dataqualityissues,163datascienceconsultant,LockeData,159defaultvalues,166digitalmarketing,160documentation,165–166Excelsolution,160favoritebooksandblogs,166funnystory,168JavaScript,161newtechnologies,bigdata,165PowerPivotandPowerView,161productanalyst,160storytelling,163stressmanagementandwork/lifebalance,167TribalSQL,161SublimeText,250,254Switch,8TTableau,161,281TEDTalk,253Telgraf,257Terraform,268TimCostelloagileandbusinessintelligence,134agilemethodology,135bigdataandbuzzwords,133career,132communication,139–140communitycontributions,141–142dataarchitect,129dataprofession,130–131datawarehouseprojects,134–135documentation,138–139favoritebooksandblogs,142–143funnystory,143–145interviewingstyle,140–141skillsforbusinessintelligenceandanalytics,132–133SSISandSSAS,137–138stressmanagementandwork/lifebalance,140technologiesinBI,137tools,datavisualization,136Toggl,214TracyBoggianoagilemethodologies,256automationtrends,258career,256cloudadoption,259communitycontributions,261–262conferences/training,260DatabaseSuperhero,Broadvine,255dataprofession,255–256documentation,258favoritebooksandblogs,259industrytrends,258interviewingstyle,260–261practices,259stressmanagementandwork/lifebalance,260struggles,257superpower,262toolsandtechniques,257Transact-SQL(TSQL),18,21,53Trello,213TribalSQL,64,161T-SQLFundamentals,246T-SQLTuesdayblog,100,105UUSDepartmentofDefense(DoD),278VVdbench,231VickyHarpagilemethodology,97AirOntario1363,101career,91–92356Indexcloudadoption,97Columbiareport,101cross-functionalteams,93–95dataprofession,92–93documentation,99–100Microsoftworkingexperience,93multimodelapproaches,98NPS,98–99Pascaldatabase,92pragmaticmindset,103productmanagement,96scoliosis,104SQLSaturday,104stressmanagementandwork/lifebalance,101successvalues,95tempdb,99tools,98trainingprograms,104treehouseinMicrosoft,102waterfallmethodology,97VisualStudioTeam(VSTS),268W,X,Y,ZWaterfallmethodology,27,97WeSpeakLinux.
com,262Wonderware,34VickyHarp(cont.
)