In my 24 years in IT, I’ve had the privilege of working with some incredibly talented developers and committed infrastructure professionals. Yet, there’s a persistent gap I’ve noticed in almost every SME I’ve encountered — a gap that most don’t see until it’s too late or is reluctantly accepted despite causing ongoing issues. This gap […]

To put it simply, Microsoft SQL Server is like a powerful and organised digital filing cabinet, specifically designed to handle huge amounts of data. The data isn’t just any random collection; it’s methodically stored, updated, and retrieved to serve various purposes. SQL stands for Structured Query Language, a programming language specifically created for managing and […]

Whenever I present demo scripts, I often set up Users, mentioning “without Login”. This raised an intriguing question recently: What’s the distinction between Logins and Users in SQL Server? Answering this via text was challenging, but I managed a concise yet accurate response. So, I’ll break it down in a simplified manner here. Essentially, a […]

Exciting news! Today marks the launch of The Virtual SQL Specialist. This is your ultimate destination for all things Microsoft SQL Server, providing expert consultancy, top-tier support, comprehensive training, and much more! Check out our brand new website – the-vsql.co.uk – to find out more. #SQLserver#Wakefield#sqlserverdba#sqlskills#newbrand

Microsoft SQL Server, simply put, is a database server. It holds and fetches data for various applications such as Sage, SAP Business One, and Intact iQ. Microsoft SQL Server can be installed on your on-premise server or accessed through the cloud. When set up right, SQL Server is fast, secure, resilient, incredibly powerful and a […]