1. Open `SSMS` -&gt; `Connect`
2. Server name: `(LocalDb)\MSSQLLocalDB`, 
3. Choose Windows Authentication.


For a reference:


[![enter image description here][1]][1]


  [1]: https://i.stack.imgur.com/DHc5it.png

You need to [download][1] and install [SQL LocalDB][2]. It is a special edition of SQL Server that does not allow remote connection and supports windows integrated authentication only. It is a simple one click MSI install so it is easy to deploy. 

&gt; To download and install SQL Server 2016 Express, go to SQL Server
&gt; downloads. LocalDB is a feature you select during installation, and is
&gt; available when you download the media. If you download the media,
&gt; either choose Express Advanced or the LocalDB package.

The above means that now you have to download and run a small downloader (cca 5 MB), select LocalDB (44 MB) and the Microsoft downloader will download MSI package to the folder you select. Then just run MSI package and LocalDB gets installed.

  [1]: https://www.microsoft.com/en-us/sql-server/sql-server-downloads
  [2]: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-2016-express-localdb

To recover your Dump, you need one server where your dump will get uploaded. 
For this you need one MS server. you can connect to server using username and password. After connection to server you can create a DB in which you want the dump to get imported.

If your SQL dump contains create Database statement, then you don&#39;t need to  create one.

If its possible to open SQL dump in text file, you can see Database name required to create or its already have statement to create DB.

Creating Dependency Injection with ASP.NET Core is fairly easy. The documentation explains it very well [here][1] and this guy has a [killer video][2] to explain it.


However, I want to do the same thing with my ASP.NET MVC 5 project. How can handle dependency injection with ASP.MVC 5?

Also, is Dependency injection limited to controllers only or can it work with any class?

  [1]: https://docs.microsoft.com/en-us/aspnet/core/fundamentals/dependency-injection?highlight=dependency#registering-your-own-services
  [2]: https://www.youtube.com/watch?v=5A2UxMGA58g

How to create dependency injection for ASP.NET MVC 5?

I have the following `bash` script which repeats for each image found. It needs to iterated over all *html*, *css* and *js* files, and replace all occurrences of an image within that file.

     for image in app/www/images-theme-dark/*.png
        do
            echo &quot;installing icon&quot; $image
    
            # extract filename from iconpath
            iconfile=$(basename $image)
            iconPath=&quot;images/&quot;$(basename $image)
    
            # replace paths in all files containing icon paths
            find app/www -type f $ -name &quot;*.html&quot; -or -name &quot;*.css&quot; -or -name &quot;*.js&quot; \
                                -or -name &quot;*.appcache&quot; $  \
                -exec sed -i &#39;&#39; -e &#39;s|$iconPath|images-theme-dark/$iconfile|g&#39; &quot;{}&quot; \;
    
        done

However when I run the script `sed` gives:

`sed: can&#39;t read : No such file or directory`

On StackOverflow I&#39;ve found https://stackoverflow.com/questions/22716187/sed-cant-read-no-such-file-or-directory But I already had quotes around `{}`

When I echo the `sed` command and and execute it on the command line manually there is no error.

I am using GNU sed v4.2.2 on Raspbian GNU/Linux 8.0 (jessie)

Does someone see what could be wrong here?

Sed gives: sed: can&#39;t read : No such file or directory

I have downloaded the SQL Server Management Studio (SSMS) 2016 to recover a huge .bak file which is an old backup of a database. But first of all I need to connect to a DB Server.

After install, I execute SSMS and it asks me to connect to a DB Server. I don&#39;t have any and I saw that it is possible to create a &quot;local&quot; db by typing only a dot &#39;.&#39; for Server Name and use Windows authentication. 

It is not working; how to do it?

How to connect to a local database in SQL Server Management Studio?

I have downloaded the SQL Server Management Studio (SSMS) 2016 to recover a huge .bak file which is an old backup of a database. But first of all I need to connect to a DB Server.
After install, I execute SSMS and it asks me to connect to a DB Server. I don't have any and I saw that it is possible to create a "local" db by typing only a dot '.' for Server Name and use Windows authentication.
It is not working; how to do it?

I&#39;ve used SQL Server Management Studio before, but only when the server is already up and running.

I need to start from the beginning and create my own instance on the local computer.

The instructions I&#39;m getting, is just put &quot;.&quot; on the server name and use Windows Authentication. But that gives me a &quot;server not found&quot; error.

Can someone please help? I&#39;m using SQL Server 2012 Management Studio.

I really thought it would be just like Access, create my tables and start creating queries.

Create Local SQL Server database

I am trying to do this:

    ALTER TABLE CompanyTransactions DROP COLUMN Created

But I get this:

&gt;Msg 5074, Level 16, State 1, Line 2
The object &#39;DF__CompanyTr__Creat__0CDAE408&#39; is dependent on column &#39;Created&#39;.
Msg 4922, Level 16, State 9, Line 2
ALTER TABLE DROP COLUMN Created failed because one or more objects access this column.

This is a code first table.  Somehow the migrations have become all messed up and I am trying to manually roll back some changed.

I have *no* idea what this is:

    DF__CompanyTr__Creat__0CDAE408

ALTER TABLE DROP COLUMN failed because one or more objects access this column

I have just upgraded to Visual Studio 2017 Professional and SSMS 17.

I can access my servers and databases through Visual Studio 17&#39;s SQL Server Object Explorer but when I try to execute SSMS outside of the VS IDE&#160;it tells me &quot;*Cannot find one or more components.&#160; Please reinstall the application*&quot;.&#160; I have reinstalled SSMS 17 twice and still cannot run it.

The SSMS executable is at:

`C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe`.

I get the same problem on another machine running VS 2017 Community.

What is causing the message &quot;*Cannot find one or more components.&#160; Please reinstall the application*&quot; when I try to execute SSMS outside of Visual Studio?    What do I need to do to execute SSMS outside of the VS IDE?

SQL Server Management Studio 17 cannot find one or more components

I&#39;ve to add row number in my existing query so that I can track how much data has been added into Redis. If my query failed so I can start from that row no which is updated in other table. 

Query to get data start after 1000 row from table 

    SELECT * FROM (SELECT *, ROW_NUMBER() OVER (Order by (select 1)) as rn ) as X where rn &gt; 1000


Query is working fine. If any way that I can get the row no without using order by.

What is `select 1` here?

Is the query optimized or I can do it by other ways. Please provide the better solution.

ROW_NUMBER Without ORDER BY

I am creating a SSIS project via Biml (Using the current version of BimlExpress per the [Varigence BimlExpress page](https://www.varigence.com/BimlExpress)) that uses a script component within a Data Flow Task.  The project is created without issue however errors when it gets to the Script Component:

&gt;Could not load file or assembly &#39;Microsoft.SqlServer.DTSPipelineWrap, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91&#39; or one of its dependencies. The system cannot find the file specified.

&gt;at ScriptMain.PreExecute()
   at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PreExecute()

I can see this dll within the GAC and when I try to add the reference manually, SSIS states that I can&#39;t add it as it is already included in the project.

However, if I open the Script Component and manually `Build` it - but change nothing else - the Data Flow Task will run through without issue.

To clarify, I know I have changed nothing else as I am recreating this project from the Biml each time I want to test a new approach, which provides a consistent baseline.

---

Does anyone know why a Script Component that includes a reference to a GAC dll, will only work when manually `Built` but not beforehand?

I have used this exact Biml before without issue, though on a different environment.  Worked using Visual Studio 2012 against a SQL Server 2016 instance yet doesn&#39;t here within Visual Studio 2015 (targeting 2012) against a SQL Server 2016 instance.

For further context I have also tested this outputting the SSIS Project targeted at SQL Server 2012, 2014 and 2016 with the exact same error message.

---

#Update

This appears to definitely be a dll version problem in the project as output from BimlExpress, in that if I manually create the `v4.0_14.100.0.0__89845dcd8080cc91` folder with the version 13 dll inside at `C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SqlServer.DTSPipelineWrap` the script component now errors out with the following:

&gt;System.InvalidCastException: Unable to cast COM object of type &#39;System.__ComObject&#39; to interface type &#39;Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData100&#39;. This operation failed because the QueryInterface call on the COM component for the interface with IID &#39;{*ID removed just in case*}&#39; failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

&gt;at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)

&gt;at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PreExecute()

&gt; at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)

SSIS Script Component Cannot Load Assembly Until Manually Opened

&quot;Contains&quot; in Entity Framework core should equivalent to the SQL %like% operator. Therefore &quot;Contains&quot; should be case insensitive however it is case sensitive! (at least in postgres????)

The following only outputs a result when the correct casing for keyword is used.

    context.Counties.Where(x =&gt; x.Name.Contains(keyword)).ToList();

What am I doing wrong?


Entity Framework core - Contains is case sensitive or case insensitive?

I&#39;m learning about microservices and I&#39;m gonna build a project with a microservices architecture.

The thing is, one of my team mates want to use one database for all services, sharing all tables so &quot;data doesn&#39;t get repeated&quot;, each service would be built with different frameworks and languages like django and rails which use very different ORM standards.

What would be the correct approach? Since I think working with one database would involve a lot of &quot;hacking&quot; the ORMs in order to make them work correctly.

Microservices with shared database? using multiple ORM&#39;s?

I am trying to write a simple app using Kotlin and [Room Persistence Library][1].
I followed [the tutorial][2] in the Android Persistence codelab. 

Here is my `AppDatabase` class in Kotlin:

    @Database(entities = arrayOf(User::class), version = 1)
    abstract class AppDatabase : RoomDatabase() {
        abstract fun userModel(): UserDao
    
        companion object {
            private var INSTANCE: AppDatabase? = null
            @JvmStatic fun getInMemoryDatabase(context: Context): AppDatabase {
                if (INSTANCE == null) {
                    INSTANCE = Room.inMemoryDatabaseBuilder(context.applicationContext, AppDatabase::class.java).allowMainThreadQueries().build()
                }
                return INSTANCE!!
            }
    
            @JvmStatic fun destroyInstance() {
                INSTANCE = null
            }
        }
    }

But when I tried to run the app, it crashes immediately.
Here is the crash log:

    Caused by: java.lang.RuntimeException: cannot find implementation for com.ttp.kotlin.kotlinsample.room.AppDatabase. AppDatabase_Impl does not exist
        at android.arch.persistence.room.Room.getGeneratedImplementation(Room.java:90)
        at android.arch.persistence.room.RoomDatabase$Builder.build(RoomDatabase.java:340)
        at com.ttp.kotlin.kotlinsample.room.AppDatabase$Companion.getInMemoryDatabase(AppDatabase.kt:19)
        at com.ttp.kotlin.kotlinsample.MainKotlinActivity.onCreate(MainKotlinActivity.kt:28)
        at android.app.Activity.performCreate(Activity.java:6272)
        at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1108)
        at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2387)
        at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2494)&#160;
        at android.app.ActivityThread.access$900(ActivityThread.java:157)&#160;
        at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1356)

It looks like the class `AppDatabase_Impl` wasn&#39;t autogenerated. I checked the original java app downloaded from codelab and found that `AppDatabase_Impl` was autogenerated.

Kotlin version: `1.1.2-3`  
Room version: `1.0.0-alpha1`

Is there anyone experienced with this?

**Edit:**
Using `kapt` solves my problem. In my case, I have to replace `annotationProcessor` with `kapt`.

  [1]: https://developer.android.com/topic/libraries/architecture/room.html
  [2]: https://codelabs.developers.google.com/codelabs/android-persistence

Android Room Persistence library and Kotlin

I am using Android Database Component Room

I&#39;ve configured everything, but when I compile, Android Studio gives me this warning:

&gt; Schema export directory is not provided to the annotation processor so
&gt; we cannot export the schema. You can either provide
&gt; `room.schemaLocation` annotation processor argument OR set
&gt; exportSchema to false.

As I understand it is the location where DB file will be located

How can it affect my app? What is the best practice here? Should I use the default location (`false` value)?

Room - Schema export directory is not provided to the annotation processor so we cannot export the schema

Microservices architecture suggest that each service should handle it&#39;s own data. Hence any service (Service A) dependent on data owned by other service (service B) should access such data not by making direct DB calls but through the api provided by the second service (service B).

**So what does microservices best practices suggest on checking foreign key constrains.** 

Example: I am developing a delivery feature (microservice 1) for products and certain products are deliverable to only certain locations as mentioned in the products table accessible to only products micro service (mircoservice 2).

How do I make sure that microservice 1 (i.e delivery feature) does not take an order to a unserviced location. I have this question because delivery feature can not directly access products database, so there is no constraints applicable at DB level when a delivery order is place in to delivery data base (no check is possible to see if a foreign key match exists in products database or table).

Microservices: how to handle foreign key relationships

I&#39;m trying to alter the length of the column &quot;Body&quot; in table &quot;Post&quot; like this:

    ALTER TABLE Post ALTER COLUMN Body nvarchar(8000) NOT NULL;

The column is defined as nvarchar(4000) and it gives me this error:

&gt; Msg 2717, Level 16, State 2, Line 1
The size (8000) given to the parameter &#39;Body&#39; exceeds the maximum allowed (4000).

How to alter column nvarchar length without drop

I notice that Database Diagrams are not supported in SSMS version 18, any idea why, and is there a way to get the same functionality?

And why is the T-SQL debugger gone now?

Content Type	Original Author	Original Content on Stackoverflow
Question	Alex	View Question on Stackoverflow
Solution 1 - Sql Server	Xin	View Answer on Stackoverflow
Solution 2 - Sql Server	Vojtěch Dohnal	View Answer on Stackoverflow
Solution 3 - Sql Server	jeetendra Mandal	View Answer on Stackoverflow

How to connect to a local database in SQL Server Management Studio?

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

Solution 3 - Sql Server

Sed gives: sed: can't read : No such file or directory

How to create dependency injection for ASP.NET MVC 5?

Attributions