SQL SERVER – DMVs to Detect Performance Problems in SQL Server – Notes from the Field #135

[Notes from Pinal]: Performance tuning is a complex subject, and not everyone knows where to start and how to handle this complex subject. There are so many different areas for performance tuning for example – tuning TempDB, the bottleneck at SAN, disk latency, etc. If a novice user start on the subject of performance tuning they will easily get lost as they do not know where to start. This is where I requested help from Edurado and he suggested that we should take help from DMVs to detect performance problems in SQL Server.

Read More

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

[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.

Read More

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

[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.

Read More

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.

Read More

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.

Read More

How to Use Zip With SSIS? – Notes from the Field #130

[Note from Pinal]: This is a 130th episode of Notes from the Field series. In this episode we are going to learn something very simple but effective about SIS and Zip. This subject is not very much discussed about and hardly there are many information about this subject available. In this episode of the Notes from the Field series database expert Kevin Hazzard explains the how to use ZIP with SSIS. Read the experience of Kevin in his own words.

Read More

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.

Read More
Menu