If you are looking for a great conference to attend, please look at Live! 360. This event combines 6 different areas of IT (including SQL Server) with some of the great experts presenting sessions for 5 days. The sessions are on December 5th thru the 9th in Orlando, FL… Read more
Please join me and about 4000+ other technology professionals for the annual PASS Summit in Seattle, WA October 24th – 28th. But before I talk about this year’s event, join me in a trip down memory lane about my path to the PASS Summit. If not, skip to the…
In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you are using the Kimball Dimensional Modeling method. In the beginning of Dimensional Modeling, it was called a Time dimension. Since then, the Time dimension has actually been separate from the…
SQLSaturday events are a pleasure to be a part of whether it involves speaking or volunteering. Volunteering definitely takes more work and time, but to see someone who is interested in SQL Server as a career take time to learn on a Saturday, makes it all worth the effort. When… Read more
Thu, Mar 24 2016 12:00 Central Daylight Time
Dustin Ryan presents What's New in Power BI
WHAT'S NEW IN POWERBI
Between the weekly and monthly updates to Power BI, its tough to stay caught up with the latest updates and improvements with Microsoft's newest business intelligence…
Multidimensional Cubes provide speed when it comes to retrieving aggregations that are important to business decisions. Being able to slice or group the measures by dimension attributes helps with a quick analysis and flexible/interactive reporting. Configuring these attributes as hierarchies has some details that are not at first obvious. The…
There are also a couple of great Pre-Cons on Friday Jan 29th, 2016 that are very cheap compared to similar training at big conferences.
Please join Idera tomorrow for a #SQLChat on Twitter. The December #SQLChat will take place Tuesday, December 9 at 11 a.m. central to 12 noon with John Morehouse (@Sqlrus). We will be discussing how to survive the holidays with SQL Server.
Other Idera ACE’s will be helping with the… Read more
Microsoft continues to improve indexes and options for additional performance enhancements. One I see frequently is the need for a covering index. Before we look at those options, let’s talk about the need for a covering index.
The term covering index was created probably a decade ago. The idea is… Read more
I started using a product called SQL Diagnostic Manager from Idera about 10 years ago at a Home Health company. It was very useful with monitoring a SQL Server instance and helped us estimate the future size of databases based on historical data. The numbers were very accurate for a… Read more
Yes, it is that time of the year again. You know, when all the nut case and normal SQL Server experts collide in Seattle (or wherever the Summit is located) to experience the largest gathering of data experts on this planet. Well, I might be lying a little about the… Read more
On Wednesday morning, Conner Cunningham from Microsoft was the keynote speaker for IT/DevConnections in Las Vegas. His talk focused on SQL Server 2016. To summarize the things he said that got my attention were a Live Query Plan, the Query Store to retrieve a previous query plan and Azure… Read more
The PASS Excel Business Intelligence virtual chapter presents Dustin Ryan introducing everybody to Power Pivot in Excel. This chapter has gotten a lot of questions during some of the last couple of sessions that can be directly done in Power Pivot through Excel.
Please join us this Thursday September 10th… Read more
DevConnections is a new conference for me and I am excited about the opportunity to present 2 different sessions. The conference is at ARIA Resort in Las Vegas, NV. There are many great speakers at this event including Grant Fritchey, Itzik Ben-Gan, Denny Cherry and many more. The conference… Read more
This is I believe the 7th SQLSaturday in Baton Rouge. Please come out this Saturday at the LSU Business Center to enjoy free training, prizes and networking with over 500 IT professionals.
Here is the schedule.
It involves connecting to the Analysis Service database as a connection and not an… Read more
The next version of SQL Server looks to add more and more features helpful in database design and administration as well as Business Intelligence.
I was thinking today about why I submit sessions to speak at the PASS Summit.
Join us today at noon central for Asgeir presenting for the Excel BI VC.
Thu, Jun 18 2015 12:00 Central Daylight Time
PASS Excel BI VC presents Ásgeir Gunnarsson: End to End Risk Assessment – Using PowerView
END TO END RISK ASSESSMENT – AFFORDABLE SOLUTION USING POWER BI…