Windows Internal Database
This past Friday I received a call from our systems team stating that they were running low on Disk Space...
Part 2: Why you should be using the Full Recovery Model
Part 2 of the SQL Server Essentials Series looks at why you should be using the Full Recovery Model to protect your data assets.
There's No Such Species as a DBA
Phil ponders whether the term 'DBA' is still really meaningful, or if it's just a blunt instrument used to bash a diverse population into a mis-conceived niche. Is it worth the trouble of being typecast, just to have those 3 letters on your CV?
Best Practice - Increasing the Number of SQL Server Error Logs
By default, there are six achieved SQL Server Error Logs along with the ERRORLOG which is currently used. However, it is a Best Practice to increase the number of SQL Server Error Logs from the default value of six. In this tip, you will see the steps which you need to follow to increase the number of SQL Server Error Logs.
Best Practice - Increasing the Number of SQL Server Error Logs
By default, there are six achieved SQL Server Error Logs along with the ERRORLOG which is currently used. However, it is a Best Practice to increase the number of SQL Server Error Logs from the default value of six. In this tip, you will see the steps which you need to follow to increase the number of SQL Server Error Logs.
Getting Into the Biz, Part 3
In a couple of previous posts (Part One and Part Two), I shared some thoughts about starting a career path...
Lockdown or Let Them Free
Do we take security too far? Are we creating unnecessary rules for those that need to use the resources we support? Steve Jones talks today about security and how we might want to approach it when handling rights for developers.
Lockdown or Let Them Free
Do we take security too far? Are we creating unnecessary rules for those that need to use the resources we support? Steve Jones talks today about security and how we might want to approach it when handling rights for developers.
Lockdown or Let Them Free
Do we take security too far? Are we creating unnecessary rules for those that need to use the resources we support? Steve Jones talks today about security and how we might want to approach it when handling rights for developers.
SQL Server Job Trends on Graphs
A colleague pointed out a site that collects a lot of job posting data and exposes graphs - so I've taken...
Blogs
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
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...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers