Tech blog with tips, tricks and hacks

Tech blog with tips, tricks and hacks

for EVs, hardware, software, home automation, programming and more

  • HOME
  • Categories
    • 3D Printing
    • Active Directory
    • Azure
    • Cyber Security
    • Electric Vehicles (EV)
      • EV Charging
      • Škoda Enyaq iV
      • Tesla
    • Hardware
      • Amazon Echo / Alexa
      • Networking
      • Raspberry Pi
      • Sky / Sky+ / Sky HD / Sky Q
    • Home Automation
    • IIS
    • Mobile Devices
      • Apple iPhone and iPad
      • BlackBerry
      • Dumb devices
    • Office 365
    • Operating Systems
      • Mac OS X
      • Windows 10
      • Windows 11
      • Windows Server 2003
      • Windows Server 2008
      • Windows Server 2012
      • Windows Server 2016
      • Windows XP
    • Power Automate
    • Power BI
    • Programming
      • .net
      • C#
      • Command Prompt
      • CSS
      • HTML
      • PowerShell
      • vb.net
    • SEO
    • Software
      • Mircosoft Exchange Server
      • Microsoft Office
      • Microsoft SQL Server
      • Microsoft Teams
    • Telecoms
    • Virtualisation
    • Window Media Services
  • Contact
  • Buy me a coffee
Recent posts
  • [ 22 September 2023 ] Mac OS X tip: How to change the menu bar colour Mac OS X
  • [ 5 August 2023 ] Getting started with Power BI: A beginners guide / tutorial Power BI
  • [ 5 August 2023 ] Getting started with PowerShell: Your ultimate beginners guide PowerShell
  • [ 22 July 2023 ] Power Automate Tips: Convert int to string Power Automate
  • [ 22 July 2023 ] Škoda Enyaq iV tips: You don’t need to use the start/stop button or handbrake Škoda Enyaq iV
HomeSoftwareMicrosoft SQL Server

Microsoft SQL Server

Microsoft SQL Server

SQL Query – select and update at the same time

12 May 2021 Richard Wallace 0

Whilst creating an application, which works from a central job list, I found myself wanting to perform both a select and update query at the same time. Essentially, marking jobs as collected, at the same […]

Create an index without locking the table - SQL Server
Microsoft SQL Server

Create a SQL Server index without locking the table

20 November 2020 Richard Wallace 0

If you have a large table of data in a SQL server database, and you want to add a new index, but can’t afford to lock the table, then this article will help you. However, […]

Microsoft SQL Server

Diagnose SQL server by viewing running and queued queries

25 January 2018 Richard Wallace 1

If you run a busy SQL server an experience performance issues, there are several things you can do to diagnose issues.  I’ll ignore the obvious ones for now (ensuring your queries are streamlined and using […]

Microsoft SQL Server

MS SQL Management Studio – Save changes is not permitted – The changes you have made require the following tables to be dropped and re-created

17 August 2009 Richard Wallace 0

If when using Microsoft SQL Server Management Studio to amend a table you encounter a dialog box saying: Saving changes is not permitted. The changes you have made require the following tables to be dropped […]

LATEST POSTS

  • Mac OS X

    Mac OS X tip: How to change the menu bar colour

    22 September 2023 0
    If like me, you like dark mode, you might be looking through the settings on your nice new Mac, and struggling to see how it’s done. I’d love to know why the menu colour doesn’t [...]
  • Getting started with Power BI: A beginners guide / tutorial
    5 August 2023 0
  • Getting started with PowerShell: Your ultimate beginners guide
    5 August 2023 0
  • Power Automate Tips: Convert int to string
    22 July 2023 0
  • Škoda Enyaq iV tips: You don’t need to use the start/stop button or handbrake
    22 July 2023 0

POPULAR POSTS

  • 3D Printing

    OctoPrint – Flashforge Creator Pro 2

    1 March 2021 14
    Before we start, it’s important for you to note that this isn’t a supported setup for the Flashforge Creator Pro 2 to work with OctoPrint, it’s more of a work around. So it’s completely at [...]
  • Sky Q Hidden Engineers Menu
    25 April 2017 13
  • Download photos from Rightmove using PowerShell [updated]
    11 August 2022 5
  • Change your Sky Q AirPlay / Bluetooth name
    4 October 2017 5
  • How to use your Sky Q box(es) as Wi-Fi repeaters
    3 November 2021 4

Tags

3D Printing Active Directory Ad blocking Alexa c# Command Prompt Creator Pro 2 DAX Docker Electric Vehicle EV Flashforge Home Assistant Home Automation Homebridge Homekit iOS iPad iPhone LightwaveRF logon script Mac OS X tips OctoPi OctoPrint office 365 PowerBI PowerShell Privacy Raspberry Pi Skoda Skoda Enyaq iV Tips Skoda Enyaq Tip Sky Q Sky Q Remote Control Sky Q Voice Control Smart home Teams Tesla Unifi vb.net Wi-Fi Windows 10 tips Windows 11 tips Zappi Zappi Tips
Support me

Buy Me a Coffee

About me

I’m Richard Wallace, an IT professional with more than 20 years experience in IT and web design.

This blog has been setup to share some of my knowledges, hacks, hints and tips.

Follow me
  • Linked In
  • Twitter
  • YouTube
  • Contact
  • Cookie Policy
  • Privacy Policy
  • Terms & Conditions

Copyright © 2023 | Richard Wallace