Tech blog with tips, tricks and hacks

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

  • HOME
  • Categories
    • 3D Printing
    • Active Directory
    • Azure
    • 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 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
Recent posts
  • [ 23 January 2023 ] How to install Home Assistant on a Raspberry Pi using Mac OS X Home Automation
  • [ 22 January 2023 ] Home Assistant: A smart home operating system / software for automation Home Automation
  • [ 20 January 2023 ] How to install PowerShell on Mac OS X Mac OS X
  • [ 19 January 2023 ] PowerShell tips: How to customise your PowerShell profile PowerShell
  • [ 18 January 2023 ] PowerShell tips: 10 tips and tricks to get the most PowerShell PowerShell
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

  • Home Automation

    How to install Home Assistant on a Raspberry Pi using Mac OS X

    23 January 2023 0
    Home Assistant is an open-source home automation platform that allows you to control and automate various aspects of your home. It can integrate with a wide range of devices and services, such as lights, thermostats, [...]
  • Home Assistant: A smart home operating system / software for automation
    22 January 2023 0
  • Install PowerShell on Mac OS X
    How to install PowerShell on Mac OS X
    20 January 2023 0
  • Custom PowerShell Profile
    PowerShell tips: How to customise your PowerShell profile
    19 January 2023 0
  • PowerShell tips: 10 tips and tricks to get the most PowerShell
    18 January 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
  • Change your Sky Q AirPlay / Bluetooth name
    4 October 2017 5
  • Download photos from Rightmove using PowerShell [updated]
    11 August 2022 5
  • Škoda order/build status codes
    2 November 2021 3

Tags

3D Printing Ad blocking ajax ajaxtoolkit Alexa asp.net BT Home Hub c# Command Prompt Containers Creator Pro 2 DAX Docker Flashforge Home Assistant Home Automation Homebridge Homekit iOS iPad iPhone logon script Microsoft Exchange Networking OctoPi OctoPrint office 365 PowerBI PowerShell Privacy Raspberry Pi Router Skoda Skoda Enyaq iV Tips Sky Q Sky Q Hack Sky Q Remote Control Sky Q Voice Control Unifi vb.net VoIP Wi-Fi Windows 10 tips Windows 11 tips wireless networks
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