Recommended Posts

How do I manage SQL Server Express visually? (as in, not via command line). I need to be able to create databases, create tables, etc. I believe that there is a program from Microsoft for this, but the name escapes me. :)

Link to comment
https://www.neowin.net/forum/topic/1064580-configuring-sql-server-express/
Share on other sites

Thats it but if you are professionally going to go into SQL management, I suggest you find the command line equivilent of what you want to do and do it that way. Practice makes perfect.

MySQL Workbench actually generates the code when you (for example) create a database. I copy and paste and execute that code instead just to get used to some of the terms :)

  • 1 year later...

I m no DBA but as an SA Im constantly utilizing SMMS, there are alot of great features in the latest versions especially with the Wizards that make new DBAs a little more confident. SQL is a constant training experience I am always learning something new.

A major use for SQL (at least in terms of Windows servers) is server/network administration (System Center 2007 and newer); however, that doesn't require you to write a lick of code.

Point of data - I am putting the finishing touches on the administration side of my virtualization lab. The front end is System Center 2012 (Configuration Manager, Endpoint Protection, and Virtual Machine Manager). SCCM and SCVMM have connected-but-separate SQL Server Express databases (built by their respective installers using default settings) - SQL Server 2012 Express itself costs nothing. (I could have used the full-sized SQL Server 2012 - however, it would be major overkill for a virtualization lab. For bigger administration tasks, System Center 2012 and its components fully support SQL Server 2012 - which itself can upgrade SQL Server 2012 Express, if usage require an upgrade.)

I m no DBA but as an SA Im constantly utilizing SMMS, there are alot of great features in the latest versions especially with the Wizards that make new DBAs a little more confident. SQL is a constant training experience I am always learning something new.

SMMS doesn't require any code-writing, either. If you are using SMMS or System Center (any version), while all require some version of SQL Server, none require writing of code. The closest thing you may get to coding is writing PowerShell cmdlets.

I've been a DBA (dBase), and probably COULD write code (I have some SQL experience, though I am admittedly rusty in SQL admin) - however, the nice thing about SMMS (and System Center) is that you don't have to be a DBA (or know diddly about SQL) to leverage multiple SQL databases.

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • The problem of course is simply that government does not always know best. My point is that agency is taken away from the EU consumer in these cases. I'm sorry, but I do not believe that governments (politicians) are inherently good, and "looking out for me." Primarily they look to themselves and their own personal desires first, foremost, and always. When the EU or the DOJ fines these companies, claiming to "represent the welfare of the consumer," how much of these billion-dollar judgments are handed to the consumers they claim to represent? Not even a dollar, as I've seen. Yet the EUC lawyers who are paid to sit around and dream up these suits make huge commissions on the fines the EUC adjudicates, which is an ironclad fact I hope everyone is aware of. It's also rank corruption, of course, but that's another topic. Last, when the EU inflicts these judgments, or the DOJ, take your pick, the costs are bundled right along in the cost of the goods and services these companies provide the consumers they are "looking out for." If you are someone who believes his government is his savior then you have my condolences. I think Apple is right here, because the whole scheme of consumer choice is that consumers pick and choose among the products companies offer. Microsoft Windows is more compatible with third party software and hardware than any desktop OS on Earth, which is my sole reason for choosing it. Just because the EUC forces companies do certain things it knows the companies do not want to do, "or else", has no bearing on consumer benefit. This Siri thing is almost idiotic it's so infantile. But this is what the EUC does when the EU in Brussels becomes cash-strapped and needs a big infusion of cash. Some people get upset by "big companies" but it's the opposite when governments dwarf the size and scope of these companies, which is so obvious it hurts.... I mean you can't honestly believe that forcing Apple to do things with Siri it has its own reasons to decline is something that "opens up" Apple, do you? Say it aint' so...
    • Looks like many years since the request was made, a directory tree view finally may be added. https://github.com/files-community/Files/pull/18537
    • There's this from last year https://gist.github.com/threat...364659a8887841aa43deca4efd9 but nothing about a buffer overflow that MS somehow can't code against. No matter what, it makes sense to take a "protected by default" approach.
  • Recent Achievements

    • One Month Later
      sjbousquet earned a badge
      One Month Later
    • Week One Done
      sjbousquet earned a badge
      Week One Done
    • First Post
      DragonOfMercy earned a badge
      First Post
    • First Post
      bella52 earned a badge
      First Post
    • Reacting Well
      Techinmay earned a badge
      Reacting Well
  • Popular Contributors

    1. 1
      +primortal
      501
    2. 2
      PsYcHoKiLLa
      213
    3. 3
      +Edouard
      156
    4. 4
      Steven P.
      84
    5. 5
      FloatingFatMan
      72
  • Tell a friend

    Love Neowin? Tell a friend!