THE FOLLOWING URL ARE VERY USEFUL FOR SQL DEVELOPERS & DBA
DBA Papers:
DBA Papers:
http://rjssqlservernotes.wordpress.com/papers/
http://www.mssqltips.com/whitepaper.asp
WHITE PAPER:
http://www.mssqltips.com/whitepaperlist.asp
DBA BOOK:
http://sqlserverpedia.com/wiki/Database_Administration
SQL SERVER –
SHRINKDATABASE For Every Database in the SQL Server
http://blog.sqlauthority.com/2010/08/12/sql-server-shrinkdatabase-for-every-database-in-the-sql-server/
QUERY
PERCENTAGE COMPLETED
http://www.sqldbops.com/2011/01/sql-server-process-completion-in.html
How to
Identify Slow Running Queries with SQL Profiler
http://www.simple-talk.com/sql/performance/how-to-identify-slow-running-queries-with-sql-profiler/
Windows
Server 2003 Performance Monitor - Getting Started
http://www.computerperformance.co.uk/HealthCheck/GettingStarted.htm
DMV: List of
DMV in SQL Server 2005 and 2008
http://www.ravikhanal.com/list-of-dmv-in-sql-server-2005-and-2008/
Performance
Monitoring with Dynamic Management Views:
http://www.sqlservercentral.com/articles/Performance+Tuning/71784/
SQL SERVER –
2005 – Last Ran Query – Recently Ran Query
http://blog.sqlauthority.com/2008/01/03/sql-server-2005-last-ran-query-recently-ran-query/
http://blog.sqlauthority.com/2007/08/28/sql-server-actual-execution-plan-vs-estimated-execution-plan/
Execution
Plan – Estimated I/O Cost – Estimated CPU Cost – No Unit
http://blog.sqlauthority.com/2010/01/22/sql-server-execution-plan-estimated-io-cost-estimated-cpu-cost-no-unit/
http://www.simple-talk.com/sql/performance/execution-plan-basics/
http://www.simple-talk.com/content/article.aspx?article=504
SQL SERVER –
2005 – Introduction and Explanation to
SYNONYM – Helpful T-SQL Feature for Developer
http://blog.sqlauthority.com/2008/01/07/sql-server-2005-introduction-and-explanation-to-synonym-helpful-t-sql-feature-for-developer/
SQL SERVER –
Importance of Database Schemas in SQL Server
http://blog.sqlauthority.com/2009/09/07/sql-server-importance-of-database-schemas-in-sql-server/
TABLE
PARTITION:
http://www.mssqltips.com/sqlservertip/1796/creating-a-table-with-horizontal-partitioning-in-sql-server/
http://blogs.msdn.com/b/craigfr/archive/2008/07/15/partitioned-tables-in-sql-server-2008.aspx
http://www.sqlservercentral.com/articles/partition/64740/
http://blogs.msdn.com/b/manisblog/archive/2009/01/18/easy-table-partitions-with-sql-server-2008.aspx
http://blog.sqlauthority.com/2008/01/24/sql-server-2005-introduction-to-partitioning/
http://msdn.microsoft.com/en-us/library/ms345146.aspx
http://technet.microsoft.com/en-us/library/dd578580(SQL.100).aspx
PROFILER
http://blog.sqlauthority.com/2009/08/03/sql-server-introduction-to-sql-server-2008-profiler-2/
http://bradmcgehee.com/wp-content/uploads/presentations/Down%20Under--Getting%20the%20Most%20Out%20of%20the%20SQL%20Server%202005_2008%20Profiler.pdf
LOCKS IN SQL
SERVER:
http://blogs.technet.com/b/josebda/archive/2009/03/19/sql-server-2008-locking.aspx
Resource
Governor in SQL Server 2008
http://www.sql-server-performance.com/articles/per/Resource_Governor_in_SQL_Server_2008_p1.aspx
http://www.sqlservercentral.com/articles/Resource+Governor/64034/
http://blog.sqlauthority.com/2009/07/18/sqlauthority-news-whitepaper-using-the-resource-governor/
See SQL
Server graphical execution plans in action
http://www.techrepublic.com/blog/datacenter/see-sql-server-graphical-execution-plans-in-action/198
http://www.techrepublic.com/blog/datacenter/see-sql-server-graphical-execution-plans-in-action/198?tag=rbxccnbtr1
http://www.techrepublic.com/blog/datacenter/optimize-sql-server-queries-with-these-advanced-tuning-techniques/179
http://blog.sqlauthority.com/2007/08/28/sql-server-actual-execution-plan-vs-estimated-execution-plan/
Ranking
Functions: RANK, DENSE_RANK, and NTILE
http://blogs.msdn.com/b/craigfr/archive/2008/03/31/ranking-functions-rank-dense-rank-and-ntile.aspx
LOG SHIPPING
VS REPLICATION VS MIRRORING
http://www.sqlservercentral.com/articles/replication/logshippingvsreplication/1399/
http://mssqltips.com/tip.asp?tip=2301
http://social.msdn.microsoft.com/forums/en-US/sqldatabasemirroring/thread/ee05954e-0934-4305-8936-b9226e231d06/
BEGIN TRY..
END TRY
http://www.eggheadcafe.com/tutorials/aspnet/6a8ef7d5-840e-4629-b53a-1a40e7db601f/using-try--catch-to-roll.aspx
JOINS:
http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/
DDL Triggers
in SQL Server - audit database objects
http://www.sqldbatips.com/showarticle.asp?ID=134
http://decipherinfosys.wordpress.com/2008/05/22/sql-server-audit-in-sql-server-2008/
http://www.sqlbook.com/SQL-Server/DDL-Triggers-in-SQL-Server-34.aspx
http://www.sqldbatips.com/showarticle.asp?ID=136
CREATE / ALTER / DROP
http://www.sqlbook.com/SQL-Server/DDL-Triggers-in-SQL-Server-34.aspx
CDC
http://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-%28cdc%29-in-sql-server-2008/
http://msdn.microsoft.com/en-us/library/dd266396(v=sql.100).aspx
http://blog.sqlauthority.com/2009/10/28/sql-server-tuning-the-performance-of-change-data-capture-in-sql-server-2008/
http://www.infosys.com/microsoft/resource-center/documents/change-data-capture.pdf
CURSOR:
http://www.mssqltips.com/tip.asp?tip=1599
EXEC DBO.DECRYPTSP2K ''
SQL SERVER –
Query to find number Rows, Columns, ByteSize for each table in the current
database – Find Biggest Table in Database
http://blog.sqlauthority.com/2007/01/10/sql-server-query-to-find-number-rows-columns-bytesize-for-each-table-in-the-current-database-find-biggest-table-in-database/
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/03/10/how-to-create-a-corrupt-database-using-bulk-insert-update-and-bcp-sql-server-as-a-hex-editor.aspx
BULK INSERT
http://bytes.com/topic/sql-server/answers/158756-rowterminator-bulk-insert-query
SQL SERVER –
Import CSV File Into SQL Server Using Bulk Insert – Load Comma Delimited File
Into SQL Server BULK INSERT
http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/
http://nathanbuggia.com/blog/post/Import-a-CSV-File-into-SQL-Server-BULK-INSERT.aspx
http://www.simple-talk.com/sql/t-sql-programming/reading-and-writing-files-in-sql-server-using-t-sql/
SQL BASIC
http://www.functionx.com/sqlserver/
SQL Server
2008 Memory Allotted to Queries
http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/cf170667-50a9-45f6-a6f0-ba29ac91f3ba
SQL Server 2008
features
http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx
http://www.sqllion.com/2009/04/sql-server-2005-vs-sql-server-2008/
PDF: SQL Server 2008 BI features:
http://www.infosys.com/microsoft/resource-center/documents/bi-sqlserver-2008.pdf
http://www.ringzero.ca/presentations/DoubleTrouble.SecTor.Oct08.pdf
RAID:
http://www.hds.com/assets/pdf/qa-raid-concepts-sep-12-07-webtech-session.pdf -- raid
Bulk Insert
http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/
TIPS
http://www.sql-server-performance.com/articles/dba/execute_sql_bulk_insert_tasks_ssis_p3.aspx
CREATE A csv
file from sql
http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/7ae2c91e-e354-4fad-ae6a-e6385a1ac248/
http://msdn.microsoft.com/en-us/library/ms190919(SQL.90).aspx
http://blog.sqlauthority.com/2008/01/08/sql-server-2005-export-data-from-sql-server-2005-to-microsoft-excel-datasheet/
http://www.simple-talk.com/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/
http://sqlserver2000.databases.aspfaq.com/how-do-i-prevent-linked-server-errors.html
SQL QUESTIONS
WITH ANSWER
http://blog.sqlauthority.com/2007/04/15/sql-server-interview-questions/
http://blog.sqlauthority.com/2007/04/20/sql-server-interview-questions-part-6/
SQL SERVER –
Rules for Optimizining Any Query – Best Practices for Query Optimization
http://blog.sqlauthority.com/2009/01/20/sql-server-rules-for-optimizining-any-query-best-practices-for-query-optimization/
Important
Activities:
http://sqlcat.com/top10lists/archive/2008/11/24/top-10-sql-server-2008-features-for-isv-applications-burzin.aspx
http://www.tomshardware.com/reviews/sas-hard-drives,1702.html
INDEX
http://technet.microsoft.com/en-us/library/ms172984(SQL.100).aspx
http://www.odetocode.com/Articles/70.aspx
FILTERED
INDEX
http://blog.sqlauthority.com/2008/09/01/sql-server-2008-introduction-to-filtered-index-improve-performance-with-filtered-index/
TOP 10 DBA
ACTIVITIES
http://sqlcat.com/top10lists/archive/2009/01/30/top-10-sql-server-2008-features-for-the-database-administrator-dba.aspx
http://technet.microsoft.com/en-us/magazine/2008.08.database.aspx?pr=blog
What is new
in SQL SERVER 2008
http://technet.microsoft.com/en-us/magazine/2008.04.overview.aspx?pr=blog
SQL Server
2005 Common Table Expressions
http://www.simple-talk.com/sql/t-sql-programming/sql-server-2005-common-table-expressions/
SQL Server
memory configuration
http://www.eraofdata.com/blog/2008/10/sql-server-memory-configuration/
FIND INDEXED
TABLES IN A SQL SERVER:
http://blog.sqlauthority.com/2007/05/26/sql-server-2005-find-table-without-clustered-index-find-table-with-no-primary-key/
DATABASE
DESIGN
https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395
http://www.smart-it-consulting.com/database/progress-database-design-guide/
Buffer Cache
Hit Ratio vs SQL Server: cache Mgr Cache Hit Ratio:
http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/17da8db5-b03a-4302-aed4-0c141fc17931/
http://blogs.msdn.com/slavao/archive/2005/02/11/371063.aspx
Optimizing
SQL Server CPU Performance:
DETERMINING
SERVER ACTIVITY:
http://technet.microsoft.com/en-us/magazine/2007.10.sqlcpu.aspx
Time Calc
http://www.unitconversion.org/unit_converter/time.html
SQL SERVER
2008 FEATURES:
http://www.rdacorp.com/pdf/SQL%20Server%202008%20Highlights.pdf
http://sqlserver-qa.net/blogs/perftune/default.aspx
http://sqlserver-qa.net/blogs/perftune/archive/2007/07/23/why-query-execution-timeout-happens-and-find-queries-that-have-granted-memory-or-waiting-on-memory.aspx
http://www.ibm.com/developerworks/web/library/wa-dbdsgn2.html
Starting SQL
Server in Single-User Mode:
http://msdn.microsoft.com/en-us/library/ms188236.aspx
Optimizing
DBCC CHECKDB Performance
http://msdn.microsoft.com/en-us/library/ms175515.aspx
SQL SERVER –
DBCC CHECKDB Introduction and Explanation – DBCC CHECKDB
Ebooks:
http://www.rodcolledge.com/rod_colledge/2009/02/dba-best-practices-book-available-now.html
http://www.macs.hw.ac.uk/cs/pgcourses/csm.htm
http://it-ebooks.info/book/1377/
http://download.red-gate.com/ebooks/SQL/sql-server-execution-plans.pdf
Query exe
time
http://www.bigresource.com/MYSQL-How-to-get-a-query-execution-time--fpAPU2vw.html
http://search.sqlauthority.com/
http://sqlcat.com/technicalnotes/archive/2008/04/21/tuning-the-performance-of-backup-compression-in-sql-server-2008.aspx
SQL
PERFORMANCE
BuffercatchHitRadio
= BufferMgr: performance:
http://sqlserverpedia.com/wiki/Memory_-_Performance_Counters
RAM is not
sufficient::::
http://www.ucertify.com/article/what-is-sql-server-buffer-manager-buffer-cache-hit-ratio-counter.html
Cost of
Storage - Direct Attached vs SAN
http://www.its.monash.edu.au/staff/systems/dsm/technical/cost-recovery/cost-comparison-das-san.html
http://www.sqlservercentral.com/articles/Administration/listofdatabaseuserswithdatabaseroles/1545/
Install sql
server 2008 step by step
http://msdn.microsoft.com/en-us/library/ms143219.aspx
SQL SERVER –
2008 – Step By Step Installation Guide With Images
http://blog.sqlauthority.com/2008/06/12/sql-server-2008-step-by-step-installation-guide-with-images/
http://msdn.microsoft.com/en-us/library/cc281953.aspx
Write a
question to SQL TEAM
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
CTE
http://www.simple-talk.com/sql/t-sql-programming/sql-server-2005-common-table-expressions/
RAID:
http://www.prepressure.com/library/technology/raid
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=90525
http://weblogs.sqlteam.com/billg/archive/2007/06/18/RAID-10-vs.-RAID-5-Performance.aspx
Understanding
RAID Concepts :
http://support.dell.com/support/edocs/software/svradmin/5.1/en/omss_ug/html/strcnpts.html
http://www.hds.com/assets/pdf/qa-raid-concepts-sep-12-07-webtech-session.pdf
BACKUP DB /
DB MAINTENANCE
http://www.databasedesign-resource.com/sql-server-dba.html
http://sqlcat.com/technicalnotes/archive/2008/04/21/tuning-the-performance-of-backup-compression-in-sql-server-2008.aspx
HOW many
Milliseconds per IO it took for each file in the database
move tempdb from one drive to another drive
http://blog.sqlauthority.com/2007/04/01/sql-server-tempdb-is-full-move-tempdb-from-one-drive-to-another-drive/
For moving
system databases, a few extra steps here:
http://support.microsoft.com/kb/224071
Lostest
running qry:
http://blog.sqlauthority.com/2009/01/23/sql-server-2008-2005-find-longest-running-query-tsql-part-2/
QUERIES:
http://www.sqlusa.com/bestpractices2005/collatedatabasedefault/
SHRINK DB:
http://technet.microsoft.com/en-us/library/ms190488(SQL.90).aspx
http://www.karaszi.com/sqlserver/info_dont_shrink.asp
SQL SERVER –
Generate A Single Random Number for Range
of Rows of Any Table –
Very interesting Question from Reader
http://blog.sqlauthority.com/2009/01/28/sql-server-generate-a-single-random-number-for-range-of-rows-of-any-table-very-interesting-question-from-reader/
LOGIN
SECURITY PERMISSION - SQL Server Security: Server Roles
DATABASE-LEVEL
ROLE NAME:
http://technet.microsoft.com/en-us/library/ms189121.aspx
http://www.sqlservercentral.com/articles/Administration/sqlserversecurityfixedroles/1163/
http://forums.asp.net/t/1002764.aspx
BULK INSERT
PERMISSION - Adding a Member to a Predefined Role
http://msdn.microsoft.com/en-us/library/aa905184(SQL.80).aspx
Query tuning
and Performance
http://msdn.microsoft.com/en-us/library/aa178391(SQL.80).aspx
SQL Server
2008: The New Data Types
http://www.simple-talk.com/sql/learn-sql-server/sql-server-2008-the-new-data-types/
DB Recovery
Model - Recovery Model Overview DB Properties
http://msdn.microsoft.com/en-us/library/ms189275.aspx
BD2 vs. SQL
SERVER
http://www.mssqlcity.com/Articles/Compare/sql_server_vs_db2.htm
INTERVIEW
QUESTIONS:
http://www.brentozar.com/archive/2009/06/top-10-developer-interview-questions-about-sql-server/
SQL Server
2008 Recovery Models and Backups
http://www.databasejournal.com/features/mssql/article.php/3782401/SQL-Server-2008-Recovery-Models-and-Backups.htm
ALTER
DATABASE Compatibility Level (Transact-SQL)
http://msdn.microsoft.com/en-us/library/bb510680.aspx
SQL Server
Integration Services - SSIS
http://www.sqlis.com/search.aspx?q=torn_page_detection
DB DESIGN: Setting
Database Options
http://msdn.microsoft.com/en-us/library/ms190249.aspx
Management
Studio Improvements in SQL Server 2008
http://www.simple-talk.com/sql/learn-sql-server/management-studio-improvements-in-sql-server-2008/
Xp_cmdshell
and permissions
http://sqlblog.com/blogs/tibor_karaszi/archive/2007/08/23/xp-cmdshell-and-permissions.aspx
EXECUTE
permission denied on object 'xp_cmdshell',
http://www.kodyaz.com/blogs/software_development_blog/archive/2006/11/23/478.aspx
http://blog.sqlauthority.com/2007/04/26/sql-server-enable-xp_cmdshell-using-sp_configure/
http://www.mssqltips.com/tip.asp?tip=1020
Attaching
and Detaching Databases
http://www.mssqlcity.com/Articles/Adm/attach_database.htm
ALTER TABLE
syntax:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=351514#details
SQL SERVER –
Database Coding Standards and Guidelines – Part 1
http://blog.sqlauthority.com/2007/06/04/sql-server-database-coding-standards-and-guidelines-part-1/
Advantage of
views:
http://sqlserverpedia.com/wiki/Views_-_Advantages_and_Disadvantages
SQL SERVER
QUESTIONS:
Views -
Advantages and Disadvantages
http://sqlserverpedia.com/wiki/Views_-_Advantages_and_Disadvantages
New Features
in SQL Server 2008
http://technet.microsoft.com/en-us/magazine/2008.04.overview.aspx?pr=blog
SQL Server
Queries - SQL Server Query Tips and Tricks for ...
davidhayden.com/blog/dave/archive/2005/09/17/2475.aspx
Find Table
Creation Date with Modified Date
http://www.devasp.net/net/articles/display/768.html
Permission
denided
http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/326b5cf2-345f-4461-a7ba-39ba7fe8bbdc
http://sqlblog.com/blogs/tibor_karaszi/archive/2007/08/23/xp-cmdshell-and-permissions.aspx
http://www.kodyaz.com/blogs/software_development_blog/archive/2006/11/23/478.aspx
Clustered
Index Design Guidelines
http://msdn.microsoft.com/en-us/library/ms190639.aspx
Get table
create and last modify date time using PL-SQL in SQL server 2008.
http://www.devasp.net/net/articles/display/768.html
Sql Server
2005 Tips and Tricks
http://www.blogcatalog.com/blogs/sql-server-2005-tips-and-tricks/posts/tag/transact+sql+(t-sql)/
MS SQL
Server Tips
http://www.bristle.com/Tips/SQL.htm
http://www.bristle.com/Tips/SQL.htm#ms_top_n_query
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1277452_mem1,00.html
http://www.databasejournal.com/features/mssql/article.php/1576231/SQL-Server-Optimization-Tips-for-Designing-Tables.htm
Create Table
TIPS ( Primary Key/ Foreigh Key)
http://blog.sqlauthority.com/2008/09/08/sql-server-%E2%80%93-2008-creating-primary-key-foreign-key-and-default-constraint/
Pivot tables
in SQL Server
http://blogs.msdn.com/spike/archive/2009/03/03/pivot-tables-in-sql-server-a-simple-sample.aspx
CASE :
http://stackoverflow.com/questions/1122557/sql-server-2008-case-if-statements-in-select-clause
When should
primary keys be used?
http://www.sql-server-performance.com/faq/primary_key_index_clustered_p1.aspx
Tips on
Optimizing SQL Server Clustered Indexes
http://www.sql-server-performance.com/tips/clustered_indexes_p1.aspx
NVARCHAR
versus VARCHAR
http://weblogs.asp.net/guys/archive/2005/01/15/353550.aspx
SQL SERVER –
Difference and Explanation among DECIMAL, FLOAT and NUMERIC
http://blog.sqlauthority.com/2007/08/29/sql-server-difference-and-explanation-among-decimal-float-and-numeric/
SQL SERVER –
Query to find number Rows, Columns, ByteSize for each table in the current
database – Find Biggest Table in Database
http://blog.sqlauthority.com/2007/01/10/sql-server-query-to-find-number-rows-columns-bytesize-for-each-table-in-the-current-database-find-biggest-table-in-database/
CALs - SQL
Server 2008 CAL
http://stackoverflow.com/questions/301777/sql-server-2008-cal
DBCC
SHRINKFILE (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms189493.aspx
UPDATE
(Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms177523.aspx
ATTACH DB
ISSUE /ATTACH DB WITHOUT .LOG FILE
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78376
http://weblogs.asp.net/gunnarpeipman/archive/2009/07/21/attaching-sql-server-database-without-log-file.aspx
http://blog.sqlauthority.com/2008/07/21/sql-server-fix-error-9004-an-error-occurred-while-processing-the-log-for-database-if-possible-restore-from-backup-if-a-backup-is-not-available-it-might-be-necessary-to-rebuild-the-log/
http://www.sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-AngleEMERGENCY-mode-repair-the-very-very-last-resort.aspx
http://www.sqlskills.com/BLOGS/PAUL/search.aspx?q=REPAIR_ALLOW_DATA_LOSS
UNZIP FILE
VBSCRIPT
http://forum.soft32.com/windows/ZIP-UNZIP-VBScript-Windows-XP-ftopict278165.html
Export Data
From SQL Server 2005 to Microsoft Excel Datasheet
http://blog.sqlauthority.com/2008/01/08/sql-server-2005-export-data-from-sql-server-2005-to-microsoft-excel-datasheet/
Export Query
results to Excel with Column names in T-SQL
http://weblogs.sqlteam.com/mladenp/archive/2006/07/25/10771.aspx
CREATE CSV
FILE
http://www.simple-talk.com/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/
VBSCRIPT: Execute
stored procedure from vbscript
http://www.tek-tips.com/viewthread.cfm?qid=1456528&page=1
UNZIP TEXT
FILE
http://web.synametrics.com/plaintextfiles.htm
http://www.sqldev.org/sql-server-integration-services/how-can-unzip-file-text-file-using-ssis-9267.shtml
http://www.c-sharpcorner.com/UploadFile/yougerthen/607172008133427PM/6.aspx
LOCK STORED
PROCEDURE
http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=getapplock
Table Hints
(Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms187373.aspx
GRANT Object
Permissions
http://msdn.microsoft.com/en-us/library/ms188371.aspx
Permissions
(Database Engine)
http://msdn.microsoft.com/en-us/library/ms191291.aspx
REVOKE
Object Permissions (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms187719.aspx
Auditing SQL
Server Permissions and Roles
http://www.mssqltips.com/tip.asp?tip=2048
AUDIT: -
Understanding SQL Server Audit
http://msdn.microsoft.com/en-us/library/cc280386.aspx
http://www.simple-talk.com/sql/database-administration/sql-server-audit-magic-without-a-wizard/
http://blogs.msdn.com/b/repltalk/archive/2010/08/31/sql-server-2008-r2-audit-triggers-for-change-data-capture-changes-tables-table.aspx
http://msdn.microsoft.com/en-us/library/dd392015(SQL.100).aspx
http://msdn.microsoft.com/en-us/library/dd392015.aspx
http://sqlserver2000.databases.aspfaq.com/how-do-i-audit-changes-to-sql-server-data.html
http://www.communitymx.com/abstract.cfm?cid=AC864
http://blogs.msdn.com/b/repltalk/archive/2010/08/31/sql-server-2008-r2-audit-triggers-for-change-data-capture-changes-tables-table.aspx
TRIGGER
http://msdn.microsoft.com/en-us/library/ms189871.aspx
CIVIL
SUPPLYES
http://www.consumer.tn.gov.in/fairprice.htm
Differential
Backup
http://database.blogs.webucator.com/2010/07/12/creating-a-differential-backup-in-sql-server-2008/
http://blog.sqlauthority.com/best_top_sql_server_blog_all_post/
http://database.blogs.webucator.com/2010/07/12/creating-a-differential-backup-in-sql-server-2008/
FIND SIMILAR
WORDS -CONTAINS (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms187787.aspx
http://www.codeproject.com/KB/database/SQLServer2K8FullTextSearh.aspx
Understanding
Full-Text Indexing in SQL Server
http://www.simple-talk.com/sql/learn-sql-server/understanding-full-text-indexing-in-sql-server/
http://www.eggheadcafe.com/community/aspnet/13/10111608/string-matching-in-sql-server.aspx
Understanding
the importance of transaction logs in SQL Server
http://www.techrepublic.com/article/understanding-the-importance-of-transaction-logs-in-sql-server/5173108
http://www.simple-talk.com/sql/learn-sql-server/managing-transaction-logs-in-sql-server/
CREATE RULE:
http://blog.sqlauthority.com/2008/06/13/sql-server-2008-introduction-to-policy-management-enforcing-rules-on-sql-server/
DATABASE
TUNING / PERFORMANCE
http://bradmcgehee.com/wp-content/uploads/presentations/SSC209--Top%2010%20Database%20Maintenance%20Best%20Practices.pdf
http://ola.hallengren.com/
http://ola.hallengren.com/sql-server-backup.html
SSRS
http://www.venkateswarlu.co.in/BI/ssrs/Software_Requirements.aspx
TUTORIAL
http://www.accelebrate.com/sql_training/ssrs_2008_tutorial.htm
SSIS
http://pragmaticworks.com/community/blogs/darrenherbold/archive/2008/05/14/why-ssis-over-dts.aspx
http://www.sqlservercentral.com/articles/whatsnewwithssis/2234/
http://decipherinfosys.wordpress.com/2008/03/11/dts-vs-ssis-a-basic-overview/
http://blogs.conchango.com/jamiethomson/archive/2005/05/09/1396.aspx
http://decipherinfosys.wordpress.com/2008/07/23/ssis-exporting-data-to-a-text-file-using-a-package/
SSIS
Questions
http://blog.sqlauthority.com/2011/05/12/sql-server-import-csv-file-into-database-table-using-ssis/
http://www.mssqltips.com/sqlservertip/2485/ssis-interview-questions--part-1/
Very useful one, like phone book
ReplyDelete