Browse Blog Posts by Tags

All Tags » beginners » dba (RSS)

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

Master SQL Chef series: Troubleshooting multi-server instances with #sql2k8r2cookbook

Managing multiple instances of SQL Servers and databases is a challenging task, having a third party tool is not a problem however it is always BEST to manage the show using SQL Server Management Studio (SSMS). SQL Server tools are easy to use and help...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jan 16 2012
Filed under: Filed under: sql server, management, ssms, dba, best practice, beginners, cookbook, ucp, #sql2k8r2cookbook, data tier, utility control point
Perform SQL Server Upgrade with the help of tools, best practices too #sqlbpa #upgrade

SQL Server upgrade is no small task, no big task either when you have perfectly planned and tested the process! Since last 2 years the most popular topic and talk that I presented in various conferences, usergroup meetings and consulting projects is upgrade...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Oct 7 2011
Filed under: Filed under: sql server, tools, database, dba, download, best practices, beginners, upgrade advisor, best practice analyzer, upgrade assistant
SQL Server Manageability series: Log files and Setup Bootstrap folder, the key elements to manage the data platform

There a different types of log files available when you start to install the SQL Server and manage the instance. Whenever you talk about log file then immediate option is SQL Server error log file, which can be viewed from SQL Server Management Studio...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Aug 11 2011
Filed under: Filed under: sql server, management, dba, best practices, beginners, configuration, setup, practices, bootstrap
Microsoft SQL Server 2008 R2 Administration Cookbook - eBook and paperback Book - quick answers to common problems #sql #book

This is something big in my life to announce, it gives immensive pleasure and happiness to share about my first book (hard paper) and eBook release, titled : Microsoft SQL Server 2008 R2 Administration Cookbook is released and out now. share my experience...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, May 24 2011
Filed under: Filed under: sql server, performance, availability, mvp, dba, programming, best practice, monitoring, beginners, ebooks, architects, scalability, experience, book, packt, real-world
SQL Server 2008 R2 Feature pack #sql #sqlpack

Over a period of time I will always visit the few pages that consist information about SQL Server. It is a best practice to get updates about Service Pack releases, Cumulative update packages, what's new release notes and feature pack. In this regard...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, May 12 2011
Filed under: Filed under: sql server, tools, dba, download, testing, beginners, feature pack
SQL Server DBA Manageability practices: Central Management Servers - how best you want to utilize them?

SQL Server 2008 version added a new face within SQL Server Management Studio that can help users to administer/manage/execute queries against multiple servers by designating Central Management Servers (CMS) and creating server groups. This means as an...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, May 4 2011
Filed under: Filed under: sql server, security, dba, best practices, beginners, system catalog, central management server, ucp
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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Feb 17 2011
Filed under: Filed under: sql server, ssms, dba, best practices, tsql, management studio, beginners, executesql
SQL Server 2008 and R2 installation: Rule "Microsoft.Net Application Security" generated a warning.

SQL Server 2008 and 2008 R2 installation method provides a single-tree feature to install required components. Whether are not you use installation wizard or unattended installation method the setup always perform the steups such as: prepare the server...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Dec 13 2010
Filed under: Filed under: sql server, dba, best practices, .NET, beginners, setup, internet, installallation, rules, system configuration checker, scc
SQL Server Transaction log size problems - SHRINK :: understanding recovery models

Transaction log issues - one of the common problems that every DBA needs to tackle, if there is no DBA then its a FAQ in forums complaining database transaction log is not reducing when we take backups. Well, if you are a DBA then you don't need any...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Dec 2 2010
Filed under: Filed under: sql server, transaction log, dba, simple, shrink, best practices, full, bulk-logged, recovery model, beginners, truncated, system catalog
SQL11 - Denali :: A note of local help aka Books Online and installed programs list

There is a change in the way you access the books online (BOL) in SQL11 - code name DENALI and also the list of programs that are installed when you choose to install SQL Server Denali CTP1! First let us go through the list of programs that are installed...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Nov 23 2010
Filed under: Filed under: sql server, dba, BOL, documentation, resources, beginners, program files, product release, help, denali, ctp1
Consolidation Planning Tool (CPT) and Microsoft Assesment and Planning (MAP) tools for SQL Server

Do you have numerous SQL Server instances to migrate/upgrade to higher version of SQL Server? DO you have any capacity planning documentation methods in place within your Enterprise? Do you follow any specific set of guidelines whenever you migrate/upgrade...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Nov 16 2010
Filed under: Filed under: sql server, tools, dba, upgrade, documentation, best practices, beginners, report, map, upgrade advisor, cpt, assesment

Page 1 of 1 (11 items)

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.