Power BI: Where Should My Data Live? Webcast
When you start a Power BI project, you need to decide how and where you should store the data in your dataset. There are three “traditional” options: Imported Model:...
2019-03-28
32 reads
Blog Posts
The Distributed Replay Utility: Replaying for Real (Where Could It Possibly Go Wrong)?
The Short Answer? (In at least a couple of places) When I first learned about the DRU, I was very excited about the possibilities. I began to play with...
2019-03-28
11 reads
A transport-level error has occurred when sending the request to the server.
Brent recently did a post called In Azure SQL DB, what does “The connection is broken and recovery is not ... Continue reading
2019-03-27
47 reads
Capturing a Workload with WorkloadTools
Last week I showed you how to use WorkloadTools to analyze a workload. As you have seen, using SqlWorkload to...
2019-03-27 (first published: 2019-03-12)
1,645 reads
Connect To SQL Server – Back to Basics
The first critical task any data professional should ever learn how to do is how to connect to SQL Server. Without a connection to SQL Server, there is barely...
2019-03-27
486 reads
Connect To SQL Server – Back to Basics
The first critical task any data professional should ever learn how to do is how to connect to SQL Server. Without a connection to SQL Server, there is barely...
2019-03-27
4 reads
Finding “Orphaned” database files – script
When you drop a database from a SQL Server instance the underlying files are usually removed. This doesn’t happen however if you set the database to be offline first,...
2019-03-27
50 reads
Microsoft Azure – How to enable Azure AD Multifactor Authentication using Azure Portal
In this article, we will learn how to enable the Azure AD multi-factor Authentication via Azure Portal. In previous article, we learnt how to set up Azure AD and...
2019-03-27
35 reads
New Improved Azure Elastic Jobs
There is a new way to setup Azure elastic jobs to run against a target group of databases (targeting an elastic pool). I actually found the process quite messy...
2019-03-27
21 reads
Querying temp tables across a linked server.
And if you are still reading you probably fit into one of the following categories.
Not a DBAA relatively new DBALike...
2019-03-27 (first published: 2019-03-14)
848 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers