Coming Soon: GET:IT Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET Coming Soon: GET:IT Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET

Tip: Installing SQL Server LocalDB for T-SQL Testing

Home Forums Other Microsoft Servers and SaaS SQL Server 2005 / 2008 / 2008 R2 / 2012 / 2016 Tip: Installing SQL Server LocalDB for T-SQL Testing

Viewing 1 post (of 1 total)
  • Author
    Posts

  • Michael Otey
    Participant
    #614637

    <p class=”MsoNormal”>When I’m developing T-SQL code I’ve often used SQL Server LocalDB on my laptop. SQL Server LocalDB is minimal lightweight version of SQL Server that’s designed to enable you to easily test your T-SQL queries, stored procedures and user-defined functions without needing to install a full version of SQL Server which can be time consuming and typically requires its own VM. LocalDB is totally free and is completely compatible with the full version of SQL Server. It can be installed on your desktop or laptop either as an option of the SQL Server Express installation or by using its standalone installer. If you want to check it out you can download the standalone SQL Server LocalDB installer from:</p>
    <p class=”MsoNormal”>https://www.microsoft.com/en-us/sql-server/sql-server-editions-express</p&gt;
    Select the SQL Server 2017 Express LocalDB option to download SQLServer2016-SSEI-Expr.exe and then run the executable to install it.
    <p class=”MsoNormal”>You can connect to SQL Server LocalDB using SSMS, Azure Data Studio, Visual Studio, Visual Studio Code or SQLCMD.</p>

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

Live Webinar: Active Directory Security: What Needs Immediate Priority!Live on Tuesday, October 12th at 1 PM ET

Attacks on Active Directory are at an all-time high. Companies that are not taking heed are being punished, both monetarily and with loss of production.

In this webinar, you will learn:

  • How to prioritize vulnerability management
  • What attackers are leveraging to breach organizations
  • Where Active Directory security needs immediate attention
  • Overall strategy to secure your environment and keep it secured

Sponsored by: