A current project I’m working on has it’s database stored in Source Control (you should be using source control) using a Visual Studio .sqlproj file. Visual Studio is able to generate a SQL script to update the database to make the objects the same as what is in Source Control. One of the things it […]
A few years ago I needed to join a table to the result of a table-value function and came across Cross Apply. Cross Apply and Outer Apply were introduced back in SQL 2005.
At Microsoft Ignite today, the SQL 2017 release date was finally announced for a week from now, on October 2. SQL 2017 is exciting because of the new Linux and Docker capabilities. Docker in particular will be an interesting one to see, particularly for dev/test environments where the ability to spin up and throw away […]
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.
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 […]
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 […]
This is the final optional step in replicating jobs between SQL instances in an AlwaysOn Availability Group. We use SQL Reporting Services to generate reports for the business. Some of the reports are scheduled to run by business users. When you schedule a job in SSRS it creates a SQL Agent Job. We want to […]
This is part 6 of the Replicating Jobs series. In the previous steps I’ve covered how to setup for replication, how to copy categories, schedules and jobs, and now finally we need to link Jobs to Schedules.
