Background The dbatools module is broadly used and is an ever-growing set of useful commands. While looking for some inspiration I checked the old issues logged on the GitHub repository. Finally, I found this one Remove-DbaDbMail Profile and Account · Issue #4990 · sqlcollaborative/dbatools (github.com). The issue was more than 2.5 years old (32 months). […]
2021-11-01
3,112 reads
IF you have a requirement to check disk free space and want to report to the team using email, can use my script
2019-05-03 (first published: 2015-06-03)
1,535 reads
IF you have a requirement to check disk free space and want to report to the team using email, can use my script
2015-06-03
313 reads
Sometime due to the heavy load in Exchange servers we received configuration alerts notifications and report delay and that time it is require to move to some other exchange servers to full fill the requirement during the critical periods.
2015-10-06 (first published: 2014-12-19)
1,035 reads
Mmm, I disagree.The SQL Agent proxy account is a windows account in wich non sysadmin SQL users will use to access OS and network resources, by running xp_cmdshell or jobs.All sysadmin users, use the account that start the SQL agent service, the non sysadmin will use that account. But I don't think that it need […]
2004-08-13
You need all of them.If you don't know what the structure is i.e. is notify_level_eventlog an int, smallint, byte it doesn't matter because SQL is intelligent enough to do an implicit cast provided that the data will fit in the datatype chosen for your specific table.i.e. an int holding 32767 will fit into a smallint […]
2004-07-20
SET DATEFIRST 7 --Set First Day of Week to Sunday SELECT SUM(CASE WHEN DATEPART(weekday,[date]) = 1 THEN [column] ELSE 0 END) AS 'Sun', SUM(CASE WHEN DATEPART(weekday,[date]) = 2 THEN [column] ELSE 0 END) AS 'Mon', SUM(CASE WHEN DATEPART(weekday,[date]) = 3 THEN [column] ELSE 0 END) AS 'Tue', SUM(CASE WHEN DATEPART(weekday,[date]) = 4 THEN [column] ELSE 0 […]
2004-07-20
thanks for the help! i was able to connect the 2 computers already However, i have another problem. When i was accessing the database from the server an error occured, 'Server user DPC/Guest is not a valid user in database 'SPCProduction' '(a database i created). And when i was checked SPCProduction in the SQL Server Login […]
2004-06-09
If you are attempting to insert data into a table with a clustered index you have to bear in mind that the data has to be moved about a lot to maintain the integrity of the index. I would recommend dropping the clustered index before the insert and then creating it again afterwards, you should […]
2004-04-06
I recently received a complaint that Query Store for a particular database was turned...
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
By Steve Jones
I had a customer that was looking to document a restore that had occurred...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers