For those of you who read my blog regularly, you know that I’ve been evaluating NuoDB, a new database company that is re-writing the rules for relational databases. They’ve introduced a new category – Cloud Data Management Systems (CDMS) – and are claiming to be the first and only. In…
Read MoreSQL SERVER – Weekly Series – Memory Lane – #016
Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…
Read MoreSQLAuthority News – Presenting at Sarasota IT Pro Camp, Florida on February 16, 2013
I am traveling the entire month of February 2013 in USA. First 18 days I am Florida and later part I am heading to another part of the country. When I am in India, every weekend I make a point to attend one of the User Group Meeting in the…
Read MoreSQL SERVER – Development Productivity Tool – dbForge Studio for SQL Server
First off, it will increase SQL coding almost instantly. There is very little to learn, you are not just memorizing codes to “cheat” off of. DbForge Studio provides code completion options and automatic SQL formatting, so that you know your code will work. One of my favorite feature is “snippets,” which stores parts of code that you use over and over to cut down on typing and searching – because you know there always a few commands you use again and again! Another time saver is the hint option, which will show you information about objects, and the navigation tool that allows toggling between items using only the F12 key.
SQL SERVER – Get SQL Server Version and Edition Information – SQL in Sixty Seconds #043 – Video
What do consultants do when they come across any new instance of SQL Server? Well, their very first question is what version of SQL Server is it? The reason is simple – SQL Server is a very vast product and each version of the product have new features released and…
Read MoreSQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1 and Included Columns Col2 and Col3 – Part 5
This is the fifth part of the series regarding Redundant Indexes. If have not read earlier part – there is quite a good chance that you will miss the context of this part. I quickly suggest you to read earlier four parts. On my production server I personally use embarcadero DB Optimizer for…
Read MoreSQL SERVER – What is Semantics Model – A Simple Explanation
“Semantics” refers to the meaning behind words, sentences, or phrases. This is its general meaning. In technology, even the word “semantics” has more meanings. Semantics, and semantic models, refer to how data is organized within a database to make it more useful for users. So, in technology, semantics have the…
Read MoreSQL SERVER – Primary Key and NonClustered Index in Simple Words
I have been writing a weekly round up from my blog where I go over last six years of blog posts and pick the best posts from the pasts. While I do this, there are two major place where I focus 1) If there are change in features – I…
Read MoreSQL SERVER – Weekly Series – Memory Lane – #015
Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…
Read More