(Nisarg Upadhyay) In this article, I am going to explain how to add a custom widget to SQL Server Operations Studio.
Tag: sql server
Creating Sparklines And Small Multiples In Power BI Using The Google Image Charts API
(Chris Webb) The excellent work that David Eldersveld has been doing recently on using SVG images in Power BI has generated a lot of interest; now that the August 2018 release of Power BI Desktop allows you to set data categories on measures – and specifically the Image URL data category – David has
SQL Python Error – ‘sp_execute_external_script’ is disabled on this instance of SQL Server. Use sp_configure ‘external scripts enabled’ to enable it.
(Manoj) You are running a Python script by using sp_execute_external_script SP but its throwing this error:
SQL SERVER – How to Generate Random Password? – Enhanced Version
(Pinal Dave) Earlier last month, I posted an interview question – How to Generate Random Passwords in SQL Server? – Interview Question of the Week #181. Though, my efforts were honest my answer was not complete in that blog post.
SQL Server Script to Determine Free Space Prior to SQL Server Backup
(Eli Leiba) We need to create a simple piece of T-SQL code that will pre-check the free disk drive space and estimate the database backup size to determine if there is enough space to run the BACKUP DATABASE statement for the selected disk drive.
SQL SERVER – Database Mirroring Login Attempt Failed With Error: ‘Connection Handshake Failed. An OS Call Failed: (80090350)
(Pinal Dave) While Microsoft has introduced an AlwaysOn availability group feature in SQL Server 2012 and people have been using it instead of database mirroring.
Getting Information About the Structure of Tables in SQL
(Hannes du Preez) Sp_help provides a lot of information about the structure of the tables inside your database.
Tips for getting started with Extended Events
(Tibor Karaszi) I know, I know. New habits are hard to learn. Many of us have been using SQL trace and the Profiler GUI for a very long time. And we know that we are supposed to move over to Extended Events (XE), but we postpone it for some later time.
Installing SQL Server 2017 for Linux on Ubuntu 18.04 LTS
Prior to SQL Server for Linux 2017 CU10 the package dependencies prevented install on Ubuntu 18.04 LTS. The SQL Server 2017 installation packages have updated use the libssl1.0.0 package, allowing installation to occur on Ubuntu 18.04 LTS installations.
Script for SQL Server Agent Job Issues Across All Instances
(Pablo Echeverria) There’s a chance your SQL Server Agent Jobs that have been running smoothly forever, but suddenly for no apparent reason they fail.
