Notes

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
======Microsoft SQL Server======

[[https://techcommunity.microsoft.com/t5/sql-server-blog/announcing-the-modern-servicing-model-for-sql-server/ba-p/385594|Microsoft SQL Server Blog - Announcing the Modern Servicing Model for SQL Server]] Published Mar 23 2019 04:49 PM 


=====Blogs=====
[[http://blogs.msdn.com/sqlcat/|Microsoft SQL Server Development Customer Advisory Team]] zie ook:[[http://sqlcat.com/Default.aspx|sqlCAT]] \\
[[http://blogs.msdn.com/sqlnativeclient/|Microsoft SQL Server Native Client team blog]] \\
[[http://blogs.msdn.com/sql_protocols/|SQL Protocols]] Topics from the Microsoft SQL Server Protocols team - Netlibs, TDS, SQL Browser, etc... \\
[[http://blogs.msdn.com/sqlexpress/|SQL Server Express WebLog]] \\
[[http://blogs.msdn.com/arvindsh/|Esoteric]] All esoteric things about SQL Server and Microsoft Developer Tools \\
[[http://blogs.msdn.com/sqlserverstorageengine/|SQL Server Storage Engine]] \\
[[http://blogs.msdn.com/b/sqlreleaseservices/|Microsoft SQL Server Release Services]] \\

[[http://weblogs.sqlteam.com/tarad/Default.aspx|Ramblings of a DBA (Tara Kizer)]] \\
[[http://sqllearnings.blogspot.com/|SQL Learnings]] \\
[[http://deepakrangarajan.blogspot.com/|Phoenix]] \\
[[http://www.sql-server-pro.com/|SQL Server Pro]] - Articles and Tips from a SQL Server DBA and Consultant \\
[[http://sqlserverperformance.wordpress.com/|Glenn Berry's SQL Server Performance]] \\
[[http://www.sqlskills.com/BLOGS/KIMBERLY/|Kimberly L. Tripp]] \\
[[http://www.fits-consulting.de/blog/CategoryView,category,Development,T-SQL.aspx|some thoughts... - Development|T-SQL]] \\

=====Documentation=====
[[http://technet.microsoft.com/en-us/sqlserver/bb671430.aspx|Microsoft TechNet - SQL Server Best Practices]] \\
[[http://msdn.microsoft.com/en-us/library/ms190445.aspx|MSDN - Create or Delete a Server Alias for Use by a Client (SQL Server Configuration Manager)]] \\


[[https://learn.microsoft.com/en-US/troubleshoot/sql/general/servicing-models-sql-server|Microsoft Learn - Servicing models for SQL Server]] \\
[[https://learn.microsoft.com/en-us/troubleshoot/sql/releases/download-and-install-latest-updates|Microsoft Learn - Latest updates and version history for SQL Server]] \\


====SQL Server Management Studio====

[[https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms|Microsoft Learn - SQL Docs - Download SQL Server Management Studio (SSMS)]] \\
[[https://aka.ms/ssmsfullsetup|Latest SSMS setup]] \\


====SQL Server 2000====
[[http://support.microsoft.com/lifecycle/?p1=2852|Microsoft ondersteunings-lifecycle - SQL Server 2000]] \\

====SQL Server 2005====
[[http://msdn.microsoft.com/en-US/library/ms130214(v=sql.90).aspx|MSDN - SQL Server 2005 Books Online]] \\
[[http://msdn.microsoft.com/en-US/library/ms143761(v=sql.90)|MSDN - Features Supported by the Editions of SQL Server 2005]] \\
[[http://msdn.microsoft.com/en-US/library/ms143685(v=sql.90)|MSDN - Memory Supported by the Editions of SQL Server 2005]] \\
[[http://msdn.microsoft.com/en-US/library/ms143760(v=sql.90)|MSDN - Maximum Number of Processors Supported by the Editions of SQL Server 2005]] \\
[[http://msdn.microsoft.com/en-US/library/ms143432(v=sql.90)|MSDN - Maximum Capacity Specifications for SQL Server 2005]] \\
[[http://msdn.microsoft.com/en-us/library/ms143694(v=sql.90)|MSDN - SQL Server 2005 - Working with Multiple Versions of SQL Server]] \\
[[http://technet.microsoft.com/en-us/library/ms143506(v=sql.90).aspx|TechNet - Hardware and Software Requirements for Installing SQL Server 2005]] \\
[[http://technet.microsoft.com/en-us/library/ms189826(v=sql.90).aspx|TechNet - Transact-SQL Reference]] \\
[[http://technet.microsoft.com/en-us/library/ms189631(v=sql.90).aspx|TechNet - Setting Server Configuration Options]] \\
[[http://technet.microsoft.com/en-us/library/ms190461(v=SQL.90).aspx|TechNet - SMO and DMO XPs Option]] \\
[[http://msdn.microsoft.com/en-us/library/ms190640(v=sql.90).aspx|MSDN - How to: Enable Log Shipping (SQL Server Management Studio)]] \\
[[http://msdn.microsoft.com/en-us/library/ms188708(v=sql.90).aspx|MSDN - How to: Enable Log Shipping (Transact-SQL)]] \\
[[http://msdn.microsoft.com/en-US/library/ms189071(v=sql.90).aspx|MSDN - How to: Remove Log Shipping (SQL Server Management Studio)]] \\
[[http://msdn.microsoft.com/en-US/library/ms191297(v=sql.90).aspx|MSDN - How to: Remove Log Shipping (Transact-SQL)]] \\

===Installation===
[[http://msdn.microsoft.com/en-us/library/ms144259(SQL.90).aspx|MSDN - How to: Install SQL Server 2005 from the Command Prompt]] \\

====SQL Server 2008====
[[http://msdn.microsoft.com/en-us/library/ms130214(v=sql.100).aspx|MSDN - SQL Server 2008 Books Online]] \\
[[http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.100).aspx|MSDN - Features Supported by the Editions of SQL Server 2008]] \\
[[http://msdn.microsoft.com/en-us/library/ms143506(v=sql.100)|MSDN - Hardware and Software Requirements for Installing SQL Server 2008]]  (for max memory supported per edition) \\
[[http://msdn.microsoft.com/en-us/library/ms143694(v=sql.100)|MSDN - Working with Multiple Versions and Instances of SQL Server]] \\
[[http://technet.microsoft.com/en-us/library/ms143506(v=sql.100).aspx|TechNet - Hardware and Software Requirements for Installing SQL Server 2008]] \\
[[http://technet.microsoft.com/en-us/library/bb510741(v=sql.100).aspx|Technet - Transact-SQL Reference (Database Engine)]] \\

===Installation===
[[http://msdn.microsoft.com/en-us/library/ms144259(SQL.100).aspx|MSDN - How to: Install SQL Server 2008 from the Command Prompt]] \\

====SQL Server 2008 R2====
[[http://blogs.msdn.com/b/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server-2008-r2.aspx|Microsoft Press - Free ebook: Introducing Microsoft SQL Server 2008 R2]] \\
[[http://msdn.microsoft.com/en-us/library/ms130214(v=sql.105).aspx|MSDN - SQL Server 2008 R2 Books Online]] \\
[[http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.105).aspx|MSDN - Features Supported by the Editions of SQL Server 2008 R2]] \\
[[http://msdn.microsoft.com/en-us/library/ms143694(v=sql.105).aspx|MSDN - Working with Multiple Versions and Instances of SQL Server]] \\
[[http://technet.microsoft.com/en-us/library/ms143506(v=sql.105).aspx|TechNet - Hardware and Software Requirements for Installing SQL Server 2008 R2]] \\
[[http://technet.microsoft.com/en-us/library/bb510741(v=sql.105).aspx|TechNet - Transact-SQL Reference (Database Engine)]] \\

===Installation===
[[http://msdn.microsoft.com/en-us/library/ms144259(SQL.105).aspx|MSDN - How to: Install SQL Server 2008 R2 from the Command Prompt]] \\ 

====SQL Server 2012====
[[http://blogs.msdn.com/b/microsoft_press/archive/2012/03/15/free-ebook-introducing-microsoft-sql-server-2012.aspx|Microsoft Press - Free ebook: Introducing Microsoft SQL Server 2012]] \\
[[http://msdn.microsoft.com/en-us/library/ms130214(v=SQL.110).aspx|MSDN - SQL Server 2012 Books Online]] \\
[[http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx|MSDN - Features Supported by the Editions of SQL Server 2012]] \\
[[http://msdn.microsoft.com/en-us/library/ms143694(v=sql.110).aspx|MSDN - Work with Multiple Versions and Instances of SQL Server]] \\
[[http://technet.microsoft.com/en-us/library/ms143506(v=SQL.110).aspx|TechNet - Hardware and Software Requirements for Installing SQL Server 2012]] \\
[[http://technet.microsoft.com/en-us/library/bb510741(v=sql.110).aspx|TechNet - Transact-SQL Reference (Database Engine)]] \\
[[http://technet.microsoft.com/en-us/library/ms187103.aspx|TechNet - About Log Shipping (SQL Server)]] \\

===Installation===
[[http://technet.microsoft.com/en-us/library/ms144259(v=sql.110).aspx|TechNet - Install SQL Server 2012 from the Command Prompt]] \\


====SQL Server 2014====

[[https://msdn.microsoft.com/en-us/library/ms143506%28v=sql.120%29.aspx|TechNet - Hardware and Software Requirements for Installing SQL Server 2014]] \\

[[https://support.microsoft.com/en-us/topic/kb2936603-sql-server-2014-build-versions-6f75da99-d86f-53fa-23ce-3d2b4825eccb|Microsoft Support - KB2936603 - SQL Server 2014 build versions]] \\


====SQL Server 2016====

[[https://msdn.microsoft.com/en-us/library/ms143506%28v=sql.140%29.aspx|TechNet - Hardware and Software Requirements for Installing SQL Server 2016]] \\

[[https://support.microsoft.com/en-us/topic/kb3177312-sql-server-2016-build-versions-d6cd8e5f-4aa3-20ac-f38f-8faef950840f|Microsoft Support - KB3177312 - SQL Server 2016 build versions]] \\
[[https://www.microsoft.com/en-us/download/details.aspx?id=103440|Microsoft Download Center -  Microsoft SQL Server 2016 Service Pack 3 (SP3)]] \\
====SQL Server 2017====

[[https://support.microsoft.com/en-us/topic/kb4041553-sql-server-service-packs-are-discontinued-starting-from-sql-server-2017-fd405dee-cae7-b40f-db14-01e3e4951169|Microsoft Support - KB4041553 - SQL Server Service Packs are discontinued starting from SQL Server 2017]]

[[https://www.microsoft.com/en-us/download/details.aspx?id=56128|Microsoft Download Center - SQL Server 2017 for Microsoft Windows Latest Cumulative Update]] \\
[[https://support.microsoft.com/en-us/topic/kb4047329-sql-server-2017-build-versions-346e8fcd-c07c-5eeb-e10b-e3411ba8d8dd|Microsoft Support - KB4047329 - SQL Server 2017 build versions]] \\


[[https://www.microsoft.com/en-in/download/details.aspx?id=55994|Microsoft Download Center -  Microsoft SQL Server 2017 Express]] \\


====SQL Server 2019====

[[https://www.microsoft.com/en-us/download/details.aspx?id=100809|Microsoft Download Center - SQL Server 2019 for Microsoft Windows Latest Cumulative Update]] \\
[[https://support.microsoft.com/en-us/topic/kb4518398-sql-server-2019-build-versions-782ed548-1cd8-b5c3-a566-8b4f9e20293a|Microsoft Support - KB4518398 - SQL Server 2019 build versions]] \\

[[https://www.microsoft.com/en-us/Download/details.aspx?id=101064|Microsoft Download Center -  Microsoft SQL Server 2019 Express]] \\


====SQL Server 2022====

[[https://www.microsoft.com/en-us/download/details.aspx?id=105013|Microsoft Download Center -  SQL Server 2022 for Microsoft Windows Latest Cumulative Update]] \\
[[https://support.microsoft.com/en-us/topic/kb5023451-sql-server-2022-build-versions-ffabbfc8-0852-4b07-ab56-11bd3ae9dda5|Microsoft Support - KB5023451 - SQL Server 2022 build versions]] \\


=====KB articles=====
[[http://support.microsoft.com/kb/287932/|INF: TCP Ports Needed for Communication to SQL Server Through a Firewall]] \\
[[http://support.microsoft.com/kb/925976|Error message when you try to install a SQL Server 2005 service pack or a SQL Server 2005 hotfix package: "Error 29528. The setup has encountered an unexpected error while Setting Internal Properties"]] \\
[[http://support.microsoft.com/kb/937137/|The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released]] \\
[[http://support.microsoft.com/kb/264474|You cannot restore system database backups to a different build of SQL Server]] \\
[[http://support.microsoft.com/kb/909967/en-us|How to uninstall an instance of SQL Server 2005 manually]] \\
[[http://support.microsoft.com/kb/328551/en-us|Microsoft Support - Concurrencty enhancements for the tempdb database (KB328551)]] \\

[[http://support.microsoft.com/kb/955392/en-us|How to update or slipstream an installation of SQL Server 2008]] \\
[[http://support.microsoft.com/kb/957826/en-us|Where to find information about the latest SQL Server builds]] \\
[[https://docs.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sql-server|Microsoft Docs - Latest updates for Microsoft SQL Server]] \\

[[http://support.microsoft.com/kb/246133/en-us|How to transfer logins and passwords between instances of SQL Server]] from SQL Server < 2005 to SQL Server <= 2005. \\
[[http://support.microsoft.com/kb/918992/en-us|How to transfer logins and passwords between instances of SQL Server]] from SQL Server >= 2005 to SQL Server <= 2012. \\

[[http://support.microsoft.com/kb/321247/en-us|How to configure security for SQL Server log shipping]] \\

[[http://support.microsoft.com/kb/956893/en-us|Support policy for Microsoft SQL Server products that are running in a hardware virtualization environment]] \\

[[https://support.microsoft.com/en-us/kb/2964518|Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014 with high-performance workloads (KB2964518)]] \\

=====Blogposts/Articles=====
**Glenn Berry**: \\
[[http://sqlserverperformance.wordpress.com/2011/02/14/sql-server-and-the-lock-pages-in-memory-right-in-windows-server|SQL Server and the “Lock pages in memory” Right in Windows Server]] \\
[[http://sqlserverperformance.wordpress.com/2009/10/29/suggested-max-memory-settings-for-sql-server-20052008/|Suggested Max Memory Settings for SQL Server 2005/2008]] \\
[[http://sqlserverperformance.wordpress.com/2011/02/10/windows-instant-file-initialization-and-sql-server/|Windows Instant File Initialization and SQL Server]]\\
[[http://sqlserverperformance.wordpress.com/2011/01/30/microsoft-support-policies-for-windows-server-and-sql-server/|Microsoft Support Policies for Windows Server and SQL Server]] \\
[[http://sqlserverperformance.wordpress.com/2010/12/27/sql-server-workload-types-and-hardware-selection/|SQL Server Workload Types and Hardware Selection]] \\
[[http://www.simple-talk.com/sql/database-administration/configuring-the-storage-subsystem/?utm_source=simpletalk&utm_medium=email-main&utm_content=storagesubsystem-20110725&utm_campaign=SQL|simple-talk - Configuring the Storage Subsystem]] 20 july 2011, by Glen Berry. \\

[[http://blogs.msdn.com/b/sqlcat/archive/2010/04/01/using-sql-agent-job-categories-to-automate-sql-agent-job-enabling-with-database-mirroring.aspx|Microsoft SQL Server Development Customer Advisory Team - Using SQL Agent Job Categories to Automate SQL Agent Job Enabling with Database Mirroring]] \\
[[http://www.sqlwebpedia.com/content/sql-server-oltp-disk-io-configuration-best-practices|SQLWebpedia - SQL Server OLTP Disk IO Configuration Best Practices]] \\
[[http://www.sqlwebpedia.com/content/preserving-sql-job-history|SQLWebpedia - Preserving SQL Job History]] \\

[[http://nickstips.wordpress.com/2010/08/16/sql-sql-server-2008-express-missing-configurationfile-ini/|Nick Olsen's Programming Tips - SQL: SQL Server 2008 Express Missing ConfigurationFile.ini]] describes how to get the SQL Server 2008 R2 Express setup to make you a ConfigurationFile.ini, which it doesn't do by default, by using the /UIMode=Normal commandline switch.\\

[[http://www.sqlservercentral.com/blogs/scarydba/archive/2011/08/22/expert_3F00_-ha_2100_.aspx|The Scary DBA - Expert? Ha!]] describes four SQL Server trace flags that influence how execution plans get built (2861, 2335, 2389, 2390) \\

[[http://blogs.technet.com/b/andrew/archive/2011/08/12/sql-server-on-windows-server-core-part-1-server-core-installation.aspx|Insufficient data from Andrew Fryer - SQL Server on Windows Server Core - part 1 Server Core installation]] \\
[[http://blogs.technet.com/b/andrew/archive/2011/08/14/sql-server-on-windows-server-core-part-2-configuring-server-core.aspx|Insufficient data from Andrew Fryer - SQL Server on Windows Server Core part 2–Configuring Server Core]] \\
[[http://blogs.technet.com/b/andrew/archive/2011/08/16/sql-server-on-windows-server-core-part-3-installing-sql-server.aspx|Insufficient data from Andrew Fryer - SQL Server on Windows Server Core part 3–Installing SQL Server]] \\
[[http://blogs.technet.com/b/andrew/archive/2011/08/17/sql-server-on-windows-server-core-part-4-sysprep-amp-sql-server.aspx|Insufficient data from Andrew Fryer - SQL Server on Windows Server Core part 4 – Sysprep & SQL Server]] \\

[[http://thavash.wordpress.com/2011/10/20/analysis-services-performance-guide/|Thavash's Sql Blog - Analysis Services performance guide]] \\
[[http://www.simple-talk.com/sql/database-administration/great-sql-server-debates-lock-pages-in-memory/|simple-talk - Great SQL Server Debates: Lock Pages in Memory]] \\
[[http://www.brentozar.com/archive/2012/01/sql-server-databases-on-network-shares-nas/|Brent Ozar PLF - SQL Server Can Run Databases from Network Shares & NAS]] \\
[[http://www.brentozar.com/archive/2013/08/what-is-the-cxpacket-wait-type-and-how-do-you-reduce-it/|Brent Ozar Unlimited - What is the CXPACKET Wait Type, and How Do You Reduce It?]] describes Maximum Degree of Parallelism (MAXDOP) optimizations. \\
[[http://thomaslarock.com/2012/01/how-to-improve-database-performance-without-changing-code/|SQLRockstar - How To Improve Database Performance Without Changing Code]] \\
[[http://weblogs.sqlteam.com/BILLG/archive/2011/02/08/sql-server-scripts-i-use.aspx|Bill Graziano's SQL Server Blog - SQL Server Scripts I Use]] \\

[[http://www.brentozar.com/archive/2008/03/sql-server-2005-setup-checklist-part-1-before-the-install/|Brent Ozar Unlimited - SQL Server 2005/2008/2012 Setup Checklist]] \\
[[http://www.brentozar.com/archive/2008/03/sql-server-2005-setup-checklist-part-2-after-the-install/|Brent Ozar Unlimited - SQL Server 2005 Setup Checklist Part 2: After The Install]] \\
[[http://www.brentozar.com/sql/sql-server-performance-tuning/|Brent Ozar Unlimited - SQL Server Performance Tuning]] \\
[[http://www.brentozar.com/archive/2007/10/backing-up-sql-server-my-own-mediocre-practices/|Brent Ozar Unlimited - SQL Server Backup Best Practices]] \\
[[http://www.sql-server-performance.com/2003/awe-memory-sql2000/|SQL Server Performance - Using AWE Memory in SQL Server 2000]] \\

[[http://blogs.msdn.com/b/buckwoody/archive/2010/06/29/the-windows-page-file-and-sql-server.aspx|MSDN Blogs > Carpe Datum > The Windows Page File and SQL Server]] \\

[[https://www.saotn.org/install-sql-server-cumulative-updates-silently/|Sysadmins of the North - Install SQL Server cumulative updates silently]]


====AlwaysOn====
[[http://www.brentozar.com/sql/sql-server-alwayson-availability-groups/|Brent Ozar - SQL Server 2014 and 2012 AlwaysOn Availability Groups]] \\

====Backup====
[[http://troubleshootingsql.com/2011/02/09/troubleshooting-that-darn-backup-error/|TroubleshootingSQL - 
Troubleshooting that darn backup error]] \\
[[http://troubleshootingsql.com/2011/06/18/sql-server-backup-simulator-v2-available-now/|TroubleshootingSQL - SQL Server Backup Simulator v2 available now]] \\
[[http://troubleshootingsql.com/2011/01/17/sql-server-backup-simulator-cumulative-update/|TroubleshootingSQL - SQL Server Backup Simulator: Cumulative update]] \\
====Permissions====
[[http://richbrownesq-sqlserver.blogspot.nl/2012/01/admin-bulkadmin-vs-administer-bulk.html|SQL Stuff - Admin: Bulkadmin vs ADMINISTER BULK OPERATIONS]] \\

=====Other links=====
[[http://vyaskn.tripod.com/administration_faq.htm|Microsoft SQL Server Administration FAQ]] \\
[[http://www.sql-server-performance.com/articles/dba/index.aspx|SQL Server General DBA Articles]] \\
[[http://www.sqldev.net/|SQLDev.Net]] \\
[[http://blogs.msdn.com/sqlsecurity/default.aspx|SQL Server Security]] blog. \\
[[http://www.sql-server-performance.com/|SQL Server Performance]] \\
[[http://sql.veranoest.net/|SQL Server troubleshooting]] \\
[[http://deepakrangarajan.blogspot.com/2007/12/backup-sql-server-databases-to-network.html|Phoenix - Backup SQL Server databases to Network Drive]] \\
[[http://www.kodyaz.com/articles/active-directory-services-queries-using-openquery.aspx|Running Active Directory Services Queries Using MS SQL Server OPENQUERY Command]] \\
[[http://www.simple-talk.com/sql/database-administration/brads-sure-dba-checklist/|simple-talk - Brad's Sure DBA Checklist]] (aka Brad McGehee's SQL Server DBA Best Practices poster) \\
[[http://www.simple-talk.com/sql/database-administration/what-specification-server-should-i-buy/|simple-talk - What Specification Server Should I Buy?]] \\
[[http://www.simple-talk.com/sql/database-administration/sql-server-security-cribsheet/|simple-talk - SQL Server Security Cribsheet]] \\
[[http://www.wasatchsoftware.com/tech_articles/sql_server_licensing.htm|Microsoft SQL Server 2000 Licensing Options Explained]] \\
[[http://www.wasatchsoftware.com/tech_articles/sql-server-2005-licensing.htm|SQL Server 2005 Licensing Explained]] \\
[[http://blogs.msdn.com/arvindsh/archive/2008/12/22/sql-server-setup-log-locations-and-more.aspx|Esoteric - SQL Server setup log locations and more]] \\
[[http://blogs.msdn.com/sqlsecurity/archive/2008/07/01/sql-server-and-the-windows-server-2008-firewall.aspx|SQL Server and the Windows Server 2008 Firewall]] \\
[[http://www.sqlhacks.com/|SQLHacks]] \\
[[http://sqlblog.com/blogs/aaron_bertrand/archive/2010/10/26/useful-free-resources-for-sql-server.aspx|Aaron Bertrand - Useful, free resources for SQL Server]] \\

[[http://blogs.msdn.com/sqlreleaseservices/|Microsoft SQL Server Release Services]] blog \\
[[https://sqlserverbuilds.blogspot.com/|Microsoft SQL Server Versions List]] \\
[[http://sqlserverpedia.com/wiki/SQL_Server_Release_Date_Calendar|SQLServerPedia - SQL Server Release Date Calendar]] \\

[[http://support.microsoft.com/kb/957826/en-us|Microsoft Support - Where to find information about the latest SQL Server builds]] \\

**Licensing** \\
[[http://sqlblogcasts.com/blogs/tonyrogerson/archive/2011/10/21/you-do-not-need-a-separate-sql-server-licence-for-a-standby-or-passive-server-this-microsoft-white-paper-explains-all.aspx|Tony Rogerson's ramblings on SQL Server - You do not need a separate SQL Server license for a Standby or Passive server - this Microsoft White Paper explains all]] \\
[[http://weblogs.sqlteam.com/joew/archive/2009/02/17/60844.aspx|Joe Webb - Reporting Services Licensing]]: every server with any piece of SQL Server installed needs its own SQL Server license even if you're not using the Database Engine on that server. \\
[[http://www.directionsonmicrosoft.com/licensing/30-licensing/1776-licensing-sql-server-2008-r2-.html|Directions on Microsoft - Licensing SQL Server 2008 R2]] \\

**SQL Server 2000** \\
[[http://technet.microsoft.com/en-us/library/cc805478.aspx|TechNet Archive - SQL Server 2000]] \\
[[http://www.nsa.gov/snac/db/mssql_2k.pdf|NSA - Guide to the Secure Configuration and Administration of Microsoft SQL Server 2000]] \\
[[http://www.sqldts.com/|Data Transformation Services on the web]] \\
[[http://www.sqldts.com/210.aspx|Execute a package from T-SQL]] \\
[[http://www.sqldts.com/301.aspx|Getting Syntax Help for DTSRun]] \\
[[http://forums.databasejournal.com/showthread.php?t=8974|Repairing Corrupt MSDB file in SQL Server 2000]] \\

**SQL Server 2005** \\
[[http://support.microsoft.com/kb/913089/en-us|Microsoft Support - How to obtain the latest service pack for SQL Server 2005]] \\
[[http://support.microsoft.com/kb/916940/en-us|Microsoft Support - A list of the new features and improvements that are included in SQL Server 2005 Service Pack 1]] \\
[[http://go.microsoft.com/fwlink/?LinkId=71711|What's New in SQL Server 2005 SP2]] (htm download) \\
[[http://support.microsoft.com/kb/921896/en-us|Microsoft Support - A list of the bugs that are fixed in SQL Server 2005 Service Pack 2]] \\
[[http://support.microsoft.com/kb/933508/en-us|Microsoft Support - Microsoft SQL Server 2005 Service Pack 2 issue: Cleanup tasks run at different intervals than intended]] \\
[[http://support.microsoft.com/kb/937137/en-us|Microsoft Support - The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released]] \\
[[http://msdn.microsoft.com/en-us/library/dd353312(SQL.90).aspx|MSDN - What's New in SQL Server 2005 SP3]] \\
[[http://support.microsoft.com/kb/955706/en-us|Microsoft Support - List of the bugs that are fixed in SQL Server 2005 Service Pack 3]] \\
[[http://support.microsoft.com/kb/960598/en-us|Microsoft Support - The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released]] \\
[[http://support.microsoft.com/kb/2463332/en-us|Microsoft Support - List of the issues that are fixed in SQL Server 2005 Service Pack 4]] \\
[[http://support.microsoft.com/kb/2485757/en-us|Microsoft Support - The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 4 was released]] \\
[[http://support.microsoft.com/kb/2507769/en-us|Microsoft Support - Cumulative update package 3 for SQL Server 2005 Service Pack 4]] \\
[[http://www.microsoft.com/en-us/download/details.aspx?id=20101|Microsoft Download Center - Feature Pack for Microsoft SQL Server 2005 SP4]] \\
[[http://technet.microsoft.com/en-us/library/cc966540.aspx|Microsoft TechNet - Troubleshooting Performance Problems in SQL Server 2005]] \\
[[http://www.microsoft.com/downloads/details.aspx?familyid=1D3A4A0D-7E0C-4730-8204-E419218C1EFC&displaylang=en|SQL Server 2005 Performance Dashboard Reports]] \\
[[http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA-F0E3FBD05E63&displaylang=en|SQL Server 2005 Best Practices Analyzer (August 2008)]] \\

[[http://secretgeek.net/sql2k_2k5.asp|Passwords in Sql Server 2000 are Case Insensitive by default -- WTF?]] \\
[[http://www.mssqltips.com/tip.asp?tip=1433|How to setup linked servers for SQL Server and Oracle 64 bit client]] \\
[[http://www.sqlmanager.net/en/articles/1251|Setting Up Delegation for Linked Servers]] \\
[[http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en|Feature Pack for Microsoft SQL Server 2005 - February 2007]] Links naar losse downloads van SQL Native Client en SQLCMD tool. \\
[[http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=273488&SiteID=1|SQL Server Upgrade 2000 - 2005 files read only but not really ]] \\
[[http://www.ss64.com/sql/index.html|SS64.com - An A-Z Index of the SQL Server 2005 database]] \\
[[http://support.microsoft.com/kb/937137|Microsoft Support - The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released]] \\
[[http://msdn.microsoft.com/en-us/library/ms190737(SQL.90).aspx|SQL Server 2005 Books Online (November 2008) - Using the SQL Server Service Startup Options]] \\
[[http://msdn.microsoft.com/en-us/library/ms188396(SQL.90).aspx|SQL Server 2005 Books Online (November 2008) - Trace Flags (Transact-SQL)]] \\

**SQL Server 2008** \\
[[http://support.microsoft.com/kb/968382/en-us|Microsoft Support - How to obtain the latest service pack for SQL Server 2008]] \\
[[http://support.microsoft.com/kb/956909/|Microsoft Support - The SQL Server 2008 builds that were released after SQL Server 2008 was released]] \\
[[http://support.microsoft.com/kb/970365/en-us|Microsoft Support - The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 1 was released]] \\
[[http://support.microsoft.com/kb/2402659/en-us|Microsoft Support - The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 2 was released]] \\
[[http://go.microsoft.com/fwlink/?LinkId=147331|Microsoft Download Center - SQL Server 2008 SP1 Release Notes]] (htm download) \\
[[http://support.microsoft.com/kb/968369/en-us|Microsoft Support - List of the bugs that are fixed in SQL Server 2008 Service Pack 1]] \\
[[http://support.microsoft.com/kb/969099/en-us|Microsoft Support - Cumulative update package 1 for SQL Server 2008 Service Pack 1(KB 969099)]] \\
[[http://support.microsoft.com/kb/970315/en-us|Microsoft Support - Cumulative update package 2 for SQL Server 2008 Service Pack 1 (KB 970315)]] "supports the concept of [[http://sqlserver-qa.net/blogs/sql2008/archive/2009/05/25/5691.aspx|Locked Pages for Standard Edition]]" Zie ook:[[http://support.microsoft.com/kb/970070/en-us|Microsoft Support - Support for Locked Pages on SQL Server 2005 Standard Edition 64-bit systems and on SQL Server 2008 Standard Edition 64-bit systems]] \\
[[http://support.microsoft.com/kb/2285068/en-us|Microsoft Support - List of the bugs that are fixed in SQL Server 2008 Service Pack 2]] \\
[[http://support.microsoft.com/kb/2289254/en-us|Microsoft Support - Cumulative update package 1 for SQL Server 2008 Service Pack 2]] \\
[[http://support.microsoft.com/kb/2467239/en-us|Microsoft Support - Cumulative update package 2 for SQL Server 2008 Service Pack 2]] \\
[[http://support.microsoft.com/kb/2555408/en-us|Microsoft Support - Cumulative update package 5 for SQL Server 2008 Service Pack 2]] \\
[[http://support.microsoft.com/kb/2582285/en-us|Microsoft Support - Cumulative update package 6 for SQL Server 2008 Service Pack 2]] \\
[[http://support.microsoft.com/kb/2546951/en-us|Microsoft Support - List of issues that are fixed by SQL Server 2008 Service Pack 3]] \\
[[http://support.microsoft.com/kb/2617146/en-us|Microsoft Support - Cumulative update package 1 for SQL Server 2008 Service Pack 3]] \\
[[http://blogs.msdn.com/petersad/archive/2009/02/25/sql-server-2008-creating-a-merged-slisptream-drop.aspx|SQL Server Setup - Creating a merged (slipstreamed) drop containing SQL Server 2008 RTM + Service Pack 1]] \\
[[http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=228de03f-3b5a-428a-923f-58a033d316e1|Microsoft SQL Server 2008 Feature Pack, October 2008]] \\
[[http://support.microsoft.com/kb/955763/en-us|Microsoft Support - The SQL Server Agent service does not start after you upgrade from SQL Server 2008 Express or from SQL Server 2008 Express with Advanced Services to SQL Server 2008 Developer, to SQL Server 2008 Enterprise, or to SQL Server 2008 Standard (KB955763)]] \\
[[http://www.asql.biz/Articoli/SQLX08/Art3_1.aspx|Insulin Power - Installing SQL Server Management Studio Express 2008]] \\
[[http://support.microsoft.com/kb/970133/en-us|Microsoft Support - FIX: When you create a compressed backup for a database in SQL Server 2008, you cannot stop the backup operation if the backup operation stops responding (KB970133)]] zie ook [[https://connect.microsoft.com/SQLServer/feedback/details/428738/nativebackup-spid-get-in-to-suspended-mode-with-backupio-and-backupthread-as-last-wait-type-when-backup-process-get-intrrupted-in-sql-server-2008-rtm|Microsoft Connect - NativeBackup SPID get in to suspended mode with BACKUPIO and BACKUPTHREAD as last wait type when backup process get intrrupted in SQL Server 2008 RTM]] \\

**SQL Server 2008 R2** \\
[[http://www.brentozar.com/archive/2009/11/sql-server-2008-r2-pricing-and-feature-changes/|Brent Ozar - SQL Server 2008 R2 Pricing and Feature Changes]] \\
[[http://support.microsoft.com/kb/2527041/en-us|Microsoft Support - How to obtain the latest service pack for SQL Server 2008 R2]] \\
[[http://support.microsoft.com/kb/981356/en-us|Microsoft Support - The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 was released]] \\
[[http://support.microsoft.com/kb/981355/en-us|Microsoft Support - Cumulative Update package 1 for SQL Server 2008 R2]] \\
[[http://support.microsoft.com/kb/2072493/en-us|Microsoft Support - Cumulative Update package 2 for SQL Server 2008 R2]] \\
[[http://support.microsoft.com/kb/2528583/en-us|Microsoft Support - List of the bugs that are fixed in SQL Server 2008 R2 Service Pack 1]] \\
[[http://support.microsoft.com/kb/2567616/en-us|Microsoft Support - The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 1 was released]] \\
[[http://support.microsoft.com/kb/2544793/en-us|Microsoft Support - Cumulative update package 1 for SQL Server 2008 R2 Service Pack 1]] \\
[[http://support.microsoft.com/kb/2567714/en-us|Microsoft Support - Cumulative update package 2 for SQL Server 2008 R2 Service Pack 1]] \\
[[http://support.microsoft.com/kb/2591748/en-us|Microsoft Support - Cumulative update package 3 for SQL Server 2008 R2 Service Pack 1]] \\
[[http://support.microsoft.com/kb/2630458/en-us|Microsoft Support - List of the bugs that are fixed in SQL Server 2008 R2 Service Pack 2]] \\
[[http://support.microsoft.com/kb/2730301/en-us|Microsoft Support - The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 2 was released]] \\
[[http://support.microsoft.com/kb/2720425/en-us|Microsoft Support - Cumulative update package 1 for SQL Server 2008 R2 Service Pack 2]] \\
[[http://support.microsoft.com/kb/2740411/en-us|Microsoft Support - Cumulative update package 2 for SQL Server 2008 R2 Service Pack 2]] \\
[[http://support.microsoft.com/kb/2754552/en-us|Microsoft Support - Cumulative update package 3 for SQL Server 2008 R2 SP2]] \\

**SQL Server 2012** \\
[[http://msdn.microsoft.com/en-us/library/bb500435.aspx|MSDN - What's New in SQL Server 2012]] \\
[[http://blogs.technet.com/b/andrew/archive/2011/08/19/installing-denali-ctp3-how-hard-can-it-be.aspx|Insufficient data from Andrew Fryer - Installing Denali ctp3–how hard can it be]] \\
[[http://denglishbi.wordpress.com/2011/07/22/configuring-sql-server-denali-reporting-services-sharepoint-2010-integration/|Dan English's BI Blog - Configuring SQL Server Denali Reporting Services SharePoint 2010 Integration]] \\
[[https://support.microsoft.com/en-us/kb/2755533|Microsoft Support - How to obtain the latest service pack for SQL Server 2012]] \\
[[https://support.microsoft.com/en-us/kb/2983249|Microsoft Support - SQL Server 2012 SP2 build versions]] \\
[[http://support.microsoft.com/kb/2772858/en-us|Microsoft Support - The SQL Server 2012 builds that were released after SQL Server 2012 Service Pack 1 was released]] \\
[[http://support.microsoft.com/kb/2692828/en-us|Microsoft Support - The SQL Server 2012 builds that were released after SQL Server 2012 was released]] \\
[[https://support.microsoft.com/en-us/kb/2958429|Microsoft Support - Bugs that are fixed in SQL Server 2012 Service Pack 2]] \\
[[http://support.microsoft.com/kb/2674319/en-us|Microsoft Support - List of the bugs that are fixed in SQL Server 2012 Service Pack 1]] \\
[[http://support.microsoft.com/kb/2679368/en-us|Microsoft Support - Cumulative update package 1 for SQL Server 2012]] \\
[[http://support.microsoft.com/kb/2703275/en-us|Microsoft Support - Cumulative update package 2 for SQL Server 2012 is available]] \\
[[http://support.microsoft.com/kb/2723749/en-us|Microsoft Support - Cumulative update package 3 for SQL Server 2012 is available]] \\
[[http://blogs.msdn.com/b/brismith/archive/2012/07/03/a-new-sql-server-and-some-different-cube-building-errors.aspx|Microsoft Office Project Support Weblog - A New SQL Server–and some different cube building errors]] \\

**SQL Server 2014** \\
[[https://support.microsoft.com/en-us/kb/2958069|Microsoft Support - How to obtain the latest service pack for SQL Server 2014]] \\
[[https://support.microsoft.com/en-us/kb/2936603|Microsoft Support - SQL Server 2014 build versions]] \\

**SQL Server 2016** \\
[[https://support.microsoft.com/en-us/help/3177312|Microsoft Support - SQL Server 2016 build versions]] \\

**SQL Server 2017** \\
[[https://support.microsoft.com/en-us/help/4047329|Microsoft Support - SQL Server 2017 build versions]] \\

**Reporting Services** \\
[[http://dobrzanski.net/2008/08/12/reporting-services-deploying-rdl-files/|Blinded by the lights - Reporting Services – deploying RDL files]] \\
[[http://sql-articles.com/blogs/download-export-rdl-files-from-report-server/|Vidhya Sagar – Blog - Download \ Export RDL files from Report Server]] \\
[[http://social.msdn.microsoft.com/forums/en-us/sqlreportingservices/thread/F76DAA9F-B9F3-4E23-8EDF-217F49523716|SQL Server Developer Center > SQL Server Forums > SQL Server Reporting Services > Shared Schedule Headache]] Fix for the "The EXECUTE permission was denied on the object 'sp_verify_job_identifiers', database 'msdb', schema 'dbo'. () (.Net SqlClient Data Provider)" error. \\

**Analysis Services** \\
[[http://sqlblogcasts.com/blogs/acalvett/archive/2009/04/05/analysis-server-appears-to-hang.aspx|Andrew Calvett - Analysis Server appears to hang...]] \\
[[http://ssas-wiki.com/|SSAS-WIKI]] \\
=====Tools=====
[[http://www.lazycoding.com/products.aspx|SQLScheduler]] is a fully functional client/server application written in C# that allows administrators to schedule various SQL jobs for SQL Server Express and other versions of SQL Server. (dead link) {{ :microsoft:sqlscheduler_latestversion.zip |Last SQLScheduler version.}} \\
[[http://robkennedy.com/files/folders/mssql_dump/default.aspx|Rob Kennedy Ingenuities - MSSQL Dump 2007]] (dead link, [[https://web.archive.org/web/20090106132753/http://www.robkennedy.com/files/folders/mssql_dump/entry16.aspx|archive.org version]]) \\
[[http://sqlprofiler.googlepages.com/|Profiler for Microsoft SQL Server 2005/2008 Express Edition]] (dead link) \\
[[http://www.asql.biz/en/|Insulin Power - SQL Tools]] heeft de volgende tool: [[http://www.asql.biz/en/DbaMgr.aspx|DbaMgr - DbaMgr2K]] A little alternative administrative console for Microsoft MSDE 1.0 and MSDE 2000 written in Microsoft Visual Basic 6.0. \\
[[http://www.ssmstoolspack.com/|SSMS Tools Pack]] is an add-in for Microsoft SQL Server Management Studio (SSMS) 2005, 2008, 2008 R2, Denali CTP3 and their respective Express versions. It contains a few upgrades to the SSMS IDE. \\
[[http://blogs.msdn.com/b/sqlserverfaq/archive/2010/10/27/sql-server-backup-simulator.aspx|MSDN Blogs > Microsoft SQL Server Tips & Tricks > SQL Server Backup Simulator]] \\

=====Auto Close=====
Auto Close is a property on a SQL database. If set to true the database is closed and used resources are freed when there are no more connections to the databaase. This option is only recommended for use on development systems. \\
[[http://doc.ddart.net/mssql/sql70/9_dmor44_26.htm|AutoClose Property (SQL-DMO)]] \\
[[http://eventid.net/display.asp?eventid=17137&eventno=9319&source=MSSQL$SQLEXPRESS&phase=1|Event ID: 17137]] \\

The following T-SQL generates ALTER DATABASE statements for all databases that currently have auto close set to on:
<code tsql>
SELECT 'ALTER DATABASE ['+name+'] 
SET AUTO_CLOSE OFF
GO'
---SELECT name
FROM master.sys.databases
WHERE is_auto_close_on = 1
</code>
Source: [[http://sqlmag.com/blog/worst-practice-allowing-autoclose-sql-server-databases|SQL Server Pro - Practical SQL Server - Worst Practice: Allowing AutoClose on SQL Server Databases]] \\

=====Collation=====
Change the collation of your database:
<code>
USE Tempdb
GO
ALTER DATABASE (database name here) COLLATE (collation name here)
GO
</code>
Bron:[[http://www.serverintellect.com/support/sqlserver/change-database-collation.aspx|Change the collation of your database]] \\


=====Activate Database mail=====

Tested and used on SQL Server 2005/2008/2019.
<code sql>
--Source: http://www.mssqltips.com/tip.asp?tip=1736

use master
DECLARE @SMTPServer VARCHAR(100)
DECLARE @AdminEmail VARCHAR(100)
DECLARE @DomainName VARCHAR(100)
DECLARE @replyToEmail VARCHAR(100)
   
SET @SMTPServer = 'smtpserver.domain.com'
SET @AdminEmail = 'admin@domain.com'
SET @DomainName = '@domain.com'
SET @replyToEmail = 'replytomail@domain.com'

exec sp_configure 'show advanced options', 1
RECONFIGURE
exec sp_configure 'Database Mail XPs', 1
exec sp_configure 'Agent XPs',1
RECONFIGURE --WITH OVERRIDE

declare @servername varchar(100)
declare @email_address varchar(100)
declare @display_name varchar(100)
declare @testmsg varchar(100)
set @servername = replace(@@servername,'\','_')
set @email_address = @servername + @DomainName
set @display_name = 'MSSQL - ' + @servername
set @testmsg = 'Test from ' + @servername
IF EXISTS(SELECT * from msdb.dbo.sysmail_profile)
PRINT 'DB mail already configured'
ELSE
BEGIN
  --Create database mail account.
   exec msdb.dbo.sysmail_add_account_sp
   @Account_name = 'SQLMail Account'
   , @description = 'Mail account for use by all database users.'
   , @email_address = @email_address
   , @replyto_address = @replyToEmail
   , @display_name = @display_name
   , @mailserver_name = @SMTPServer
   --Create global mail profile.
   exec msdb.dbo.sysmail_add_profile_sp
   @profile_name = 'SQLMail Profile'
   , @description = 'Mail profile setup for email from this SQL Server'
   --Add the account to the profile.
   exec msdb.dbo.sysmail_add_profileaccount_sp
   @profile_name = 'SQLMail Profile'
   , @Account_name = 'SQLMail Account'
   , @sequence_number=1
   --grant access to the profile to all users in the msdb database
   use msdb
   exec msdb.dbo.sysmail_add_principalprofile_sp
   @profile_name = 'SQLMail Profile'
   , @principal_name = 'public'
  , @is_default = 1
END
--send a test message.
exec msdb..sp_send_dbmail
@profile_name = 'SQLMail Profile', 
@recipients = @AdminEmail,
@subject = @testmsg,
@body = @testmsg

EXEC msdb.dbo.sysmail_help_profile_sp

-- Enabling SQL Agent notification
USE [msdb]
EXEC msdb.dbo.sp_set_sqlagent_properties 
 @email_save_in_sent_folder=1
 
EXEC master.dbo.xp_instance_regwrite 
 N'HKEY_LOCAL_MACHINE'
 , N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent'
 , N'UseDatabaseMail'
 , N'REG_DWORD'
 , 1
 
EXEC master.dbo.xp_instance_regwrite 
 N'HKEY_LOCAL_MACHINE'
 , N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent'
 , N'DatabaseMailProfile'
 , N'REG_SZ'
 , N'SQLMail Profile'

</code>
Bron:[[http://www.mssqltips.com/tip.asp?tip=1736|MSSQLTips - SQL Server Database Mail and SQL Agent Mail setup by using a script]] \\


====Changing the mailserver====

Check current settings
<code sql>
EXEC msdb.dbo.sysmail_help_account_sp
</code>
Change the mailserver
<code sql>
EXEC msdb.dbo.sysmail_update_account_sp @account_name = 'SQLMail Account', @mailserver_name = 'smtpserver.domain.com'
</code>
Send a test email
<code sql>
EXEC msdb.dbo.sp_send_dbmail @profile_name = 'SQLMail Profile', @recipients = 'admin@domain.com', @subject = 'Testmail', @body = 'Testmail'
</code>


====Adding Operators (to be mailed)====

To quickly add an operator which can be mailed (from a SQL Server Agent Job) use the following T-SQL code (and change name and email_address):
<code tsql>
EXEC msdb.dbo.sp_add_operator @name=N'Email1', 
		@enabled=1, 
		@pager_days=0, 
		@email_address=N'email1@domain.com'
GO
</code>

A SQL Server Agent Job can only mail 1 operator. \\
To be able to mail multiple e-mailaddresses, add a new operator containing each of the e-mailaddresses separated by semicolons (;). // The total length of the e-mailaddress field cannot exceed 100 characters. //
<code tsql>
EXEC msdb.dbo.sp_add_operator @name=N'Email1 & Email2', 
		@enabled=1, 
		@pager_days=0, 
		@email_address=N'email1@domain.com;email2@domain.com'
GO
</code>
Source:[[https://stackoverflow.com/questions/7431582/sql-server-agent-job-notify-multiple-operators-on-failure|Stack Overflow - SQL Server Agent Job Notify multiple operators on failure]]


====Deleting mail profiles and accounts====

Query the configured profiles and accounts:

<code sql>
EXEC msdb.dbo.sysmail_help_profile_sp
EXEC msdb.dbo.sysmail_help_account_sp
</code>

Delete profile and account by name:

<code sql>
EXEC msdb.dbo.sysmail_delete_profile_sp @profile_name = 'SSIS ERROR';
EXEC msdb.dbo.sysmail_delete_account_sp @account_name = 'SSIS JOBS';
</code>

Sources:
  * [[https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sysmail-delete-profile-sp-transact-sql?view=sql-server-ver16|Microsoft Learn - sysmail_delete_profile_sp (Transact-SQL)]]
  * [[https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sysmail-delete-account-sp-transact-sql?view=sql-server-ver16|Microsoft Learn - sysmail_delete_account_sp (Transact-SQL)]]



=====Full Text Indexing=====
Enable:
<code>
EXEC sp_fulltext_database 'enable'
</code>
Show information about all full-text catalogs associated with the current database:
<code>
EXEC sp_help_fulltext_catalogs
</code>
Start a full population:
<code>
EXEC sp_fulltext_catalog 'catalogname', 'start_full'
</code>
Bron:[[http://technet.microsoft.com/en-us/library/ms174394(SQL.90).aspx|SQL Server 2005 Books Online - Full-Text Search Stored Procedures (Transact-SQL)]] \\
See also:[[http://technet.microsoft.com/en-us/library/ms142581(SQL.90).aspx|SQL Server 2005 Books Online - Full-Text Search Fundamentals]] \\


=====Memory Usage=====
[[http://support.microsoft.com/kb/274750|Microsoft Support - How to configure SQL Server to use more than 2 GB of physical memory]] also look at:[[http://support.microsoft.com/kb/283037/|Large memory support is available in Windows Server 2003 and in Windows 2000]] \\
[[http://database.ittoolbox.com/documents/popular-q-and-a/memory-addressing-for-the-siebel-database-server-with-sql-server-2000-32-bit-3940#|Memory Addressing for the Siebel Database Server with SQL Server 2000 - 32 bit]] \\
[[http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-clustering/3365/Boot-ini|Boot.ini]] \\
[[http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=107424|Memory Configuration and /3GB /PAE]] \\
[[http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55191|SQL Memory]] \\
[[http://weblogs.asp.net/omarzabir/archive/2007/10/19/a-significant-part-of-sql-server-process-memory-has-been-paged-out-this-may-result-in-performance-degradation.aspx|A significant part of sql server process memory has been paged out. This may result in performance degradation]] \\
[[http://blogs.msdn.com/psssql/archive/2007/05/31/the-sql-server-working-set-message.aspx|CSS SQL Server Engineers - The SQL Server Working Set Message]] \\
[[http://support.microsoft.com/kb/918483|Microsoft Support - How to reduce paging of buffer pool memory in the 64-bit version of SQL Server (KB918483)]] \\
[[http://blogs.msdn.com/b/psssql/archive/2009/09/11/fun-with-locked-pages-awe-task-manager-and-the-working-set.aspx|MSDN Blogs > CSS SQL Server Engineers > Fun with Locked Pages, AWE, Task Manager, and the Working Set…]] \\

=====Installation=====
[[http://www.dbazine.com/sql/sql-articles/cook19|SQL Server 2005 and Express Installation Tips and Tricks]] \\
[[http://www.appdeploy.com/packages/detail.asp?id=662|Appdeploy - SQL Server 2005]]

**Troubleshooting**\\
[[http://blogs.msdn.com/psssql/archive/2008/09/05/sql-server-2005-setup-fails-in-wow-x86-on-computer-with-more-than-32-cpus.aspx|CSS SQL Server Engineers - SQL Server 2005 Setup Fails in WOW (x86) On Computer With More Than 32 CPUs]] meld trace flag -T8015 als oplossing.\\

====MSDE 2000 Release A====
Installatie MSDE 2000 Release A (=SP3a):
  * Start MSDE2000A.exe en laat het uitpakken naar bijvoorbeeld D:\Setup\MSDE.
  * Maak vervolgens in D:\Setup\MSDE\ een install.cmd aan met de juiste setup.exe parameters. Een voorbeeld voor een installatie met instancenaam MSDESP3a, benaderbaar via het netwerk, mixed mode authenticatie, datadir D:\Data\MSSQL#E2000SP3a (laatste directory maakt setup zelf aan) en installatiemap D:\MSDE2000\E2000SP3a\Binn (laatste twee directories zet setup er zelf achter bij named instance) ziet er zo uit:
<code dos>
D:\Setup\MSDE\setup.exe SAPWD="password" INSTANCENAME="E2000SP3a" DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL DATADIR=D:\Data\ TARGETDIR="D:\MSDE2000\"
</code>

Mocht je meer dan één instance willen installeren, kopieer dan bovenstaande regel en pas INSTANCENAME aan.

Mocht je tegen de melding "Please go to the Control Panel to install and configure system components." aanlopen, zorg dan dat het volledige pad naar setup.exe is vermeld in install.cmd of dat je 'm dubbelklikt vanuit explorer in de D:\Setup\MSDE\ directory. Zie ook:[[http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21607778.html|Experts Exchange - MSDE SQL Server Questions]].

Bij een instancenaam van 2000SP3a liep ik tegen de melding "The instance name specified is invalid." aan, na aanpassen instancenaam naar E2000SP3a liep de setup wel door.

====SQL 2005 Client Tools and SSMS====

The following commands can be executed to install the SQL 2005 Client Tools and SQL Server Management Studio. \\

Install
<code>
setup.exe /qb ADDLOCAL=Client_Components,Connectivity,SQLXML,SQL_Tools90
</code>

Repair
<code>
setup.exe /qb REPAIR=Client_Components,Connectivity,SQLXML,SQL_Tools90
</code>

Uninstall
<code>
setup.exe /qn REMOVE=Client_Components,Connectivity,SQLXML,SQL_Tools90
</code>

====SQL Server 2005 SP1 Installation for Client Tools====

The following options can be used when updating the SQL 2005 SP1 Client Toos and SSMS installation.

Install (x86-English)
<code>
SQLServer2005SP1-KB913090-x86-ENU.exe /quiet
</code>

Report Only Option (To see what installed components will be upgraded)
<code>
SQLServer2005SP1-KB913090-x86-ENU.exe /reportonly
</code>

Installation Log is located in %SystemRoot%\hotfix and are labled hotfix.log and hotfixX.log where X is the next incremented number.

====SP2 for SQL Server 2005====
Commando: \\
SQLServer2005SP2-KB921896-x86-ENU.exe met hierachter de volgende opties: \\

^Command^Function^
|/?|Displays Help dialog.|
|/quiet|Runs Setup in quiet mode.|
|/reportonly|Displays the features that the package can update.|
|/allinstances|Upgrades all SQL Server instances and all shared components.|
|/instancename|Upgrades a specific SQL Server instance and all shared components.|
|/sapwd|Password for the SQL Server sa account to run scripts.|
|/user|User account for connecting to a remote cluster node.|
|/password|Password for user account for connecting to a remote cluster node.|
|/rsupgradedatabaseaccount|User account for upgrading Reporting Services.|
|/rsupgradepassword|Password for user account for upgrading Reporting Services.|
|/rsupgradedatabase|Prevents the Reporting Services database from being upgraded when the parameter equals 0.|

For more information, see the 'Installing from the Command Prompt (Hotfix)' Help topic. \\

Om SP2 silent te installeren: \\
<code>
SQLServer2005SP2-KB921896-x86-ENU.exe /quiet /allinstances
</code>
Met alleen /quiet installeerde de SP2 update bij mij niet op een installatie van SQL Server 2005 Developer Edition.

====Cumulative Update installation fails on SQL Server 2008 R2=====

Scenario: \\
Installing SQL Server 2008 R2 SP2 CU3 on two named SQL Server 2008 R2 SP2 instances fails. \\
The detailed setup log files mention the following: 

> 2012-12-12 16:47:29 Slp: Error: Action "Microsoft.SqlServer.Configuration.ScoExtension.VerifiedCopyFileAction" threw an exception during execution.
> 2012-12-12 16:47:29 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: File d:\Microsoft SQL Server\MSSQL10_50.SQL2008R2\MSSQL\Binn\DllTmp64\sqlagentctr100.dll could not be copied to file path C:\Windows\system32\perf-MSSQL10_50.SQL2008R2-sqlagtctr.dll. ---> Microsoft.SqlServer.Configuration.ScoExtension.CopyFileException: File d:\Microsoft SQL Server\MSSQL10_50.SQL2008R2\MSSQL\Binn\DllTmp64\sqlagentctr100.dll could not be copied to file path C:\Windows\system32\perf-MSSQL10_50.SQL2008R2-sqlagtctr.dll. ---> Microsoft.SqlServer.Configuration.Sco.ScoException: The process cannot access the file 'C:\Windows\system32\perf-MSSQL10_50.SQL2008R2-sqlagtctr.dll' because it is being used by another process. ---> System.IO.IOException: The process cannot access the file 'C:\Windows\system32\perf-MSSQL10_50.SQL2008R2-sqlagtctr.dll' because it is being used by another process.

> 2012-12-12 16:47:34 Slp: Error: Action "AgentPatch_AgentPatching_Cpu64" failed during execution.
> 2012-12-12 16:47:34 Slp: Completed Action: AgentPatch_AgentPatching_Cpu64, returned False

> 2012-12-12 16:48:29 Slp: Error result: -2058354685
> 2012-12-12 16:48:29 Slp: Result facility code: 1360
> 2012-12-12 16:48:29 Slp: Result error code: 3

Workaround:
  - Rename the file by executing the following in an (elevated) command prompt: <code>REN C:\Windows\system32\perf-MSSQL10_50*-sqlagtctr.dll perf-MSSQL10_50*-sqlagtctr.dll.old</code>
  - Rerun the Cumulative Update installer.

Sources: \\
[[http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/f63ae703-1d0c-4692-8770-3171b63dfccf|SQL Server Developer Center > SQL Server Forums >  SQL Server Setup & Upgrade >  Failed install of CU7 for SQL Server 2008 R2 SP1]] \\
[[http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/c7192e88-eb2e-4167-a0a1-bcf18871046c|SQL Server Developer Center > SQL Server Forums >  SQL Server Setup & Upgrade >  SQL 2008 R2 repair error]] \\
[[http://connect.microsoft.com/SQLServer/feedback/details/576412/-the-process-cannot-access-the-file-c-windows-syswow64-perf-mssql10-50-mssqlserver-sqlagtctr-dll-because-it-is-being-used-by-another-process|Microsoft Connect - The process cannot access the file 'C:\Windows\SysWOW64\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll' because it is being used by another process]]. The page mentions that it should be fixed starting with SQL Server 2008 R2 SP1 CU10 and SQL Server 2008 R2 SP2 CU4. \\

=====Installatie SQL Server 2005 en 4 x 6-core CPU's=====
[[http://support.microsoft.com/kb/954835/en-us|KB954835 - On a computer that has a multicore processor, if the ratio of the logical processors to the physical sockets is not divisible by two, you cannot install SQL Server 2005]] \\ 

Dit probleem onlangs ondervonden op een IMB x3850 M2 met 4 x een 6-core Xeon. Deze machine had effectief 24 cores, dit is deelbaar door 2, dus de inhoud van KB954835 zou niet van toepassing moeten zijn op deze situatie, maar de oplossing voor en de symptomen van dit probleem waren dat wel. \\ 

Ik probeerde SQL Server 2005 x64 Enterprise op een Windows Server 2003 x64 Enterprise editie op deze x3850 M2 te installeren en liep tegen hetzelfde probleem aan waarbij de SQL Server service niet wilde starten en setup de melding "The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually"" gaf met een Retry en Cancel knop. Klikken op Retry gaf weer dezelfde melding en klikken op Cancel rolde de installatie van het SQL Server service gedeelte terug waardoor je met een onvolledige installatie kwam te zitten. \\ 

Uiteindelijk de machine opnieuw geinstalleerd en via msconfig de processoren beperkt tot 1. Hierna kon de installatie van SQL Server 2005 uitgevoerd worden en daarna SP3 voor SQL Server 2005. Vervolgens via msconfig de standaard startup opties hersteld en na een herstart draaide SQL Server 2005 SP3 op de 24 cores.\\

Hieronder een drietal van de bijbehorende meldingen in het event log: \\

<code>
Event Type:	Error
Event Source:	Application Error
Event Category:	(100)
Event ID:	1000
Date:		2/16/2009
Time:		3:57:21 PM
User:		N/A
Computer:	MACHINE01
Description:
Faulting application sqlservr.exe, version 2005.90.1399.0, faulting module sqlservr.exe, version 2005.90.1399.0, fault address 0x0000000000b323f0.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 70 70 6c 69 63 61 74   Applicat
0008: 69 6f 6e 20 46 61 69 6c   ion Fail
0010: 75 72 65 20 20 73 71 6c   ure  sql
0018: 73 65 72 76 72 2e 65 78   servr.ex
0020: 65 20 32 30 30 35 2e 39   e 2005.9
0028: 30 2e 31 33 39 39 2e 30   0.1399.0
0030: 20 69 6e 20 73 71 6c 73    in sqls
0038: 65 72 76 72 2e 65 78 65   ervr.exe
0040: 20 32 30 30 35 2e 39 30    2005.90
0048: 2e 31 33 39 39 2e 30 20   .1399.0 
0050: 61 74 20 6f 66 66 73 65   at offse
0058: 74 20 30 30 30 30 30 30   t 000000
0060: 30 30 30 30 62 33 32 33   0000b323
0068: 66 30                     f0      
</code>

<code>
Event Type:	Information
Event Source:	DrWatson
Event Category:	None
Event ID:	4097
Date:		2/16/2009
Time:		3:57:22 PM
User:		N/A
Computer:	MACHINE01
Description:
The application, D:\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe, generated an application error The error occurred on 02/16/2009 @ 15:57:21.979 The exception generated was c0000005 at address 0000000001B323F0 (sqlservr!DmpGetClientExport)
</code>

<code>
Event Type:	Error
Event Source:	MsiInstaller
Event Category:	None
Event ID:	10005
Date:		2/16/2009
Time:		4:01:37 PM
User:		MACHINE01\Administrator
Computer:	MACHINE01
Description:
Product: Microsoft SQL Server 2005 (64-bit) -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is  (1053) The service did not respond to the start or control request in a timely fashion.
.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 37 39 46 31 42 36 35   {79F1B65
0008: 45 2d 38 46 43 30 2d 34   E-8FC0-4
0010: 44 30 33 2d 39 35 34 44   D03-954D
0018: 2d 46 39 45 37 31 43 38   -F9E71C8
0020: 35 41 45 43 37 7d         5AEC7}  
</code>

=====Mirroring=====
[[http://msdn.microsoft.com/en-us/library/ms190941.aspx|MSDN - Setting Up Database Mirroring]] \\
[[http://technet.microsoft.com/nl-nl/cc984166(en-us).aspx|Microsoft TechNet - Database Mirroring FAQ]] \\
[[http://msdn.microsoft.com/en-us/library/ms151799.aspx|Microsoft TechNet - Replication and Database Mirroring]] \\
[[http://technet.microsoft.com/en-us/library/cc917680.aspx|Database Mirroring in SQL Server 2005]] \\
[[http://support.microsoft.com/kb/907741/en-us|KB907741 - Issues to consider when you use the database mirroring feature in the initial release of SQL Server 2005]] \\
[[http://social.msdn.microsoft.com/forums/en-US/sqldatabasemirroring/thread/89361e01-e2b8-4ca3-8192-c3d43731a2a2/|MSDN forums - use trace flag 1400 during startup]] \\
In de RTM release van SQL Server 2005 (voor SP1) moet trace flag -T1400 gebruikt worden om mirroring mogelijk te maken. \\
[[http://technet.microsoft.com/nl-nl/library/cc917681(en-us).aspx|Microsoft TechNet - Database Mirroring Best Practices and Performance Considerations]] voor SQL Server 2005. \\
[[http://technet.microsoft.com/nl-nl/library/cc917680(en-us).aspx|Microsoft TechNet - Database Mirroring in SQL Server 2005]] onderaan de pagina is een link naar een Word document met dezelfde inhoud. \\
[[http://deepakrangarajan.blogspot.com/2007/12/database-mirroring-errors.html|Phoenix - Database Mirroring Errors]] \\
[[http://sqlcat.com/technicalnotes/archive/2010/02/10/mirroring-a-large-number-of-databases-in-a-single-sql-server-instance.aspx|SQLCAT - Mirroring a Large Number of Databases in a Single SQL Server Instance]] \\
[[http://blogs.msdn.com/b/sqlblog/archive/2011/08/24/setting-up-database-mirroring-with-certificates.aspx|Microsoft SQL Server Support Blog - Setting up database mirroring with certificates]] \\
[[http://blogs.msdn.com/b/suhde/archive/2009/07/13/step-by-step-guide-to-configure-database-mirroring-between-sql-server-instances-in-a-workgroup.aspx|MSDN Blogs > Blogs from Suhas > Step-by-step guide to configure Database Mirroring between SQL Server Instances in a Workgroup]] \\

=====ODBC connectie naar SQL Server 2005 Express mogelijk maken=====
Ga naar **SQL Server Surface Area Configuration** en dan **Surface Area Configuration for Services and Connections**. \\
Ga vervolgens naar **SQLEXPRESS**->**Database Engine**->**Remote Connections**. Stel deze in op **Using TCP/IP only**. Herstart de **SQL Server (SQLEXPRESS)** service.\\
Ga vervolgens naar **SQL Server Browser**->**Service**, zet de startup type op **Automatic** en start de service. \\

=====I/O Requests Taking Longer Than 15 Seconds To Complete=====
[[http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/21/642314.aspx|SQL Server Storage Engine - Why are IOs taking so long?]] \\
[[http://blogs.msdn.com/chrissk/archive/2008/06/19/i-o-requests-taking-longer-than-15-seconds-to-complete-on-file.aspx|Troubleshooting Microsoft SQL Server - I/O requests taking longer than 15 seconds to complete on file]] \\
[[http://rusanu.com/2008/10/28/event-id-833-io-requests-taking-longer-than-15-seconds/|rusan consulting - Event ID 833: I/O requests taking longer than 15 seconds]] \\
[[http://www.sql-server-pro.com/i-o-requests-taking-longer-than-15-seconds-to-complete.html|SQL Server Pro - I/O Requests Taking Longer Than 15 Seconds To Complete]] \\
[[http://support.microsoft.com/kb/931279/en-us|Microsoft Support - SQL Server timing values may be incorrect when you use utilities or technologies that change CPU frequencies (KB931279)]] \\

=====Time Stamp Counter=====
[[http://blogs.msdn.com/psssql/archive/2007/08/19/sql-server-2005-rdtsc-truths-and-myths-discussed.aspx|SQL Server 2005 - RDTSC Truths and Myths Discussed]] \\
[[http://blogs.msdn.com/psssql/archive/2006/11/27/sql-server-2005-sp2-will-introduce-new-messages-to-the-error-log-related-to-timing-activities.aspx|SQL Server 2005 SP2 will introduce new messages to the error log related to timing activities.]] \\
[[http://support.microsoft.com/kb/931279|Microsoft Support - SQL Server timing values may be incorrect when you use utilities or technologies that change CPU frequencies]] \\
[[http://www.sqlpass.nl/Forum/tabid/259/forumid/18/tpage/1/view/topic/postid/119/language/nl-NL/Default.aspx#591|Subject: The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs.]] \\

=====Reporting Services=====
====Client Print====
[[http://www.kodyaz.com/articles/client-side-printing-silent-deployment-of-rsclientPrint.aspx|Kodyaz Development Resources - Reporting Services Client-Side Printing and Silent Deployment of RSClientPrint.cab ActiveX file.]] \\
[[http://blogs.msdn.com/mariae/archive/2008/12/11/unable-to-load-client-print-control-after-install-a-service-pack-or-cumulative-update-of-sql-server-2005.aspx|Maria's two cents - "Unable to load client print control" after install a Service Pack or Cumulative Update of SQL Server 2005]] zie ook:[[http://blogs.msdn.com/mariae/|Maria's two cents]]. \\
[[http://support.microsoft.com/kb/280579/en-us|Microsoft Support - How To Install ActiveX Controls in Internet Explorer Using the Active Directory]] \\
[[http://support.microsoft.com/kb/967511|Microsoft Support - Error message when you try to print a SQL Server 2005 Reporting Services report on a client computer: "Unable to load client print control"]] \\
[[http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/4a4a2239-3ac5-4f1d-8b2d-b2c5f03d3c07|MSDN Forum - Unable to load client print control]] \\

[[http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/799e7c86-1d2d-445f-9b18-687c1474e0a7|SQL Server > SQL Server Forums > SQL Server Reporting Services > Unable to load client print control sql2008 sp2]] describes that the correct updated version of RSClientPrint will not be installed with SP2 for SQL Server 2008 because they forgot to include it in the SP2 installer. A quick/good fix is suggested, namely "Install SQL server 2008 R2 on a test server and copy the cab from: ...\Reporting Services\ReportServer\bin". \\
====E-mail====
Reporting Services bied (in een AD omgeving) de optie om mail te sturen naar de alias van de gebruiker, of naar een in te vullen mailadres. \\
Als je gebruik maakt van het alias, moet er in de (Exchange) mailomgeving een mailadres bestaan met het alias en moet in RSReportServer.config de <DefaultHostName></DefaultHostName> geconfigureerd zijn.
Als je geen gebruik maakt van het alias, dan sta je de eindgebruikers toe om zelf een mailadres in te vullen, soms is dit niet een gewenste situatie. \\

Als je niet een vanaf extern mailbaar alias wil aanmaken, dan kun je er voor kiezen om alle (Exchange) mailgebruikers te voorzien van een alias@ADdomeinnaam mailadres en de volgende configuratie in RSReportServer.config te gebruiken:
<code>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName>ADdomeinnaam</DefaultHostName>
</code>
Vergeet niet om ook <SMTPServer> te configureren.

Bronnen: \\
[[http://technet.microsoft.com/en-us/library/ms159155.aspx|SQL Server 2008 Books Online (May 2009) - Configuring a Report Server for E-Mail Delivery]] \\
[[http://msdn.microsoft.com/en-us/library/ms157273.aspx|SQL Server 2008 Books Online (May 2009) - RSReportServer Configuration File]] \\
[[http://support.microsoft.com/kb/945601/en-us|Microsoft Support - SQL Server 2005 Reporting Services e-mail subscriptions do not work in Windows Vista and in Windows Server 2008 if you use aliases as e-mail addresses]] \\
[[http://www.sqlmag.com/Articles/Index.cfm?ArticleID=93771|SQL Server magazine - Self-Service Subscriptions]] bied als workaround stored procedures om achteraf de mailadressen te corrigeren in een SQL table. \\

=====Openquery/Openrowset en Active Directory(/LDAP)=====

Deze werkt:
<code tsql>
SELECT Name, displayName,givenname,distinguishedName, SAMAccountName
FROM 
OPENROWSET('ADSDSOObject','adsdatasource'; 'domain\user';'password',
'SELECT  Name, displayName,givenname,distinguishedName, SAMAccountName
    FROM ''LDAP://domainfqdn/dc=domain,dc=local''')
</code>
Dan ben je echter, met de standaard instellingen op de domain controller, beperkt tot een resultaat van maximaal 1000 regels. \\ 

De volgende statement zou dit moeten verhelpen door PageSize=10000, maar deze geeft een foutmelding:
<code tsql>
SELECT Name, displayName,givenname,distinguishedName, SAMAccountName
FROM 
OPENROWSET('ADSDSOObject','User ID=domain\user;Password=password;ADSI Flag=0x11;Page Size=10000',
'SELECT  Name, displayName,givenname,distinguishedName, SAMAccountName
    FROM ''LDAP://domainfqdn/dc=domain,dc=local''')
</code>
Bovenstaande statement geeft de volgende foutmelding:
<code>
Msg 7321, Level 16, State 2, Line 2
An error occurred while preparing the query "SELECT  Name, displayName,givenname,distinguishedName, SAMAccountName
    FROM 'LDAP://domainfqdn/dc=domain,dc=local' WHERE objectClass = 'USER'" for execution against OLE DB provider "ADSDSOObject" for linked server "(null)". 
</code>

[[http://www.fits-consulting.de/blog/PermaLink,guid,1e768aef-9ae5-4e60-9dad-2f2e73b00faa.aspx|some thoughts... - SQL Server View of AD Users or Performing a SQL Distributed Query by Using ADSI]] \\
[[http://forum.lessthandot.com/viewtopic.php?f=17&t=5104|LessThanDot Forum - Querying Active Directory]]
[[http://www.codeproject.com/KB/database/SQL_Server_%96_Active_Direc.aspx|The Code Project - SQL Server –Active Directory Interaction]] \\
[[http://www.databasejournal.com/features/mssql/article.php/3849891/Query-Active-Directory-Data-from-SQL-Server-using-T-SQL.htm|Database Journal - Query Active Directory Data from SQL Server using T-SQL]] \\
[[http://weblaunch.nl/?p=21|weblaunch - How to run a SSRS report showing the data in the Global Address List]] \\
[[http://codebetter.com/blogs/brendan.tompkins/archive/2003/12/19/4746.aspx|CodeBetter.com Blogs - Brendan Tompkins - Create a SQL Server View of your AD Users]] \\
[[http://www.rlmueller.net/SQLDistributedQuery.htm|Hilltop Lab - SQL Distributed Queries]] \\
[[http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=93097|SQLTeam.com Forums - querying active directory through openquery]] \\
[[http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=144082|SQLTeam.com Forums - OPENROWSET with ADsDSOObject]] \\
[[http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic15653.aspx|sql newgroups - Active Directory Linked Server Fails After Upgrade to SQL Server 2]] \\

[[http://support.microsoft.com/kb/299410/en-us|Microsoft Support - Performing a SQL distributed query by using ADSI (KB299410)]] \\
[[http://msdn.microsoft.com/en-us/library/ms681571(VS.85).aspx|MSDN - Microsoft OLE DB Provider for Microsoft Active Directory Service]] \\

"It is my understanding that the OLEDB provider for Microsoft Directory Services doesn't expose the page size property....I'm pretty sure I've seen this logged as a feature request on MS connect before but it might not hurt to log it again" aldus Tommy Bollhofer op 
[[http://www.sqlservercentral.com/Forums/Topic831764-149-1.aspx#bm831870|SQL ServerCentral.com Forum - ADSI, OpenRowset and Page Size]] \\

"Based on my research, OLEDB Command object does not expose the property "Page Size". A possible workaround is to use ADODB in our .NET project, instead of using OLEDB." aldus Jialiang Ge op [[http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/e483c098-b2c1-4037-b9fb-3c882f3b14c4|MSDN Visual Basic Developer Center - Forums - How to query Active Directory with OLEDB and get over the 1000 rows limi]] \\


=====Connection is busy with results for another hstmt=====
With the standard SQL Server driver on an ODBC data source, you can only have one active cursor at a time. When the program using the ODBC data source tries to open a second cursor when the previous one hasn't been neatly closed, you get the "Connection is busy with results for another hstmt" error.

If the SQL Native Client driver from SQL Server 2005 is supported by the application you could work around the problem by replacing the ODBC data source with the SQL Server driver by one that uses the SQL Native Client driver and setting MARS to enabled. To create such an ODBC data source use the following command:

On a 32-bit system running a 32-bit program or a 64-bit system running a 64-bit program:
<code>
"%systemroot%\system32\odbcconf.exe" /a {CONFIGSYSDSN "SQL Native Client" "DSN=datasourcename|Description=fill in description|SERVER=Servername\instancename|Trusted_Connection=no|Database=databasename|MARS_Connection=yes"}
</code>

On a 64-bit system running a 32-bit program:
<code>
"%systemroot%\syswow64\odbcconf.exe" /a {CONFIGSYSDSN "SQL Native Client" "DSN=datasourcename|Description=fill in description|SERVER=Servername\instancename|Trusted_Connection=no|Database=databasename|MARS_Connection=yes"}
</code>

Or add the "MARS_Connection, REG_SZ, yes" setting to the registry key for the ODBC data source below HKLM\SOFTWARE\ODBC\ODBC.INI\DATASOURCENAME or HKCU\Software\ODBC\ODBC.INI\DATASOURCENAME if it already uses the SQL Native Client driver.

[[http://dbaspot.com/forums/sqlserver-odbc/185468-connection-busy-results-another-hstmt.html|Dba Spot - Connection is busy with results for another hstmt - sqlserver-odbc]] \\
[[http://www.phwinfo.com/forum/ms-sqlserver-server/369319-how-fix-error-connection-busy-results-another-hstmt.html|PHWinfo - how to fix error "Connection is busy with results for another hstmt"]] \\
[[http://sourceitsoftware.blogspot.com/2008/06/connection-is-busy-with-results-for.html|Coding With The Enemy - Thursday, June 12, 2008
" Connection is busy with results for another hstmt"]] \\
[[http://blogs.msdn.com/b/dataaccess/archive/2005/08/02/446894.aspx|MSDN Blogs > Data Access blog > Using MARS with SQL Native Client [Chris Lee]]] \\
[[http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/thread/1647d29f-1007-4d25-9f0d-1457e7c630a1/|SQL Server Developer Center > SQL Server Forums > SQL Server Data Access > Connection is busy with results for another hstmt]] \\
=====Firewall exceptions=====
To enable remote connections to SQL Server and any named instances open the following ports in the firewall:
|Default Instance|tcp 1433|
|SQL Server Browser|udp 1434|
|SQL Server Analysis Services|tcp 2382|

Sources: \\
[[http://blogs.msdn.com/b/karang/archive/2009/09/05/sql-server-analysis-services-port-sql-2005-2008.aspx|MSDN Blogs > SQL BI > SQL Server Analysis Services Port (SQL 2005 / 2008)]] \\
====Named instance====
To open the correct tcp port for a SQL Server named instance, do the following: \\ 
Open SQL Server Configuration Manager, go to "SQL Server Network Configuration" rightclick on TCP/IP below "Protocols for instancename" and select properties. On the IP Addresses tab take note of the value for "TCP Dynamic Ports" and open that tcp port in the firewall.|

=====SQL 2008 R2 Max Memory=====
Max 64 GB of memory for SQL Server 2008 R2 Standard.

This seems to be per instance:

<file>
Posted by Robert on 6 April 2011
Glenn,

Regarding the max server memory for SQL 2008 R2, it looks like Standard Edition can utilize 64GB. Do you know if this is 64GB per server or per instance? For example, if I have a server with 96GB of memory and two SQL instances, could I set max server memory to 45GB on each instance or would I need to set it to 32GB on each instance?

Robert

Posted by Glenn Berry on 6 April 2011
Robert,

That 64GB limit for SQL Server 2008 R2 Standard Edition is per instance. You could go 45GB per instance, or you might decide to favor one instance over the other, depnding on the relative workloads.
</file>
Source: [[http://www.sqlservercentral.com/blogs/glennberry/2011/02/25/some-suggested-sql-server-2008-r2-instance-configuration-settings/|Glenn Berry's SQL Server Performance - Some Suggested SQL Server 2008 R2 Instance Configuration Settings]] \\
See also: [[http://serverfault.com/questions/230862/sql-server-2008-r2-memory-limit-per-instance-or-server|Server Fault - SQL Server 2008 R2 memory limit per instance or server?]] \\

=====Database versioning=====
[[http://www.codeproject.com/Articles/42958/Automatic-Script-SQL-Server-2005-Objects-and-Commi|CodeProject - Automatic Script SQL Server 2005 Objects and Commit under Subversion]] \\
[[http://blog.boxedbits.com/archives/133|All about Business Intelligence - Synchronize a SQL Server Database with an SVN Repository]] \\

=====Can't delete SQL Agent Job for Maintenance Plan=====

While trying to delete a SQL Agent job in SQL Server 2005 for a maintenance plan (that no longer exists) you receive the following error:
<file>
TITLE: Microsoft SQL Server Management Studio
------------------------------

Drop failed for Job 'MaintenancePlan.Subplan_1'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.5000.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+Job&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The DELETE statement conflicted with the REFERENCE constraint "FK_subplan_job_id". The conflict occurred in database "msdb", table "dbo.sysmaintplan_subplans", column 'job_id'.
The statement has been terminated. (Microsoft SQL Server, Error: 547)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.5000&EvtSrc=MSSQLServer&EvtID=547&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
</file>

The following script should fix it:

<code>
USE [msdb]
 declare @job_name varchar(100)
 set @job_name = N'MaintenancePlan.Subplan_1'


--First, delete the logs for the plan

 delete sysmaintplan_log
 FROM sysmaintplan_subplans AS subplans INNER JOIN
 sysjobs_view AS syjobs ON subplans.job_id = syjobs.job_id INNER JOIN
 sysmaintplan_log ON subplans.subplan_id = sysmaintplan_log.subplan_id
 WHERE (syjobs.name = @job_name)


--delete the subplan

 delete sysmaintplan_subplans
 FROM sysmaintplan_subplans AS subplans INNER JOIN
 sysjobs_view AS syjobs ON subplans.job_id = syjobs.job_id
 WHERE (syjobs.name = @job_name)


--delete the actual job (You can do the same thing through Management Studio (Enterprise Manager)

 delete
 from msdb.dbo.sysjobs_view where name = @job_name

</code>
Source:[[http://web.archive.org/web/20110108122558/http://gudenas.com/2007/04/20/sql-server-2005-delete-maintenance-plan-error/|Archive.org - Gediminas (Gedas) Gudenas - Sql Server 2005 Delete Maintenance Plan Error]], [[http://gudenas.com/2007/04/20/sql-server-2005-delete-maintenance-plan-error|original link]], [[http://www.tech-forums.net/forums/f57/delete-sql-maintenance-plan-210902/|via]]  \\

=====Event ID 28005=====
The full event log item:
<code>
Log Name:      Application
Source:        MSSQLSERVER
Date:          26-6-2013 12:50:55
Event ID:      28005
Task Category: (2)
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      server.domain.local
Description:
An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 11. Could not obtain information about Windows NT group/user 'DOMAIN\username', error code 0x534.
</code>
This occurs because a database owner is set to a certain domain account, but SQL Server can't get the account properties (SID) of that account.

The workaround is to check which database has the DOMAIN\username as owner and set the database owner for that database to sa:
<code tsql>
USE databasename
GO
EXEC sp_changedbowner 'sa'
GO
</code>

Sources: \\
[[http://ddkonline.blogspot.fr/2011/07/fix-for-sql-2008-exception-20-items.html|David Klein's Corner - Fix for SQL 2008 Exception - An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 19. Could not obtain information about Windows NT group/user 'DOMAIN\username', error code 0x5]] \\
[[http://dev.ektron.com/kb_article.aspx?id=30764|Ektron Devcenter - PROBLEM:Notifications not updated in Activity Stream]] \\
[[http://www.geekproject.com/showtopic.aspx?ID=77|geekProject.com - Change authorization to ease SQL Server development]] \\
[[http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=122295|SQLTeam Forums - SQL Error 15404: Could not obtain information...]] \\

=====Permissions=====
[[http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.serverpermissionset_properties.aspx|MSDN - ServerPermissionSet Properties]] \\
[[http://msdn.microsoft.com/en-us/library/ms178569.aspx|MSDN - GRANT Database Permissions (Transact-SQL)]] \\
[[http://www.sqlbackuprestore.com/backupandrestorerights.htm|SQLBackupRestore.com - Backup rights]] \\
[[http://msdn.microsoft.com/en-us/library/ee677610.aspx|MSDN - CREATE SERVER ROLE (Transact-SQL)]] \\
[[http://msdn.microsoft.com/en-us/library/ms187936.aspx|MSDN - CREATE ROLE (Transact-SQL)]] \\

=====Event ID 18456 - Login failed - Token-based server access validation failed=====
[[http://blogs.technet.com/b/the_9z_by_chris_davis/archive/2014/02/21/sql-event-id-18456-login-failed-for-user-reason-token-based-server-access-validation-failed.aspx|TechNet Blogs »  The 9z, by Chris Davis »  SQL Event ID 18456: Login failed for user Reason: Token-based server access validation failed]] \\
[[http://www.sblackler.net/2012/05/30/sql-server-fix-token-based-server-access-validation/|Stuart Blackler - SQL SERVER Fix - Token-based server access validation failed with an infrastructure error]] \\