SQL

SQL Server 500+ 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

Laymen to SQL Developer

 

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

Connect With me on

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

  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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: