Hi there, my name is Rich! I am a database developer or formerly a Senior Information Systems Analyst working in the United Kingdom. This website is my place on the internet for things I have created, articles, tutorials and anything else I would like to share, mainly related to SQL Server and data.
Over on Discord this week we were asked if the below diagram was “good enough” for a …
It has been a long time since a blog post was written here, however today we are announcing the …
I was talking to someone recently about NHS Numbers, if you don’t know, an NHS Number is a …
Sometimes there is a requirement to build out a table based on another table in your SQL Server …
So, you have an availability group and one of your databases gets removed, during the time that the …
In this post we are going to have a look at a very basic PIVOT table and how to go about creating …
When I first started learning SQL Server I had no idea where to start, it is overwhelming there is …
Do you have a complicated SSIS package that has steps which include configuration where things could …
An issue with SQL Server that you might not be aware of is that every time a backup is sucessfully …
In Database Design you will often see tables with a PRIMARY KEY these can be seen in the database …
Information schema’s are one of the methods that SQL Server provides to obtain meta data about …
In SQL Server there are two options for converting data from one data type to another in your T-SQL …
Rich In SQL as a blog turns 12 months old this year, although I have been periodically posting to a …
In this post we are going to look at creating a Test Lab on our local machine, if like me you …
In this post I am going to look at how to find information about objects in all of the databases on …
One thing that I have always wanted to do is explore the data that my Apple Devices capture about my …
Something I always end up forgetting how to do is moving objects between schemas within a database, …
Do you ever have a requirement where you want to spin up a database quickly on a test enviroment but …
In this post we are going to look at re-seeding the identity column on one of our tables, sometimes …
Have you ever written code that when you come to test there was that one column or line of code that …
Another year is complete and when I was thinking about what to write for my year in review post I …
The Formula One PowerBi dashboard is an un official dashboard created by RichInSQL using freely …
Photo By Annie Spratt This is just a quick post to wish you all a very Merry Christmas, whatever you …
Have you ever had a situation where a change was made to a stored procedure, table or schema in a …
Sometimes we have the need to send results which are output from our queries to someone via email, …
In this post we are going to look at how to configure database mail in SQL Server.
There are a number of ways to concatenate strings in SQL server and each will give you a different …
There was a situation recently where the developers had built an application in C# but wanted some …
In Microsoft SQL Server it is possible to create views and also stored procedures, but what are the …
In Microsoft SQL Server it is possible to create views and also stored procedures, but what are the …
Clairon date is the number of days that have elapsed since December 28, 1800, in SQL Server this …
In this post we are going to take a look at Inner Joins, what they are and how they work.
In this post we are going to take a look at Left Joins, what they are and how they work.
A CTE or Common Table Expression specifies a tempoary named result set for the current session, a …
Sometimes you will come across a dataset that contains two or more rows of the same data, in a data …
Recently, we had a user delete a number of rows from a production database by mistake, it transpired …
Something new happened this week, well not new in the sense like buying a new car but new to me, I …
In this post, I want to take a look at datediff, how it works and how I use it as part of my job.
When I first starting learning T-SQL things like DATEADD took a really long time for my brain to …
In SQL Server 2012 Microsoft added a function called EOMONTH, this returns the end of the month of …
One of the things I have spent a lot of time investigating recently is slow running queries, why are …
I have been working on a project at work that needed to make use of a calendar, the data warehouse …
Sometimes Scalar functions are useful, other times however they are not but they do have their uses, …
In this post, I am going to show you how to install SQL Server Intergration services for Visual …
In my new job one of the things I often find myself doing is needing to get the start of the …
So you want to get the first day of the month in SQL server? using DATEADD it is as simple as using …
Recently we had an issue raised that a user was getting an error thrown in the application front end …
One of the most time consuming tasks when configuring a new computer is installing all of the …
It is no secret that the past 18 months has been a challenge for everyone, worldwide.
This year has been incredibly strange to try and bring back some kind of normality I decided to …
I recently moved to a new development workstation at home, still using Windows 10 but it was a fresh …
I had an issue on one node in the new SQL 2014 cluster that had just been built S-SQL06 specifically …
So here we are going to look at corrupting a database and how we can go about restoring the …
This post is mainly for me to look back on in the future and see how this was done, so I will keep …
I needed a way of getting a complete list of databases over multiple instances in SQL Server into …
Last weekend I made a decision, after what feels like a lifetime having sites running on WordPress I …
I was recently asked to move one of our production databases to a staging server, this was to allow …
I have never done a my setup post here before, I don’t think it ever occurred to me that it …
In SQL Server it is possible to insert data from one table into another using a select within the …
I have been having a problem at work where when I try to either install or update a module on my …
I haven’t published a post here in what feels like an eternity, I came across a problem …
Recently I needed to export some data from a table that was being used to hold information from a …
Contents Part One – Project Overview Part Two – Database Schema Part Three – Stored Procedures …
Recently I was asked to look into the possibility of encrypting some of the column level data that …
Contents Part One – Project Overview Part Two – Database Schema The Database Schema In Part One we …
This month’s T-SQL Tuesday comes from Todd Kleinhans (Blog & Twitter) he asked, “what do …
Contents Project Overview Part Two – Database Schema A little while ago I answered a question over …
Last week I wrote about how I was getting started with dbatools a lot has happened since then, I …
I have never really got into PowerShell it is just something that I have never needed to use, …
Recently I came across a stored procedure I had written a few years ago, when I first started as a …
So, I have a problem, TempDB is blowing up, I don’t know what is causing it but I need to …
When you first install SQL Management Studio (SSMS) there are lots of options shown in the toolbar, …
So you have that really fast SSD in your development machine or that machine that is provided by …
Dates are one of the things I find myself googling more than anything else when writing queries, so …
Recently I ran into an issue I had never experienced before, a third party vendor was using …
So, recently I ran into a problem where I wasn’t getting any alerts for any of my SQL Agent …
Recently I was writing a login process that required me to query Active Directory, admittedly …
Availability groups and SQL Server Agent Jobs, how do you go about managing them?
Grab a beverage of your choosing, you may be here for a while…
Let’s warp back in time 15 years, …