All the mistakes you might make with SQL Server—and how to avoid them! 100 SQL Server Mistakes and How to Avoid Them prepares you for the pitfalls database professionals often encounter—from administration to development, availability, and security. You'll learn to sidestep common errors that slow down your T-SQL code and ensure your SQL Server is installed and configured to handle anything your organization throws at it. Inside 100 SQL Server Mistakes and How to Avoid Them you'll learn to avoid: Development errors when writing T-SQL Installation and administration mistakes Optimization missteps Common pitfalls relating to high availability and disaster recovery (HA/DR) Security oversights that can endanger your data 100 SQL Server Mistakes and How to Avoid Them doesn't focus on the "happy path"—instead, it covers all the errors and problems you might face as a SQL Server developer or administrator. Each chapter is filled with real-world issues drawn from author Peter A. Carter’s two-decade-long career in SQL Server. Peter's seasoned advice helps dispel myths, debunk misconceptions, and set you on the right road. About the Technology Perfecting a SQL Server system can be a complex balancing act. Why is T-SQL running so slowly? Are the right data available? Are we protected against data theft? What about that new server instance I need to administer? Even the most skilled SQL Server experts make mistakes that cost time and performance. This book can help you get it right the first time. About the Book 100 SQL Server Mistakes and How to Avoid Them focuses exclusively on the errors that you might—and probably will—make as a SQL Server admin or developer. Real-world examples, code samples, and helpful diagrams make it easy to understand each issue and its solution. You’ll learn how to write performant code, design efficient database schemas, implement error handling, work with complex data types, and much more, all in a friendly, common-sense problem/solution format. What's Inside T-SQL development Installation, administration, and optimization High availability and security About the Reader Readers need to understand basic SQL Server concepts and SQL queries. Perfect for junior database admins, full-stack developers, and “accidental” DBAs. About the Author Peter A. Carter is a SQL Server expert with experience developing, administering, and architecting data-tier applications and SQL Server platforms. Quotes A masterful job! Covers the nuances of SQL Server that a new admin, or even an experienced one, needs to understand. - Allen White, SQL Server MVP 2007-2022 Quick, actionable advice that greatly improved my SQL Server skills. - Ruben Vandeginste, PeopleWare A practical path through pitfalls in administration and development with specific solutions, examples, and code snippets. - Josephine Bush, sqlkitty.com Worth reading for the testing and debugging section alone! - Mike McQuillan, McQTech Ltd.

This keynote panel, featuring Bryan Bischof, Head of AI at Hex, and Chris White, CTO at Prefect, will explore what it takes to launch AI-based products in the context of running a successful, non-AI startup. Hear in-the-trenches insights and hot takes from these two product leaders as they discuss how to create an AI strategy, how to (actually) move into production, and how to measure success. Conversation will be moderated by Brittany Walker, Principal at CRV.

Recorded live in San Francisco at the AI Engineer Summit 2023. See the full schedule of talks at https://ai.engineer/summit/schedule & join us at the AI Engineer World's Fair in 2024! Get your tickets today at https://ai.engineer/worlds-fair

Brittany Walker Brittany Walker is a principal at CRV, an early-stage venture capital firm known for leading investments in companies such as Airtable, Vercel, Cribl, and Postman, among others. She specializes in data infrastructure and AI/ML infrastructure, and works with the founders of promising early-stage startups including Doppler, Meilisearch, Impart Security, and Lokalise.

Chris White Chris White is a cofounder of Prefect, a data workflow orchestration and observability platform, for which he currently serves as the Chief Technology Officer. Chris began his journey into software while getting his PhD in Mathematics at the University of Texas at Austin, where he researched optimization guarantees for non-convex data-driven problems. In addition to his work at Prefect, Chris is an active angel investor in AI and developer tooling. Outside of tech Chris is also passionate about the ocean, literature, and is an avid runner.

Bryan Bischof Dr. Bryan Bischof leads AI at Hex, and is an adjunct professor in the Rutgers Masters of Business and Analytics program where he teaches Data Science. Previously, he was the Head of Data Science at Weights and Biases, and built the DS, ML, and Data Engineering teams. Before that he built ML products at Stitch Fix, Blue Bottle Coffee, and IBM. He recently co-authored the O’Reilly book Building Production Recommendation Systems. His data visualization work appeared in the popular book The Day it Finally Happens by Mike Pearl. His Ph.D. is in pure mathematics.

On this episode, we chat with Emily White, a music industry veteran who started her career as a world class tour manager before retiring at 23 to pursue artist management, entrepreneurial endeavors, and academia. Emily has worked with everyone from Dinosaur Jr. to Zac Brown Band, she’s founded and run multiple entertainment companies, released a number of books, and now, when she’s not teaching at NYU’s Tisch School of the Arts, Emily is using music data analytics to help activate voters for the upcoming presidential election in November. The #iVoted initiative, which Emily founded with Madison House co-founder Mike Luba and Wilco’s Pat Sansone, is gearing up to be one of the biggest digital music festivals ever, with dozens of artists performing via webcast nationwide. The cost of admission for fans? A selfie from home with their mail-in ballot or a photo from outside their polling place, though we strongly encourage the former. For a full list of artists performing on Nov. 3, check out iVotedConcerts.com, and full disclaimer: Chartmetric is a proud data partner of the #iVoted initiative. Connect With Emilyhttps://twitter.com/emwizzle https://twitter.com/iVotedConcerts https://twitter.com/collectiveent_ https://www.instagram.com/collectiveentinc/ Connect With Ushttp://podcast.chartmetric.com/http://chartmetric.com/https://blog.chartmetric.comhttps://smarturl.it/chartmetric_social

In this session, Mike Flowers, Chief Analytics Officer, Enigma, sat with Vishal Kumar, CEO AnalyticsWeek and shared his journey as an analytics executive, best practices, hacks for upcoming executives, and some challenges/opportunities he's observing as a Chief Analytics Officer. Mike discussed his journey from trial prosecutor to Chief Analytics Officer, sharing some great stories on how Govt. embraces data analytics.

Timeline: 0:29 Mike's journey. 23:32 Mike's role in Enigma. 27:46 The role of CAO in Enigma. 29:50 How much Mike's role is customer-facing vs. in facing. 30:00 Getting over the roadblocks of working with the government. 34:06 Creating a data bridge. 39:17 Collaboration in the data science field. 46:02 Challenges in working with Clients at Enigma. 51:34 Benefits of having a legal background before coming to data analytics.

Podcast link: https://futureofdata.org/enigma_io/

Here's Mike Flowers Bio: Mike is Chief Analytics Officer at New York City tech start-up Enigma, an operational data management and intelligence company, where he leads data scientists assisting the development and deployment of decision-support technologies to Fortune 500 clients in compliance, manufacturing, banking, and finance, and several U.S. and foreign government agencies. In addition, he is a Senior Fellow at Bloomberg Philanthropies, working with select U.S. city governments to launch sustainable analytics programs. Mike is also an advisor to numerous organizations in a wide variety of fields, including, for example, Weil Cornell Medical College, the Inter-American Development Bank, the Office of the New York State Comptroller, the Greater London Authority, the government of New South Wales, Australia, and the French national government.

From 2014-15, Mike was an Executive-in-Residence and the first MacArthur Urban Science Fellow at NYU’s Center for Urban Science and Progress, where he advised students and faculty on projects to advance data-driven decision-making in city government.

From 2009-2013, Mike served under Mayor Michael Bloomberg as New York City’s first Chief Analytics Officer. During his tenure, he founded the Mayor’s Office of Data Analytics, which provides quantitative support to the city’s public safety, public health, infrastructure development, finance, economic development, disaster preparedness and response, legislative, sustainability, and human services efforts. In addition, Mike designed and oversaw the implementation of NYC DataBridge, a first-of-its-kind citywide analytics platform that enables the sharing and analysis of city data across agencies and with the public, and he ran the implementation of the city’s internationally-recognized Open Data initiative. For this work, Mike was twice recognized by the White House for innovation.

Follow @mpflowersnyc

The podcast is sponsored by: TAO.ai(https://tao.ai), Artificial Intelligence Driven Career Coach

About #Podcast:

FutureOfData podcast is a conversation starter to bring leaders, influencers, and lead practitioners to discuss their journey to create the data-driven future.

Want to Join? If you or any you know wants to join in, Register your interest @ http://play.analyticsweek.com/guest/

Want to sponsor? Email us @ [email protected]

Keywords:

FutureOfData #DataAnalytics #Leadership #Podcast #BigData #Strategy