http://msmvps.com/blogs/paleo/archive/tags/SQL+Server/default.aspxTags: SQL ServerenCommunityServer 2008.5 SP2 (Build: 40407.4157)http://msmvps.com/blogs/paleo/archive/2009/06/16/materiais-de-refer-234-ncia-sobre-sql-server.aspxTue, 16 Jun 2009 13:24:00 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1695618paleo0http://msmvps.com/blogs/paleo/rsscomments.aspx?PostID=1695618http://msmvps.com/blogs/paleo/commentapi.aspx?PostID=1695618http://msmvps.com/blogs/paleo/archive/2009/06/16/materiais-de-refer-234-ncia-sobre-sql-server.aspx#comments<h5>Armazenamento de Dados</h5> <ul> <li><a href="http://technet.microsoft.com/en-us/library/cc966414.aspx">TechNet Library Whitepaper: Physical Database Storage Design</a> <li><a href="http://msdn.microsoft.com/en-us/library/ms190764.aspx">RAID Levels and SQL Server</a> <li><a href="http://msdn.microsoft.com/en-us/library/ms179316.aspx">Books Online: Files and Filegroups Architecture</a> <li><a href="http://msdn.microsoft.com/en-us/library/ms345146.aspx">SQL Server 2005 Technical Article: Partitioned Tables and Indexes in SQL Server 2005</a> </li></ul> <h5>Tempdb</h5> <ul> <li><a href="http://technet.microsoft.com/en-us/library/cc966545.aspx">TechNet Library Whitepaper: Working with Tempdb in SQL Server 2005</a> <li><a href="http://msdn.microsoft.com/en-us/library/ms175527.aspx">Books Online: Optimizing tempdb Performance</a> <li><a href="http://msdn.microsoft.com/en-us/library/ms345368.aspx">Books Online: Capacity Planning for tempdb</a> </li></ul> <h5>Monitoramento</h5> <ul> <li><a href="http://technet.microsoft.com/en-us/library/cc786837.aspx">Windows Server 2003 Help: Performance monitoring Concepts</a> <li><a href="http://msdn.microsoft.com/en-us/library/ms181091.aspx">Books Online: Introducing SQL Server Profiler</a> <li><a href="http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/performance_tuning_waits_queues.mspx">TechNet Library: SQL Server 2005 Waits and Queues - SQL Server Best Practices Article </a> <li><a href="http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx">TechNet Library: SQL Server Best Practices Article - Predeployment I/O Best Practices</a> </li></ul> <h5>Backup </h5> <ul> <li><a href="http://technet.microsoft.com/en-us/library/ms187048.aspx">Books Online: Backing Up and Restoring Databases in SQL Server</a> <li><a href="http://support.microsoft.com/?id=230785">Support Article: SQL Server 7.0, SQL Server 2000, and SQL Server 2005 logging and data storage algorithms extend data reliability</a> <li><a href="http://support.microsoft.com/?id=234656">Description of using disk drive caches with SQL Server that every database administrator should know</a> </li></ul> <h5>Segurança</h5> <ul> <li><a href="http://msdn.microsoft.com/en-us/library/bb283235.aspx">Books Online: Securing SQL Server</a> <li><a href="http://msdn.microsoft.com/en-us/library/ms143504.aspx">Books Online: Setting Up Windows Service Accounts</a> <li><a href="http://msdn.microsoft.com/en-us/library/ms144228.aspx">Books Online: Security Considerations for a SQL Server Installation</a> </li></ul> <h5>Alta disponibilidade</h5> <ul> <li><a href="http://msdn.microsoft.com/en-us/library/ms190202.aspx">Books Online: High Availability Solutions Overview</a> <li><a href="http://msdn.microsoft.com/en-us/library/bb510414.aspx">Books Online: Selecting a High Availability Solution</a> <li><a href="http://msdn.microsoft.com/en-us/library/ms189852.aspx">Books Online: Database Mirroring Overview</a> <li><a href="http://msdn.microsoft.com/en-us/library/ms187103.aspx">Books Online: Log Shipping Overview</a> </li></ul> <h5>Replicação</h5> <ul> <li><a href="http://msdn.microsoft.com/en-us/library/ms151198.aspx">Books Online: SQL Server Replication</a> <li><a href="http://msdn.microsoft.com/en-us/library/ms152567.aspx">Books Online: Replication Publishing Model Overview</a> <li><a href="http://msdn.microsoft.com/en-us/library/ms152531.aspx">Books Online: Types of Replication Overview</a> <li><a href="http://msdn.microsoft.com/en-us/library/ms152501.aspx">Books Online: Replication Agents Overview</a> </li></ul> <h5>Service Broker</h5> <ul> <li><a href="http://msdn.microsoft.com/en-us/library/bb522893.aspx">Books Online: SQL Server Service Broker</a> <li><a href="http://msdn.microsoft.com/en-us/library/ms166104.aspx">Books Online: Overview (Service Broker)</a> <li><a href="http://msdn.microsoft.com/en-us/library/ms166049.aspx">Books Online: What Does Service Broker Do?</a> <li><a href="http://msdn.microsoft.com/en-us/library/ms166071.aspx">Books Online: Typical Uses of Service Broker</a> </li></ul> <h5>Serviço de Integração</h5> <ul> <li><a href="http://msdn.microsoft.com/en-us/library/ms141026.aspx">Books Online: SQL Server Integration Services</a> <li><a href="http://msdn.microsoft.com/en-us/library/ms137833.aspx">Books Online: Security Overview (Integration Services)</a> <li><a href="http://msdn.microsoft.com/en-us/library/ms141134.aspx">Books Online: Integration Services Packages</a> <li><a href="http://msdn.microsoft.com/en-us/library/bb500440.aspx">Books Online: Support for Data Transformation Services (DTS) in SQL Server 2008</a> <li><a href="http://msdn.microsoft.com/en-us/library/ms141132.aspx">Books Online: Creating Package Configurations</a> </li></ul> <h5>SQL Server 2008 </h5> <ul> <li><a href="http://msdn.microsoft.com/en-us/library/cc721270.aspx">SQL Server 2008 Technical Article: Introduction to New T-SQL Programmability Features in SQL Server 2008</a> <li><a href="http://msdn.microsoft.com/en-us/library/cc749633.aspx">SQL Server 2008 Technical Article: Introduction to Spatial Coordinate Systems: Flat Maps for a Round Planet</a> <li><a href="http://msdn.microsoft.com/en-us/library/bb933866.aspx">Books Online: Managing SQL Server Workloads with Resource Governor</a> <li><a href="http://msdn.microsoft.com/en-us/library/bb895232.aspx">Books Online: Introducing Resource Governor</a> <li><a href="http://msdn.microsoft.com/en-us/library/bb934084.aspx">Books Online: Resource Governor Concepts</a> </li></ul> <p>Fonte: <a href="http://gilmaroassis.spaces.live.com/Blog/cns!A5E9C41598F2DEC8!406.entry">http://gilmaroassis.spaces.live.com/Blog/cns!A5E9C41598F2DEC8!406.entry</a></p><div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1695618" width="1" height="1">SQL Serverhttp://msmvps.com/blogs/paleo/archive/2008/03/06/sql-server-para-alugar.aspxThu, 06 Mar 2008 21:11:00 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1535654paleo0http://msmvps.com/blogs/paleo/rsscomments.aspx?PostID=1535654http://msmvps.com/blogs/paleo/commentapi.aspx?PostID=1535654http://msmvps.com/blogs/paleo/archive/2008/03/06/sql-server-para-alugar.aspx#comments<p>Você precisa do SQL Server para sua aplicação, mas a versão gratuita carece de recursos e você carece de recursos para a paga?</p> <p>Que tal alugá-lo? Não pode? Pode sim, diretamente da Microsoft.</p> <p>Inscreva-se para ser um Beta Tester deste projeto: <a href="http://www.microsoft.com/sql/dataservices/default.mspx">http://www.microsoft.com/sql/dataservices/default.mspx</a></p><div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1535654" width="1" height="1">SQL Serverhttp://msmvps.com/blogs/paleo/archive/2008/01/26/login-failed-for-user-reason-the-password-of-the-account-must-be-changed.aspxSat, 26 Jan 2008 18:06:00 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1481579paleo0http://msmvps.com/blogs/paleo/rsscomments.aspx?PostID=1481579http://msmvps.com/blogs/paleo/commentapi.aspx?PostID=1481579http://msmvps.com/blogs/paleo/archive/2008/01/26/login-failed-for-user-reason-the-password-of-the-account-must-be-changed.aspx#comments<p>Digamos que você acaba de criar uma nova conta no seu SQL Server a fim de gerenciar um banco criado para uma aplicação LOB e obtém este erro.</p> <p>Sua primeira reação é tentar desmarcar as caixas de verificação referentes à expiração, mas também não consegue. Remarcá-las conduz ao mesmo erro. O que fazer? Cancelar, isso mesmo, clique em Cancel.</p> <p>Selecione &quot;New Query&quot; e digite o seguinte:</p> <p>ALTER LOGIN UserLogin WITH PASSWORD = &#39;NewPassword&#39; UNLOCK</p> <p>Naturalmente substituindo UserLogin e NewPassword pelos respectivos valores. Isto irá desbloquear a conta.<br /><br />Se desejar desabilitar a política de senhas, faça o seguinte:<br /><br />ALTER LOGIN UserLogin WITH CHECK_EXPIRATION = OFF<br /><br />ALTER LOGIN UserLogin WITH CHECK_POLICY = OFF</p><div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1481579" width="1" height="1">SQL Serverhttp://msmvps.com/blogs/paleo/archive/2008/01/21/sql-server-offline.aspxMon, 21 Jan 2008 17:21:00 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1473786paleo0http://msmvps.com/blogs/paleo/rsscomments.aspx?PostID=1473786http://msmvps.com/blogs/paleo/commentapi.aspx?PostID=1473786http://msmvps.com/blogs/paleo/archive/2008/01/21/sql-server-offline.aspx#comments<p>Ok, esta dúvida surgiu 3 vezes só hoje, então resolvi postar.</p> <p>Digamos que você esteja gerenciando o SQL Server através do SQL Server Management Studio, ou o que o valha. Então dá um clique direito em uma base de dados e seleciona &quot;Take Offline&quot;.</p> <p>Maravilha, isto funciona perfeito, mas então clica denovo e tenta selecionar &quot;Bring Online&quot;. Não funcionou, certo? Nem poderia...</p> <p>Para trazer o banco de volta você precisará acessar o OSQL como administrador. Para isto siga os passos abaixo:</p> <p><strong>OSQL -E</strong></p> <p><strong>ALTER DATABASE &lt;nome_do_banco&gt; SET ONLINE</strong></p> <p>Pronto, só precisa fazer isto!</p><div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1473786" width="1" height="1">SQL Serverhttp://msmvps.com/blogs/paleo/archive/2007/11/30/livros-online-sobre-sql-server-2005.aspxSat, 01 Dec 2007 01:33:00 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1372451paleo0http://msmvps.com/blogs/paleo/rsscomments.aspx?PostID=1372451http://msmvps.com/blogs/paleo/commentapi.aspx?PostID=1372451http://msmvps.com/blogs/paleo/archive/2007/11/30/livros-online-sobre-sql-server-2005.aspx#comments<p>Está disponível para download a nova versão dos livros para SQL Server 2005, aproveite e atualize sua biblioteca de livros online.</p> <p><a href="http://www.microsoft.com/downloads/details.aspx?familyid=be6a2c5d-00df-4220-b133-29c1e0b6585f&amp;displaylang=en&amp;tm">http://www.microsoft.com/downloads/details.aspx?familyid=be6a2c5d-00df-4220-b133-29c1e0b6585f&amp;displaylang=en&amp;tm</a></p><div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1372451" width="1" height="1">SQL Server