SelectEtoile : Base de connaissance SGBD

Posts Tagged 'lien'

Les liens pratiques de SQL Server

Cet article contient une liste de sites web pratiques pour l'administration SQLServer

 

Les docs Microsoft SQLServer

Les vidéos microsoft : http://technet.microsoft.com/en-us/sqlserver/ff977043.aspx

 

Gestion du journal de log

Log Management :
http://www.sqlservercentral.com/articles/Stairway+Series/94552/
http://www.sqlservercentral.com/articles/Transaction+Logs/71415/

Log Tuning : http://www.simple-talk.com/sql/database-administration/sql-server-transaction-log-fragmentation-a-primer/

 

Monitoring :

SQLServer Creation d'une alerte/montoring SQLServer : http://www.sqlservercentral.com/articles/SQL+Monitoring/100615/

 

Les partitions

Gestion des partitions : http://www.simple-talk.com/content/article.aspx?article=1587

Ex d'un switch et split de partition : http://blogs.msdn.com/b/sql_pfe_blog/archive/2013/08/13/oops-i-forgot-to-leave-an-empty-sql-table-partition-how-can-i-split-it-with-minimal-io-impact.aspx

 

Les indexes

https://www.simple-talk.com/sql/performance/14-sql-server-indexing-questions-you-were-too-shy-to-ask/?utm_source=ssc&utm_medium=publink&utm_content=indexingquestions

 

Trace Profiler

Mise en place de trace profiler sous SQL SERVER : http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm

 

AlwaysOn :

http://blogs.msdn.com/b/sqlcat/archive/2014/02/03/alwayson-availability-groups-listener-named-instances-port-numbers-etc.aspx

 

Performances Monitoring :

http://www.databasejournal.com/features/mssql/article.php/3932406/Top-10-SQL-Server-Counters-for-Monitoring-SQL-Server-Performance.htm

http://www.mssqltips.com/sqlservertip/2393/determine-sql-server-memory-use-by-database-and-object/

https://www.simple-talk.com/sql/database-administration/baselining-with-sql-server-dynamic-management-views/

https://www.simple-talk.com/sql/database-administration/eight-steps-to-effective-sql-server-monitoring/

 

Pratique

Comment regrouper un RTM et un SP2 sous SQLServer 2008 (slipstream) : http://blogs.msdn.com/b/petersad/archive/2010/10/14/creating-a-merged-slipstream-drop-containing-sql-server-2008-rtm-and-service-pack-2.aspx

Faire de la pagination sous SQLServer : http://www.databasejournal.com/features/mssql/paging-data-with-tsql.html

 

Change Data Capture

http://www.databasejournal.com/features/mssql/getting-starting-with-change-data-capture-cdc-in-sql-server-part-1.html

Les deadlocks

Surveiller les deadlocks : http://www.opsvault.com/how-to-monitor-deadlocks-in-sql-server/

Des exemples tres detaillés : https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/?utm_source=ssc&utm_medium=publink&utm_campaign=simpletalk&utm_term=additionalarticle

 

Tout sur la base tempdb :

tempdb contention : http://www.sqlservercentral.com/blogs/robert_davis/2010/03/05/Breaking-Down-TempDB-Contention/

 

Hashage / Cryptage :

http://blog.developpez.com/sqlpro/p12496/langage-sql-norme/hachage-nest-pas-cryptage-de-la-securite-des-donnees-chiffrees-dans-les-sgbdr

 

Encryption / Chiffrement...

http://www.dbi-services.com/index.php/blog/entry/transparent-data-encryption-key-management-and-backup-strategies

 

Les traceflags :

Les traceflag sous SQLServer : http://www.sqlservercentral.com/articles/trace+flags/70131/

 

Sauvegarde et restauration

Backup / restore avec powershell : https://www.simple-talk.com/content/article.aspx?article=1802

 

SQLServer 2014 :

New Features : http://www.databasejournal.com/features/mssql/whats-new-with-sql-server-2014.html

AlwaysOn 2014 : http://blogs.technet.com/b/dataplatforminsider/archive/2013/06/27/alwayson-in-sql-server-2014-ctp1.aspx

 

Performances sur les disques :

SSD : http://henkvandervalk.com/maximizing-sql-server-2008-r2-table-scan-speed-from-dsi-solid-state-storage

Tester ces io : https://www.simple-talk.com/sql/database-administration/the-sql-server-sqliosim-utility/

 

Hekaton :

Procedure stockée en code natif : http://msdn.microsoft.com/fr-fr/library/dn424864.aspx

gestion des tables Hekaton : http://conseilit.wordpress.com/2013/07/01/sql-server-2014base-de-donnes-et-premire-table-hekaton/

http://blog.developpez.com/mikedavem/p12490/sql-server-2014/tables-in-memory-indexes-hash-et-paramtrage-du-nombre-de-buckets

 

Perfs et tuning :

Parameter sniffing : http://www.sqlservercentral.com/articles/Parameter+Sniffing/98481/


Gestion des licences

http://www.sqlservercentral.com/articles/108317/

http://conseilit.wordpress.com/2011/11/04/licences-sql-server-2012/
http://blogs.msdn.com/b/editeurs_de_logiciels/archive/2013/10/30/licensing-comprendre-le-mode-de-fonctionnement-des-licences-sql-server-2012.aspx

 http://conseilit.wordpress.com/2011/11/04/licences-sql-server-2012/

 

Quelques outils utiles

SQL Query Stress :

http://www.mssqltips.com/sqlservertip/2730/sql-query-stress-tool/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=2012717

 

 

http://sqlquerystress.software.informer.com/download/

 

 

Quelques exemples pratiques de code SQL sous SQLServer :

Les fonction window in :

https://www.simple-talk.com/sql/t-sql-programming/window-functions-in-sql/

https://www.simple-talk.com/content/article.aspx?article=1927

 

Des scripts SQL et powershell :

http://gallery.technet.microsoft.com/scriptcenter/site/search?f[0].Type=RootCategory&f[0].Value=databases&f[0].Text=Databases&f[1].Type=SubCategory&f[1].Value=sqlserver&f[1].Text=SQL%20Server

 

Les sites et blogs utiles :

http://thesqlagentman.com/

http://drsql.org

http://www.simple-talk.com/

http://thomaslarock.com/

http://dba.stackexchange.com/

http://brentozar.com

http://www.scarydba.com/