Search results for 'app:weblogs' matching tags 'Best Practices' and 'management studio'

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

Anonymous — Wed, 27 Jul 2011 05:00:00 GMT

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)

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

Anonymous — Thu, 17 Feb 2011 06:00:00 GMT

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)

SQL Server Manageability series - shortcut for SSMS keyboard shortcuts!

Anonymous — Fri, 30 Oct 2009 05:00:00 GMT

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...(read more)

Export SQL Servers registration using Management Studio?

Anonymous — Wed, 03 Oct 2007 05:00:00 GMT

If you are managing hundreds of SQL Server and you might have organised your Management Studio screen with relevant server groups under Server registration. In this case if a new starter has joined and required to assist you in monitoring all of the SQL Server you are taking care, you wouldn't attempt or anyone to register each of the server when you have nearly 500 SQL instances to manage. Until SQL Server 2000 this was a big problem to import and export the Server instance registations, there wasn't...(read more)