Latest Blog Posts
Minion CheckDB will be available for download on February 1, 2017! In celebration, we’re having a Minion CheckDB webinar on Wednesday, February 1 at 12:00 PM, and, another Minion CheckDB webinar on Friday, February 3 at 12:00 PM. And, we will be giving away 3 licenses of Minion Enterprise to… Read more
In Belgium, a national campaign is launched to raise money for cancer research: #TourneeMinerale. In this campaign, people can be sponsored for not drinking alcohol for the whole month of February 2017. This sponsor money is donated to the national cancer research center. The name of the campaign – Tournée… Read more
This month I’ll be speaking to the PowerShell Virtual Chapter of PASS. The session is on Linux OS Fundamentals for the SQL Admin. At the core of the session we will introduce you to OS concepts like managing files and file systems, installation packages, using PowerShell on Linux,… Read more
I am studying the latest R integration with SQL Server 2016, and I believe I encounter a bug when using sp_execute_external_script. So here is the re-play of the bug;
If I run the following code, I will get an error.
-- this will return an error exec…
If you’re in the Boston area tomorrow, I urge you to go to this year’s Virtualization Technology Users Group (VTUG) Winter Warmer event tomorrow at Gillette Stadium. It’s better than a regional VMUG, and not just VMware specific. It’s covering all things infrastructure, virtualization, and cloud, and it’s held… Read more
Someone once told me at the shop that we have plenty of software utilities laying around that could be very useful that no one is utilizing. I got to thinking about that from a DBA standpoint; we are fortunate enough to have the Tool Belt from Red Gate and with… Read more
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
I was editing an article on PoSh and learned something cool. I can use Grid-View to surface an object in a pipeline and then change the items… Read more
The power and capabilities of Azure SQL Data Warehouse are pretty amazing. However, it’s still basically SQL Server under the covers. SQL Server still needs maintenance and one type of maintenance is keeping statistics up to date. Statistics maintenance is doubly important within Azure SQL Data Warehouse because statistics are… Read more
Blocking is just part of life I’m afraid. Because we have locks (and yes we have to have them, and no, NOLOCK doesn’t avoid them) we will have blocking. Typically it’s going to be very brief and you won’t even notice it. But sometimes you get a query or… Read more
After a short break, we are back with the 3rd interview on #DataChannel. Mr.Hamish Watson, Community Lead from Christchurch, New Zealand discusses "DevOps Practices and Azure" with me. Had a great time as always talking technology with the ever awesome Hamish. Interview recording provided below
Interview transcript to…
Management of the database is very much essential in today’s date and for doing this, there is a need to have a platform. SQL Server is one such platform to manage the database in a relational manner. It was developed by Microsoft and operated by many users, especially in different… Read more
For those not aware there are 2 cool local and national events coming to both Melbourne and Gold Coast…
- SQL Saturday 582 (Sat 11 Feb 2017). Melbourne. For those looking for some great free local SQL (and related!) learning, you simply cannot go past a SQL Saturday anywhere in…
Grant Fritchey will be presenting Faster Provisioning with SQL Clone and Denny Cherry is presenting Optimizing SQL Server Performance in a Virtual Environment. The event is being held at Nova Southeastern in Orlando. Register (Free) at https://www.eventbrite.com/e/sql-sons-of-beaches-tour-tickets-30043366518. Hope to see you there!
I was an early adopter of Microsoft’s OneNote and started using it in February of 2004 and have never stopped. I love it for the simplicity of use and ease of collaborating with a team. Team collaboration with Microsoft OneNote is a huge productivity gain and one of the main… Read more
Newly added to the Power BI Service is a much awaited feature called Power BI Subscriptions. If you’ve worked in Microsoft BI in the past this idea is likely familiar to you. This new feature shares some similarities to Subscriptions in Microsoft Reporting Services.
The idea of subscriptions is to… Read more
Well, in v7.3, this is in there, and I didn’t realize it. You can clearly see this in the formatting… Read more