What happens when we drop a column on a SQL Server table? Where's my space?
You have dropped a column and wondering why you haven't recovered any space? Let's take a look.
2024-04-26
1,600 reads
You have dropped a column and wondering why you haven't recovered any space? Let's take a look.
2024-04-26
1,600 reads
Learn how you can use AutomatedLab to quickly create new environments.
2023-08-04
2,365 reads
This article delves into five new dbatools command that work with sequence objects.
2023-05-31
1,450 reads
We cannot import multiple packages on the SSIS server. So, loading 100 packageS from file location will be a tedious task for a DBA. We can solve this issue by making use of the DTUTIL utility. The DTUTIL utility can also import one package at a time, but we can write the batch file using the […]
2021-09-27 (first published: 2021-09-22)
1,456 reads
create a sql server polybase scale out group in azure for free
2021-06-23 (first published: 2021-04-12)
1,549 reads
In this article, I am going to explain fixing a problem related login failure error with SQL Server. The Problem One of the common error in the SQL Server error log is "Login failed for user 'DomainName\ServerName$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]". Even though it says that […]
2020-11-24
40,468 reads
Introduction The Master database. Just in case that you are not familiar with this database, the Master database is used in SQL Server to store all the system information, instance-level settings, logon information, database file locations, etc. SQL Server can't run without access to a fully functional master database. It's highly recommended not to use […]
2020-11-10
3,915 reads
When was last time you have checked your Always On Availability Groups' replicas storage distribution?
2020-11-09
1,840 reads
-WhatIf you could see what would happen if you ran a command?
2020-10-23
3,723 reads
A colleague left the company, a couple of days after SQL Server processes start failing...what do you do?
2020-09-29
6,123 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Comments posted to this topic are about the item One more reason to use...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers