You know what we really need? Better interpersonal communication
Today we have a guest editorial as Steve is traveling. Ben Kubicek notes that sometimes it is hard for technical people to communicate well.
Create Calendar Table Using Power Query M Language
Learn how to create a customizable calendar date table that can be used for Power BI reports using Power Query.
PowerShell editors and environments: Part 1
There is no shortage of PowerShell editors and environments for developing and running scripts. Greg Moore explains some of his favorites.
Using Dynamic SQL
Today Steve notes that Dynamic SQL can be helpful, but it's a technique you should understand well before you start using it.
Using Azure SQL Data Sync to Replicate Data
Learn how to setup and use Azure SQL Data Sync to synchronize and replicate data from various locations including Azure SQL Database, cloud and on-premises databases.
Win a Pluralsight subscription with Redgate’s competition
Redgate is giving you the chance to win a three-month subscription to the technical skills platform Pluralsight and Redgate goodies with their latest competition. To enter, visit the Redgate Forums and answer the question ‘What’s your favorite SQL Monitor feature and why?’
Microsoft Azure ADF - Dynamic Pipelines
Azure Data Factory (ADF) is a cloud based data integration service that allows you to create data-driven workflows in the cloud for orchestrating and automating data movement and data transformation. Azure Data Factory does not store any data itself. but it allows you to create data-driven workflows to orchestrate the movement of data between supported […]
Viva
Microsoft is working on the future of work, and adapting to remote work. Steve isn't sure this will work, but they have at least one interesting technology idea he likes.
sqldf in R Example for SQL Server
R has a package called sqldf that allows developers to manipulate data inside a dataframe in the same way a SQL developer queries a SQL table which we will cover with examples in this article.
Common Table Expression Misunderstandings
I frequently use Common Table Expressions (CTEs) when I demo windowing functions and get questions about them. Windowing functions are limited to the SELECT and ORDER BY clause which means that you can’t filter or group on them directly. Using a CTE is one way to separate the logic of the query into multiple steps […]
Blogs
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers