Latest Blog Posts
To kick off this series, I thought it would be worthwhile to discuss why it is I step up to help lead the effort to pull this event together. I know it did because it helped change mine. Without hesitation, which I now question sometimes, I stepped up and said…
This will be my second time speaking at SQL Saturday in Dallas. My first was last year and it was a great time. I enjoyed hanging out with all the attendees and speakers. Who wouldn’t want to have a chat with Kalen Delaney or Bob Ward? The Dallas edition of…
Time for another update.
The minutes for the June in-person meeting have been approved and are now ready for your information. We accomplished a lot in the two days and you can read what we did there. I’m pleased about two things. First, while it took until the July meeting… Read more
I’m off to the Viking Ship Museum for SQL Saturday #532. Actually, the Viking Museum will (hopefully) be a side trip on Friday before the actual event. The actual training will be at the Noroff campus in Oslo.
This is my first trip to Norway, and while it… Read more
A few months ago, I posted a question over on ask.sqlservercentral.com. In a nutshell, it was how do you measure DTU? How could you pull the data shown in the Azure Portal graphs with T-SQL? No one answered, so this motivated me get off my butt and answer my… Read more
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
I often see people struggling to use triggers for auditing, or having issues with building them to handle multi row updates. However, there’s another choice: the OUTPUT… Read more
We know you you’ve been dying to know, what is TWID? Drumroll please…. We’re excited to announce the launch of This Week In Data! This Week In Data is a weekly video podcast hosted by Adam Jorgensen and Devin Knight that discusses important news and topics within the… Read more
SQL Server 2016 introduces a very cool new feature called real-time operational analytics, which is the ability to run both analytics (OLAP) and OLTP workloads on the same database tables at the same time. This allows you to eliminate the need for ETL and a data warehouse in some cases… Read more
Continuing my exploration of Azure the next logical step seemed to be copying an on-premise database up to the cloud. This is also the next in the ideas I got while watching Jes Borland’s (b/t) excellent session on Azure and SQL Server on the Pass Data… Read more
I have a fairly large backlog of articles that are in progress or that are planned for my series about Extended Events. Despite the backlog and planned articles, every now and then something else comes up that bumps things around. This article is an example of bumping the schedule around.… Read more
As many companies rely on SQL Server Database for the storage of their data, database administrators need to make sure that the database is made available whenever required without failure. In order to ensure that, he/she needs to make sure that the data integrity is maintained all the time… Read more
On episode of one of our favorite podcasts – 10 on Tech from ActualTech Media – recently focused on a discussion with James Green and myself on some of the challenges with moving large scale operations to the cloud. Check out this podcast here!
Since data consistency is a crucial aspect for every user, the server has in-built mechanism which helps to maintain the data consistency at every step. Sometimes, the user may face SQL Server Error 824 while making any SQL query or data modification. It is mainly inconsistency based error that reports… Read more
0 comments, 90 reads
Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 23 August 2016
I decided to write a long term review… Read more
If you haven't explored the visual color coding of tabs based on pattern matches with SQL Prompt, I'd suggest you check this out.
Earlier iterations of Red Gate's SQL Prompt did not change tab color immediately when the connection was changed.
Red Gate's tab color could get out of sync… Read more
If you have followed my blog for the past year or so you may remember when I posted a Power BI workbook I created to analyze the previous season’s NFL player stats to help me with my fantasy football draft. I know, its nerdy, but I like Power BI and… Read more