Forum Replies Created

Viewing 15 posts - 1,006 through 1,020 (of 6,394 total)

  • Reply To: Report performance of SQL Server

    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...

  • Reply To: smtp in store procedure

    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...

  • Reply To: Error 1105 filegroup full

    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...

  • Reply To: SSRS unable to view previous subscriptions

    What is detailed in the reporting services logs on the SSRS server?

  • Reply To: Azure Data Studio and Jupyter Notebooks

    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"...

  • Reply To: How to access SSRS out of network

    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...

  • Reply To: 64KB Allocation Size

    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...

  • Reply To: Availability groups - licencing considerations

    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...

  • Reply To: Availability groups - licencing considerations

    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...

  • Reply To: sql server installation in azure VM

    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...

  • Reply To: MCSA Certifications - SQL2016

    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...

  • Reply To: Availability groups - licencing considerations

    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...

  • Reply To: Logshipping

    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...

  • Reply To: Use a variable for a file connection manager

    You would set the expression of the FileName property or the ConnectionString property which ever you are building to be that of the parameter either at package or project level...

  • Reply To: Install-DbaFirstResponderKit

    What version of DBATools do you have installed?

    Should be 1.0.114, you should be keeping this up to date.

    With everything that's going on with the BLM movement, terms like master have...

Viewing 15 posts - 1,006 through 1,020 (of 6,394 total)