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 More
SQL SERVER – How to Install SQL Server 2014 – A 99 Seconds Video
Last month I presented at 3 community and 5 corporate events. Every single time I have been asked by others what is my experience with SQL Server 2014. Every single time I have told the audience that they should try this out themselves, however, the response has been very lukewarm. Everybody wants to know how SQL Server 2014 works, but no one wants to try out themselves.
SQL Authority News – Download Microsoft SQL Server 2014 Feature Pack and Microsoft SQL Server Developer’s Edition
Yesterday I attended the SQL Server Community Launch in Bangalore and presented on Performing an effective Presentation. It was a fun presentation and people very well received it. No matter on what subject, I present, I always end up talking about SQL. Here are two of the questions I had received during the event. Let us answer the questions related to SQL Server 2014 feature pack.
SQL 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