Creating Azure Policy to setup Virtual Machine Auto-Shutdown
The Auto-Shutdown policy is another important policy to ensure our virtual machines don’t expend more than what […]
The Auto-Shutdown policy is another important policy to ensure our virtual machines don’t expend more than what […]
There are many new features in SQL Server 2022. In relation to T-SQL querying, there are a […]
Solution Summary cards are the name I have given to simple 1-page documents we provide to developers […]
Imagine that while developing or testing a SQL Server database, you get an error message mentioning a […]
I wrote before about enforcing Azure SQL AD Authentication using Azure Policies in two different ways. First, […]
The series so far: Getting started with MySQL Working with MySQL tables Working with MySQL views Working […]
One of the most essential parts of producing a great technical article, blog, or even a book, […]
SQL Server provides the GROUP BY clause as a means to take a set of detailed values […]
Welcome back to this series about improving the security in your MySQL infrastructure. The first part of […]
Power BI Datamarts is an important new feature announced during BUILD. This new feature expands Power BI […]
PostgreSQL is a popular database that is used by many applications. It’s been in active development for […]
The Link technology in Synapse is used to synchronize data from different data sources to Synapse Analytics. […]
The VALUES clause is probably one of the most misused features in SQL. If you look at […]
In Power BI, when importing data with Power Query, one basic performance concept is the use of […]
Security is a critical part of any infrastructure – it’s even more so in the database world, […]
Figuring out uniqueness in large datasets is somewhat trivial in SQL via the DISTINCT statement. This DISTINCT […]
The series so far: Text Mining and Sentiment Analysis: Introduction Text Mining and Sentiment Analysis: Power BI […]
If you look at the postings on SQL forums, you will notice that people are sloppy. They […]
As a database administrator, one of your jobs is to make sure each SQL Server instance you […]
A growing number of organizations have deployed hyperconverged infrastructure (HCI) systems in an effort to simplify IT […]
Microsoft recently announced the ability to include Power BI reports inside Jupyter notebooks. After overcoming the dazzle […]
Power BI has taken the world by storm when it comes to creating attention-grabbing dashboards that empower […]
The transaction log is a file that each SQL Server database has. It can be thought of […]
SQL Server is a powerful and feature-rich database management platform that can support a wide range of […]
The series so far: DBA in training: So, you want to be a DBA… DBA in training: […]
The series so far: Oracle sequences: The basics Oracle sequences: RAC In my first article on Sequences, […]
When developing an application that accesses SQL Server, you need to set up a security model, so […]
The execution plan cache in SQL Server is a treasure trove of information about queries that have […]
Organizations that support data-intensive applications must make many decisions about how to best implement and maintain them. […]
Managing Security for SQL Server is extremely important. As a DBA or security administrator, you need to […]
A data dictionary is a documentation tool that provides metadata, metrics, or details about a database and […]
Many database applications make use of “meaningless ids” or “synthetic keys” rather than using columns of user […]
Part II : Equivalent Solutions in Functional Programming – Scala Part I of this two-part series presented […]
SQL Server databases are under greater threat than ever. Cyberattacks are on the rise, and they’re becoming […]
The series so far: Mastering TempDB: The basics Mastering TempDB: Managing TempDB growth As you learned in […]
Interpolation is a mathematical technique which was popular before we had a lot of cheap computing power. […]
Synonyms inside SQL Server are one of those useful but forgotten features. A synonym is a database […]
Part I: Problem Space, SQL Server Simulation and Analysis This article covers an interesting approach to a […]
Setting up and managing SQL Server security is an important part of building and maintaining your SQL […]
Imagine a world without any data. Now imagine the extent of all the available data. Both are […]
The series so far: Storage 101: Welcome to the Wonderful World of Storage Storage 101: The Language […]
This is the fifth year that Redgate has surveyed IT professionals about their organization’s DevOps practices. Each […]
Experienced DevOps professionals have the responsibility to assimilate new people into the movement. DBAs coming on board […]
The series so far: DBA in training: So, you want to be a DBA… DBA in training: […]
I regularly deliver a presentation called “Mastering TempDB”. I wrote it based on what I wish I […]
SQL Server triggers are a subject of both functionality and controversy on any database platform. They can […]
Each instance of SQL Server logs information about its processing to a file known as the error […]
In an earlier article, I explained why you might see log file switches taking place much more […]
Kubeflow is a Machine Learning platform that runs on top of Kubernetes and provides end to end […]
“Database migrations made easy” and “Version control for your database” are a couple of headlines you will […]