Courses by Adam
-
SQL Server Machine Learning Services: Python2h 31m
SQL Server Machine Learning Services: Python
By: Adam Wilbert
-
Microsoft SQL Server 2019 Essential Training4h 24m
Microsoft SQL Server 2019 Essential Training
By: Adam Wilbert
Articles by Adam
-
Get started with SQL Server on MacOS, complete with a native GUI.
Get started with SQL Server on MacOS, complete with a native GUI.
By Adam Wilbert
Contributions
-
What are the most effective ways to avoid database errors?
Leveraging "warm standby" servers is another way to protect your database from potentially damaging failures and costly outages. By maintaining a second, synced copy of the entire system on another device, the warm standby can step in and assume read/write responsibilities at a moments notice should the primary database go offline. As a bonus, this secondary replica can often serve as a read-only access point for reporting and analysis tasks, so that these activities don't impact the performance of your primary database.
-
What are the most effective ways to avoid database errors?
While consistency is the most important thing to keep in mind when naming objects, you should also take into consideration the standard format for the particular platform you're using. PostgreSQL databases for example tend to use `snake_case` object names, where SQL Server databases typically use `PascalCase` names. Sticking with the platform's preferred format will make maintenance easier.
-
What are some best practices for naming and labeling your database entities and attributes?
I often see columns named "Date" which is a clear reserved word conflict with the SQL date datatype. Beyond this though, a "date" column isn't very descriptive anyway. Consider "OrderDate," "ShipDate," "DeliveryDate," "BirthDate" or "HireDate" as much more descriptive column names.
Activity
-
I recently completed the “PostgreSQL Essential Training” course by Adam Wilbert! This course gave me a solid understanding of PostgreSQL and…
I recently completed the “PostgreSQL Essential Training” course by Adam Wilbert! This course gave me a solid understanding of PostgreSQL and…
Liked by Adam Wilbert
-
Just finished "Machine Learning with Python: k-Means Clustering" by Frederick Nwanganga! Check it out: https://lnkd.in/eawFysgn #python…
Just finished "Machine Learning with Python: k-Means Clustering" by Frederick Nwanganga! Check it out: https://lnkd.in/eawFysgn #python…
Liked by Adam Wilbert
-
One of the biggest issues I frequently have with recording #LinkedinLearning courses at home occurs when a cat secretly sneaks into the booth with…
One of the biggest issues I frequently have with recording #LinkedinLearning courses at home occurs when a cat secretly sneaks into the booth with…
Shared by Adam Wilbert
Experience
-
-
-
-
-
-
-
Education
Licenses & Certifications
Publications
Languages
-
English
-
Organizations
-
NACIS - North American Cartographic Information Society
NACIS News Coordinator
-
More activity by Adam
-
It’s been a while since my last post, so I wanted to share an update on my career since leaving LinkedIn in December 2023. This year has been a mix…
It’s been a while since my last post, so I wanted to share an update on my career since leaving LinkedIn in December 2023. This year has been a mix…
Liked by Adam Wilbert
-
I can’t believe it has been 8 years since I started writing my first LinkedIn Learning Course. After recording I think 29 courses in that time on…
I can’t believe it has been 8 years since I started writing my first LinkedIn Learning Course. After recording I think 29 courses in that time on…
Liked by Adam Wilbert
Other similar profiles
Explore collaborative articles
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
Explore More