You might have seen my earlier posts about SQL Server 2016 management studio. There are a lot of changes which have happened in SSMS area. One of such change which I heard is that SSMS now uses Visual Studio 2015 shell. I am a sort of guy who likes some of the settings to be as they were when I worked with good old SQL 2000 days too. I like the color coding used for ages since I first worked with SQL Server using Enterprise Manager. Here is an example where I personally felt the old style is far more productive than the new default. Let us see how we can change color for the system object name in the text editor.
SQL SERVER – Optimizing Tabular Models for Self-Service Reporting: Summarize By – Notes from the Field #123
[Note from Pinal]: This is a new episode of Notes from the Field series. I personally have no problem accepting that I do not know many topics. One of the such topic is Tabular Models. I always wanted to learn more and I finally got the opportunity to learn more.
In this episode of the Notes from the Field series I asked SQL Expert Bill Anton a very crucial question – How can we optimize Tabular Models for self service reporting with the help of Summarize By ? Bill was very kind to answer the questions and provides plenty of information about how a novice developer can work with Tabular Models.
SQL SERVER – Skip “Save Changes to the Following Items?” Prompt in Management Studio (SSMS 2016)
As a DBA/Developer, you must have seen below screen lot of times and most of the time you must have hit No. I know it is one of those moments when you want to leave from work and those annoying popup just stops you for that couple of seconds that you don’t want to waste. In reality, I inadvertently press the space bar and it asks for a location to save. Let us see an interesting blog post about SSMS 2016.
SQL SERVER 2016 – Scroll Bar Enhancement in Management Studio (SSMS 2016)
While I am getting ready to play with SQL Server 2016, I am finding fresh look and feel for SQL Server Management Studio. I heard that its uses latest version of visual studio shell. There are many enhancements which I am seeing in SSMS 2016 and today I would talk about Scroll Bar settings. I am sure you are going to miss some of them considering all these are hidden mostly in some options deep within. Be assured for many more blogs on these topics in future too.
SQL SERVER – Q&A: SQL Clustering Virtual Server Name and Instance Name
Of late some of the troubleshooting scenario I am getting involved is amazing. Though some of them are complex, it gives me a unique opportunity to learn and try something new to share later with you folks. Recently I was contacted by a team who takes care of SQL installations. Since they are very new to SQL Server cluster installation and had basic questions. Let us learn more about SQL Clustering.
SQL SERVER – FIX: Setup Was Not Able to Access Domain
One of my clients approached me to provide assistance in performance tuning – which is my bread and butter these days. Often once you get into an engagement, they try to maximize the time they get with me. While doing the tuning exercise, the DBA had a side question during the call. Let us learn about how setup is not able to access domain.
How to Insert Multiple Rows in a Single SQL Query – Interview Question of the Week #069
There are so many different databases in the world and many of them use the language SQL for their programming. It is very easy to assume that if they are using SQL, we can easily use code from one database to another database. Unfortunately the reality is very different, not all the scripts from one database works in another database. Today we will see very interesting question where the user asked a question about inserting multiple rows in a single SQL query.