This is 51th episode of Memory Lane. 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. My favorite blog post is about Union, Union All. Let me know which one of the following is your favorite article from memory lane.
Big Data – Operational Databases Supporting Big Data – Columnar, Graph and Spatial Database – Day 14 of 21
In yesterday’s blog post we learned the importance of the Key-Value Pair Databases and Document Databases in the Big Data Story. In this article we will understand the role of Columnar, Graph and Spatial Database supporting Big Data Story. Now we will see a few of the examples of the operational databases.…
Read MoreBig Data – Operational Databases Supporting Big Data – Key-Value Pair Databases and Document Databases – Day 13 of 21
In yesterday’s blog post we learned the importance of the Relational Database and NoSQL database in the Big Data Story. In this article we will understand the role of Key-Value Pair Databases and Document Databases Supporting Big Data Story. Now we will see a few of the examples of the operational databases. Relational…
Read MoreSQLAuthority News – Why VoIP Service Providers Should Think About NuoDB’s Geo Distribution
You can always tell when someone’s showing off their cool, cutting edge comms technology. They tend to raise their voice a lot. Let us read more about Geo Distribution.
Big Data – Operational Databases Supporting Big Data – RDBMS and NoSQL – Day 12 of 21
In yesterday’s blog post we learned the importance of the Cloud in the Big Data Story. In this article we will understand the role of Operational Databases Supporting Big Data Story. Even though we keep on talking about Big Data architecture, it is extremely crucial to understand that Big Data system can’t…
Read MoreSQL SERVER – How to easily work with Database Diagrams
The right methodology of designing a database is based on the foundations of data normalization, according to which we should first define database’s key elements – entities. Afterwards the attributes of entities and relations between them are determined. Let us learn in this blog post how to work with database diagrams.
Big Data – Role of Cloud Computing in Big Data – Day 11 of 21
In this post we learned the importance of the NewSQL. In this article we will understand the role of Cloud Computing in Big Data Story
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.