Viewing 15 posts - 1,006 through 1,020 (of 6,400 total)
Well I would never recommend an in-place upgrade as you've no quick and easy backout and it'll be a whole world of pain to go backwards. But then again once...
August 21, 2020 at 7:58 am
Reporting services from 2017 onwards is installed outside of the main SQL installer, as such it no longer exists in the MMC snap-in as its not part of the installer...
August 21, 2020 at 7:44 am
As Andreas has already eluded too, your going to need to go and tune the query doing the data gathering, be that reducing what its doing, adding indexes moving things...
August 20, 2020 at 12:55 pm
You need to configure database mail via T-SQL or the GUI in the Management->Database Mail area.
The first hit in Jeff's link he kindly posted will point you to these three...
August 20, 2020 at 12:51 pm
Lots of things to check, size of the "old" ndf, size of the "new" ndfs, eg you cant put 300GB of data from "old" into 2x100GB of files of "new".
When...
August 20, 2020 at 8:30 am
What is detailed in the reporting services logs on the SSRS server?
August 19, 2020 at 11:43 am
Had to break out of ADS and install manually from python instead
"C:\Users\<myuser>\azuredatastudio-python\0.0.1\python.exe" -m pip install --trusted-host=pypi.python.org --trusted-host=pypi.org --trusted-host=files.pythonhosted.org --upgrade pip --user
"C:\Users\<myuser>\azuredatastudio-python\0.0.1\python.exe" -m pip install --trusted-host=pypi.org --trusted-host=files.pythonhosted.org --trusted-host=prose-python-packages.azurewebsites.net --user "jupyter>=1.0.0" "pandas>=0.24.2"...
August 19, 2020 at 11:42 am
You would be best writing a client website which does this for you and is accessible via the internet and has the proper authentication methods in place.
Making SSRS internet faceable...
August 17, 2020 at 12:25 pm
This raw tin on raw disk or you using VM's with a mounted data store etc.
Reason I ask is that in one shop the disk presented to Hyper-V was formatted...
August 13, 2020 at 12:58 pm
From Server A to ServerB, it would work but not without upgrading server A to be SQL 2016 first
Once you bring the DB online on ServerB to be standby the...
August 12, 2020 at 12:51 pm
Sounds like your going to have to write your own methods.
If they don't allow replication then they wont allow CDC. What about change tracking instead of CDC more lightweight not...
August 12, 2020 at 7:19 am
It depends, you can do it either way, depends how much control over the installation you require and how you are licensing the server.
If your bringing your own license as...
August 10, 2020 at 1:42 pm
Which of the MCSA's where you looking at undertaking?
Development? Admin? BI?
For all of these you would want to look at DP-900 for the new Azure Data Fundamentals exam as a...
August 10, 2020 at 11:47 am
You would need to change ServerC to be Enterprise also, you can't go mixing Dev & Ent in an AG as if you get audited well your going to be...
August 7, 2020 at 9:30 am
One by one in log order
RESTORE LOG <dbname> FROM DISK <path> WITH NORECOVERY;
Why are you manually restoring the logs, what has gone wrong with the native logshipping to require you...
July 22, 2020 at 7:37 am
Viewing 15 posts - 1,006 through 1,020 (of 6,400 total)