Viewing 15 posts - 136 through 150 (of 2,736 total)
I guess what you’re asking for is the amount of space actually used by data pages within the space allocated to db files of your databases.
To give you such...
April 1, 2021 at 3:59 pm
One of those ports is also the default listening port for McAfee anti-virus.
The only thing I can say to this is "aw h*ll NO!"
Sometime in the coming months we're...
March 4, 2021 at 9:38 pm
Make sure you have regular backups of all user & system databases, especially before doing any type of server or software changes.
Very definitely this too. While neither of the...
February 23, 2021 at 5:52 pm
If you're looking at the SQL Server Installation Center, you go to the "Installation" link on the left, then "New SQL Server stand-alone installation or add features to an existing...
February 23, 2021 at 3:54 pm
Yes. Just start the installer and it will give you the option to "add features" to the existing instance.
February 23, 2021 at 3:38 pm
Yeah, it's government for the "cloud" provider...
My team leads' gone over the contract and it's not specified in the contract. What he's trying to collect, information-wise, is how much we're...
February 3, 2021 at 1:31 pm
So, probably not a comparatively odd thing to do, but I managed to bang out (OK, a LOT was cribbed from a script I found) a Powershell script that can...
February 2, 2021 at 10:08 pm
I know that this is off topic, but I'm wondering how businesses like the state department I work for, will handle things like pensions and so on, with the...
January 5, 2021 at 2:49 am
So pre-COVID I had one day a week of work-from-home, and it was fine. Granted the commute some days into work could be trying (not length, or even slow traffic,...
January 4, 2021 at 1:15 pm
I stand corrected, I'll be honest, I forgot to look at what SQL version section this was in (I'm still mostly on SQL2014, so compression of TDE is still a...
December 29, 2020 at 9:50 pm
So my off-the-cuff thought is, the answer to both is the TDE. Once you enable TDE, your backups (full, log, and differentials) are encrypted / backing up encrypted data. Encrypted...
December 29, 2020 at 7:11 pm
We've been using Teams for a lot of communication, but sometimes it's nice to get up and walk over to someones' desk, or turn the chair to chat...
December 15, 2020 at 3:44 pm
We've been using Teams for a lot of communication, but sometimes it's nice to get up and walk over to someones' desk, or turn the chair to chat with them.
One...
December 15, 2020 at 2:11 pm
Found out the other week, we're likely to be working from home to the end of June 2021...
So I splurged and bought myself a new, more adjustable desk chair than...
December 14, 2020 at 4:07 pm
Yes, because the backup is only the actual data in the database, as well as enough info to re-create the database files. So you could have a 1TB size-on-disk but...
September 24, 2020 at 5:48 pm
Viewing 15 posts - 136 through 150 (of 2,736 total)