Viewing 15 posts - 1 through 15 (of 9,244 total)
Items such as maxdop, max server memory, enable IFI and tempdb configuration are all install time configuration items not post install
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 21, 2025 at 9:16 pm
@use_databasemail is an integer input with no default, it must be specified
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 25, 2025 at 11:43 am
download the Kerberos configuration manager tool and run it, it will provide a report of what it finds
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 25, 2025 at 11:19 am
you need to setup delegation between the endpoints, the account details have to be delegated to the remote endpoint, first make sure all SPNs are correct, then setup the account...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 25, 2025 at 10:53 am
Did you authorise sql agent to use the mail profile?
Use the following script
EXEC msdb.dbo.sp_set_sqlagent_properties @email_save_in_sent_folder=1,
@databasemail_profile=yourprofilename,
@use_databasemail=1
GO
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 25, 2025 at 10:41 am
Now, nothing against Ola Hallengren's script, but I prefer something I can support and that is more targeted to my environment. I also prefer small, specific scripts over...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2025 at 3:30 pm
Oof... I would almost bet real money it was set to default... BUT glad I didn't - it is set to 7 days. That makes me feel better.
Now I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2025 at 3:28 pm
only time you'll want to shrink a database is refreshing into a lower level env where space is limited but even that's frowned upon.
Prod data shouldn't be pushed to lower...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2025 at 3:25 pm
Good morning,
Once again, I find myself Sr. DBA for a company. As I review this latest environment, I see something interesting.
I see one of the main production servers is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2025 at 2:40 pm
On one of my database servers, I have a maintenance plan that includes the following tasks:
1. Check Database Integrity 2. Back Up Database Task 3. Recognize Index (includes Fragmentation...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2025 at 12:00 pm
@grant fritchey
are you feeling bored by any chance 🙂
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2025 at 11:09 am
You can backup and restore databases to a new instance of 2022 from as early as SQL 2005, depending on the compatibility level of the database, this link details the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2025 at 11:05 am
For log shipping, this means the secondary server now has to restore bigger log backup files, increasing replication lag. Your DR site that was just a few seconds behind...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2025 at 10:36 am
check the number of days history retained and the number of projects\packages on the SSIS instance properties, default is 365 days for history and can lead to SSISDB becoming bloated...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2025 at 10:21 am
As already stated, need more detail on the latency length and how the publisher, subscriber and distributor are configured.
The replication monitor usually provides good info on the current state
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2025 at 10:18 am
Viewing 15 posts - 1 through 15 (of 9,244 total)