Blog Articles

by Marcin Gminski

Should we run SQL Server on the default port 1433

There are two types of DBAs. Those that run SQL Server on the default port 1433 and those that don’t. Those that do not run on the default port 1433 say it’s more secure, and those who do say it’s “security by obscurity” do not make it any more secure. Which DBA are you? Let’s find out who is right.

by Marcin Gminski

To log backup or not to log backup

SQL Server has been around for decades, but I still come across companies that do not have dedicated DBAs and do not understand the concept of Log Backups, which often means they put their data at risk.

by Peter Downes

Consistent information and/or correct information

A business perspective may initially suggest that correctness is better since the information is used to drive important decisions however experience suggests consistency to be a far better focus as this drives trust and trust is something that is easy to lose but hard to gain.Imagine if your car brakes worked inconsistently, would you have faith in them that they would work in an emergency? You may get them fixed …

by Peter Downes

Why I build data warehouses

Putting the obvious reasons aside, the aspect that I get most pleasure from is seeing the initial relief and ongoing happiness in the people who can now answer, quicker and more consistently, the many questions they are asked. I rarely get to know the details but can be quite sure that this information helps make better business decisions which helps drive an increase in the bottom line. Everyone has data …

by Marcin Gminski

Dynamic data sources in PowerBI Desktop

What if we had 50 SQL Servers and wanted to plot the history of SQL Agent jobs or any other common metric? And what if we wanted to create a template and be able to feed a different list of servers every time? This could be challenging but hopefully, PowerBI can be dynamic.

by Marcin Gminski

Move data to Azure Archive Storage using PowerShell

We can move existing files, in the existing Storage Account to the archive tier, or upload files as we normally would to an existing account and can then mark them for archiving. This process is completely manual but with the help of PowerShell can be easily automated.

by Marcin Gminski

Use CONTEXT_INFO to avoid firing triggers

DML Triggers are commonly used to apply some business rules to the data in the table. The most common implementation would be updating the date_updated column automatically whenever the data in the table changes. Learn how to avoid firing trigger when doing an update without disabling it.

by Marcin Gminski

How to intelligently auto-cycle ERRORLOG using T-SQL

In my earlier post, I described different ways to read very large SQL Server Log (ERRORLOG) – 5GB – to be exact. However, this was a reaction to something that has already happened. In this post, I will show you how to prevent this from happening at all.