How To Guides

Remove Carriage Returns in SQL Server SSMS

Carriage returns in SQL Server Management Studio (SSMS) can break your formatting, logic, or exports – especially when copying from Excel or web forms. Here’s how to clean them up.

1 February 2023 1 Comment

How To Guides

How to create Pivot Tables in Excel

PivotTables in Excel turn raw data into dynamic summaries – perfect for analysing trends, comparing categories, and answering business questions fast.

26 January 2023 4 Comments

How To Guides

How to show line numbers in SQL Server Management Studio

Line numbers in SQL Server Management Studio (SSMS) make debugging and navigation easier – especially when working with long scripts or error messages.

18 January 2023 1 Comment

How To Guides

How to Connect Excel to SQL Server

Connecting Excel to SQL Server lets you pull live data into your spreadsheets – perfect for building dynamic reports and reducing manual copy-paste.

12 January 2023 No Comments

How To Guides

Drag and Drop Field Names in SQL (SSMS)

Speed up your SQL writing in SSMS by dragging and dropping field names – no typing, no typos, just clean code faster.

5 January 2023 1 Comment

How To Guides

Tables in Excel

Excel tables offer dynamic formatting, filter-ready columns, and formula clarity that streamline analysis and reduce errors. This post highlights 10 key benefits – from banded rows to slicer integration – that make tables essential for structured, scalable spreadsheets

28 December 2022 1 Comment

How To Guides

SQL Timesaver – Add comma separators

Speed up SQL formatting with this quick tip: use Excel formulas to add comma separators to long lists of values. Ideal for WHERE clauses, this method saves time and reduces manual errors when working with large datasets.

28 December 2022 1 Comment

add a date dimension in power bi cover page showing a calendar

How To Guides

Add a date dimension table in Power BI

A date dimension table is essential for time-based analysis in Power BI. This post explains how to create one using Power Query, enabling consistent filtering, custom calendars, and advanced time intelligence. It’s a must-have for clean models and reliable visuals.

28 December 2022 5 Comments

How To Guides

Our Top 5 Power BI Timesavers 2022

Boost your Power BI workflow with five smart timesavers – from reusable themes and custom date tables to DAX shortcuts and visual templates. This post highlights practical tips that save hours and improve consistency across reports.

27 December 2022 No Comments

Top 5 SQL Timesavers videos for 2022 title screen

How To Guides

Top 5 SQL Time savers of 2022

Speed up your SQL workflow with five practical time-savers – from using Excel to format value lists to leveraging system views for quick table checks. This post shares simple tricks that reduce manual effort and boost productivity.

22 December 2022 No Comments