Latest Blog Posts
In most of the cases, users create a backup file of their database on their machine. This help the users to perform recovery at the time of any disaster, or manage large amount of database onto the SQL server. However, users generally knows the way to create a backup… Read more
After my Asia-tour this summer I feel it is about time for this article.
0 comments, 168 reads
Posted in Andreas Wolter SQL Server & BI blog (English / German) on 20 September 2016
Three men are in a hot-air balloon. Soon, they find themselves lost in a canyon somewhere. One of the three men says, “I’ve got an idea. We can call for help in this canyon and the echo will carry our voices far.” So he leans over the basket and yells… Read more
The ideal is to make a change and see that change deployed to production, in a perfect world we would be told to work on something, write the code + tests, deploy to a test environment, prove it works and deploy - this is the cycle time and the faster…
Thanks for attending my presentation on window functions in TSQL during the September 15, 2016. I hope you learned something you can take back and use in your projects or at your work. You will find an link to the session and code I used below. If you have any… Read more
Recently I have had to restore a number of databases into our training environment. Looking up each backup individually would be time consuming and I prefer to save time whenever possible. So, instead of lookup up the backup for each database I needed, I thought a quick script would be… Read more
What is a Data Governance Policy?
Data governance policy is concerned with how an organization collects, stores, accesses and maintains its data. As data is now a core enterprise asset, ensuring it is properly maintained and controlled is critical.
When creating a data governance program there are at least 4… Read more
It’s Monday and time for this week’s blog and twitter round-up. It’s been a few weeks since the last recap, apparently vacation a month and a half ago slowed my roll on blogging. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to… Read more
If you’re working with Azure SQL Database or you’ve moved into SQL Server 2016, one of the biggest new tools is the Query Store. It provides a mechanism of capturing query performance over time and persisting it with the database. You also get the execution plans for those queries. Finally,… Read more
In this module you will learn how to use the Sunburst chart Power BI Custom Visual. The Sunburst chart is similar to the standard donut chart but allows you to show multiple level at once, which is great when presenting hierarchical data.
Module 17 – Sunburst
- Power BI Custom…
For many years it’s been a best practice to never put an ORDER BY in a view. The idea is that a view shouldn’t have an inherent order. Just like any other query. If you want the data from a view ordered then you query the view with an ORDER… Read more
I will be presenting a technical session entitled ‘Virtual SQL Servers. Actual Performance‘ tomorrow evening for the Suburban Chicago SQL Server Users Group. Doors open at 5:30pm and the session starts at 6:00pm!
Abstract: Virtualizing your business-critical SQL Servers should not imply that they will run slower… Read more
As with everything on this site...The owner of gethynellis.com will not be liable for…
The most common questions I’m asked during networking sessions at technical conferences and events aren’t technical! People want to know what it’s like being an independent consultant. Things like how to get started and what to look out for are common themes. So I wanted to share the some… Read more