Why Doesn't Database Software Help Us?
Databases don't manage themselves, but Steve sees this as an opportunity, not a problem.
Databases don't manage themselves, but Steve sees this as an opportunity, not a problem.
Beginning with SQL Server 2012, SQL Server Integration Services packages can be deployed and executed from a SQL Server database named SSISDB, which serves as a repository for SSIS packages.
Today Steve asks about the tools you use for your job and if they help or hurt your productivity.
In this article we walk through how to connect to Azure SQL Database using Azure Active Directory authentication along with multi-factor authentication.
Dave Poole explains the need for high quality database documentation and then demonstrates how to document the SQL Server database for a data catalog, in both HTML and Git Markdown, using SQL Doc, SQL Data Catalog, PowerShell, and a few helper scripts to ensure consistency and correctness.
Introduction You often need to check the performance of a PostgreSQL query you just wrote to look for some way to improve performance. In order to do this, you need a report of the query execution, which is called the execution plan). The query execution plan gives you the entire summary of the query execution […]
Spending time on low value tasks isn't often worth the cost for highly paid employees.
This article is an interesting approach to solving a data transformation problem in SQL and Scala. Shel Burkow uses a SQL execution plan for software design.
Some people think every IT department is unique. While that might be literally true, Steve doesn't think that is actually the case.
Authentication is the first step in letting a principal get access to an instance of SQL Server, essentially resolving the question, Who are you? In this stairway level you’ll learn about the basics of authentication and the authentication options available. This level covers logins and users and you’ll learn about the password policies that can help strengthen SQL Server authentication.
By Steve Jones
Here are the slides from my talk today: CI in Azure DevOps If you...
By Steve Jones
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...
By Steve Jones
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers