As we are nearing the end of a very interesting year, I was mesmerizing about the changes we saw this year. This took me back to what I’d later would call the very beginning of what would become my personal IT-Career, ...
As we are nearing the end of a very interesting year, I was mesmerizing about the changes we saw this year. This took me back to what I’d later would call the very beginning of what would become my personal IT-Career, ...
In this blog I will be talking about Creating and Managing Audits in SQL Server. We will first look at what SQL Server audit is and why you should use it. Then I'll discuss the configuration and activatation of the SQL server audit, and many more...
Automating a Data Factory pipeline using a runbook seemed like an easy last step in a Azure DWH setup I developed lately. The part in my script responsible to start and stop the DWH ran without problems, but then ...
Some time ago I wrote a blogpost to retrieve all the measures from your tabular cube or from your open Power BI files. I made a simple addition to this blog, enjoy! And don't forget to watch the how-to video.
"Basically", Stephanie started, "we have 2 different options under the umbrella what we call Always On. We have on one side Always On High Availability Groups and on the other side we have Always On Failover Cluster Instances. Hence the confusion."
I made a very useful ELT program in python and wanted it do run inside a Databricks cluster. Databricks on Azure fully supports python 3, so I thought I was up for a walk in the park. Trying to import the database connection classes, already gave a small hint of the troubles ahead...
Is SSRS on Azure happening? Well as always in Azure it depends… If you mean that ‘SQL Service Reporting Services’ is going to be provided on Azure, the answer is NO as SSRS is a product name as well as a part of SQL Server. But...
When helping a fellow dba on dba.stackexchange.com, I came across an interesting subject. What about synonyms in Azure SQL DB? We know that synonyms that stay in the current database scope work, but how do we get cross db synonyms to work?
Recently I needed to have a SQL Server 2008 R2 instance to do some testing. I had to install it on my laptop, but I wasn't a big fan of installing such an old version locally. But I found a solution!