SQL Tips and Tricks Archives - Page 89 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Becoming a More Effective DAX Developer with DAX Studio – Notes from the Field #134

July 28, 2016

Notes from the Field, SQL Analysis Services, SQL Scripts, SQL Server, SSAS

[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 topics is DAX Studio. 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 to become a more effective DAX developer with DAX Studio? Bill was very kind to answer the questions and provides plenty of information about how a novice developer can work with DAX Studio.

SQL SERVER – System Stored Procedures I Use to Get Started

July 26, 2016

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Stored Procedure

Call me an old school or whatever – there are certain things I believe in strongly. I have a working style and these in my opinion have evolved over years. I keep innovating myself as I learn on my way but there are few things I do that always makes me think I have not changed much. Let us learn about System Stored Procedures I Use to Get Started.

SQL SERVER – Network Servers List is Empty in SQL Server Management Studio

July 23, 2016

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Server Management Studio

I have in numerous places told that the first tool that I often open when the computer boots up will be SQL Server Management Studio. I get intrigued whenever someone comes up with an error relating to SSMS. There is something that gets my troubleshooting character out and I get out full swing to solve the same. Don’t you ever like such challenges? I am for sure you like similar challenges. One of my clients reported below problem with Network Servers List in SQL Server Management Studio.

Free DBA Tools for SQL Server Professionals – Notes from the Field #133

July 21, 2016

Pinal Dave

SQL Tips and Tricks

Career Advice, Notes from the Field, SQL Server

[Note from Pinal]: This is a 133rd episode of Notes from the Field series. I know Mike for many years and Mike has always inspired me with his positive energy. I have always enjoyed spending time with him as I have always learned something new but along with it, I have also improved as a human. It is very critical that we often meet someone who is not only technically brilliant but gives us a different viewpoint of life. I really respect Mike and enjoy love talking to him. Today is going to a fun note from Mike about Free DBA Tools.

SQL SERVER – Query to Get CPU Usage History for SQL Server and Operating System

July 16, 2016

Pinal Dave

SQL Tips and Tricks

SQL CPU, SQL Scripts, SQL Server

I have seen a number of customers manage their SQL Server environments in an adhoc manner. These accidental DBA’s need to know what happened in the system in a chronological order or even worst need to know what led to the lead up to a particular problem. Many times when we troubleshoot a problem with high CPU, its asked that when it all started and do we have any historical data of CPU usage? Here is the one query which I have re-written to have more details. Let us see Query to Get CPU Usage History for SQL Server and Operating System.

SQL SERVER 2016 – Encrypt Your PII Data – Notes from the Field #132

July 14, 2016

Pinal Dave

SQL Tips and Tricks

Notes from the Field, SQL Server, SQL Server 2016, SQL Server Security

[Note from Pinal]: In this episode of the Notes from the Field series database expert Mike Lawell talks about his thoughts and observation about SQL Server 2016 Encryption. Security of the data is very important and we often spend so many hours securing our data. However, lots of people do not understand about Encrpting about their database personal information. Every single day you will find plenty of incidents where PII data is stolen or misused. I discussed about this with Mike and of Linchpin People and he was very kind to share his view on encryption of PII data and SQL Server 2016. Let us read Mike’s story in his own words.

SQL SERVER 2016 – Find Expiry Date of Developer Edition

July 13, 2016

Pinal Dave

SQL Tips and Tricks

SQL Download, SQL Scripts, SQL Server, SQL Server 2016

The title of the blog is little weird, but it was a question asked to me by a developer. Have you ever got such error messages which are strange yet difficult to comprehend? He told me that he has installed SQL Server 2016 developer edition from MSDN (which is free now): Download SQL SERVER 2016 Developer Edition for FREE