Having just returned from SQL PASS I thought I would blog a few highlights about the conference and some of the things I came across and am looking forward to. I went over to Seattle with two of my colleagues and we started with a little sight-seeing to get our body clocks back in sync and I would thoroughly recommend it. T
The Adatis SQLPass team: Myself, Neil Dobner, Tim Kent
This was my first time at PASS and I was not disappointed. The first couple of evenings in Seattle were spent catching up with some people I have met at SQL Bits. The SQL community being what it is I was quickly introduced to more people and making new connections. The #SQLfamily on twitter are a welcoming bunch and really add a lot to the atmosphere of a friendly conference. I would strongly recommend using twitter for both connecting with people and using the #SQLHelp hash tag to ask questions. I had come across a number of the speakers at SQL Bits and they were all very good quality and I heard very little negative comment on the sessions across the 3 days.
There were a good number of highlights for me that I would like to pass on in case they are as relevant to you as they are to me. I’ve split them down into a few areas, firstly Powerview:
- PowerView coming to SSAS Multidimensional
- PowerView in Excel
- Powerview on Multidimensional will come to Sharepoint well before it gets into the Office Excel release cycle
- Image Urls and geospatial reports are also particularly easy
Some brilliant stuff in a Tabular internals stuff given by Akshai Mirchandani and Allan Folting, DAX queries by Alberto Ferrari and 2012 SSAS by Chris Webb:
- Insights into value encoding and hash encoding compression which makes sense of guidance such as
- Don’t bring in any row level identifier or document numbers etc unless you really have to
- Use a process defrag as maintenance when doing updates and deletes
- Lower end hardware can be quicker, ie go for less but faster procs
- Profile you DAX queries to look out for formula engine calls using: CallBackDataId
- Partitions are not eliminated by the query optimiser they only help you manage processing, this is particularly impressive because the engine is so fast it didn’t need this!
- Direct query really is unusable given the limitations and the awful SQL it generates
- Two thirds of the SSAS multidimensional codebase is there to deal with M2M correctly
Finally some database engine stuff:
- Windowing functions in 2012 really will be a lifesaver for complex queries, especially lag and lead for those moments where your user thinks you work in Excel
- Updatable columns store indexes!
- Licencing can be a nightmare of Cores, processors and virtualisation but the key way to keep it sensible on the new model is to keep you core density at 4 cores per processor.
I met loads of fantastic interesting people and have picked up some great contacts. The conference has also had the added side affect of getting me excited about SQL Server again. It is easy to get caught in the day job and forget what a brilliant product we work with and what hard work goes on at Microsoft to keep it that way.
Thanks everyone
See you Next Year? or maybe SQL Bits a bit closer to home.
Introduction to Data Wrangler in Microsoft Fabric
What is Data Wrangler? A key selling point of Microsoft Fabric is the Data Science
Jul
Autogen Power BI Model in Tabular Editor
In the realm of business intelligence, Power BI has emerged as a powerful tool for
Jul
Microsoft Healthcare Accelerator for Fabric
Microsoft released the Healthcare Data Solutions in Microsoft Fabric in Q1 2024. It was introduced
Jul
Unlock the Power of Colour: Make Your Power BI Reports Pop
Colour is a powerful visual tool that can enhance the appeal and readability of your
Jul
Python vs. PySpark: Navigating Data Analytics in Databricks – Part 2
Part 2: Exploring Advanced Functionalities in Databricks Welcome back to our Databricks journey! In this
May
GPT-4 with Vision vs Custom Vision in Anomaly Detection
Businesses today are generating data at an unprecedented rate. Automated processing of data is essential
May
Exploring DALL·E Capabilities
What is DALL·E? DALL·E is text-to-image generation system developed by OpenAI using deep learning methodologies.
May
Using Copilot Studio to Develop a HR Policy Bot
The next addition to Microsoft’s generative AI and large language model tools is Microsoft Copilot
Apr