Forum Replies Created
Viewing 15 posts - 16 through 30 (of 1,079 total)
-
RE: Migrating data from one server to another
How much data are you migrating?
Complete Database or only certain tables or rows?-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: SQL Server express 2017 Limitaions
The link will provide side-by-side edition comparison.
SQL Server Express does not come with a SQL Agent.-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: Log Shipping
Got it right, was hoping to be wrong, and have Azure DB now support it. (ghost Agent or something!)
Thanks for the question.-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: Connecting to an Availability Group
You should connect to your listener name, this will ensure you're always connecting to the R/W Replica copies.
Treat the AG itself and the name as a logical collection, not...-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: SQL server 2017 always On and quorum settings
Best answer I can give, is to check the Stairway series on the subject here.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: Migration from Dev to QA
Yes.
You can script out the database and tables as a create statement and run on your QA environment,Right-Click on your database, Tasks, Generate Scripts.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: How do I change the font in the Enter SQL Query window in SSDT
Oh I see.
I would be very surprised if you can change the font for the task SQL task editor.
Let us know if you manage to solve this.-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: How to schedule a sql script in SQL Express?
You can schedule the execution of scripts using Windows Task Scheduler.
Simply follow the steps on his FAQ section:How do I get started with the SQL Server...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: How do I change the font in the Enter SQL Query window in SSDT
Like this?
I am using, not that it should be different in 2017.Microsoft Visual Studio 2015 Shell (Integrated)
Version 14.0.23107.0 D14REL
Microsoft .NET Framework
Version 4.7.03062
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: Unable to connect from SQL Server Management studio 2016 to SQL Server 2008 R2 database Server
Your issue is TLS related, not so much version or login specific, review all the known issues and fixes with TLS connections here.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: Azure Data Factory
More wrong than correct. Interesting.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: How to get a record if any of it's column values is set to true ?
Your question lacks all the basics of asking good questions here.
I will attempt to answer you anyway, but please supply DDL and sample data for us to assist you...-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: AX On SQL Server 2008
alex.sqldba - Tuesday, June 19, 2018 4:53 AM-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: SSAS to be installed on separate server
komarneni18 - Tuesday, June 19, 2018 4:21 AM-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: RTO AND RPO
Recovery Time Objective - How much downtime is acceptable. Example, the company will not lose money before 2/4/8 hrs of downtime, or they will lose money from the 1st minute.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
Viewing 15 posts - 16 through 30 (of 1,079 total)