Viewing 15 posts - 16 through 30 (of 1,976 total)
That's how we did it. Most important things are the encryption keys
July 11, 2024 at 7:59 am
I've found https://www.sqlservercentral.com/articles/migrating-sql-server-reporting-services
To migrate from 2014 to 2016. 2016 to 2019 should be similar.
Don't have experience with scale-out.
Beware, from 2017/2019 MS disabled multiple SSRS instances on the same server
July 9, 2024 at 3:46 pm
As we work on goodwill, please provide some sample data, the formatted query (like Phil did), expected results
DDL: tablestructure/views
Sampledata: insert statements
Query: formatted / human readable ( code tag?)
Expected results
Otherwise: have...
July 9, 2024 at 3:22 pm
LOL "NOTE: No Refresh Buttons were abused in posting this message"
June 7, 2024 at 2:14 pm
Nvarchar(max). Every now and then the developers get a reminder to review those. They sneak in when you're in a hurry.
SELECT table_schema,table_name,COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE data_type in ('nvarchar','varchar','char','nchar')
and CHARACTER_MAXIMUM_LENGTH=-1
ORDER...
June 7, 2024 at 2:13 pm
Thanks
Steve for the Json references, Phil for the validation, Frederico for the date suggestion.
My workaround is storing it in an nvarchar(max) variable, replace the wanted character and write it back...
June 3, 2024 at 3:40 pm
We're currently using to much on-premises addons (sql agent, SSRS, SSIS, linked servers). Currently spoiled with our hardware infrastructure.
If we move, it would be Azure SQL for small databases.
May 27, 2024 at 8:05 am
Kubernetes is indeed complex to setup and maintain. That's why except the odd containers we work with vm's on-premises.
The cloud can handle that complexity better behind the scenes.
May 21, 2024 at 9:21 am
Querystore could have been full at that moment, then it switches to readonly mode skipping your query.
Query store capture mode also influences what is captured. https://www.sqlozano.com/query-store-customising-your-capture-mode/
May 15, 2024 at 11:47 am
https://www.brentozar.com/archive/2012/03/how-decide-if-should-use-table-partitioning/
I'm quite hesitant to use partition because it requires maintance and good queries that support it. Maybe the odd partition swap.
As Brent usually mentions, what is the developer trying...
May 10, 2024 at 10:12 am
Recently I had the opportunity of 3 monitors and I liked it.
1 as main screen, 2 as internet browsing / compare, 3 as backgrond monitoring/email etc
May 10, 2024 at 9:20 am
The 504 gateway error is annoying. So far the posts went through
May 8, 2024 at 9:56 am
We don't have an official off hours call support duty. The occasional call may get fixed if the person feels up to it, otherwise it is postponed to working hours.
May 3, 2024 at 2:51 pm
The square ones didn't complete
https://joeydantoni.com/2016/11/02/circles-and-squares-what-do-they-mean-in-the-query-store/
May 2, 2024 at 1:15 pm
Viewing 15 posts - 16 through 30 (of 1,976 total)