webcast signup header

Development Best Practices for SQL Server


I always think of best practices as being a combination of using industry standard ideas (source control, for example), using positive design patterns specific to SQL Server, and avoiding the many pitfalls that can affect any application that uses a database. It's also complicated by two big things; the tendency to think there is only one right way to do things and the database being the hardest part to change once it's in use.

This presentation will give an overview of these things, but focus on best practices for SQL Server that I think are reasonable and useful based on a lot of experience. Some of it requires just learning rules (be wary of functions) and some of it requires you to understand how SQL Server works so that you can work with the platform instead of against it. My approach is to show things I think work and why this will give you a starting point for seeing what works for you and your applications in the real world.

We'll cover quite a few areas from coding to design to testing, so there should be something here for DBA’s, developers, and managers.

Webcast Date

Tuesday, April 13, 2021
3:00:00 PM EDT (New York) | 7:00:00 PM UTC

Speaker(s)

presenter 1
Andy Warren is a SQL Server consultant based in Orlando. Andy was a founding principal of SQLServerCentral.com, is the former President of the Orlando SQL Server Users Group, and one of the founders of SQLSaturday. He has been an MVP since 2009 and has written and presented extensively SQL Server. Andy blogs at www.sqlandy.com, is on LinkedIn at www.linkedin.com/in/sqlandy, and is occasionally on Twitter as @SQLAndy.

Sponsored by

sponsor logo


Register for this webinar:

First Name*


Last Name*


Business Email*


Organization*


Org Address*


Org City*


Org State


Org Postal Code*


Org Country*


Org Phone*


Industry*


Job Title*


# of SQL Servers*


Organization Size*


SMS reminder
carrier: number: (5551234567)


Save My Details

Register me for these webinars too:

 
Keeping Your SQL Servers Running Strong
Thursday, April 15, 2021 - 1:00:00 PM EST
Speaker(s): Joey DAntoni - Sponsor: dbWatch

 
Moving SQL Server workload to the cloud
Thursday, April 22, 2021 - 1:00:00 PM EST
Speaker(s): Anat Dror - Sponsor: Quest

 
Indexing for Performance: Query Strategies to Maximize Your SQL Server Indexes
Tuesday, April 27, 2021 - 1:00:00 PM EST
Speaker(s): Kevin Kline and Thomas LaRock - Sponsor: SolarWinds

 
SQL Server Architecture Options for Disaster Recovery and High Availability
Thursday, April 29, 2021 - 1:00:00 PM EST
Speaker(s): Mike Walsh and Dave Bermingham - Sponsor: SIOS

 
Smashing SQL Server Silos with DreamFactory
Tuesday, May 04, 2021 - 1:00:00 PM EST
Speaker(s): Jason Gilmore - Sponsor: DreamFactory

 
Identify SQL Server Performance Problems Quickly and Efficiently
Thursday, May 06, 2021 - 1:00:00 PM EST
Speaker(s): Franklin Yamamoto - Sponsor: SQLGrease

 
Database Farm Management Solution from dbWatch
Thursday, May 13, 2021 - 1:00:00 PM EST
Speaker(s): Per Christopher Undheim - Sponsor: dbWatch

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


 
 


Copyright (c) 2006-2021 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.