SQL Server Machine Learning Using Python – Step by Step

In this series of post we are going to cover all the steps required to be able to perform Machine learning on Microsoft SQL Server. We will start off with installing and configuring Machine learning on MS SQL Server. Followed by adding packages to SQL Server using sqlmlutils and finally using data from SQL Server…

Plotting Graph database in Power BI – Greek Mythology

During the lockdown I started rereading Stephen Fry’s Mythos. A modern interpretation of the Greek myths with the trademark Fry Humor. Greek mythology like most ancient literature is dotted with characters related to each other in a number of ways and presented a great opportunity to create a Graph database of the different characters and…

What does a brute force attack look like?

Ever wondered if your server is being targeted for a brute force attack? What does it look like? How to prevent it? What is a brute force attack? A brute force attack is different from other attacks because it’s relying purely on a numbers game to gain access to the system. Unlike social engineering attacks…

How to identify conversion issues using TRY_CAST ()

A common issue with the ELT process is that you find out errors after they have been loaded. This is usually not any issue unless the database specifically doesn’t have an option to help identify the error specifically. An example of this is the relief expressed by developers when Microsoft announces the release of the…

How to navigate between pages in PowerBI

In this post we explore the way to navigates between pages in PowerBI. The latest release of PowerBI has made this process very simply and most developers will find it useful to convert the old bookmarks into Action events. This will not only reduce the number of steps but also improve usability. Adding a button…

How to Backup MySQL databases

WordPress uses MySQL as its database back end and as a result it is important to upgrade and patch MySQL database versions when possible. This is especially true for older versions of MySQL which get installed by default with older WordPress Installers like those found on Web Platform Installer. Before proceeding with any such changes…

How to use Relative Time Filter in PowerBI

In this post we cover how to use the Relative Time Filter in PowerBI desktop. A great features to have when reporting the relative Time Filter Option allows the developer to show only a certain set of date that is constrained relative to the current time. For example show only data from the last 24…

Power BI Automated page Refresh

Automated page refresh is a feature that allows the developer to display real time information on the power Bi report. This is not to be confused with features like incremental refresh which only loads a subset of data from very large tables. Automated page refresh supports two mode Scheduled and Change Detection (Premium only) In…

PowerBI – Personalize Visual

This feature has been requested a number of times and it’s great to be able to see it being implemented in PowerBI finally. This feature is currently in preview. In order to enable preview features please review the link at the bottom of this post. Once the changes have been made you will need to…

Power BI – New Features – importing data and enabling preview features

PowerBI is one of the products where Microsoft aggressively releases features every month. The effort is paying off as it’s quickly become the industry standard for reporting. The most attractive aspect for most companies is the comparable visualizations at a very attractive price point. In this series of posts we cover the new features released…

Using Snippets in SSMS

A little know and used feature by database developers is Snippets. Database developers understandably do not use this feature because we have long been accustomed to using prebuilt templates and code blocks from other sources. Often we have a readymade template which we customize as needed and that is it. Database administrators have mastered SQLCMD…

Database Options: – Filestream

Filestream is a great feature for databases that have to handle a large volume of BLOB data. It allows the DBA to store data in Filesystem folders rather than data pages within SQL Server. Since the filesystem is meant to store and work with such data it makes it a perfect candidate for this feature….

DB Options: – Parameterization

In this video we cover the two options available under parameterization in MSSQL database properties. Ad hoc queries are queries that aren’t stored procedures. Since the code is ad-hoc in nature we see that the WHERE condition often has hard coded values. Each time the hard coded value changes we see a new execution plan…

DB Options: Page Verify

https://youtu.be/eXLELsEVAP0 It’s become significantly rarer for database corruption to occur nowadays because of hardware and software improvements. In older version of SQL Server it was fairly common for database pages to be corrupted when written to disk especially during power failures etc. Page Verify is one of the options that SQL Server uses to identify…

DB Options – ANSI WARNINGS | ANSI PADDING and more

In this video we cover multiple database options most of which are fairly easy to understand and don’t really require significant research before being set. Often these settings are enabled by default and Microsoft recommends they remain that way. Some of the options we cover are listed below ANSI WARNINGS – Must be set to…