SQL

SQL Server 200 + SQL Server Script

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

image_thumb[1]

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

Interesting Blog post

· I am presenting @ Navi Mumbai User Group Event on Microsoft Technologies in Surya InfoEdge on SQL Server 2012

· 2015 in review–BI,SQL Blog and Power BI (About me) , Happy New Year 2016

· Merry Christmas & Gifts of Slides on SQL Coding Conventions, Best Practices, Tips and Programming Guidelines for TSQL

· SQL Server 2016–Getting Started, Download, Installation and First Look

· Back to origin, SQL Saturday Atlanta event day updates – SQLSaturday #392

· 2014 in review ! Wish you all Happy New Year ! Happy SQL Scripting !

· Microsoft Power Business Intelligence (Power BI) Workshop in Microsoft Mumbai Office

 

All about SQL

· 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 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

· BI SQL # 164 : SQL Server DBA Scripts : List all Database Permissions

· BI SQL # 165 : SQL Server DBA Scripts : List all heap tables

· BI SQL # 166 : SQL Server DBA Scripts : List all indexed Views

· BI SQL # 167 : SQL Server DBA Scripts : List all Locks of the Current Database

· BI SQL # 168 : SQL Server DBA Scripts : List all Objects and Indexes per Filegroup or Partition

· BI SQL # 169 : SQL Server DBA Scripts : List all Server Permissions

· BI SQL # 170 : SQL Server DBA Scripts : List all SSIS packages stored in msdb database

· BI SQL # 171 : SQL Server DBA Scripts : List all SSRS report parameters with definition

· BI SQL # 172 : SQL Server DBA Scripts : List all SSRS subscriptions

· BI SQL # 173 : SQL Server DBA Scripts : List all trigger with SQL definition

· BI SQL # 174 : SQL Server DBA Scripts : List connection strings of all SSRS Shared Data sources

· BI SQL # 175 : SQL Server DBA Scripts : List Database Roles and Members with Server Login

· BI SQL # 176 : SQL Server DBA Scripts : List for all SSRS reports that use data sources and datasets with the command text

· BI SQL # 177 : SQL Server DBA Scripts : List expensive queries CHILD

· BI SQL # 178 : SQL Server DBA Scripts : List expensive queries MAIN

· BI SQL # 179 : SQL Server DBA Scripts : Log Growth Rate

· BI SQL # 180 : SQL Server DBA Scripts : List log file information for all the databases on the server

· BI SQL # 181 : SQL Server DBA Scripts : Overview of Locks per Database and Type

· BI SQL # 182 : SQL Server DBA Scripts : Page Life Expectancy

· BI SQL # 183 : SQL Server DBA Scripts : Pages per object in buffer pool

· BI SQL # 184 : SQL Server DBA Scripts : Pending IO Requests

· BI SQL # 185 : SQL Server DBA Scripts : Programmability Objects and their Parameters

· BI SQL # 186 : SQL Server DBA Scripts : Find the details of the given report name by querying Report Server Database

· BI SQL # 187 : SQL Server DBA Scripts : Query Master Data with Details as Comma Separated Value

· BI SQL # 189 : SQL Server DBA Scripts : Run DBCC CHECKDB on all databases

· BI SQL # 190 : SQL Server DBA Scripts : Script to find the partition key of a table

· BI SQL # 191 : SQL Server DBA Scripts : Search for a string in all tables of SQL Server Database

· BI SQL # 192 : SQL Server DBA Scripts : Search string or pattern in SQL module definition

· BI SQL # 195 : SQL Server DBA Scripts : SQL Server replication publication information

· BI SQL # 196 : SQL Server DBA Scripts : Script to VLF count for all databases

· BI SQL # 197 : SQL Server DBA Scripts : Overview of all objects created in SSRS ordered by the folder hierarchy

· BI SQL # 197 : SQL Server DBA Scripts : Overview of all objects created in SSRS ordered by the folder hierarchy

· BI SQL # 198 : SQL Server DBA Scripts : Stored procedure Execution statistics

· BI SQL # 199 : SQL Server DBA Scripts : Temporary Tables and Their Size

· BI SQL # 200 : SQL Server DBA Scripts : Various SQL Server IO Statistics

· BI SQL # 201 : SQL Server DBA Scripts : Job Failure Notification

· BI SQL # 202 : SQL Server DBA Scripts : How to Delete Database through Script

· BI SQL # 203 : SQL Server DBA Scripts : Identify Top Nth heavy I / O Operation

· BI SQL # 204 : SQL Server DBA Scripts : Identify Top Nth waits With I / O Specification

· BI SQL # 205 : SQL Server DBA Scripts : Identify High Latch Waits

· BI SQL # 206 : SQL Server DBA Scripts : Identify IO Stall For Each DB

· BI SQL # 207 : SQL Server DBA Scripts : Identify Free space in Temp DB

· BI SQL # 208 : SQL Server DBA Scripts : Identifying Procedures Taking More Execution time

· BI SQL # 209 : SQL Server DBA Scripts : Displaying Table Name Having Primary Key with Column Name

· BI SQL # 210 : SQL Server DBA Scripts : Reset Identity Column

· BI SQL # 211 : SQL Server DBA Scripts : How to Drop All Table from database through Script

· BI SQL # 212 : SQL Server DBA Scripts : Searching String in Steps of JOB

· BI SQL # 213 : SQL Server DBA Scripts : Reads and Writes in Database

· BI SQL # 214 : SQL Server DBA Scripts : Identify Number of Lines of code for each database Object

· BI SQL # 215 : SQL Server DBA Scripts : Making IDENTITY column to NON-IDENTITY & vice versa

· BI SQL # 216 : SQL Server DBA Scripts : Searching For Specific column for all Tables in database

· BI SQL # 217 : SQL Server DBA Scripts : Display Configuration Settings

· BI SQL # 218 : SQL Server DBA Scripts : Identify size of all non clustered indexes

· BI SQL # 219 : SQL Server DBA Scripts : Add mdf file as new DB

· BI SQL # 220 : SQL Server DBA Scripts : Find Any Column with Specific DataType

· BI SQL # 221 : SQL Server DBA Scripts : Find Specific text in database

· BI SQL # 222 : SQL Server DBA Scripts : Find Tables without Primary Key

· BI SQL # 223 : SQL Server DBA Scripts : Get All table Size Information

· BI SQL # 224 : SQL Server DBA Scripts : Display Memory Configuration

· BI SQL # 225 : SQL Server DBA Scripts : Display Space Details for Given database

· BI SQL # 226 : SQL Server DBA Scripts : Display Name And Size of Drive on Machine

· BI SQL # 227 : SQL Server DBA Scripts : Display Table info with Index and Rows

· BI SQL # 228 : SQL Server DBA Scripts : Create Alter Script Dynamically

· BI SQL # 229 : SQL Server DBA Scripts : Enable Data Compression

· BI SQL # 230 : SQL Server DBA Scripts : Disable Data Compression

· BI SQL # 231 : SQL Server DBA Scripts : Create Primary Key for all Tables

· BI SQL # 232 : SQL Server DBA Scripts : Backup Old And Restore new Database through Script

· BI SQL # 233 : SQL Server DBA Scripts : Trim all column of given table

· BI SQL # 234 : SQL Server DBA Scripts : Get Distinct Value for each column from Table

· BI SQL # 235 : SQL Server DBA Scripts : Identify Structure of a Table

· BI SQL # 236 : SQL Server DBA Scripts : Find list of stored procedure with content info

· BI SQL # 237 : SQL Server DBA Scripts : A. Compare Database

· BI SQL # 238 : SQL Server DBA Scripts : B. Compare Database

· BI SQL # 239 : SQL Server DBA Scripts : C. Compare Database

· BI SQL # 240 : SQL Server DBA Scripts : Foreign Key & Primary Key Relationship All

· BI SQL # 241 : SQL Server DBA Scripts : Find SQL Server Service Account

· BI SQL # 242 : SQL Server DBA Scripts : Shrink Log file through Script

· BI SQL # 243 : SQL Server DBA Scripts : Finding all the objects that have been modified in the last N days in database

· BI SQL # 244 : SQL Server DBA Scripts : Restore Database Through script

· BI SQL # 245 : SQL Server DBA Scripts : Show Running Queries on SSMS

· BI SQL # 246 : SQL Server DBA Scripts : SQL DMV to find the details of current processes running like percent completed!!

· BI SQL # 247 : SQL Server DBA Scripts : List all the Databases on Server

· BI SQL # 248 : SQL Server DBA Scripts : Find Tables with Foreign Key Constraint in Database

· BI SQL # 249 : SQL Server DBA Scripts : Finding tempdb Size and Growth Parameters

· BI SQL # 250 : SQL Server DBA Scripts : List all roles of the current database with their members

· BI SQL # 251 : SQL Server DBA Scripts : List SQL Script to find the Roles assigned to the SQL Logins including Create_data and modify_date

· BI SQL # 252 : SQL Server DBA Scripts : Find SQL Server Start time and End time

· BI SQL # 253 : SQL Server DBA Scripts : Permissions Script

· BI SQL # 254 : SQL Server DBA Scripts : Estimating Rows per Page

· BI SQL # 255 : SQL Server DBA Scripts : Find Recently Executed Stored Procedures

· BI SQL # 256 : SQL Server DBA Scripts : Check VLF Counts in Database

· BI SQL # 257 : SQL Server DBA Scripts : SQL Agent Job Script

· BI SQL # 258 : SQL Server DBA Scripts : Index Definition Audit Script

· BI SQL # 259 : SQL Server DBA Scripts : Database current size, auto growth setting and file location

· BI SQL # 260 : SQL Server DBA Scripts : Find last backup details of all databases in a server

· BI SQL # 261 : SQL Server DBA Scripts : Find If any database is Offline

· BI SQL # 262 : SQL Server DBA Scripts : Find IP Address of machine

· BI SQL # 263 : SQL Server DBA Scripts : All Database Information

· BI SQL # 264 : SQL Server DBA Scripts : Monitoring Database Backups

· BI SQL # 265 : SQL Server DBA Scripts : Compare Data Table

· BI SQL # 266 : SQL Server DBA Scripts : Find Cumulative IO Stats

· BI SQL # 267 : SQL Server DBA Scripts : Identity Columns: Are You Nearing The Limits?

· BI SQL # 268 : SQL Server DBA Scripts : Find Statistics Info for all tables

· BI SQL # 269 : SQL Server DBA Scripts : Find all server running in n/w

· BI SQL # 270 : SQL Server DBA Scripts : Find the SQL Server Protocols Status

· BI SQL # 271 : SQL Server DBA Scripts : Display all Server Information

· BI SQL # 272 : SQL Server DBA Scripts : Find Connectivity information

· BI SQL # 273 : SQL Server DBA Scripts : Core in server

· BI SQL # 274 : SQL Server DBA Scripts : Space used by version store

· BI SQL # 275 : SQL Server DBA Scripts : Find Session details

· BI SQL # 276 : SQL Server DBA Scripts : Find all DB IO with Rank

· BI SQL # 277 : SQL Server DBA Scripts : Find TOP IO Stored Procedure

· BI SQL # 278 : SQL Server DBA Scripts : How to Quick Search Anything in Database in SQL Server

Interesting Finds

· BISQL – Laymen to SQL Developer # 18 – Record Storage and Primary File Organization #3 – Operation on Files, Files of Unordered Records (Heap Files), Files of ordered records [sorted files]

· BISQL – Laymen to SQL Developer # 19 – Record Storage and Primary File Organization #4 – Hashing Techniques

· BISQL – Laymen to SQL Developer # 20 – Index Structures of Files #1 – Introduction, Primary Index, Clustering Index

· BISQL – Laymen to SQL Developer # 21 – Index Structures of Files #2 – Multilevel Indexes, B+Tree Index Files, B-Tree’

· BISQL – Laymen to SQL Developer # 22 – Entity-Relationship Model #1 – Introduction, Conceptual Data model for Database Design

· BISQL – Laymen to SQL Developer # 23 – Entity-Relationship Model #2 – ER Model Concept with an example

· BISQL – Laymen to SQL Developer # 24 – Entity-Relationship Model #3 – Components of an ER Model, Constraints on Relationships Types

· BISQL – Laymen to SQL Developer # 25 – Relational Algebra #1 – Introduction, Relational Model Constraints

· BISQL – Laymen to SQL Developer # 26 – Relational Algebra #2 – Update Operation on Relations, The Relational Algebra

· BISQL – Laymen to SQL Developer # 27 – SQL#1 – Introduction, Tuple Relational Calculus

· BISQL – Laymen to SQL Developer # 28 – SQL #2 – Multi Table Queries, Data Manipulation Language

· BISQL – Laymen to SQL Developer # 29 – SQL #3 – The Create Table Statement, Specifying of Constraints & Default Values of SQL

· BISQL – Laymen to SQL Developer # 30 – Functional Dependencies and Normalization For Relational Databases #1 – Introduction, Information Design Guide Lines for Relational Database

· BISQL – Laymen to SQL Developer # 31 – Functional Dependencies and Normalization For Relational Databases #2 – Levels of Relation Schema & Functional Dependency, Normal Forms Based on Primary Keys

· BISQL – Laymen to SQL Developer # 32 – Functional Dependencies and Normalization For Relational Databases #3 – Boyce Codd Normal Form (BCNF)

· BISQL – Laymen to SQL Developer # 33 – Functional Dependencies and Normalization For Relational Databases #4 – Fourth Normal Form (4NF), Normalization using Join Dependencies

· BISQL – Laymen to SQL Developer # 34 – Transaction Processing #1 – Introduction, Transaction Processing Concepts, Transactions in a Multiuser System

· BISQL – Laymen to SQL Developer # 35 – Transaction Processing #2 – Desirable Properties of Transactions, Concepts of Schedule History, recoverable cascading rollback and script schedules

· BISQL – Laymen to SQL Developer # 36 – Concurrency Control Techniques #1 – Introduction, Types of Locks: Locking Technique for Concurrency Control

· BISQL – Laymen to SQL Developer # 37 – Concurrency Control Techniques #2 – The Two Phase Locking Protocol

· BISQL – Laymen to SQL Developer # 38 – Recovery Techniques #1 – Introduction, Techniques for Recovering

· BISQL – Laymen to SQL Developer # 39 – Recovery Techniques #2 – Deferred Update, Immediate Update

· BISQL – Laymen to SQL Developer # 40 – Distributed Databases #1 – Introduction, Client-Server Model

· BISQL – Laymen to SQL Developer # 41 – Distributed Databases #2 – Data Fragmentation, Replication, and Allocation Techniques for Distributed Database Design

· BISQL – Laymen to SQL Developer # 42 – Relational Databases #1 – Introduction, Basics of Object Oriented Design (OOD)

· BISQL – Laymen to SQL Developer # 43 – Relational Databases #2 – Object Oriented Data Model, Object Oriented Databases, Object Relational Database Management Systems

· BISQL – Laymen to SQL Developer # 44 – Security & Integrity #1 – Introduction, Security & Integrity Violations

· BISQL – Laymen to SQL Developer # 45 – Security & Integrity #2 – Authorization, Granting of Privileges, Security Specification in SQL

My Blogs:

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: