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)
953 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
8 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
460 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
169 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)
138 reads
Statistics Parser
Using Statistics Parser to easily read output from STATISTICS IO and STATISTICS TIME.
2023-05-23
288 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
25 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)
483 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
128 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)
415 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers