The First 30 Days at a New Database Job
Over the last four years, ok it seems longer than that, I’ve started four jobs. A couple just weren’t good fits. One I was at for three years. I...
2022-07-11 (first published: 2022-06-27)
675 reads
Blog Posts
usp_SQLServerCarpenter_Tools_Estimate_Cardinality
This procedure will estimate the cardinality of all the columns of the supplied table list. If the table list is not supplied (or supplied with NULL, the default value)...
2022-07-11
27 reads
usp_SQLServerCarpenter_Tools_Estimate_Ineffective_Indexes
This procedure will list down all the indexes (Clustered as well Nonclustered Indexes) whose first key column having poor cardinality.
2022-07-11
27 reads
usp_SQLServerCarpenter_Tools_Estimate_Nonclustered_Indexes_Clashing_With_Clustered_Index
This procedure will list down all the nonclustered indexes, which includes key columns as that of the clustered index. It will also list the key columns of both –...
2022-07-11
27 reads
usp_SQLServerCarpenter_Tools_GenerateTSQLCode_For_Get_Put_APIs
This procedure will generate SQL Code for Get and Put API's. This may be useful if you are developing your own data replication strategy to replicate data across multiple...
2022-07-11
47 reads
Daily Coping 8 Jul 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-07-08
36 reads
Preventing Noisy VM Neighbors for SQL
Last Updated on January 24, 2023 by John Morehouse In today’s modern world, virtualization is often used to help mitigate cost as well as to provide flexibility in scaling...
2022-07-08
23 reads
The Effectiveness of Solar Estimation
We added a solar system to the ranch as a way to hedge against future costs as well as require less energy from the utility. I don’t plan to,...
2022-07-08 (first published: 2022-06-24)
234 reads
When is a mouse not a mouse?
This is the first in the series of tools and technologies that I use to deal with the loss of functionality in my hands and arms. Check out this...
2022-07-08 (first published: 2022-06-24)
336 reads
Daily Coping 7 Jul 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-07-07
16 reads
Blogs
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
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...
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