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 […]
simple-talk.com
What’s new in T-SQL in SQL Server 2022
There are many new features in SQL Server 2022. In relation to T-SQL querying, there are a […]
Boost productivity with ‘Solution Summary’ cards
Solution Summary cards are the name I have given to simple 1-page documents we provide to developers […]
Searching through a database via SQL
Imagine that while developing or testing a SQL Server database, you get an error message mentioning a […]
Parameterizing Azure Policy and Ensuring Azure SQL AD Authentication
I wrote before about enforcing Azure SQL AD Authentication using Azure Policies in two different ways. First, […]
Introducing the MySQL SELECT statement
The series so far: Getting started with MySQL Working with MySQL tables Working with MySQL views Working […]
The Job of a Technical Editor (as Louis sees it)
One of the most essential parts of producing a great technical article, blog, or even a book, […]
Summarizing data using GROUP BY and HAVING clauses
SQL Server provides the GROUP BY clause as a means to take a set of detailed values […]
Security in MySQL: Part Two
Welcome back to this series about improving the security in your MySQL infrastructure. The first part of […]
Datamarts and exploratory analysis using Power BI
Power BI Datamarts is an important new feature announced during BUILD. This new feature expands Power BI […]
How to troubleshoot and fix PostgreSQL performance issues
PostgreSQL is a popular database that is used by many applications. It’s been in active development for […]
Azure Synapse Link for SQL: From production to a data ...
The Link technology in Synapse is used to synchronize data from different data sources to Synapse Analytics. […]
The VALUES clause or building tables out of nothing
The VALUES clause is probably one of the most misused features in SQL. If you look at […]
Power BI: When a Power Query Native Query is not ...
In Power BI, when importing data with Power Query, one basic performance concept is the use of […]
Security in MySQL: Part One
Security is a critical part of any infrastructure – it’s even more so in the database world, […]
Creating unique datasets with managed code
Figuring out uniqueness in large datasets is somewhat trivial in SQL via the DISTINCT statement. This DISTINCT […]
Text Mining and Sentiment Analysis: Oracle Text
The series so far: Text Mining and Sentiment Analysis: Introduction Text Mining and Sentiment Analysis: Power BI […]
A UNIQUE experience
If you look at the postings on SQL forums, you will notice that people are sloppy. They […]
Improving performance with instant file initialization
As a database administrator, one of your jobs is to make sure each SQL Server instance you […]
SQL Server and hyperconvergence
A growing number of organizations have deployed hyperconverged infrastructure (HCI) systems in an effort to simplify IT […]
Embed Power BI in Jupyter Notebooks
Microsoft recently announced the ability to include Power BI reports inside Jupyter notebooks. After overcoming the dazzle […]
Introduction to generic Power BI themes
Power BI has taken the world by storm when it comes to creating attention-grabbing dashboards that empower […]
SQL Server transaction log architecture
The transaction log is a file that each SQL Server database has. It can be thought of […]
SQL Server performance tuning: Nine best practices
SQL Server is a powerful and feature-rich database management platform that can support a wide range of […]
DBA in training: SQL Server high availability options
The series so far: DBA in training: So, you want to be a DBA… DBA in training: […]
Oracle Sequences: RAC
The series so far: Oracle sequences: The basics Oracle sequences: RAC In my first article on Sequences, […]
SQL Server security – Providing a security model using user-defined ...
When developing an application that accesses SQL Server, you need to set up a security model, so […]
SQL Server plan cache mining – Plan attributes
The execution plan cache in SQL Server is a treasure trove of information about queries that have […]
How to choose between SQL and NoSQL databases
Organizations that support data-intensive applications must make many decisions about how to best implement and maintain them. […]
SQL Server Security – Fixed server and database roles
Managing Security for SQL Server is extremely important. As a DBA or security administrator, you need to […]
Building a SQL Server data dictionary
A data dictionary is a documentation tool that provides metadata, metrics, or details about a database and […]
Oracle sequences: The basics
Many database applications make use of “meaningless ids” or “synthetic keys” rather than using columns of user […]
A data transformation problem in SQL and Scala: Dovetailing declarative ...
Part II : Equivalent Solutions in Functional Programming – Scala Part I of this two-part series presented […]
What to monitor for SQL Server security
SQL Server databases are under greater threat than ever. Cyberattacks are on the rise, and they’re becoming […]
Mastering TempDB: Managing TempDB growth
The series so far: Mastering TempDB: The basics Mastering TempDB: Managing TempDB growth As you learned in […]
What is interpolation?
Interpolation is a mathematical technique which was popular before we had a lot of cheap computing power. […]
How SQL Server synonyms help database DevOps
Synonyms inside SQL Server are one of those useful but forgotten features. A synonym is a database […]
A data transformation problem in SQL and Scala: Dovetailing declarative ...
Part I: Problem Space, SQL Server Simulation and Analysis This article covers an interesting approach to a […]
SQL Server authentication methods, logins, and database users
Setting up and managing SQL Server security is an important part of building and maintaining your SQL […]
How to become a data scientist: A data-driven approach to ...
Imagine a world without any data. Now imagine the extent of all the available data. Both are […]
Storage 101: RAID
The series so far: Storage 101: Welcome to the Wonderful World of Storage Storage 101: The Language […]
Key insights from the 2021 State of Database DevOps survey
This is the fifth year that Redgate has surveyed IT professionals about their organization’s DevOps practices. Each […]
Recruiting DBAs for DevOps
Experienced DevOps professionals have the responsibility to assimilate new people into the movement. DBAs coming on board […]
DBA in training: SQL Server under the hood
The series so far: DBA in training: So, you want to be a DBA… DBA in training: […]
Mastering TempDB: The basics
I regularly deliver a presentation called “Mastering TempDB”. I wrote it based on what I wish I […]
SQL Server triggers: The good and the scary
SQL Server triggers are a subject of both functionality and controversy on any database platform. They can […]
Search SQL Server error log files
Each instance of SQL Server logs information about its processing to a file known as the error […]
Oracle archived redo size – the research
In an earlier article, I explained why you might see log file switches taking place much more […]
Kubeflow for data scientists introduction
Kubeflow is a Machine Learning platform that runs on top of Kubernetes and provides end to end […]
Database version control: Getting started with Flyway
“Database migrations made easy” and “Version control for your database” are a couple of headlines you will […]