background preloader

Ten Common Database Design Mistakes

Ten Common Database Design Mistakes
No list of mistakes is ever going to be exhaustive. People (myself included) do a lot of really stupid things, at times, in the name of “getting it done.” This list simply reflects the database design mistakes that are currently on my mind, or in some cases, constantly on my mind. I have done this topic two times before. Before I start with the list, let me be honest for a minute. So, the list: Poor design/planning Ignoring normalization Poor naming standards Lack of documentation One table to hold all domain values Using identity/guid columns as your only key Not using SQL facilities to protect data integrity Not using stored procedures to access data Trying to build generic objects Lack of testing Poor design/planning “If you don’t know where you are going, any road will take you there” – George Harrison Prophetic words for all parts of life and a description of the type of issues that plague many projects these days. Ignoring Normalization Are there always 12 payments? Maintainability Related:  shiny stuff

Five simple database design tips A flawed database can affect all areas of your application, so getting the design right is of paramount importance. Check out Builder's five simple design tips, and share some of your own. If an enterprise’s data is its lifeblood, then the database design can be the most important part of an application. I’ll get the show started by listing my five favorite tips and giving a brief explanation of the rationale behind each one. #1: Use meaningful field namesI once worked on a project I inherited from another programmer who liked to name fields using the name of the onscreen control that displayed the data from that field. Unless you are using a system that restricts you to short field names, make them as descriptive as possible—within reason, of course. #2: Do your homeworkNot only should you research your business needs when designing a new database, you should check out the existing system, as well. Restrict the user from editing the field after the record’s creation.

Unity 3 – April 2013 patterns & practices Developer Center April 2013 Unity is a lightweight, extensible dependency injection container with support for instance and type interception. Overview Unity is a lightweight, extensible dependency injection container with support for constructor, property, and method call injection. Simplified object creation, especially for hierarchical object structures and dependencies. Unity is a general-purpose container for use in any type of Microsoft.NET Framework-based application. In addition, Unity is extensible. This release adds support for Windows Store apps as well as the registration by convention feature to ease the task of configuring Unity. Audience Requirements These reusable components and guidance are intended primarily for software developers and software architects. Contents of This Release Microsoft Unity 3 contains the following: Binaries. System Requirements Supported architectures: x86 and x64. For a rich development environment, the following are recommended:

c# - Best Practices of fault toleration and reliability for scheduled tasks or services Codecademy Labs Audit and document Security User Rights Assignment using C# | Network Audit and Documentation, CENTREL Solutions Blog For more information on the Windows Server documentation abilities of XIA Configuration please see the following We've recently been asked about the auditing of User Rights Assignment as seen in the Local Group Policy Editor. Having looked into this issue it is apparent that this cannot be done with any high level API such as WMI and requires the use of P/Invoke and the Win32 method LsaEnumerateAccountsWithUserRight. I've seen many posts on the Internet on the topic but I haven't seen a simplified example of this in use so have writen a quick C# sample application to enumerate the various rights and privileges and display the users assigned to that right in a grouped listview as per the screenshot below. This can be downloaded from our web site in Visual Studio 2010 The sample supports the following Document and Audit User Rights Assignment with XIA Configu

Your Personal PLC Tutor Site - RS232 Communications/software Learn quickly with our PLC Training DVD Series: on sale $599.00 $379 Click here now for details! RS-232 Communications (software) Now that we understand the hardware part of the picture, let's dive right into the software part. We'll take a look at each part of the puzzle by defining a few of the common terms. ASCII is a human-readable to computer-readable translation code. The picture below shows how data leaves the serial port for the character "E" (45h 100 0101b) and Even parity. Another important thing that is sometimes used is called software handshaking (flow control). The last thing we should know about is delimiters. Sometimes an STX and ETX pair is used for transmission/reception as well. Finally, we might also come across an ACK/NAK pair. RS-232 has a lot of information to absorb, so feel free to reread it.

agile SE-Radio Episode 307: Harsh Sinha on Product Management Bryan Reinero talks with Harsh Sinha, VP of Engineering at TransferWise, about Product Management. Product Management deals with the planning, delivery and marketing of a software product. The discussion covers how those functions are achieved, and how product management interfaces with engineering; how product requirements are derived from customer needs; how teams build product based […] Continue Reading » SE-Radio Episode 306: Ron Lichty on Managing Programmers Ron Lichty talks with SE-Radio’s Nate Black about managing programmers. Continue Reading » SE-Radio Episode 280: Gerald Weinberg on Bugs Errors and Software Quality Marcus Blankenship talks with Gerald Weinberg about software errors, the fallacy of perfection, how languages and process can reduce errors, and the attitude great programmers have about their work. Continue Reading » SE-Radio Episode 253: Fred George on Developer Anarchy Continue Reading » Continue Reading »

Episode 253 | Kyle Scarmardo - Motivation Matters Kyle Scarmardo talks with Dave Rael about being deliberate with your time, the importance of self-awareness, coaching and mentoring, and taking action Kyle spent sixteen years in the Information Technology space for a large financial company, the 20th largest private company in America, where he worked his way up from the bottom to become an executive in 13 years at the age of 35. The latter part of his career heavily involved helping others with self-improvement, career growth, improving executive function, applying new strategies to better communicate and influence, and assist with culture change. In this work Kyle tapped into a passion that ultimately would pull him away from a full time focus on technology. Kyle now spends more time assisting others looking to accelerate their careers, become more effective leaders, and take self-improvement to a deeper introspective level.

Related: