Viewing 15 posts - 196 through 210 (of 2,736 total)
Based on what you say your backup is capturing, I don't think it's getting the filesystem.
On top of that, I'd expect a chance that even if the filesystem (including the...
January 29, 2020 at 5:11 pm
I found a sql agent job that was pre-running the reports at 8am to get them in cache and give the illusion of performance
I am confused, this sounds...
January 29, 2020 at 1:19 pm
unfortunately licensing for the physical server when dealing with virtualization is only available on the Enterprise license.
If using Standard the only option is to license the VM itself as...
January 24, 2020 at 6:34 pm
With SQL Server 2017 Enterprise Edition, customers who have licensed all physical cores on the server can run an unlimited number of instances
(First, a disclaimer. I'm not by any...
January 24, 2020 at 2:43 pm
Please point me to a link which talks about this "pool of new Ids for Identity columns", because I am unfamiliar with it.
Phil, here you go: https://blog.sqlauthority.com/2017/03/24/sql-server-jump-identity-column-restart/
I ran into...
January 22, 2020 at 7:12 pm
The first question would be, do the Oracle drivers show up in SSMS under Server Object->Linked Servers->Providers?
If not, then SQL isn't seeing the drivers and thus can't use them. Additionally,...
January 14, 2020 at 1:50 pm
Good luck with that. Not sure third party tools make this better, but you're welcome to eval SQL Backup from Redgate if...
January 13, 2020 at 4:06 pm
Good luck with that. Not sure third party tools make this better, but you're welcome to eval SQL Backup from Redgate if it might...
January 13, 2020 at 1:30 pm
Grrr
All set to use the dbatools.io Powershell to generate scripts to migrate my SQL logins, only to find out that because of the bloody way our systems get locked down,...
January 10, 2020 at 4:49 pm
Good luck with that. Not sure third party tools make this better, but you're welcome to eval SQL Backup from Redgate if it might help
Yeah, I've...
January 10, 2020 at 3:38 pm
I've not driven near as many cars as you, and certainly nothing as exciting as a 911, but right now I'm reasonably happy with the car I've been driving for...
January 10, 2020 at 2:04 am
Good luck with that. Not sure third party tools make this better, but you're welcome to eval SQL Backup from Redgate if it might help
Yeah, I've trialed it a...
January 9, 2020 at 11:57 pm
Well, I'm finally getting one of my wishes at work and I'm simultaneously happy and worried...
I'm getting complete control over my database backups. We're cloudifying (well, they're calling it a...
January 9, 2020 at 5:54 pm
Well, I suspect most people are already starting their New Years Eve fun, after all, any Australian readers are either already in 2020 or have just a short bit to...
December 31, 2019 at 2:12 pm
Alternatively, stop using the errorlog to capture login events and use SQL Audit or an Extended Events session instead. That way, you can control with fine granularity what you...
December 23, 2019 at 5:14 pm
Viewing 15 posts - 196 through 210 (of 2,736 total)