Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
Lots of people have never worked with LocalDB, which is an in-process version of SQL Express. No service account, just a SQL Server instance running with your app. It’s a nice lightweight way to get SQL Server running quickly without a hassle.
This is a SQL Server Express version, but the bare bones for development. This post looks at how you can get this running.
This version of SQL is installed with SQL Express, and with Visual Studio. If you look in this path: C:\Program Files\Microsoft SQL Server\150\Tools\Binn, there is a SQLLocalDB.exe. You can see that here.
This is my SQL Server 2016 version of LocalDB. I can start a new instance by calling this with the CREATE option. I can give this a name as well, as I might want to stat multiple instance for different apps. Here I’ll create an instance called app1.
SQLLocalDB create app1
I then call the same command, but use START instead of CREATE. You can see this reports as started from the CLI. I also add the INFO call to get status.
Now I can connect. I use (LocalDB)\app1 to connect:
I see I’m connected to a version of LocalDB then:
Now it’s just an instance of SQL Server I can use.
SQL New Blogger
I needed to check something for a customer and realized I hadn’t started LocalDB in a long time, so I needed to check the docs. I spent 10 minutes putting this post together.
An easy type of post for any of you out there. Learn something, try something, write something.