Latest Blog Posts
Please join the PASS Excel Business Intelligence Virtual Group onn March 22nd 11AM Eastern for Microsoft’s Program manager Alexander Lahuerta. The presentation will be shorted than typical meetings, lasting 20-30 minutes.
But, the session will provide great insights into changes in Excel Pivot tables. You can register for the session… Read more
As this is being posted I’m on my way up to Dublin Airport to catch my flight to Iceland ready for SQL Saturday Iceland tomorrow! Been looking forward to this for a while now, my first opportunity to give a full session on a subject that I’ve become quite involved… Read more
I wrote a short article on enabling and disabling trace flags. You can read it, but I didn’t really discuss the implications of session v global trace flags, which is something I’d like to do here.
In the article, I set trace flag 3226 for my session. This showed… Read more
Recently, I was tasked with “enhancing” a third party application. This third party application (TPA) outputs a bunch of files to a file share in a way that makes sense to the application, but makes no sense to a human.
Make a copy of these files in a… Read more
Compressing your backups has very few downsides. It’s usually faster (the additional time for compression is less than the time saved by reduced IO) and of course, the backups are smaller. I have run into a few issues, however.
On one occasion there was 75gb free on a drive, the… Read more
We'll see you there on Saturday!
Sparkhound speakers in the lineup
This is the debut blog post of Chris Gibson. Chris is in expert in Microsoft Windows and is turning his attention more and more to the Cloud. You can read more about Chris on the About Us Page
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
One of the things that you might encounter at some point is the need to create a BACPAC. This is essentially a DACPAC with data included. There… Read more
I hope you all can join me for an upcoming webinar as part of the Datacenter Madness webinar series, presented by ActualTech Media, Nutanix, and Intel. The Madness is moving from the basketball court to the cloud. It’s time for the ultimate data center showdown where… Read more
I’ve written a few articles on containers so I thought it’d be a good idea to have a page that listed them for easy reference. So here’s all the posts: –
It’s T-SQL Tuesday time again, and this is a good one. The host this month is Kennie Pontoppidan, who I had the pleasure of running with one morning in Copenhagen. His theme is The daily (database-related) WTF.
It’s the time of the month again: the T-SQL Tuesday! This month’s edition is hosted by Kennie Nybo Pontoppidan (blog|twitter) and the topic is “daily database related WTF”. In other words, we get to tell one of our horror stories we encountered in our career as… Read more
The daily (database-related) WTF
Database horror stories. Things that make your eyes pop and not in a good way. What a fun topic! But not an… Read more
1 comments, 120 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 14 March 2017
In this module you will learn how to use the Stars Power BI Custom Visual. The Stars visual is a great way to visualize ratings data.
Module 42 – Stars
- Power BI Custom Visual – Stars
- Dataset – Movie Ratings.xlsx
- Completed Example – Module 42 – Stars.pbix
This month’s T-SQL Tuesday – hosted by Kennie T Pontoppidan(@KennieNP) – is called “The daily (database-related) WTF“. He asked us to be inspired by the IT horror stories from http://thedailywtf.com, and tell our own daily WTF story.
Years ago in a previous job, I… Read more
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the month’s host. This month’s host is Kennie Nybo Pontoppidan (b|t) and this months topic is: The daily (database-related) WTF.
Some of the biggest WTF moments… Read more