Latest Blog Posts
Over the last four years I’ve blogged almost 400 times. It’s become a refuge, a resource, a source of pride, and a pleasure. I started out trying to build an on-line resume (just in case) and over time it’s evolved like crazy. I’ve become a huge proponent of blogging and… Read more
SQL Server 2016 comes up with the new release of Master Data Services (MDS). In it, some new features have been added to improve its performance. It helps the database administrators to manage the database properly. In the following discussion, we will be discussing the changes that have taken place… Read more
0 comments, 134 reads
Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 25 July 2016
Today marks one years since Power BI was officially released. It’s been an amazing ride and I’d like to thank the team at Microsoft for so responsive to the community’s feedback. Check out this video the community created to celebrate!
Well today marks the one year anniversary since the initial release of Power BI. We all have watched this product mature from a small infant to what we see today in an amazing Business Intelligence solution. To the Power BI product team and those that support the product keep up… Read more
San Antonio is such a great city with a lot to see and do, such as the Alamo and the river walk. I’m excited to be speaking at their very first SQL Saturday!!
My session is on troubleshooting and monitoring storage, including SAN, flash, and in Azure. If you ever… Read more
The sessions have been informative and the event team has done a wonderful job with all of…
I am excited to share that I will be presenting at the DevConnections conference in Las Vegas in October of this year. This is my fourth (if I remember correctly) time to have spoken at DevConnections, and the first time I will have delivered a full-day workshop there. This year… Read more
Speaking on Consolidated Essential Performance Health Check using PowerShell – SQLSaturday (Sacramento)
The first time I heard someone mention drift at Redgate, it made sense to me. After all, in the context of the schema of your database, I can see the code “drifting” away from what you expect. Someone noticed this was a problem when implementing continuous delivery and DLM Dashboard Read more
Here is an overview of the articles I published in the second quarter of 2016, which were all focused on the new changes for Master Data Services in SQL Server 2016:
- Approval Workflow in SQL Server Master Data Services 2016 using Change Sets – Part 1
- Approval Workflow in Master…
Finding the right event or combination of events to monitor may seem like quite a daunting task with so many events to explore and (frequently) too little familiarity with Extended Events. In this follow-up article to Extended Event Help Queries, I will share another means to quickly explore the… Read more
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
Having system named objects is one of those things that people may debate, but as you move to more automated and scripted processes can cause you issues.… Read more
I was recently browsing www.myplates.com and I’ll say it’s actually quite fun to see what plates people have randomly bought. I found it easy to spend 15 or so minutes typing in all sorts of fun and silly things into the search just to see what would come up.
If you have not already seen in the What’s New in Integration Services list there is a new property for Data Flows that is called AutoAdjustBufferSize. Why is this important and what does it actually do?
First, let’s remember that in SQL 2014 we had a max DefaultBuffersize of… Read more