Refresh a Power BI Dataset using Microsoft Power Automate
Learn how to refresh a Power BI dataset by integrating Power Automate into the report.
Psychological Safety
Building psychological safety inside of a company is hard, but it is important to build trust and develop a team.
Women as Tech Leads – Tackling the Challenges at the Data Community Summit
The WIT panel at this year's PASS Data Community Summit includes a number of women who will answer questions on growing your career and rising up the org chart within your organization.
Backing up MySQL Part 1: mysqldump
mysqldump is one of the most popular database backup tools in the MySQL world. The tool is prevalent partly because it’s very basic and quite powerful – mysqldump database backup tool is command line-based, very simple and very straightforward to use. As far as MySQL or its flavors (MariaDB and Percona Server) are concerned, this command line-based tool is one of the top choices for junior and senior database engineers across the world alike.
Expert-led PASS Data Community Summit Pre-cons
Spaces are still available for next month's PASS Data Community Summit pre-conference sessions - but they’re booking up fast! Choose from 18 deep-dive full day pre-cons, featuring some of the best minds in the data industry, covering everything from technical processes to personal growth.
Register now
DevOps is Culture
A big part of adopting DevOps and becoming better at building software is establishing culture.
MDX in Power BI tutorial
Learn a bit about MDX and how you can incorporate it into your Power BI reports.
Sign up to PASS Data Community Summit 2022
There's still time to register for Summit and unlock access to over 300 sessions. Join peers and industry leaders in the data community homecoming. Register now.
SQL Server Indexes to Improve Query Performance
In this article, we look at how to design SQL Server indexes and why the way an index is created makes a difference in query performance.
Cassandra Springboot Integration
In this article, you will see how to initialize a Cassandra database that is used in a Springboot application.
Blogs
2024 PASS Data Community Summit Prep
By Steve Jones
Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling...
A New Word: Bye-over
By Steve Jones
bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional...
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Forums
PASS Summit Time
Comments posted to this topic are about the item PASS Summit Time
database restore chain
I have a backup of full, differential and transaction log setup for our database....
Temporary Table Problem
Hello everyone, I hope you can help me. I have a table with measurement...
Question of the Day
Incremental Statistics
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers