search
Follow Topic rss_feed

Useful links, scripts, tools and best practice for Microsoft SQL Server Database

Bharat Dwarkani shared on Nov 30, 2019
image
github.com
bookmarks
share
favorite_border0 visibility2
favorite_border0 visibility2 share bookmarks

Naming convention is a set of rules for choosing the character sequence to be used for identifiers which denote variables, types, functions, and other entities in source code and documentation.

Bharat Dwarkani shared on Nov 30, 2019
image
github.com
bookmarks
share
favorite_border0 visibility5
favorite_border0 visibility5 share bookmarks

In an effort to make my team write better SQL, written by non-developers and code reviews, and gathered common mistakes and missed optimization opportunities in SQL.

Bharat Dwarkani shared on Nov 23, 2019
image
hakibenita.com
bookmarks
share
favorite_border0 visibility2
favorite_border0 visibility2 share bookmarks

The public cloud is making a huge impact on the way enterprises host, manage, and scale their database operations. They’ve been freed from the scalability constraints of their on-premise systems. They can provision new infrastructure at the click of a button, without a lengthy hardware procurement process. They no longer need large, upfront capital investments to launch new IT projects. And they’re taking advantage of new, cloud-oriented technologies when storing and analyzing their data.

Bharat Dwarkani shared on Nov 07, 2019
image
logz.io
bookmarks
share
favorite_border0 visibility2
favorite_border0 visibility2 share bookmarks

One nice thing about PGSQL is it comes with some utility binaries like createuser and createdb. So we will be making use of that.

Bharat Dwarkani shared on Nov 03, 2019
image
link.medium.com
bookmarks
share
favorite_border0 visibility1
favorite_border0 visibility1 share bookmarks

FINE TUNING FULL TEXT SEARCH WITH POSTGRESQL 12

Bharat Dwarkani shared on Nov 02, 2019
image
rob.conery.io
bookmarks
share
favorite_border0 visibility1
favorite_border0 visibility1 share bookmarks

Among the plethora of notable users of PostgreSQL are Reddit, Skype, Instagram, Tripadvisor, Met Office, Sony Online, BASF, Grofers and many more. These users are using PostgreSQL at an unprecedented scale.

Bharat Dwarkani shared on Nov 02, 2019
image
citrusleaf.in
bookmarks
share
favorite_border0 visibility2
favorite_border0 visibility2 share bookmarks

Postgres is our favorite database system. No wonder, Postgres is world’s most advanced open source database! We’ll talk about some of the most powerful but rather lesser used features and aspects of Postgres in this post.

Bharat Dwarkani shared on Nov 02, 2019
image
citrusleaf.in
bookmarks
share
favorite_border0 visibility3
favorite_border0 visibility3 share bookmarks

Everyone was jumping on the bandwagon of NoSQL and we kept on the SQL side.

Bharat Dwarkani shared on Nov 02, 2019
image
link.medium.com
bookmarks
share
favorite_border0 visibility1
favorite_border0 visibility1 share bookmarks

MySQL joins are used to fetch data from multiple tables. We can call it as a method for fetching records from one or more tables based on some common values in the table.

Mishel Vettukattil shared on Oct 19, 2019
image
geekinsta.com
bookmarks
share
favorite_border0 visibility4
favorite_border0 visibility4 share bookmarks
add