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 58m
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.
Never did I think that I'd be able to run SQL Server on my Mac. My, how times have changed.
3 Comments
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 discovered my love for online learning when I was struggling in a web design class in college. Out of desperation I found CSS Fundamentals by James…
I discovered my love for online learning when I was struggling in a web design class in college. Out of desperation I found CSS Fundamentals by James…
Liked by Adam Wilbert
-
Just completed the “SQL Server: Reporting Services” course by Adam Wilbert! Gained valuable insights into leveraging SSRS for advanced reporting and…
Just completed the “SQL Server: Reporting Services” course by Adam Wilbert! Gained valuable insights into leveraging SSRS for advanced reporting and…
Liked by Adam Wilbert
-
Just finished the course "Microsoft SQL Server 2022 Essential Training" by Adam Wilbert! Check it out: https://lnkd.in/d6GgPG_v #microsoftsqlserver.
Just finished the course "Microsoft SQL Server 2022 Essential Training" by Adam Wilbert! Check it out: https://lnkd.in/d6GgPG_v #microsoftsqlserver.
Liked by Adam Wilbert
Experience & Education
-
LinkedIn
View Adam’s full experience
See their title, tenure and more.
or
Licenses & Certifications
Publications
Languages
-
English
-
Organizations
-
NACIS - North American Cartographic Information Society
NACIS News Coordinator
-
More activity by Adam
-
I'm thrilled to share that I have successfully completed Database Foundations: Intro to Databases. A big thank you to Adam Wilbert for the valuable…
I'm thrilled to share that I have successfully completed Database Foundations: Intro to Databases. A big thank you to Adam Wilbert for the valuable…
Liked by Adam Wilbert
-
I am thrilled to share that I have completed the DBeaver Essential Training by Adam Wilbert on LinkedIn Learning This comprehensive course has…
I am thrilled to share that I have completed the DBeaver Essential Training by Adam Wilbert on LinkedIn Learning This comprehensive course has…
Liked by Adam Wilbert
-
Just finished the course “SQL Server Integration Services” by Adam Wilbert, and I’m thrilled to have deepened valuable skills in designing ETL…
Just finished the course “SQL Server Integration Services” by Adam Wilbert, and I’m thrilled to have deepened valuable skills in designing ETL…
Liked by Adam Wilbert
-
> At a time when Elon Musk and Mark Zuckerberg have shown that the whims of one person can upend an entire social network, Mastodon’s CEO and…
> At a time when Elon Musk and Mark Zuckerberg have shown that the whims of one person can upend an entire social network, Mastodon’s CEO and…
Liked by Adam Wilbert
-
Find out how to advance your organization with industry-leading AI and cloud services.
Find out how to advance your organization with industry-leading AI and cloud services.
Liked by Adam Wilbert
-
I'm excited to share that I've completed the "PostgreSQL Essential Training" course by Adam Wilbert on LinkedIn Learning. This course provided me…
I'm excited to share that I've completed the "PostgreSQL Essential Training" course by Adam Wilbert on LinkedIn Learning. This course provided me…
Liked by Adam Wilbert
Other similar profiles
-
Ray Villalobos
Prompt Engineer, Vibe Code Enthusiast and AI Evangelist. LinkedIn Top Voice. Staff Instructor at LinkedIn, Instructor at Stanford University.
Connect -
Amy Balliett
Connect -
Chris Orwig
Photographer + Creative Director + Author + Ambassador + Educator + Content Creator
Connect -
Jody Campbell
Assistant Professor Of Communication Design at Milwaukee Institute of Art & Design
Connect -
Brad Batesole
Connect -
Petrula VRONTIKIS
Connect -
Kate Kennen
Owner, RLA
Connect -
Paul Marsh
Connect -
Kathleen J. Shields
Owner of Kathleen's Graphics
Connect
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