Sometimes there are incidents when our attitude creates confusion in the communication and we end up creating a situation which is absolutely not warranted.
SQL SERVER – What is SSAS Tabular Data Model and Why to Use It – Part 2
In my last article, I talked about the basics of tabular data model and why use it. Then I demonstrated step by step creation of a basic tabular model project. In this part I’m going to throw some light on how to create measures and analyses in excel. Let us learn about the SSAS Tabular Data Model.
SQL SERVER – How to Change Compatibility of Database to SQL Server 2014
Yesterday I wrote about how we can install SQL Server 2014. Right after the blog post was live, I received a question from the developer that he has installed SQL Server 2014 and attached a database file from previous version of SQL Server. Right after attaching database, he was not…
Read MoreSQL Authority News – Presenting at SQL Bangalore on May 3, 2014 – Performing an Effective Presentation
SQL Bangalore is a wonderful community and we always have a great response when we present on technology. It is SQL User Group and we discuss everything SQL there. This month we have SQL Server 2014 theme and we are going to have a community launch on this subject. We…
Read MoreMySQL – How to Create Stored Procedure in MySQL
MySQL supports Stored Procedures which can execute set of codes by applying relevant business logics. In this post we will see how to create a stored procedure and execute it. Let us create the following tables CREATE TABLE items(item_id INT, item_description VARCHAR(100)); CREATE TABLE sales(sales_id INT auto_increment KEY,item_id INT, sales_date…
Read More
SQL SERVER – Synchronize Data Exclusively with T-SQL
Database developers often face the task to synchronize users’ data. Currently, to solve this task, there was developed quite a big number of various utilities. In this article, we will review the process of creating the new functionality to synchronize data exclusively with T-SQL.
SQL SERVER – Faster Application Performance with In-Memory OLTP
Today, I’d like to examine how in-memory OLTP engines to vastly improve performance and scalability of SQL Server databases and to accelerate applications. A very large part of this article focuses specifically on SQL Server 2014 and its new In-Memory OLTP capabilities.