Prototyping is my favorite part of programming. I like building new stuff and getting things working. It’s no surprise, then, that I am a big fan of MongoDB and NoSQL in general. Don’t get me wrong: I ...
A PostgreSQL's plpgsql interpreter uses a two step checking. First step is syntax checking when function is validated - it is done on function's creation time or when function is executed first time ...
Database administrator with 14+ years of hands-on experience in database management and database design. After spending 15 years as a SQL Server DBA, I've witnessed numerous technological evolutions, ...
The primary key column is often set to auto-increment when constructing a SQL Server database. To achieve this, the IDENTITY property is enabled on the primary key column. The starting value and ...
Community driven content discussing all aspects of software development from DevOps to design patterns. Once you’ve installed SQLite, you’ll probably want to learn how to maneuver around the ...
I am starting this new year the same way I ended the last: taking antibiotics because my biological daughter brought home a nasty sinus bug from Carnegie Mellon’s preschool. This was after my first ...