If you are traveling to SQL PASS, Seattle this year, you do not want to miss out on my pre-con: 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs. This session is going to be amazing fun and very unique. It is full day demo-oriented learning session.
SQL Authority News – Updates on Recent Trip to SQL PASS 2017, Seattle
Today is Thanksgiving in the USA and few other countries. Earlier last week I returned from the USA attending various customer meetings and conferences. Here is a quick update about my trip to SQL PASS 2017, Seattle.
SQL SERVER – SQLPASS 2016 – Feedback and Rating – Kick Start! SQL Server 2016 Performance Tips and Tricks
Earlier this year, I presented at SQLPASS 2016, Seattle on SQL Server 2016 and I am very happy to see the feedback of my sessions. I have presented two sessions and I will write feedback of one session in this blog post and another one later this week. my session was about SQL Server 2016 Performance Tips and Tricks.
SQL SERVER 2016 – Creating Clustered ColumnStore with InMemory OLTP Tables
I have been writing a lot of my findings with SQL Server 2016 in the recent past. This is also being something I have been investing big time keeping my session at SQLPASS coming in the October timeframe. I will be talking on a number of capabilities and enhancements around SQL Server 2016 from a performance standpoint that it is critical for me to explore some. I invest considerable time in preparation for any session and every single year going to SQLPASS has been the highlight and most of the time it is about hard work to make sure everyone attending my session gets the best of content. Also, it is a great way for me to do due diligence and homework as I prepare with real world problem statement with possible alternatives and solutions as part of my session. Let us learn about Creating Clustered ColumnStore with InMemory OLTP Tables.
SQL SERVER – Interesting Observations Using MONEY Datatype
MONEY is one of the data types supported in SQL Server. There are some interesting information about this. Observation 1: Money datatype can accept up to four scale values. DECLARE @money money SET @money='$1,200.45679' SELECT @money which results to 1200.4567 Observation 2: If the scales value exceeds 4 digits, it is rounded to…
Read MoreSQL SERVER – Looking Forward to Meeting you at SQLPASS 2015
If you are going to at SQLPASS 2015, Seattle, I am looking forward to meet you. I will be there and presenting two technology sessions. Here are the details of my sessions. I will be very happy if you are at SQLPASS and attend my session. If you see me…
Read MoreSQLAuthority News – Ryan Adams Running for PASS Board of Directors
I recently learned that Ryan Adams is running for the PASS Board of Directors. I care for PASS which is a Professional Association of SQL Server. I care about who runs PASS as it directly affects my daily routine. Every year, I spend a good amount of time in making sure…
Read More