Viewing 15 posts - 3,856 through 3,870 (of 39,821 total)
If the data is loaded and the log files keep growing to 100GB in Simple mode, there's not much you can do. Shrinking them makes no sense because they'll grow...
June 21, 2019 at 4:28 pm
dbatools can do this, but SQL Server doesn't really have this. I guess the Data Tier Applications and the .bacpac extrat/import do this as well. I'd lean towards dbatools.
June 21, 2019 at 4:17 pm
I'd lean towards merge here as well, even though it feels like overkill. Doing this with triggers is complex, as you'd likely need linked servers and some sort of merge...
June 21, 2019 at 4:15 pm
I think as Drew mentioned, you need a key created from your EKM provider. That would be something your EKM system gives you sample code on how to do this....
June 20, 2019 at 4:26 pm
Two ideas here, but first, was SSMS installed with a different account than yours?
June 20, 2019 at 4:07 pm
I'll certainly update the article with the link, as this might not be an issue, but still, exposing dev databases live is an issue. These are refreshed, and it's entirely...
June 20, 2019 at 3:58 pm
An important trend as workloads increase. Most of us would prefer more machines to grow a load than a larger single machine.
June 20, 2019 at 3:53 pm
2a. Set the instance to pause to drain connections (or dbs to restricted user)
2b. Tail log backup of databases
2c. script out all logins/linked servers/jobs (This could be done ahead of...
June 20, 2019 at 3:28 pm
No auditing I know of for this. You could restore old backups as a new db and check the job status, using the data from Erland's post to decide which...
June 20, 2019 at 3:21 pm
The link is for OpenQueryStore, ported to 2012/2014. That's why I added it.
June 19, 2019 at 10:59 pm
Excluding article forums is probably a good idea. I'll submit that as a bug.
The user time thing was welcome, since I was in Australia, times looked really strange to me....
June 19, 2019 at 10:57 pm
Not for now. T "bold" adds a lot of tracking code to the process. Some of this can be async, but it has to work in the WordPress platform, and...
June 19, 2019 at 10:55 pm
The most replies was supposed to be last 24 hours, but the filter wasn't applied when we switched some other items (poor code implemented). This finally got fixed last week...
June 19, 2019 at 6:54 pm
While the 'Replies Created' looks a little cleaner without seeing my full reply, I don't know if it is any better, see attached.
This is intended to give you a...
June 19, 2019 at 6:53 pm
Viewing 15 posts - 3,856 through 3,870 (of 39,821 total)