SQL
SQL Server
(Tutorials,Post ,Study,Help,Understand ,Material ,Everything …)
![image_thumb[1]_thumb[1]](http://sqlmentalist.files.wordpress.com/2011/12/image_thumb1_thumb1.png "image_thumb[1]_thumb[1]")
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 :Analyzing 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 analyse 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 – Storage manager, Query Processing ,Transaction Management
- 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 – Explanation ad 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 in procedure table relationship
- BISQL # 95 – SQL Server 2012–What’s new Or Summary for future SQL server
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"
Comments (0)
Trackbacks (0)
Leave a comment
Trackback
Leave a Reply
about.me
Vishal Pawar
Experienced Microsoft Business Intelligence Architect with SQL Server 2012 & 2008 R2,MSBI-SSIS,SSRS
Result-driven, dynamic professional with an overall IT experience in full life cycle projects in Microsoft Technology applications in SQL Server, MSBI (SSIS, SSRS, SSAS, Power Pivot, Power View, DQS and MDS)
Experience in Microsoft technology projects with The Most Group (OGNAM Technologies), Pune as Senior Technology Specialist, BI Lead and MSBI SOLUTION ARCHITECT in Microsoft Business Intelligence Domain in SSIS, SSRS and SSRS as key technologies. Currently employed with the same.
Experience in Microsoft technology projects with Tata Consultancy Services Pvt Ltd, Kolkata as Assistant Systems Engineer.
Experience in various Google Search Analysis andMicrosoftdevelopment projects with Right Click Enterprises, Mumbai as Database Developer and Company Representative asSr. Ex. Officer For Search Engine optimization
Experience in Microsoft development projects as SQL DBA Assistance and MS BI DBA Assistance in Right Click Enterprises, Mumbai
