When was my SQL Server Database Last Accessed?
Your boss walks up to you one morning and says, “Hey, I wanna list of all of our databases and when they were last accessed”. If you’ve got some...
2024-04-15 (first published: 2024-04-02)
1,169 reads
Blog Posts
A New Word: the Wends
the wends– n. the frustration that you’re not enjoying an experience as much as you should, which prompts you to try plugging in various through combinations to trigger anything...
2024-04-12
36 reads
The London Redgate Summit Comes on Apr 17
I’m heading to the UK in a few weeks for the London Redgate Summit. This starts a wild period of travel for me, but I’m excited. This is the...
2024-04-12 (first published: 2024-04-03)
147 reads
What is data classification, and why is it important?
The benefits of data classification and the features of a tool like Microsoft Purview, a unified data governance service. Data classification organizes data into categories based on its type,...
2024-04-12 (first published: 2024-04-02)
411 reads
Bringing the Redgate Seminar to Brisbane
We’ve been on a Redgate tour this year, running lots of events to interest, educate, and inspire customers. We know that there are challenges in building and operating database...
2024-04-10
26 reads
How I use Terraform to deploy my AWS amplify react js project
As a Software Engineer, I would like to deploy my AWS Amplify react js project using Terraform so that I can automate my workflow and eliminate any manual intervention...
2024-04-10 (first published: 2024-04-01)
233 reads
Manually Updating Redgate Monitor/SQL Monitor Patch Info
This post looks at updating the patch information for SQL Monitor/Redgate Monitor without using the automated process. I have other posts on SQL Monitor as well. I heard from...
2024-04-10
61 reads
Power Query ODBC bug affecting date calculations
I was working on an imported Power BI semantic model, adding some fiscal year calculations to my date table. The date table was sourced from a view in Databricks...
2024-04-10 (first published: 2024-04-02)
214 reads
T-SQL Tuesday #173–The AI Job Helper
This month I had a new host, Pinal Dave. I was surprised to see he hadn’t hosted, but I didn’t see him in the list. His invite is interesting,...
2024-04-09
45 reads
Announcements from the Microsoft Fabric Community Conference
(Shameless plug: The price of my book “Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh” has dropped on Amazon to its...
2024-04-08 (first published: 2024-03-28)
543 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers