AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Lifehack script free font4/17/2024 Just like the example I gave earlier about jackets with more pockets.Īnother life hack which I have started doing again since working in the Netherlands is to commute more. In reality, I have other lifehacks which are useful outside of technology as well. I covered some of its uses in a previous post here. In addition, you can use it alongside udl files as a quick way to create connection strings. NotepadĪnother lifehack some may find strange is to realise just how useful notepad actually is.įor example, if you have issues with copying and pasting between two different applications copy to notepad first and from there post to the other application. For the demo scroll along to 22:40 into the video towards the end. If you want to see it in action, you can watch in in a video I made last year here. Which is currently called ‘Deploy SQL Server’. My last honourable mention about SQL Server related life hacks is about Azure Data Studio.īecause if you want to quickly deploy Docker containers locally or Big Data Clusters into AKS there is a useful wizard that you can use in Azure Data Studio. Which I recommend reading if you want to work with SQL Server more efficiently. You can find the links to these and other free tools in a post I did about free SQL Server tools. I have a lot of respect for these people who provide things for the community to use for free. Like the other tools mentioned above, dbatools is written by community members for us to all use for free. Which by itself shows you just how useful this module can be when working with SQL Server. In fact, you can use dbatools commands with all the other free tools I have mentioned previously and more. Sure, writing your own PowerShell can be fun, but for the more complicated stuff this will save you a lot of time. In addition, I recommend using Ola Hallengren’s index maintenance solution instead of writing your own.Īnother SQL Server life hack is to use PowerShell modules like dbatools as much as possible. For starters, I also use Brent Ozar’s First Responder toolkit to help with issues, and actively promote others to use it. I will give some honourable mentions here. However, I have noticed that he now has an updated version of the scripts on his own site here. Until recently, Glenn was working for SQLSkills and kept the scripts updated on their site. On occasion, it has also helped me identify issues with memory allocation (NUMA) as well. In addition, Glenn has scripts that can help you identify problem queries. It has made myself and clients very happy because the number times I have used it to identify indexing problems.Ī lot of common performance issues are down to indexes, so this helps a lot. Personally, I have used this script a lot to identify potentially missing indexes. In fact, I have been a big fan of Glenn’s index advantage script ever since it was in the original MVP Deep Dives book many years ago. Like the configuration of your SQL Server and potentially missing indexes. You can use these scripts to find out a lot of things. For years now Glenn has provided a whole load of diagnostic scripts to check things in SQL Server. I will quickly recap for those who are not fully aware of these scripts. However, I have used Glenn’s scripts for many years now. It was a close call between this and Brent Ozar’s First Responder toolkit. I will give honourable mentions to other life hacks outside of technology towards the end because sharing is caring.Īfter deep thought, here is my favourite SQL Server life hack. So, I should do my favourite SQL Server related one. For example, I now wear jackets with as many pockets in as possible when taking short flights to carry more items. Plus, I don’t know about other people but mine seem to keep growing. Mostly because after being on this planet for a long time and working in IT for over half of it I have collected a fair few. You can read more about the invite in detail by clicking on the T-SQL Tuesday logo above.įor me, this is a tough call. Jess invites us all to write about our favourite life hack. This month’s T-SQL Tuesday is hosted by Jess Pomfret. However, I will give some honourable mentions to others as well. My T-SQL contribution for this month is about my favourite SQL Server life hack.
0 Comments
Read More
Leave a Reply. |