Tag Archives: expert

Part 2 MSSQL Machine Learning – Step by Step

By | June 4, 2020

Now that we have Machine learning services installed on SQL Server the next thing will be to install additional packages. Packages are precompiled code that we can use similar to a function to perform certain tasks. The most common examples are numpy, matplotlib, sklearn etc. Each of these modules contains easy to use functions that… Read More »

SQL Server Machine Learning Using Python – Step by Step

By | June 3, 2020

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… Read More »

3 server settings you can enable in 3 seconds to improve performance

By | May 28, 2020

There are a number of dials and knobs in SQL Server that allow the DBA to fine tune almost every aspect of the server. In this post I highlight five quick wins that every DBA can enable on their server to improve performance. The best part is they will take all of three seconds of… Read More »

How to Increase transfer rate when copying to External HDD

By | May 23, 2020

Recently I had to purchase an additional external hard disk to back up my data. While creating a system image of the laptop I noticed that it was taking far too long. On further inspect I found out the transfer rate was far lower than promised. This post will explain how to identify and fix… Read More »

Series on Tuning SQL Server using Fill Factor to control page splits

By | May 21, 2020

Is it better to take a hit on performance due to Fill Factor or Page Splits? That is the question being answered in this video. As with most things in SQL Server there is a trade-off. Is the impact of additional pages caused by a fill factor of 70% more damaging than the impact of… Read More »

Why you should continue to defrag your indexes:-What are page splits 1/4

By | May 18, 2020

Recently I came across a video in which it was suggested the Page Splits/sec counter was not useful in identifying Page splits and that using fill factor to reduce the number of page splits doesn’t really fix the issues and often makes things worse. Naturally this goes contrary to a number of practices DBAs have… Read More »

Plotting Graph database in Power BI – Greek Mythology

By | May 16, 2020

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… Read More »

What does a brute force attack look like?

By | May 13, 2020

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… Read More »

How to identify conversion issues using TRY_CAST () or TRY_CONVERT()

By | May 12, 2020

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… Read More »

How to navigate between pages in PowerBI

By | May 11, 2020

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… Read More »