Windows SQL Server Management Studio // IT Management Solutions

Windows SQL Server Management Studio

Man with mustache working on a computerThe primary video card in my (awesome) workstation sadly died earlier this month.

Which meant that rather than fiddle around with trying to get old drivers to uninstall correctly and new drivers to install optimally with my new/replacement video card, I just decided to repave from scratch and save myself some hassle. Benefits of repaving from scratch brought along the allure of the following benefits:

  • The option to install Windows 8.1 Update (from scratch)—which I’m actually quite enamored with as it packs some really great (though subtle) changes and improvements.
  • The ability to cut ties with .NET 2.0 and just go all 4.0 or higher by no longer bothering with Visual Studio 2012 and just going straight to Visual Studio 2013.
  • The ability to also cut SQL Server Management Studio (SSMS) 2012 out of the mix and install SSMS 2014 on to my box as my primary client tool for dev, tweaking, queries, tests, and all things T-SQL-y.
  • The ability to clear out crud, clutter, and cruft from running Windows 8 for over a year, and install a few bigger games and a couple of other apps I no longer want or need. (Or, in other words, to get that runs fast feeling that you get with a new install of Windows and which gradually disappears over time—even on insanely fast hardware like mine.)

Repaving a workstation from scratch is always fraught with a bit of danger or the potential for disaster—but I’ve done it enough times now that I’ve got it down to a science. It also doesn’t hurt that as of Windows 7 and higher, Microsoft has really made OS installation obscenely easy in terms of drivers and initial configuration.

Et Tu SSMS 2014?

There were, of course, a couple of surprises and even hiccups along the way—but the biggest of these was, sadly, in the form of a couple of problems I noted almost immediately when installing SSMS 2014 (and when using it over the next few days). And, just to be clear, I only installed SSMS 2014 and the client tools (I’ve got a VMware host where I run latest server builds and where I keep some dev servers for various tests and exploring—so I don’t need to install SQL Server Developer Edition locally).

You might also like

VISTA & SQL Server Management Studio Express

by dreamweavers

OK, I have vista and installed SQL 2005 with Server Management Studio Express. I logged in as "Windows authentication" and tried to create a database but get an error saying "CREATE DATABASE permission denied in database 'master'. (Microsft SQL Server, Error: 262)"
Grrr... I have done this with XP many times but now with VISTA it does not work. What could be wrong and what can I do to resolve this issue?

My website is slow loading from

by blur

GoDaddy.
I like them but there is a noticeable lag time when I access it.
The SQL Server management interface sucks. It's a web form where you have to copy/paste your stored procs in. Not a good development environment, minimal flexibility. It doesn't maintain indentations or do anything remotely similar to the Management Studio.
Is it worth it for me to upgrade to Windows Server that I host? So that I can run SQL changes from my machine? Plus I'm tired of drilling into their multiple layers of logins that timeout after a period

Here are requirements for a job I found on

by AnotherSite

"BA / BS in Computer Science or equivalent experience. 5 or more years of professional software programming experience in a client / server application environment, with maintenance support experience. Strong analytical, problem solving skills, and background in electric utility industry. Previous project management experience, with strong knowledge of software development life cycle. Solid programming skills with J2EE/Java, C, Monk, AIX and / or Solaris Unix shell scripting, XML, EDI X12, SQL, Oracle PL/SQL, OOD, EAI toolkits, .NET (DotNet), BEA WebLogic, SeeBeyond eGate, Embarcadero DT/Studio ETL Tool, MS Data Transformation Services, MS Windows, MS Office and related tools

Sams Publishing Microsoft SQL Server 2008 R2 Unleashed
Book (Sams Publishing)

Look beyond APM to unified performance monitoring  — TechTarget
ORLANDO, Fla. -- The lack of interoperability among traditional performance monitoring tools means data centers must use -- and pay for -- multiple tools. But movement toward unified performance monitoring could change all that.

Microsoft Software SQL Server Developer Edition 2012
Software (Microsoft Software)
  • Not licensed for production use. Licensed for development and testing only
  • Build and validate applications running on SQL Server 2012.
  • Test enhanced availability, performance and security features, and business intelligence capabilities.
  • Demonstrate to customers and stakeholders before putting solution into production.
  • Investigate performance and manageability by running software on multiple systems.
Sams Publishing Microsoft SQL Server 2008 Management and Administration
Book (Sams Publishing)
Microsoft Software Visual Studio 2010 Professional (Old Version)
Software (Microsoft Software)
  • Unit Testing
  • Windows Development
  • Office and SharePoint Development
  • Microsoft Visual Studio Team Explorer 2010
  • Test Case Management
O'Reilly Media Programming SQL Server 2005
Book (O'Reilly Media)
  • Used Book in Good Condition

Related Posts



Copyright © . All Rights Reserved