SQL

SQL Server 200 + SQL Server Script

(Tutorials,Post ,Study,Help,Understand ,Material ,Everything …)

SQL Server Tutorial / Post / Example / Script / Practical’s

• BISQL # 1 :IT’s All About Primary Key and Basics of It !!!
• BISQL # 2 :How To Create Solution? Why and What is its Use!!
• BISQL # 3 :Time and Date Query code and Analysis Part -I
• BISQL # 4 :Identifying and Search of Relationship’s
• BISQL # 5 :Analysing the Size of Database and Size of table
• BISQL # 6 :Identifying Running Query and Last Modified Query
• BISQL # 7 :ALL in One Database Hero Script !! Set–I
• BISQL # 8 : Pros and Cons of Money Data Type
• BISQL # 9 :How to Get Answers,Common Question :SQL Server FAQs eBook
• BISQL # 10 :Top 10 Things For SQL Server Performance Part – I
• BISQL # 12 :SQL Server Technical White Papers,All in one
• BISQL # 13 :Concept of Change Data Capture (CDC) in SQL Server 2008 Part –I
• BISQL # 14 :Concept of Change Data Capture (CDC) in SQL Server 2008 Part –II
• BISQL # 15 :Concept of Change Data Capture (CDC) in SQL Server 2008 Part –III
• BISQL # 16 :TO Get All File Details From local file into SQL Server
• BISQL # 17 :How to determine the version and edition of SQL Server
• BISQL # 18 :How to Backing up a Mirrored database using SQL Agent
• BISQL # 19 :How should we store Images and BLOB files in SQL Server 
• BISQL # 20 :Why should I Learn SQL
• BISQL # 21 :All White Paper For SQL Server R2 Review and Better Understanding
• BISQL # 22 : Deep dive into GUID in SQL Server
• BISQL # 23 :SQL Server “Denali”: CTP3 now available !!
• BISQL # 24 :ALL Link Resource information for DB,.NET ,BI and Many More..
• BISQL # 25 : Audit Trail Part : I- What is Audit Trailing ?
• BISQL # 26 : Audit Trail Part : II- Implementation of Auto Auditing with Pros,Cons
• BISQL # 27 : Audit Trail Part : III-Implementation of Audit Trailing with CDC
• BISQL # 28: Audit Trail Part : IV–Comparing Entity Framework and SQL CDC
• BISQL # 29 : Analysis and Documentation Query
• BISQL # 30 : How Should I Find Information about Data Type
• BISQL # 31 : How To Create Folder from SSMS
• BISQL # 32 : How To find Parent Child Relationship Between Tables
• BISQL # 33 : Lets Understand Stored Procedure
• BISQL # 34 : What is Identity IN SQL {Identity Part–I}
• BISQL # 35 : Deep dive into Identity Functions in SQL {Identity Part–II}
• BISQL # 36 : Queries to Understand more on Identity aspect {Identity Part–III}
• BISQL # 37 :Checking, Seeding and Reseeding of Identity {Identity Part–IV}
• BISQL # 38 : Introduction To Function – {SQL Server Function Part – I }
• BISQL # 39 : Details of Row set functions – {SQL Server Function Part – II}
• BISQL # 40 : SQL Server Code Name “Denali” CTP3 Product Guide
• BISQL # 41 : Difference Between Char And Varchar
• BISQL # 42 : How to find count of all the records in all the table
• BISQL # 43 : Introduction to DAC – Data-Tier Application {DAC Part – I}
• BISQL # 44 : DAC-Database Project Overview {DAC Part – II}
• BISQL # 45 : How to Rename .MDF File and .LDF file ? (i.e – .mdf , .ldf)
• BISQL # 46 : Information of SQL Server Database Services and Startup account
• BISQL # 47 : How to find Details of Any Column in Entire Database in One Query
• BISQL # 48 : How to Generate SELECT script for all tables in a Database
• BISQL # 49 : SQL Server Denali Feature # 1–FileTables #1 – Introduction,Theory
• BISQL # 50 : SQL Server Denali Feature # 1- FileTables # 2 – Demo , Scripting
• BISQL # 51 : SQL Server Denali Feature # 2 – Sequence number
• BISQL # 51 : SQL Server Denali Feature # 2 – Sequence number –All Explanation !!
• BISQL # 52 : How To Check Database log file Details and Who Access last
• BISQL # 53 : SQL Server Denali Feature # 3 – AlwaysOn
• BISQL # 54 – SQL Server Execution Plan #1 – All Basics & Introduction to Execution Plan
• BISQL # 55 – Playing With Date type for getting Results as We Required
• BISQL # 56 – All SQL Server (T- SQL) Optimization Tips in Details with some example
• BISQL # 57 – How should I increase number of Recent File Option in SSMS plane !
• BISQL # 58 – Useful SQL Command for SQL Server Database Development
• BISQL # 59 – SQL Server 2012 Developer Training Kit Web Installer Preview
• BISQL # 60 – How to Take Fast Script only for Stored Procedures from Data Base
• BISQL # 61 – How to analyze Views & Stored Procedures in Rapid Development !
• BISQL # 62 – What are Statistics ?SSMS Statistics Information and Usage ,Reasons !
• BISQL # 63 – How to get list of Object with its Owner information and Object type
• BISQL # 64 – How to Check for all running process and How to Kill running process
• BISQL # 65 – How to Find Column name by Data type in Database ?
• BISQL # 66 – SQL Server Denali Feature # 4 – Columnstore Indexes
• BISQL # 67 – SQL Server Denali Feature # 5–Security
• BISQL # 68 – How to Kill Process Very Fast , With Analysis and Efficiently
• BISQL # 69 – Laymen to SQL Developer # 1 – Introduction to brand New SQL Server
• BISQL # 70 – Laymen to SQL Developer # 2 – Assignment #1 – Part #1–Introduction
• BISQL # 71 – SQL Server 2012 #1– Download now – Release Candidate 0 !! Useful links
• BISQL # 72 – Laymen to SQL Developer # 3 – Assignment #1 – Part #2 – Why DBMS 
• BISQL # 73 – How To find list of SQL Server Instances Installed on any machine
• BISQL # 74 – All SQL Query Related to Memory usage details for SQL Server instance
• BISQL # 75 – Laymen to SQL Developer # 4 – Assignment #1 – Part #3 – What is Data..
• BISQL # 76 – Laymen to SQL Developer # 5 – Assignment #1 – Part #4 – What is Data..
• BISQL # 77 – Laymen to SQL Developer # 6 – Assignment #1 – Part #5 – Schemes
• BISQL # 78 – How to Check All presents SQL Server Rights ,Permission and Right
• BISQL # 79 – SQL Server Global Variable #1–Introduction Global Variable with detailed
• BISQL # 80 – SQL Server Global Variable #2 – Global Variable 12 of 36
• BISQL # 81 – SQL Server Global Variable #3 – Global Variable 24 of 36
• BISQL # 82 – SQL Server Global Variable #4 – Global Variable 36 of 36
• BISQL # 83 – Laymen to SQL Developer # 7 – Assignment #1 – Part #6 – Storage manager, Query Processing ,Transaction Management and Internals
• BISQL # 84 – How to select ALL tables or Select all Top rows in one script .
• BISQL # 85 – SQL SERVER – Interview Questions and Answers Book
• BISQL # 86 – How to Run SSIS package in SQL Server using xp_cmdshell
• BISQL # 87 – Why DB Diagram doesn’t Work !! OR How to enable Database Diagram
• BISQL # 88 – Laymen to SQL Developer # 8 – Assignment #1 – Part #7 – Explanation and Basic Theory for Codd’s Rules and Normalization
• BISQL # 89 – How to establish / Find relationship between Table and stored Procedure
• List of Monthly post of MS BI, SQL & Link Resource Blog – March 2012
• BISQL # 90 – How to find Number of lines of Code in procedure or function
• BISQL # 91 – How to alter Similar column Or Alter All column in one Query in DB
• BISQL # 92 – How to find Number of lines of Code in Database
• BISQL # 93 – How to find list of Stored procedure which does not depend on any table
• BISQL # 94 – How to find tables which is not participating in SP  table relationship
• BISQL # 95 – SQL Server 2012–What’s new Or Summary for future SQL server
• BISQL #96 – SQL Server 2012 – Restore Database Features and Simplicity
• BISQL #97 – Laymen to SQL Developer # 9 – Assignment #2 – Relational Model, Schema, Attribute, Database, Key & Relational Query
• BISQL # 98 – Introduction of Private Cloud with SQL Server and Hyper-V, Resource Link
• BISQL # 99 – ‘A to Z’ SQL Command # 1 – List of Command which are present in SQL Server 2008 R2 AND SQL Server 2012
• Starting of Brand New Series – ‘A to Z’ SQL Command Series
• List of Monthly post of MS BI,SQL & Link Blog – May 2012
• Security Guide for SAP on SQL Server 2012 – Whitepaper Released
• Developer Experience #1 – What’s new in SSIS ! No More NEW from Now !!
• Breakthrough Insight SQL Server 2012 , SQL Server Evolution 2000 – 2012
• New Features , SSDT Introduction and links
• Installation, Problem, Support and Help !
• Migrating to SQL Server 2012 Failover Clustering and Availability Groups
• SQL Server Team – SQL Server 2008 R2 Service Pack 2 Customer Technology Preview (CTP) Available–Updates and Downloads
• 100 Download in 5 Days – SQL PraRup – Free Tool for Formatting/Indenting SQL Server
• BISQL # 103 : ‘A to Z’ SQL Command with Syntax, Description, Usage and Example # 2 : ALTER USER
• BISQL # 104 : ‘A to Z’ SQL Command with Syntax, Description, Usage and Example # 3 : Checkpoints
• Microsoft Press : Free eBook: Introducing Windows Server 2012
• List of Monthly post of MS BI,SQL & Link Blog : July 2012
• BISQL # 105 : SQL Server 2012 : Resource Governor : Introduction, Syntax, Example, Resources and Explanation with SQL Server 2012 Enhancement
• BISQL # 106 : SQL Server 2012 : CONCAT() function : Introduction, Syntax, Example and Queries
• Year 2012 – Thanks , Review Stats, Summaries and Some Memories and Good Bye !
• BISQL # 107 : Guest Post : Index Best Practices By: Mohammad Shahed
• BI SQL # 108 : Restarting Blogging in SQL Domain – Back Log and Future blog post and Series information !
• SQL Server Spirit With Community Badges ! fun ! Updates to About Me page !
• BI SQL # 109 : Information on SQL Server 2012 Licensing Core-based and Server/CAL Models
• BI SQL # 110 : SQL Server Script : Drop Database script without getting affected by any running queries on same Database 
• Database Objects
• Launching SQL PraRup – Free Tool for Formatting SQL Server Database Objects
• Lunching INFOGRAPHICS Mentalist – New face of knowledge sharing –New Blog , Under Mentalist Hood , Image worth explaining 100’s of Words !
• BI SQL # 111 : SQL Server Script : Optimization : Find top N heavy and time consuming SQL operation at runtime at any time
• BI SQL # 112 : SQL Server DBA Scripts : Generate Script for ALL index for Given Database
• BI SQL # 113 : SQL Server DBA Scripts : Display Table, Index Name , Key Cols and list of included columns
• BI SQL # 114 : SQL Server DBA Scripts : Find all nested stored procedure – Stored procedure called in another procedure
• BI SQL # 115 : SQL Server DBA Scripts : Simply find DB Size in MB and GB
• BI SQL # 116 : SQL Server DBA Scripts : Find All Database table relation in 1-* format
• BI SQL # 117 : SQL Server DBA Scripts : Find restored Date and Back up Date with Source file details
• BI SQL # 118 : SQL Server DBA Scripts : Find out the stored procedure which contain the selected Column name
• BI SQL # 119 : SQL Server DBA Scripts : Get the total Rows, Reserved Space, Data, Index Size, and Unused Space of Table
• BI SQL # 120 : SQL Server DBA Scripts : How to Verify Backup before restoring it !
• BI SQL # 121 : SQL Server DBA Scripts : Script to identify tables without Primary Key
• BI SQL # 122 : SQL Server DBA Scripts : Script to backup all Database in SQL Server
• BI SQL # 123 : SQL Server DBA Scripts : Re-Indexing Script at Database Level
• BI SQL # 124 : SQL Server DBA Scripts : SQL Command to find the free space and used space of each file of a specific database!!
• BI SQL # 125 : SQL Server DBA Scripts : SQL Script to find the List of blocked processes and time blocked for each blocking process!
• BI SQL # 126 : SQL Server DBA Scripts : Space utilization in terms of Driver Space
• BI SQL # 127 : SQL Server DBA Scripts : To find all the log files and the percentage space used of those log files in an instance!
• BI SQL # 128 : SQL Server DBA Scripts : To list the files(.mdf and .ndf) and their details in a particular database!
• BI SQL # 129 : SQL Server DBA Scripts : SQL SP to find the details about locks currently held by the processes
• TechEd Europe Announcement : SQL Server 2014 – Public CTP Now Available ! Download , Learn & Share
• BI SQL # 130 : SQL Server DBA Scripts : SQL DBCC command to check the open transactions!
• BI SQL # 131 : SQL Server DBA Scripts : SQL Script to find MS SQL Server product level details!
• BI SQL # 132 : SQL Server DBA Scripts : Report Login Failures
• BI SQL # 133 : SQL Server DBA Scripts : Cumulative IO Stats
• BI SQL # 134 : SQL Server DBA Scripts : Display Session request and Internal allocation
• BI SQL # 135 : SQL Server DBA Scripts : Display Table With Row page per count
• BI SQL # 136 : SQL Server DBA Scripts : Find Circular reference in given Database
• BISQL – Laymen to SQL Developer # 10 – DBMS [Database Management System] #1 – Introduction, Database Environment, Working of a Simple Centralized Database System
• BI SQL # 137 : SQL Server DBA Scripts : Copy data from one database to another
• BI SQL # 138 : SQL Server DBA Scripts : Current processes and their SQL statements
• BI SQL # 139 : SQL Server DBA Scripts : Current SSRS Sessions
• BI SQL # 140 : SQL Server DBA Scripts : Database size growth as a pivot table
• BI SQL # 141 : SQL Server DBA Scripts : Database Space usage in detail
• BI SQL # 142 : SQL Server DBA Scripts : Databases Processes Overview
• BI SQL # 143 : SQL Server DBA Scripts : High CXPacket Wait counts in an OLTP environment
• BI SQL # 144 : SQL Server DBA Scripts : State of the databases with the command DBCC CHECKDB
• BI SQL # 145 : SQL Server DBA Scripts : Defrag all indexes within a database
• BI SQL # 146 : SQL Server DBA Scripts : Delete duplicates from any table
• BI SQL # 147 : SQL Server DBA Scripts : Delete rows from relational tables with foreign keys
• BI SQL # 148 : SQL Server DBA Scripts : Delta IO Stats
• I am presenting @ Navi Mumbai User Group Event on Microsoft Technologies in Surya InfoEdge on SQL Server 2014 & MS BI
• BI SQL # 149 : SQL Server DBA Scripts : Detailed list of all tables and their size
• BI SQL # 150 : SQL Server DBA Scripts : Detailed Table and Index Breakdown information
• BI SQL # 151 : SQL Server DBA Scripts : Detailed Table and Index Breakdown With Buffered
• BI SQL # 152 : SQL Server DBA Scripts : Determine last database backups
• BI SQL # 153 : SQL Server DBA Scripts : File sizes per type for all databases
• BI SQL # 154 : SQL Server DBA Scripts : Find columns by properties
• BI SQL # 155 : SQL Server DBA Scripts : Foreign Keys Overview
• BI SQL # 156 : SQL Server DBA Scripts : Get List of Linked Servers and associated logins
• BI SQL # 157 : SQL Server DBA Scripts : Get database file space usage for all Database
• BI SQL # 158 : SQL Server DBA Scripts : How many Objects exists in a Schema
• BI SQL # 159 : SQL Server DBA Scripts : List of all to Get SSRS Usage Report
• BI SQL # 160 : SQL Server DBA Scripts : Get the status of the SQL Server jobs
• New Announcement : NMUG now Chapter of with SQL PASS
• BI SQL # 161 : SQL Server DBA Scripts : How to find the SQL Server Running Jobs Time Elapsed status
• BI SQL # 162 : SQL Server DBA Scripts : How to get information from Change Data Capture (CDC) Tables
• BI SQL # 163 : SQL Server DBA Scripts : List of all check constraints
• BI SQL # 164 : SQL Server DBA Scripts : List all Database Permissions

Interesting Finds

• SQL Server 2008 R2 Master Data Services Overview
• For Money and SQL Money Data Type Be Care full while using !!!!
• Must Download & hands on “SQL Server 2008 R2 Update for Developers Training Kit
• Deep Dive on new Search Features in Denali CTP1
• New White Paper on Spatial Features in SQL Server Code-Named "Denali"
• Introducing SQL Server 2014 – Unlocking Real, Time Insights !!

My Blogs:

• Business Intelligence Mentalist >> MS BI World
• SQL Server Mentalist >> SQL Learning Blog
• Google Profile

Connect With me on

| Facebook| Twitter | LinkedIn| Google+ | Word Press | RSS |Find us on Google+|