I was working with a client just the other day that has several SQL Server 2000 servers still in mission critical production environments, and a couple of newer versions of SQL Server 2005, 2016, 2019. Not often do I admit that I do still occasionally work on SQL Server 2000, and given that we are now in 2022, that makes …
SQL Server 2000 to SQL Server 2019 – What’s the difference? Read more »
One of the feature differences between SQL Server Express Edition and the other paid versions is the ability to schedule jobs or tasks using the SQL Server Agent. Even if you are running SQL Server Express Edition, there is a need to run scheduled jobs. Things like: Backups Index and Statistics Maintenance Shrink DB (Just Kidding, don’t do that) A …
Using OSQL.EXE to run a scheduled task on SQL Server Express Edition Read more »
So you have upgraded to SQL Server 2019, and figuring that you got the new version, you may as well install all the features, including R, Python and Java, but then when you try and do that service pack update you have problems updating and the service pack just hangs installing the SPO.cab. After several retries and searching around you …
Uninstalling R, Python and Java on SQL Server 2019 Read more »