how to embed a PowerBI report into HTML code
PowerBI is a powerful reporting solution for Business Intelligence for analytical reports, it is not meant to replace SSRS, the focus of this tool is to be able to...
2018-10-03
7 reads
Blog Posts
Query to determine XE Session status
On a previous post, we discussed what is an extended event (XE) and how to create one.
With the following T-SQL...
2018-10-03
254 reads
Query to determine XE Session status
On a previous post, we discussed what is an extended event (XE) and how to create one.With the following T-SQL you can quickly check what are the currently running...
2018-10-03
15 reads
Shortchanged with International Money in SQL Server
Imagine you have to perform some salary analysis for your employer International Mega Corp.
The data you have to work with...
2018-10-03 (first published: 2018-09-25)
1,737 reads
SQL Change Automation, Visual Studio, and the “Unknown SQL Server Platform” error
I recently set up Redgate’s SQL Change Automation in Visual Studio 2017, and I ran into a confusing error when I started trying to use it. For any other...
2018-10-03
12 reads
What is a DBA anyway?
Some time ago we started a new series here, called Database Fundamentals. The very first post in that series asked...
2018-10-03
289 reads
Go Green with Blue Using Azure
Is your company working on ways to become more environmentally friendly? Taking care of the environment is an important topic,...
2018-10-02
220 reads
Introducing Azure Data Studio
If you’re watching Microsoft Ignite or tracking the information coming out of it on social media, then you know that...
2018-10-02 (first published: 2018-09-24)
3,566 reads
Power BI Dashboards, Reports, and Datasets with the SQL Chefs
Watch this week's video on YouTube
This week I had the opportunity to learn about dashboards, reports, and datasets in Power BI using the best kind of teaching tool: fresh,...
2018-10-02
8 reads
Power BI Dashboards, Reports, and Datasets with the SQL Chefs
Watch this week's video on YouTube
This week I had the opportunity to learn about dashboards, reports, and datasets in Power BI using the best kind of teaching tool: fresh,...
2018-10-02
4 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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...
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