SqlServerKudos

Management Studio

1
kudos

Kudos

SQL Server Managebility Series: Management Studio download with SQL 2008 R2 SP1 and few notes? #sql #tools

published 184 days, 10 hours, 53 minutes ago posted by

sa 192 days, 10 hours, 26 minutes ago

SQL Server Managebility Series: Management Studio download with SQL 2008 R2 SP1 and few notes? #sql #tools

In continuation to the SQL2K8R2 Service Pack1 post I got few emails asking why there are 2 additional files ( SQLManagementStudio_x64_ENU.exe & SQLManagementStudio_x86_ENU.exe) included in the SP1 download page. Few notes and gotchas about this SQL 2008 R2 SP1 release: This Service Pack1 is ONLY for SQL Server 2008 R2 instance, you CANNOT apply to a SQL Server 2008 instance. Service Pack 1 for SQL Server 2008 R2 does not include the MS11-049 security update QFE . For your personal purpose this...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, DBA, Documentation, downgrade, download, Management Studio, SQL Server, Tools

1
kudos

Kudos

SQL Server Manageability Series: upgrade of client tools and error: The File %CommonDir%\dte80.olb could not be loaded #sql #ssms #sqltools

published 218 days, 13 hours, 22 minutes ago posted by

sa 228 days, 12 hours, 58 minutes ago

$SQL Server Manageability Series: upgrade of client tools and error: The File %CommonDir%\dte80.olb could not be loaded #sql #ssms #sqltools$

For all my consulting tasks I prefer to use SQL Server 2008 R2 Management Studio provided the involved instances are on version 2005 or higher. Recently I bought a new laptop and in process get all necessary tools installed so that I can make use of this new 'beefy' machine , usually my habit is to install the SQL Server instances (versions from 2000 till 2008 R2). In this process I have successfully installed all the instances and tools, but when I have opened the SQL Server 2008 R2 Management Studio...... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: BOL, code examples, file search, installallation, Management Studio, SQL Server, SSMS, system32, Tools

1
kudos

Kudos

My head hurts from hitting it against a wall–SSMS log viewer

published 238 days, 14 hours, 44 minutes ago posted by

sa 248 days, 14 hours, 24 minutes ago

My head hurts from hitting it against a wall–SSMS log viewer

Every time I go to a client to do a review I find I’m looking in the event log trying to find information. Every time I feel like I’m hitting my head against a wall as the process is awful and painful. Given SQL is a relational database production the...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Administration, Management Studio

1
kudos

Kudos

Agent XPs disabled

published 239 days, 14 hours, 49 minutes ago posted by

sa 248 days, 15 hours, 29 minutes ago

When you expand object explorer and see “Agent XPs Disabled” don’t worry. This happens when SQL Agent is stopped. I guess the idea is to reduce the surface area if SQL Agent isn’t running. You don’t have to manually enable them. They will be enabled automatically...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Administration, Management Studio

1
kudos

Kudos

SQL Server DBA practices: Show or hide specific table in management studio?

published 342 days, 21 hours, 3 minutes ago posted by

sa 351 days, 22 hours, 34 minutes ago

SQL Server DBA practices: Show or hide specific table in management studio?

During a recent DBA consulting engagement one of the users at a client posed a question stating, "how do we hide certain tables on Management Studio even though the set of users do need read/write privileges on those tables?". For a moment I was thinking permissions and privileges to set out, but there is more to the question asked above. As it states the users do have required permissions on those tables. The mentioned tables consist confidential information about the monetary transactions where...(read... (more)

category: News | clicked: 2 | comment | | source: sqlserver-qa.net

tags: beginners, Best Practices, DBA, executesql, Management Studio, SQL Server, SSMS, TSQL

1
kudos

Kudos

Controlling what appears on your tabs

published 556 days, 13 hours ago posted by

sa 565 days, 15 hours, 39 minutes ago

You can control what appears on your tabs from SQL 2008 onwards. Its still not ideal, IMHO you need to have multi line tabs to show server, database, filename etc. Anyway to control what appears go to Tools | Options and then select the Tec Editor node...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Management Studio, Tips and Tricks

1
kudos

Kudos

Quick tip: SQL Server Management Studio shell and keyboard accelerators

published 676 days, 21 hours, 56 minutes ago posted by

sa 686 days, 41 minutes ago

Quick tip: SQL Server Management Studio shell and keyboard accelerators

SQL Server Management Studio (SSMS) plays important role to connect/manage the database estate without having difficulty, also there are few goodies (hidden gems) that you can simply enable on your Management Studio that will make your day-to-day usage life much better! Going on the topic of accelerator BOL defines clearly that it allows you to select a menu command or button by pressing ALT+ (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: beginner, Best Practices, BOL, help, keyboard, Management Studio, shell, SQL Server, ssma

1
kudos

Kudos

SQL Server Management Studio - Obtain Misisng Indexes information and its limitations!

published 745 days, 5 hours, 6 minutes ago posted by

sa 751 days, 16 hours, 56 minutes ago

SQL Server Management Studio - Obtain Misisng Indexes information and its limitations!

It is a common criteria that using Dynamic Management Views (DMVs) you can easily obtain the system & database state on a SQL instance. It may not be easy for a starter DBA to ensure what kind of DMV is used to obtain information on Recent Expensive Queries, if so for you Activity Monitor is the tool to obtain information about SQL Server processes and how these processes affect the current instance of SQL Server. [This topic is pre-release documentation and is subject to change in future releases....(re... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: best practice, database tuning advisor, execute plan, Management Studio, Performance, Query, SQL Server, SSMS

1
kudos

Kudos

Unable to cast COM object of type 'Microsoft.Office.Interop.Access.Dao.DBEngineClass' to interface type 'Microsoft.Office.Interop.Access.Dao._DBEngine'

published 747 days, 5 hours, 16 minutes ago posted by

sa 753 days, 9 hours, 1 minute ago

Unable to cast COM object of type 'Microsoft.Office.Interop.Access.Dao.DBEngineClass' to interface type 'Microsoft.Office.Interop.Access.Dao._DBEngine'

No doubt that the error on subject line will get no where! This is presented when trying to open a Database Properties using SQL Server Managment Studio, going back to history on the SQL instance where this is presented is an upgraded database instance having upto date service packs (SQL Server 2008 SP1) with no cumulative update packages. Further information on full error text is below: Access Object Collector error: Database Unable to cast COM object of type 'Microsoft.Office.Interop.Access.Dao.DBEngin... (more)

category: News | clicked: 1 | comment | | source: sqlserver-qa.net

tags: access, dll, error, Management Studio, path, registered, sp_configure, SQL Server, SSMS, system

1
kudos

Kudos

SQL Server Manageability series - shortcut for SSMS keyboard shortcuts!

published 817 days, 10 hours, 20 minutes ago posted by

sa 826 days, 23 hours, 56 minutes ago

SQL Server Manageability series - shortcut for SSMS keyboard shortcuts!

For any user manage the work with short-cut is desirable, for better productivity in your work (with UI tools) I always suggest to manage it by keyboard not with the mouse. Here is another block of SQL manageability series I want to cover based on feedback that I have received for earlier posts on this blog, this time let us visit on keyboard shortcuts. Since the version 2005 release Microsoft has done good job for SQL Server Management Studio offering the users 2 kinds of keyboard schemes. One of...(rea... (more)

category: News | clicked: 1 | comment | | source: sqlserver-qa.net

tags: Best Practices, keyboard, Management Studio, nodes, query editor, query plan, server, shortcut, SQL Server, Tips

1
kudos

Kudos

SQL Server Manageability tips - Quick view on Object Explorer and its best usage

published 822 days, 10 hours, 40 minutes ago posted by

sa 832 days, 19 minutes ago

SQL Server Manageability tips - Quick view on Object Explorer and its best usage

As a SQL Server user Object Explorer is one component that you will never miss when you are using SQL Server Management Studio, in specific from version 2005 onwards. As it states this connects to Database Engine instances, Analysis Services, Integration Services, Reporting Services, and SQL Server Compact 3.5. A brief view of all the objects in the server and presents a user interface to manage them. But not many out there knew the capabilities of how best the Object Explorer's can be used and it...(rea... (more)

category: News | clicked: 1 | comment | | source: sqlserver-qa.net

tags: beginner, Best Practices, DBA, file search, fillter, Management Studio, Object Explorer, SQL Server, usage, user connections

1
kudos

Kudos

PBM – it’s like liquid awesome!

published 879 days, 15 hours, 44 minutes ago posted by

sa 887 days, 12 hours, 12 minutes ago

Brent Ozar and Thomas LaRock do a 3 part video series on the power of Policy-based Management (PBM). Interestingly SCOM comes up several times in the discussion. They cover the basics of PBM and Thomas goes into more depth on how he’s using it in his environment. The series is about 35 minutes in total. Regardless of your PBM experience level I highly recommend watching these videos. http://thomaslarock.com/2009/08/policy-based-management-podcast-part-1/ http... (more)

category: Management | clicked: 0 | comment | | source: blogs.msdn.com

tags: Management Studio, Policy, SSMS

3
kudos

Kudos

For shared SQL Server providers : hiding your list of databases from customers

published 921 days, 16 hours, 7 minutes ago posted by

sa 923 days, 22 hours, 38 minutes ago

For shared SQL Server providers : hiding your list of databases from customers

In a shared SQL Server hosting environment, there are several problems that can arise when you let your customers use Management Studio to connect and administer their databases. In the typical case, you give them a single SQL Authentication username and password, and they are supposed to be able to connect only to their database. By default, however, Object Explorer and Object Explorer Details will gladly present the entire list of databases on the server. In this case, not only are you exposing all ... (more)

category: Security | clicked: 8 | comment | | source: sqlblog.com

tags: Database List, Management Studio, Security, Shared Hosting, SSMS

Welcome!

Management Studio

SQL Server Managebility Series: Management Studio download with SQL 2008 R2 SP1 and few notes? #sql #tools

SQL Server Manageability Series: upgrade of client tools and error: The File %CommonDir%\dte80.olb could not be loaded #sql #ssms #sqltools

My head hurts from hitting it against a wall–SSMS log viewer

Agent XPs disabled

SQL Server DBA practices: Show or hide specific table in management studio?

Controlling what appears on your tabs

Quick tip: SQL Server Management Studio shell and keyboard accelerators

SQL Server Management Studio - Obtain Misisng Indexes information and its limitations!

Unable to cast COM object of type 'Microsoft.Office.Interop.Access.Dao.DBEngineClass' to interface type 'Microsoft.Office.Interop.Access.Dao._DBEngine'

SQL Server Manageability series - shortcut for SSMS keyboard shortcuts!

SQL Server Manageability tips - Quick view on Object Explorer and its best usage

PBM – it’s like liquid awesome!

For shared SQL Server providers : hiding your list of databases from customers

Open ID Login

Standard Login

Forgot Password?

Sign up