SqlServerKudos

SSMS

1
kudos

Kudos

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

published 232 days, 5 hours, 52 minutes ago posted by

sa 238 days, 17 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 234 days, 6 hours, 2 minutes ago posted by

sa 240 days, 9 hours, 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

Extended Properties in Object Explorer Details – Vote on Connect

published 349 days, 15 hours, 12 minutes ago posted by

sa 359 days, 13 hours, 50 minutes ago

Extended Properties in Object Explorer Details – Vote on Connect

After a discussion with a friend of mine, I’ve opened a suggestion on Connect to request to have Extended Properties visible in the main Object Explorer Details window. This will be especially useful for creating self-documenting database, since that window can easily provide additional information about, for example, column in a table or in a view and so on. Just image to have all the available Extended Columns in this list to be selected: If columns’ Extended Properties will contain a Descriptio... (more)

category: Management | clicked: 0 | comment | | source: sqlblog.com

tags: Connect, SSMS

1
kudos

Kudos

SQL Server 2008 Object Explorer Details

published 359 days, 15 hours, 57 minutes ago posted by

sa 366 days, 14 hours, 25 minutes ago

Ok, maybe this post contains information that anyone already knows, but since I just discovered the SQL Server 2008 Object Explorer Details’ features today, maybe other people are in the same situation. In older version of SQL Server the Object Explorer Details window was simply not useful at all since it just replicate what you can see in the Object Explorer treeview. So I never used it. This morning, doing some work for the Italian SQL Server UG, I pressed F7 instead of F8 to open the Object Explorer... (more)

category: Management | clicked: 0 | comment | | source: sqlblog.com

tags: Object Explorer, SSMS

1
kudos

Kudos

Directly Opening a Solution in SQL Server Management Studio

published 366 days, 16 hours, 31 minutes ago posted by

sa 374 days, 10 hours, 46 minutes ago

Directly Opening a Solution in SQL Server Management Studio I use Solutions a lot in SQL Server Management Studio (SSMS), and you should be aware of this simple tip: If you want to open a Solution without having to open SSMS and then jumping through all the menus, just double-click the solution name in the Windows folder. It will automatically open the Solution and SSMS at the same time. This tip, by the way, also works with any .SQL files, unless you've installed another product that has that file ass... (more)

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

tags: DBA, Developer, Development, SQL Server, SQL Server Management Studio, SSMS, Tips

1
kudos

Kudos

PBM – it’s like liquid awesome!

published 366 days, 16 hours, 31 minutes ago posted by

sa 374 days, 12 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

1
kudos

Kudos

Management Studio Error - Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'

published 373 days, 14 hours, 20 minutes ago posted by

sa 379 days, 9 hours, 22 minutes ago

Management Studio Error - Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'

Just ran into this problem last week, and couldn't find any information about this online. The only MSDN forum solution I can find only suggests uninstall and reinstall SQL Server, which I did and still failed! And I finally found the solution of this problem.... Turns out that the Microsoft.SqlServer.DataStorage.dll assembly is somehow replaced or misversioned in my GAC, due to some other installation I did in the past. What I had to is to find ano... (more)

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

tags: SSMS, Troubleshooting

1
kudos

Kudos

SQL 2008 R2 Breaks SSMS Addins

published 375 days, 4 hours, 39 minutes ago posted by

sa 381 days, 10 hours, 32 minutes ago

If you are trying out SQL Server 2008 R2 CTP2 and you are a frequent user of Addin’s for SSMS like the SSMS Tool Pack or the SQL Server 2008 Extended Events Addin that I wrote, you will notice almost immediately that the Addin’s will not work and raise a couple of exceptions. This is because as previously mentioned in my blog post about the Devenus SQL.CLR Addin, SSMS Addins are not a supported feature by Microsoft, so there is no guarantee that code will work from build to build of SQL Server. Until r... (more)

category: Management | clicked: 2 | comment | | source: sqlblog.com

tags: Addins, SSMS

1
kudos

Kudos

Introducing: Extended Events Code Generator v1.0

published 402 days, 17 hours, 7 minutes ago posted by

sa 406 days, 8 hours, 7 minutes ago

Introducing: Extended Events Code Generator v1.0

SQL Server 2008 Extended Events. It's a high-performance, feature-rich, and extremely useful tracing system. Too bad it's so difficult to figure out how to use it! Or is it? Earlier this week Jonathan Kehayias announced his SSMS addin for Extended Events, which makes it super-easy to create and manage events, and even view the raw event data. It's all done via a simple UI, so if you don't have time to learn how to do all of that stuff with the Extended Events DML and DMVs, no worries. But what if you ... (more)

category: Management | clicked: 2 | comment | | source: sqlblog.com

tags: Extended Events, SSMS

1
kudos

Kudos

Code Collapse and Expand Feature in SQL Server Management Studio 2008

published 402 days, 17 hours, 7 minutes ago posted by

sa 406 days, 11 hours, 11 minutes ago

Code Collapse and Expand Feature in SQL Server Management Studio 2008 In SQL Server Management Studio 2008, whenever you have a "block" of code (BEGIN....END, etc) SSMS will put a little plus-sign in the margin and allow you to "collapse" that block of code so you only see the BEGIN, not stuff underneath. If you're working with a really large set of code, that's helpful. But I got an e-mail from a friend that said her SSMS didn't do that. I was kind of surprised, since I never had to do anything to mak... (more)

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

tags: DBA, Developer, Development, SQL Server, SQL Server 2008, SQL Server Management Studio, SSMS, Tips

1
kudos

Kudos

Extended Events Manager Update: Now A SSMS Addin

published 402 days, 17 hours, 7 minutes ago posted by

sa 407 days, 9 hours, 27 minutes ago

Extended Events Manager Update: Now A SSMS Addin

I published the beta build last week for an update to the Extended Events Manager that made a performance enhancement to the TargetDataViewer in the Library to make it work on a background worker thread to prevent UI freezing while the data is pulled, improving performance while reading target data from the asynchronousfiletarget. Included in the update is the addition of an SSMS Addin that eliminates the need for an external UI, implementing the application functionality entirely in SQL Server Manage... (more)

category: Management | clicked: 2 | comment | | source: sqlblog.com

tags: Events, SSMS

1
kudos

Kudos

Spooky: What do you connect to?

published 409 days, 16 hours, 45 minutes ago posted by

sa 410 days, 11 hours, 41 minutes ago

I only recently discovered that SSMS will connect to different things. For instance, press the "New query" button. What were you connected to... (more)

category: Management | clicked: 2 | comment | | source: sqlblog.com

tags: SSMS

1
kudos

Kudos

SQL SERVER – Maximizing View of SQL Server Management Studio – Full Screen – New Screen

published 409 days, 16 hours, 45 minutes ago posted by

sa 410 days, 11 hours, 57 minutes ago

SQL SERVER – Maximizing View of SQL Server Management Studio – Full Screen – New Screen

I had a great, unforgettable time at Teched India 2009 in Hyderabad. I had delivered a successful session on SQL Server Management Studio Best Practices, which created a lot of interest in community. I was truly amazed at the tremendous response I got. I received countless different questions on this subject as soon as the event was over. One of the most frequently asked questions was about my demo on how to increase real estate of SSMS (SQL Server Management Studio)... (more)

category: Management | clicked: 4 | comment | | source: blog.sqlauthority.com

tags: SSMS

1
kudos

Kudos

PowerShell's "Mini-Shell" Is Not A "Mini" Shell

published 409 days, 16 hours, 45 minutes ago posted by

sa 410 days, 23 hours, 10 minutes ago

PowerShell's "Mini-Shell" Is Not A "Mini" Shell

I just learned about a Connect item entered on Friday: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=475337. Here's the description in the item.Please invoke the full powershell not a "mini-shell". Powershell is very powerful but the mini-shell you get when invoking Powershell from the Management Studio is missing a lot of functionality. I'm not sure how the submitter determined that there was any missing functionality, because there isn't. SQLPS.exe is PowerShell 1.0... (more)

category: Management | clicked: 0 | comment | | source: sqlblog.com

tags: PowerShell, SSMS

3
kudos

Kudos

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

published 408 days, 16 hours, 54 minutes ago posted by

sa 410 days, 23 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

Welcome!

SSMS

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'

Extended Properties in Object Explorer Details – Vote on Connect

SQL Server 2008 Object Explorer Details

Directly Opening a Solution in SQL Server Management Studio

PBM – it’s like liquid awesome!

Management Studio Error - Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'

SQL 2008 R2 Breaks SSMS Addins

Introducing: Extended Events Code Generator v1.0

Code Collapse and Expand Feature in SQL Server Management Studio 2008

Extended Events Manager Update: Now A SSMS Addin

Spooky: What do you connect to?

SQL SERVER – Maximizing View of SQL Server Management Studio – Full Screen – New Screen

PowerShell's "Mini-Shell" Is Not A "Mini" Shell

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

Open ID Login

Standard Login

Forgot Password?

Sign up