A New Word: Idlewild
idlewild – adj. feeling grateful to be stranded in a place where you can’t do much of anything, which temporarily alleviates the burden of being able to do anything...
2023-08-04
10 reads
Blog Posts
Altering the Default Schema for a User
I had to test something for a customer, and as a part of this there as a need to have a different default schema for a user. I wrote...
2023-08-04 (first published: 2023-07-19)
236 reads
Microsoft Fabric: Lakehouse vs Warehouse video
Since Microsoft Fabric became available, I blogged about it and have an introduction video on Fabric that you can view here. I wanted to follow up with a short 30-minute video...
2023-08-04 (first published: 2023-07-18)
470 reads
Things I Carry in My Travel Bag
A friend asked me for some travel tips and ideas recently. One of their questions was on what types of things do I actually carry on the road, both...
2023-08-03
19 reads
How do I tell if a user is orphaned or actually created without a login?
One of the wonderful things about blogging is the ability to make notes for future me. Which is basically what ... Continue reading
2023-08-02 (first published: 2023-07-18)
667 reads
Steps to Have a Service Principal Take Over a Dataset in Power BI When Using Data Gateways
A little background for those new to using Power BI and Data Gateways. If the data source for your Power BI dataset lives on-prem or behind a private endpoint,...
2023-08-02 (first published: 2023-07-17)
471 reads
I’m speaking at the Data Saturday Holland!
As you may have noticed, the agenda for Data Saturday Holland was recently published. I’m delighted to share that I will be conducting a full-day precon on October 7,...
2023-08-01
15 reads
T-SQL Tuesday #165: What Do All The Database Job Titles Actually Mean?
It’s an honor to host this month’s T-SQL Tuesday. In case you don’t know the rules already, here is a recap of them: Earlier this year, when I was...
2023-08-01
135 reads
A high level view of the most costly queries by CPU
A high level view of the most costly queries by CPU
I want to see at a high level i.e at batch or stored procedure level, not at the individual...
2023-07-31 (first published: 2023-07-13)
1,265 reads
Assigning a Default Schema to a New User–#SQLNewBlogger
I had to test something for a customer, and as a part of this there as a need to have a different default schema for a user. Since this...
2023-07-31 (first published: 2023-07-12)
273 reads
Blogs
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Monday Monitor Tips: ServiceNow Integration
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Forums
How Do I Choose a Good Ophthalmologist in Dubai for Eye Checkups?
Choosing the right Ophthalmologist in Dubai starts with checking credentials, experience with children, and...
SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Cannot get KB959420
Hi, we lost our sever sql2000 To restore database to a new one we...
Question of the Day
The New Database CheckDB
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers