Do you wonder why SQL Server ignores an index? Do you think about how you can deal with this problem? When you include too many columns in a query you decrease index selectivity. So, if you write a query like “Select * From …” the chance of choosing your nonclustered index will decrease.
2025-03-03
In this article, we look at how to create a SQL backup to network share or restore a backup from a network share.
2025-02-28
This next article in the Data Engineering with Fabric series showcases how tally tables can help load data in a Fabric warehouse.
2025-02-26
2,311 reads
How can we get familiar with Azure Databricks with Spark Dataframes?
2025-02-26
Learn how to emulate Azure storage for files, blogs, and queues.
2025-02-24
1,774 reads
Let’s get a little nerdy and look at database internals.
2025-02-24
See a walkthrough of setting up a maintenance plan in SQL Server.
2025-02-21
4,565 reads
There will come as time when you need to upgrade the host operating system and SQL Server to a newer version. If you are using SQL Server Integration Services (SSIS), one of the things you may need to do is to move the SSIS catalog (SSISDB database) to the new server. We will cover the steps in this tutorial to migrate the SSISDB from one server to another.
2025-02-21
Learn how to recover a database from a missing or corrupt transaction log file.
2025-02-19
9,868 reads
Accelerated Database Recovery (ADR) is a database-level feature that makes transaction rollbacks nearly instantaneous. Here’s how it works.
2025-02-19
Security on your SQL Server is important. That doesn’t need any explaining. But where...
It’s that time of year again! EightKB is back on August 20th at 13:00...
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
Comments posted to this topic are about the item Are You Working More Hours?
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Comments posted to this topic are about the item A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers