Create a Microsoft Azure SQL Database in screenshots guide.
Creating a Azure SQL Managed Instance database, in Screen shots.
This event has a lot of good video resources. The current/next one will be in Sept 2020 at New Orleans, LA – subject to Microsoft confirmation due to the Covid-19 outbreak. These – event recorded sessions – are also available on pluralsight. Click here for the main website. Click here for some past Session videos.
Got this error below while attempting to run DQC – Data Quality Client – which previously worked on this SQL Server which had previously an ok/verified DQS – Data Quality Server installation. Error text: SQL Server Data Quality Services ——————————————————————————– Message Id: LogOnWindowFailedToConnect Cannot connect to <SERVER>. A .NET Framework error occurred during execution of […]
SQL Server 2017 Development Edition Installation – installation source , click here.
Error screenshots and resolution. Issue from SSMS 2017 – Click here to download SSMS 2017 Get Powershell Gallery from this link. Click here.
Issue: SQL Server 2016 would not send mail on a new server migration to Windows Server 2016 Solution: By default, Windows Server 2016 installs .net framework 4.7 The database mail feature needs .Net 3.5 Install this windows feature and this issue gets resolved.
“R is a free software environment for statistical computing and graphics” – source click here. Useful links: Getting Started with Microsoft R Client Microsoft R Installing DeployR for Microsoft R Server 2016 (8.0.5) on Windows Set up SQL Server R Services (In-Database) SQL Server 2016 R Services: Guide for Server Configuration Quick notes: You […]
Highlights and useful links. SQL Server 2016 SQL Server on Linux Microsoft Data management and analytics
Below is an error that showed up while trying to execute a stored procedure on instance X from SQL server instance y. MYSERVER here represents the name of SQL Server instance X Msg 7411, Level 16, State 1, Line 1 Server ‘MYSQLSERVER′ is not configured for RPC. Solution to this was to set RPC in/out […]