SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

Management Studio

1
kudos

Kudos

Controlling what appears on your tabs

published 3 days, 4 hours, 46 minutes ago posted by

sa 12 days, 7 hours, 26 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 123 days, 13 hours, 43 minutes ago posted by

sa 132 days, 16 hours, 28 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 191 days, 20 hours, 52 minutes ago posted by

sa 198 days, 8 hours, 43 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 193 days, 21 hours, 2 minutes ago posted by

sa 200 days, 48 minutes 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 264 days, 2 hours, 6 minutes ago posted by

sa 273 days, 15 hours, 42 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 269 days, 2 hours, 27 minutes ago posted by

sa 278 days, 16 hours, 6 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 326 days, 7 hours, 31 minutes ago posted by

sa 334 days, 3 hours, 59 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 368 days, 7 hours, 54 minutes ago posted by

sa 370 days, 14 hours, 25 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

SqlServerKudos

Welcome!

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