About SQL, IT and Life
I came across this familiar error recently when writing some scripts. Normally I see this error when doing an insert, and the number of columns you've specified doesn't match the number of values you've provided. But this time it was in an UPDATE script. Here's the script: When this runs it gives an error Column …
Continue reading "Column name or number of supplied values does not match table definition"
We have a database that we refresh every night with data from our production system. This is so that we can do a final test with real data when required. The first step of the job kills all of the users connections, however one of the applications that our developers runs tries to reconnect again …
I have a Synology NAS at home and it's awesome. With access to most things now done over a secure channel (e.g. HTTPS) it's really annoying to not have a valid certificate issued by an authorised authority. Synology is aware of the problem and so have made it super simple to get a certificate from Let's …
Continue reading "Updating Let’s Encrypt SSL Cert on Synology NAS"
I always think it's a great idea to ask for help. When I was a kid, my parents taught me that it's always a good idea to ask for help - the worst that will happen is they'll say no. In IT there is too much to learn so I always think it's a great idea …
Recently, I did regular patching of SQL Server, upgrading to SQL 2014 SP2 CU3. Normally this goes without any problems and we had tested it out in our test environments, but this time it took all reporting services offline. What happened? We upgraded the DR server like normal, but in doing so it upgraded the SQL …
Continue reading "Dangers Patching Reporting Services in a Scale Out Environment"
I had a question yesterday about whether or not you can use a case statement as part of a join condition. I was pretty sure the answer was yes, but we can always just run a simple test to prove it. It's a pretty simple test to setup, I'm going to create 2 tables, populate them …
Continue reading "Can you use a case statement as part of a join?"
Overnight (at least in Australia) GitLab had a little problem: https://twitter.com/gitlabstatus/status/826591961444384768 At the time of writing this, it looks like GitLab has lost about 6 hours of data that it will never see again, that's affected a bit over 5000 projects. In that document it looks like they were doing some maintenance which triggered a replication …
Like a lot of companies that use Windows, my PC is connected to a domain and this is great when I'm connecting to the companies SQL Servers using Windows Credentials in SSMS because it "just works"™. But sometimes I need to VPN to another domain and connect to SQL Servers on the other domain using Windows Credentials. …
Continue reading "Run SSMS as a domain user on a different domain"
While looking at long running queries today I noticed that one of our worst performing queries was a monitoring tool that checked when the last backup ran. SELECT database_name = DB_NAME(DB_ID([database_name])) , type = [type] , backup_start_date = MAX([backup_start_date]) , backup_finish_date = MAX([backup_finish_date]) FROM msdb..backupset WHERE DB_ID([database_name]) IS NOT NULL GROUP BY DB_NAME(DB_ID([database_name])) ,[type] I had …
We use Change Data Capture (cdc) in our production environment on a few tables so we can do some asynchronous processing of data. Our developers have a pre-deployment environment which is a nightly restore of our nightly backups (this has an added bonus of testing our nightly backups). Usually the testers don't care about testing the CDC …
