Viewing 15 posts - 1 through 15 (of 1,165 total)
This should be straight forward Powershell. There are plenty of search results like:
June 22, 2022 at 8:04 am
ps. If you have not used Azure Automation before there is an outline tutorial if you keep following the next steps link in the following:
https://docs.microsoft.com/en-us/azure/automation/overview
June 21, 2022 at 9:12 pm
Using the Ola scripts the "@CleanupTime" parameter is not allowed !
This is a limitation of the SQL Server BACKUP TO URL and not specifically to do with Ola's scripts.
I...
June 21, 2022 at 9:01 pm
ps In some situations the following may be worth looking at:
https://www.sqlshack.com/introduction-to-sql-server-filtered-indexes/
June 17, 2022 at 8:11 am
multiple bulkier tables with years of data
https://www.sqlshack.com/database-table-partitioning-sql-server/
https://www.brentozar.com/archive/2012/08/potential-problems-partitioning/
June 17, 2022 at 7:03 am
I suspect the SQL Agent and system health will not be much use for this. Assuming you have the basics covered, like enough memory for Windows to run without paging...
June 11, 2022 at 11:28 am
This was removed by the editor as SPAM
June 11, 2022 at 11:14 am
I am not sure what you hope to achieve by signing all the SPs with a certificate. I have only ever signed t-sql SPs when ownership chaining is not going...
May 27, 2022 at 9:23 pm
Here is an article by Brent Ozar which includes performance counters:
https://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/
I suspect the main use for PerfMon information is when there seems to be load on the server but...
May 24, 2022 at 10:15 am
If you have difficulty understanding joins you may want to start with a basic general SQL tutorial:
https://www.w3schools.com/sql/
If you want to learn t-sql you can read Itzik Ben-Gan's books. Maybe...
May 23, 2022 at 6:13 pm
It seems to UPDATE with the first non null value it comes across.
Due to the way SQL Server is internally structured, with a small heap under low load this will...
May 19, 2022 at 6:42 pm
Any major development environment will work with Azure SQL database. (.Net, Java, PHP, Python etc)
As you are asking this question I assume you do not have much development experience. If...
May 15, 2022 at 2:02 pm
Viewing 15 posts - 1 through 15 (of 1,165 total)