Free tools

These are some of the free tools I have available for you to use under MIT License (so you are free to use and modify them at your choice as long as you give me the proper credit)

SQL table to HTML (Version 1.1)


Download file

This stored procedure converts a table or select query to an HTML table format, with some customization options.

A script Carlos Robles from dbamastery.com provided me for a static table was taken as the base, so I modified it to accept any table or select query and apply different or no styles, also you can choose to show or hide columns from the final table.
  • This SP works with dynamic queries, also data is not validated, so it is vulnerable to SQL injection attacks, so always validate and sanitize your queries before using it.
  • Null values are not converted on this initial release, so before using it, remove null values from your data.
  • Some special data types like geography, timestamp, XML, image are not supported, if you try to use them, an error will raise, remove these columns before using it.
  •  This tool is not designed to handle huge amounts of data, so, for massive information, you can split them in various executions.
To Download the source and check documentation, Access this link
Quick tutorial here



Comments

Post a Comment

Popular posts from this blog

Checking Azure SQL DB service tier via T-SQL

Image
If you have to manage or work with an Azure SQL database and want to know what service tier the database is currently operating, but you don't have access to the Azure subscription or CLI. Or you want to know the status of the service tier after a scale up or scale down, directly from the database; you can do it via T-SQL Just query the sys.database_service_objectives DMO to obtain this information, this will give information about the service tier, and also will tell you if the database is part of an elastic pool or not. Basic usage (in the context of the database you need the information): SELECT * FROM sys.database_service_objectives; This will return the following information for the current database: I am running on a General Purpose tier with 1 VCore What if you want the information for all the databases created? Just change the context to the master database and execute the following query: SELECT D.name AS DB , D.create_date , SO.edition , SO.service_o
Read more

Quick tip: Zoom in Azure Data Studio

Image
If you finally have given a try t o Azure Data Studio , and if you use it on a regular basis, maybe you want to customize it to suit your needs. Among the huge customization options it has, you can control the text size in form of zoom. To do change it, just use the following keyboard combinations: (Ctrl + = ) For Zoom in. (Ctrl + - ) For Zoom out. (Ctrl + 0) For Zoom reset.  You can see it in action: Also, as with everything on this tool, you can access this functionality from command palette (Ctrl + Shift + P) , and type "zoom" (you can fine-control the editor zoom from here): If you haven't tried it yet, you can download Azure Data Studio here .
Read more

Embed Azure Data Studio Notebooks in your website

Image
Notebooks are a functionality available in Azure Data Studio, that allows you to create and share documents that may contain text, code, images, and query results. These documents are helpful to be able to share database insights and create runbooks that you can share easily. Are you new to notebooks? don't know what are the uses for it? want to know how to create your first notebook? then you can get started in ADS notebooks checking my article for MSSQLTips.com here . Once you have created your first notebooks and share them among your team, maybe you want to share it on your website or blog for public access. even when you can share the file for download, you can also embed it on the HTML code. On this post, I will show you how to do it. What do you need? We will use an online HTML converter, nbviewer , provided by Jypiter website, on that homepage, you just have to provide the link of your .ipynb file (my GitHub Notebook repository for this example). It looks
Read more