Browsing articles in "Links and Articles"
Sep
24
2013

Info – SQL Server Proxy accounts and job agent execution contexts

SQL Server proxies are used in cases where impersonation is required in complex and secured environments and more control is required while executing packages, jobs, PowerShell commands etc. below links and details are collected to give more info on this topic, it requires a good amount of reading and may take up to 2-3 hours to understand it completely, so be patient if you land on this page and go through all links and articles […]

Feb
21
2013

Why there is separate package for SQL Native Client (SNAC) on cumulative update download page?

If you are wondering that Cumulative Update download page has a package for SNAC, should you download and install or not? Then probably you will find your answer below.   Everything about SNAC is clearly explained at following link, http://blogs.msdn.com/b/psssql/archive/2009/10/23/should-i-have-a-snac-with-my-cumulative-update.aspx   Just to brief it out,   What is SNAC? SNAC stands for SQL Native Client   Why separate package is there on download page? It is a package only to apply updates to native […]

Feb
20
2013

Enable Policy Based Management using Central Management Servers

While trying to configure policy based management (PBM) across 100+ SQL servers in my domain faced issue that by default you need to import policies on individual servers or evaluate by connecting to a central policy server. Although this dilemma was broken by the articles written by several DBA’s across several forums and communities that Central management server (CMS) can be used to deploy or evaluate policies across set of servers or all SQL servers […]

Feb
19
2013

How to become a Microsoft Most Valuable Professional (MVP)?

This question was haunting me from long that how to become an MVP, the simplest solution is CONTRIBUTE and SHARE!   The Microsoft Most Valuable Professional (MVP) Award is an annual award given to outstanding members of Microsoft’s technical communities based on contributions made during the previous 12 months to offline and online Microsoft-related technical communities.   More you can found on MVP FAQ’s available at http://mvp.support.microsoft.com/gp/mvpfaqs   If you think you or your friend […]

Feb
15
2013

Microsoft SQL Server on Private Cloud

While trying to identify a solution for an internal private cloud for a client and deploy SQL Server as a service on it, came across following articles which can provide some useful insight and references,   Microsoft provides certain case studies and articles at following link on private cloud, http://www.microsoft.com/en-us/sqlserver/solutions-technologies/hybrid-it/private-cloud.aspx   Microsoft with HP and Dell has provided Database consolidation and private cloud appliances as well, details at following link, http://www.microsoft.com/sqlserver/en/us/solutions-technologies/Appliances/HP-dca.aspx http://h71028.www7.hp.com/enterprise/us/en/partners/microsoft-database-consolidation-solution.html http://blogs.technet.com/b/dataplatforminsider/archive/2011/10/13/announcing-the-first-database-consolidation-amp-private-cloud-appliance.aspx   If […]

Feb
15
2013

Virtualizing Microsoft SQL on VMware vSphere

Useful resources for virtualizing your SQL Servers on VMWare ESX   http://www.vmware.com/solutions/business-critical-apps/sql-virtualization/microsoft-support.html   DBA Guide to Databases on VMware – White Paper Availability and Recovery Options for Microsoft SQL® on vSphere Best Practices Guide for Virtualizing SQL Server SQL Server on vSphere FAQ Support and Licensing Guide – SQL Server on vSphere SQL Server on vSphere – Use Cases VMware Performance Benchmarks and Resources Reference Architecture: EMC Business Continuity for SQL Server 2008 Reference Architecture: […]

Feb
7
2013

Symantec Veritas Netbackup Useful References

Some useful references which comes handy while configuring, fixing, troubleshooting problems related to NetBackup ,   How to Backup and Restore Microsoft SQL Server Backup via Netbackup –By Zahid Haseeb   A comprehensive list of solutions for the most common NetBackup for Microsoft SQL Server database agent backup and restore issues –By Symantec Team   Setup NetBackup to send Emails – by Mariam Kupatadze   –Will keep the list updated as and find some new […]

Jan
28
2013

Memory Supported by the Editions of SQL Server

SQL Server 2005: http://msdn.microsoft.com/en-us/library/ms143685(v=sql.90).aspx SQL Server 2008: http://msdn.microsoft.com/en-us/library/ms143685(v=sql.100).aspx SQL Server 2008 R2: http://msdn.microsoft.com/en-us/library/ms143685(v=sql.105).aspx

Dec
25
2012

Troubleshooting Insufficient Disk Space in tempdb

Text Reference: http://dba.stackexchange.com/questions/19870/how-to-identify-which-query-is-filling-up-the-tempdb-transaction-log Some tips for minimizing tempdb utilization 1. Use fewer #temp tables and @table variables 2. Minimize concurrent index maintenance, and avoid the SORT_IN_TEMPDB option if it isn’t needed 3. Avoid unnecessary cursors; avoid static cursors if you think this may be a bottleneck, since static cursors use work tables in tempdb – though this is the type of cursor I always recommend if tempdb isn’t a bottleneck 4. Try to avoid spools […]

Dec
24
2012

Tips to optimize tempdb performance

In order to optimize tempdb performance pay attention to physical disk configuration, file configuration, as well as some settings within the database. Physical disk configuration tempdb should reside on its own dedicated physical disks. This allows it to split I/O transactions from the remainder of volumes on the SQL Server. To move tempdb to a new disk drive, use ALTER DATABASE. It is the key T-SQL command to perform this operation. Microsoft offers a good […]

Pages:«123»

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 263 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

December 2020
M T W T F S S
« Nov    
 123456
78910111213
14151617181920
21222324252627
28293031  

View Post by Categories

%d bloggers like this: