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
[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
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
SQL SERVER 2016 – Getting Started with R Services and Forecasting – Notes from the Field #131
[Notes from Pinal]: R Services are very much new thing and trust me, I still have to get my hand dirty on this subject. I know the basics of it, but still I personally do not know enough that I can blog about it and teach others. This is when I reach out to Eduardo, he has this incredible ability to learn new thing and teach others in the lucid easy way. I requested Eduardo to help me out with R Services and Forecasting and he happily accepted.
Pester the Tester: PowerShell Bugs, Beware! – Notes from the Field #129
[Note from Pinal]: In this episode of the Notes from the Field series database expert Robert Cain explains about Pester which is a bug testing framework for Powershell. I know Robert from last many years. Besides his amazing credentials of MVP, MCTS, Published Author and he is an amazing person to hang out with. I have seen him speaking at many prestigious events like PASS Summit, TechEd and every single time I learn something related to technology.
SQL SERVER – Database Mail Breaks with TLS 1.0 Disabled Discovery – Notes from the Field #128
[Note from Pinal]: In this episode of the Notes from the Field series database expert Ryan Adams explains a very critical error related to Database Mail. Ryan is one guy who spends more time with real world issues with SQL Server than anything else. He has mastered the art of resolving complex errors and document them so easily that one can’t find anywhere else. In this blog post Ryan addresses a very interesting error related to Database Mail Breaks with TLS 1.0 Disabled Discovery. Read the experience of Ryan in his own words.
SQL Server 2016 Management Studio – Warning: SSMS install detected shared components on this machine
As soon as SQL Server 2016 Management Studio was released on 1st June 2016, I tried installing it. This is a great way to learn and I love to get going as soon as the new software gets released. I especially get excited when it is related to SQL Server. If you have not known new process to install SQL Server Management Studio, then you should read below the blog.