Automated email alerts lead to information overload. Emails for failures, confirmation, or just for information. So, we build rules and filters to try and handle them, hoping nothing new slips through the net. How about an alternative to bring consistency and streamline your inbound emails? Let’s take a look at Sub-addressing to overcome the overload. What is […]
In Management Studio we can view object details by hitting F7 in Object Explorer. It gives us basic metrics but I find it very slow to load for the details I typically need. For that reason I though I’d share a script to turn to for metrics I commonly need. This query returns: Results for the AdventureWorks2022 […]
Productivity is a core component of our day to day jobs in and around code. Part of that comes from the tools we use and a common one would be Notepad++ thanks to all of its handy features and plugins to extend it. One of the simplest out of the box features is the ability […]
One of the most time consuming tasks in Management Studio is repeating the same changes across multiple lines of a query. The answer to this? – Multi Line (or Column Mode) Editing. Here’s a quick post to explain what it is, how to do it, and examples to see it in action. What is multi […]
A view can be created in SQL Server to allow data to be presented in a specific way for a particular user or use case which may need to consume it. Recently I came upon a feature which I hadn’t been aware of throughout my career around SQL Server – you can perform data modifications […]
When using SQL Server Management Studio (SSMS) you have the option of creating or maintaining tables via regular SQL DDL statements or you can use the built in Designer tool which provides a GUI interface covering a selection of the same functionality such as adding fields, changing data types, maintaining foreign keys etc. Sometimes the […]
Andy Brownsword 