Impact of TDE on Performance
Microsoft states that enabling TDE usually has a performance overhead of 2–4%. That doesn’t sound like very much, and personally I wouldn’t let it bother me if I want...
2023-05-24 (first published: 2023-05-10)
957 reads
Blog Posts
Microsoft Fabric – the first look
Microsoft has just announced Microsoft Fabric during the Microsoft Build conference. This is a unified analytic solution of the era of AI. Microsoft Fabric is an end-to-end, unified analytics...
2023-05-24
9 reads
Microsoft Fabric – the first look
Microsoft has just announced Microsoft Fabric during the Microsoft Build conference. This is a unified analytic solution of the era of AI. Microsoft Fabric is an end-to-end, unified analytics...
2023-05-24
463 reads
Setting up a Local http Server with Node
Setting up a local web server was something that I haven’t done in a long time and this was really easy. This post shows how to do this with...
2023-05-24
179 reads
What Backups Are In This File?–#SQLNewBlogger
I had a question on multiple backups in a file and had to check my syntax. This post shows how to see which backups are in a file. Note:...
2023-05-24 (first published: 2023-05-10)
146 reads
Statistics Parser
Using Statistics Parser to easily read output from STATISTICS IO and STATISTICS TIME.
2023-05-23
290 reads
Tales From The Field Weekly Wrap Up for the Week of 05-15-2023 The Graduate & the Very BIG Week
MY WILL, MY BUG, MY GRADUATEJust a little under 18 and one half years ago, William came into my life. There are a lot of words to describe a new...
2023-05-23
27 reads
How to refresh Power BI desktop data
Recently we faced the issue on one project to refresh power BI desktop file to update structures.
There could be various reasons why you would like to automate PB desktop...
2023-05-22 (first published: 2023-05-09)
490 reads
SSAS Tabular Error – A device attached to the system is not functioning
I’m working on SSAS Tabular project and suddenly i got following error when I even try to connect to SSAS.
Messages:
“The following system error occurred: A device attached to the...
2023-05-22
138 reads
T-SQL Tuesday 162 : Data Science and ChatGPT
This month’s T-SQL Tuesday is hosted by Tomaz Kastrun – his call is to write about how we’ve used ChatGPT, and what are ethical issues, if any, that we...
2023-05-22 (first published: 2023-05-09)
418 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers