How to create a Linked Server for SQL Server to PostgreSQL

Linking SQL Server & PostgreSQL via Linked Server Read more →

How to open Task Scheduler by cmd

Question: I'm on a Windows 2016 trying to open Windows Task Scheduler by cmdline - but it's not opening?Could you lete me know the cmd line reference for opening Windows Task Scheduler? Answer: To start Windows Task Scheduler on Windows 2016 use this cmd from the cmdline function: control schedtasks This will open a GUI similar to this one: Read More on Windows Administrative tasks Windows Server 2012 empty recycle bin (SQL Server DBA) Find Windows pagefile location through command line and How to write to a sql error to windows server event viewer (SQL ... Read more →

Alter database compatibility on all databases in a SQL Server Instance

Question: I have a SQL Server Instance with 102 databases at a database compatibility level of SQL Server 2012 (110). I've recently migrated all the databases onto a SQL Server 2016 instance - and the database compatibility level is still at 110. Is there a scripted way I can change the database compatibility level of all the user databases to SQL Server 2016 (130), rather than having to hand crank for every database? Answer: Hi - this is a common problem particularly during SQL Server migration work , which you could solve by generating a script with all the ALTER... Read more →

Cumulative Update 5 for SQL Server 2016 SP1

Keeping up with SQL Server patching can be time consuming - but worthwhile . There are different types of patching: Service Packs - which generally is the minimum level for versioning Cumulative Update - include bug fixes etc - but are more of a general catch up - and not necessarily part of the version timeline Security Patch - Released as necessary. I usually focus on Service Packs & Cumulative Updates. Cumulative Updates include Security Patches. The latest Cumulative Update for SQL Server 2016 SP1 is available as number 5. For detailed notes check https://support.microsoft.com/en-gb/help/4040714 In another post I'll write... Read more →

SSRS migration and renaming the ReeportServer database

With an existing SQL Server Reporting Services (SSRS) deployment, renaming the ReportServer & ReportServerTempDb databases is not straightforward. When the ReportServer database is initially created & named, it is created with hard-coded references to the ReportServerTempDb. There are ways of hacking the stored procedures to point to a new database name – but it’s unsupported – and there is the high risk you will omit changes and create more problems for the service. It is not advisable to use the stored procedure hacking method If you are migrating ReportServer databases from another installation onto a new SSRS installation – then... Read more →