Home
Videos uploaded by user “SQL with Manoj”
Import data from Excel to SQL Server table
 
02:25
Import data from Excel to SQL Server table My SQL Blog: https://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 44378 SQL with Manoj
Backup and Restore Database in SQL Server
 
07:15
Backup and Restore Database in SQL Server Check my blog for more on Constraints and related sample SQL Queries: http://sqlwithmanoj.com/2009/12/27/sql-basics-working-with-foreign-key-fk-constraints/ Check the whole "SQL Server Basics" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv14f3cWDhubPaddxRvx1reKR Check my SQL blog at: http://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 44493 SQL with Manoj
Delete vs Truncate - similarities and differences in SQL Server
 
10:09
Differences and similarities between DELETE & TRUNCATE statement in SQL Server. Check more on my blog: http://sqlwithmanoj.com/2009/02/22/difference-between-truncate-delete-and-drop-commands/ For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 19520 SQL with Manoj
HAVING clause and difference with GROUP BY & WHERE clause in SQL statement
 
10:17
Using HAVING clause and difference with GROUP BY & WHERE clause in SQL statement Link for scripts on my blog: https://sqlwithmanoj.com/2015/05/23/sql-basics-difference-between-where-group-by-and-having-clause/ Check the whole "SQL Server Basics" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv14f3cWDhubPaddxRvx1reKR Check my SQL blog at: http://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 54687 SQL with Manoj
Connect SQL Server from Excel and retrieve data
 
07:01
Connect SQL Server from Excel and retrieve data My SQL Blog: https://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 27080 SQL with Manoj
Move master database to another drive in SQL Server
 
05:35
Move master database to another drive in SQL Server Also check this my blog: https://sqlwithmanoj.com/2016/06/28/dba-move-master-database-to-another-drive-in-simple-steps/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 3944 SQL with Manoj
Move tempdb to another drive in SQL Server
 
05:08
Move tempdb to another drive in SQL Server Check Script on my blog: https://sqlwithmanoj.com/2013/06/27/dba-move-tempdb-to-another-drive-in-simple-steps/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 2706 SQL with Manoj
DDL, DML, DCL & TCL statements in SQL (Database basics)
 
09:35
DDL, DML, DCL & TCL statements in SQL (Database basics) Check my blog on this: https://sqlwithmanoj.com/2009/02/10/what-are-ddl-dml-dcl-and-tcl-commands-difference-bw-them/ Check the whole "SQL Server Basics" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv14f3cWDhubPaddxRvx1reKR Check my SQL blog at: http://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 238288 SQL with Manoj
Export a Table or Query results from SQL Server to Excel
 
05:39
Export a Table or Query results from SQL Server to Excel My SQL Blog: https://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 21090 SQL with Manoj
Detach and Attach a Database in SQL Server
 
10:21
Detach and Attach a Database and move DB files (mdf, ndf, ldf) in SQL Server
Views: 21641 SQL with Manoj
Call Stored Procedure from Excel and show results
 
03:22
Call Stored Procedure from Excel and show results My SQL Blog: https://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 5057 SQL with Manoj
Run SQL Query with Date Range filter in Excel
 
05:38
Run SQL Query with Date Range filter in Excel My SQL Blog: https://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 10397 SQL with Manoj
Install SQL Server Reporting Service (SSRS 2014)
 
06:50
Install SQL Server 2014 - Reporting Service (SSRS) For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 36149 SQL with Manoj
new STRING_SPLIT() function in SQL Server 2016
 
06:10
New STRING_SPLIT() function in SQL Server 2016 to split a string into multiple values & rows. Check the whole "SQL Server 2016" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv16mB9n4av00uZB5TJsdK3CG Check the details and code on my SQL blog at: https://sqlwithmanoj.com/2016/03/10/new-in-built-table-valued-function-string_split-in-sql-server-2016-to-split-strings/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 7081 SQL with Manoj
Install AdventureWorks sample database for SQL Server
 
10:51
Install AdventureWorks sample SQL Server database, from GitHub : https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 27278 SQL with Manoj
Move user Database (.mdf and .ldf files) to another drive in SQL Server
 
06:36
Move user Database (.mdf and .ldf files) to another drive in SQL Server Check Script on my blog: https://sqlwithmanoj.com/2012/12/17/sql-basics-move-use-database-mdf-ldf-files-to-another-drive/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 16429 SQL with Manoj
Call Stored Procedure with multiple parameters from Excel
 
05:16
Call Stored Procedure with multiple parameters or different parameter values from Excel SYNTAX: {CALL uspGetManagerEmployees (?)} My SQL Blog: https://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 8798 SQL with Manoj
Install SQL Server Named Instance
 
08:51
Install SQL Server 2014 with Named Instance For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 16755 SQL with Manoj
Row Level Security (RLS) in SQL Server 2016
 
10:50
Implementing “Row Level Security” (RLS) with SQL Server 2016 CTP Check my blog for T-SQL reference and code sample: http://sqlwithmanoj.com/2015/07/13/implementing-row-level-security-rls-with-sql-server-2016/ For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 4083 SQL with Manoj
Candidate, Primary, Alternate, Super and Composite key types in DBMS (SQL)
 
10:00
Candidate, Primary, Alternate, Super and Composite key types in DBMS (SQL) Check my blog on this: https://sqlwithmanoj.com/2014/09/15/db-basics-what-are-candidate-primary-composite-super-keys-and-difference-between-them/ Check the whole "SQL Server Basics" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv14f3cWDhubPaddxRvx1reKR Check my SQL blog at: http://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 44410 SQL with Manoj
Install SQL Server Integration Service (SSIS 2014)
 
06:50
Install SQL Server 2014 Integration Service (SSIS) Download SQL Server setup from: https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016 For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 29096 SQL with Manoj
Install SQL Server Analysis Services (SSAS, MOLAP 2014)
 
05:00
Install SQL Server 2014 - Analysis Services (SSAS, MOLAP) For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 15267 SQL with Manoj
GROUP BY with Aggregate functions in SQL statement
 
25:01
Using "GROUP BY" clause with Aggregate functions in SQL statement Check the whole "SQL Server Basics" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv14f3cWDhubPaddxRvx1reKR Check my SQL blog at: http://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 35189 SQL with Manoj
Temporary Tables vs Table Variables - SQL Server Basics
 
19:48
SQL Basics - Temporary Tables vs Table Variables Check my blog on this: http://sqlwithmanoj.com/2010/05/15/temporary-tables-vs-table-variables/ Check the whole "SQL Server Basics" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv14f3cWDhubPaddxRvx1reKR Check my SQL blog at: http://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 19954 SQL with Manoj
Install SQL Server Management Studio (SSMS) 2016
 
04:13
Install SQL Server Management Studio (SSMS) 2016 Download SSMS 2016: https://sqlwithmanoj.com/2016/04/06/download-install-sql-server-management-studio-ssms-2016-decoupled-from-sql-server-engine-setup/ Check the whole "SQL Server 2016" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv16mB9n4av00uZB5TJsdK3CG All SQL Server 2016 posts on my blog SQLwithManoj.com: https://sqlwithmanoj.com/sql-server-2016-articles/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 41443 SQL with Manoj
CONCAT() function in SQL Server 2012
 
10:30
Concatenate Strings and Columns by using new CONCAT() function in SQL Server 2012 Check the whole "SQL Server 2012" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv17Wwmn5iFbDs5kIyvn8M3xd Check my SQL blog at: http://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 5826 SQL with Manoj
RANKING functions with OVER clause in SQL Server 2012
 
07:16
RANKING functions with OVER clause in SQL Server 2012 Check my blog for more details and SQL Queries: http://sqlwithmanoj.com/2010/08/09/ranking-functions-with-sql-server-2005/ For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 3240 SQL with Manoj
Live Query Statistics with Execution Plans in SQL Server 2016
 
03:34
Get Live Query Stats on your long running queries ( my blog link: http://sqlwithmanoj.com/2015/06/03/see-execution-plans-running-with-live-query-statistics-sql-server-2016/). - Execution plan fires as soon as you run the query and shows the progress of each operator, check in this video. For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 5413 SQL with Manoj
Temporal Tables (Deep Dive) in SQL Server 2016
 
23:58
Temporal Data and Tables (Deep Dive) in SQL Server 2016 CTP For Temporal T-SQL scripts check my blog posts: Part-1: http://sqlwithmanoj.com/2015/06/15/temporal-data-support-in-sql-server-2016-part-1/ Part-2: http://sqlwithmanoj.com/2015/06/17/time-travel-with-temporal-tables-in-sql-server-2016-part-2/ For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 5809 SQL with Manoj
Create Parametrized SQL Reports in Excel
 
03:26
Create Parametrized SQL Reports in Excel My SQL Blog: https://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 1403 SQL with Manoj
Create Pivot Table report in Excel by connecting SQL Server
 
04:00
Create Pivot Table report in Excel by connecting SQL Server My SQL Blog: https://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 3040 SQL with Manoj
Dynamic Data Masking in SQL Server 2016 CTP
 
07:13
Dynamic Data Masking in SQL Server 2016 CTP Check my blog for T-SQL reference and code sample: http://sqlwithmanoj.com/2015/07/20/obfuscate-column-level-data-by-using-dynamic-data-masking-in-sql-server-2016/ For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 2649 SQL with Manoj
Install SQL Server 2014 (with Default Instance)
 
07:04
Installing SQL Server 2014 (with Default Instance) For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 6306 SQL with Manoj
Computed Columns (Persisted and Non Persisted) in SQL Server
 
10:37
Computed Columns (Persisted and Non Persisted) in SQL Server Check my blog for more on IDENTITY property and related sample SQL Queries: http://sqlwithmanoj.com/tag/computed-columns/ For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 7001 SQL with Manoj
IDENTITY property (Part 1/3) of a Column in SQL Server
 
10:33
IDENTITY property (Part 1/3) of a Column in SQL Server Check my blog for more on IDENTITY property and related sample SQL Queries: http://sqlwithmanoj.com/2010/10/19/sql-basics-identity-property-of-a-column-in-a-table/ For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 2829 SQL with Manoj
IDENTITY property (Part 3/3) More about IDENTITY in SQL Server
 
10:14
IDENTITY property (Part 3/3) More about IDENTITY in SQL Server Check my blog for more on IDENTITY property and related sample SQL Queries: http://sqlwithmanoj.com/2012/05/03/all-about-identity-columns/ For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 1245 SQL with Manoj
Install SQL Server 2014 Analysis Service Tabular Model (SSAS - ROLAP)
 
07:29
Install SQL Server 2014 Analysis Service Tabular Model (SSAS - ROLAP) Download SQL Server free Developer version: https://sqlwithmanoj.com/2016/04/01/good-news-microsoft-makes-sql-server-developer-edition-free-for-developers/ For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 2983 SQL with Manoj
CHOOSE() and IIF() functions in SQL Server 2012
 
07:55
New CHOOSE() and IIF() functions in SQL Server 2012 Check the whole "SQL Server 2012" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv17Wwmn5iFbDs5kIyvn8M3xd Check my SQL blog at: https://sqlwithmanoj.com/2012/08/06/new-choose-and-iif-functions-introduced-in-sql-server-2012-denali/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 2587 SQL with Manoj
Install SQL Server 2016 RTM
 
06:15
Install SQL Server 2016 RTM (just DB engine) Download SQL Server 2016 RTM: https://sqlwithmanoj.com/2016/06/01/sql-server-2016-full-and-final-version-available-download-it-now/ Check the whole "SQL Server 2016" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv16mB9n4av00uZB5TJsdK3CG All SQL Server 2016 posts on my blog SQLwithManoj.com: https://sqlwithmanoj.com/sql-server-2016-articles/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 7094 SQL with Manoj
WHERE clause in SQL Server
 
15:55
WHERE clause in SQL Server, and working with OR, AND, LIKE, BETWEEN, IN, NOT IN operators Check the whole "SQL Server Basics" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv14f3cWDhubPaddxRvx1reKR Check my SQL blog at: http://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 7131 SQL with Manoj
Foreign Key (FK) Constraint in SQL Server (Referential Integrity)
 
15:12
Foreign Key (FK) Constraint in SQL Server Check my blog for more on Constraints and related sample SQL Queries: http://sqlwithmanoj.com/2009/12/27/sql-basics-working-with-foreign-key-fk-constraints/ For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 11902 SQL with Manoj
Import multiple Recordsets from an Excel sheet to SQL Server
 
04:54
Import multiple Recordsets from an Excel sheet to SQL Server My SQL Blog: https://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 1588 SQL with Manoj
Temporary Tables in SQL Server (Hash Tables)
 
08:42
Temporary Tables in SQL Server (aka Hash Tables) Check my blog on this: http://sqlwithmanoj.com/2010/05/15/temporary-tables-vs-table-variables/ Check the whole "SQL Server Basics" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv14f3cWDhubPaddxRvx1reKR Check my SQL blog at: http://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 2992 SQL with Manoj
Native JSON support in SQL Server 2016
 
05:28
Native JSON support in SQL Server 2016 CTP My blog link for SQL Scripts: http://sqlwithmanoj.com/2015/06/01/exportconvert-table-or-sql-query-data-to-json-string-format-sql-server-2016-part-1/ - Export SQL Tables or Queries to JSON Strings with "FOR JSON AUTO/PATH" option For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 8002 SQL with Manoj
StretchDB - Stretch tables to Azure SQL Database with SQL Server 2016
 
17:40
Stretch you Database tables to Azure DB with SQL Server 2016CTP Check more on my blog: http://sqlwithmanoj.com/2015/09/15/stretch-you-on-premise-databasetable-to-azure-sql-database-with-stretchdb-sql-server-2016/ For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 2139 SQL with Manoj
Create Database in SQL Server
 
10:54
Create Database in SQL Server Check the whole "SQL Server Basics" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv14f3cWDhubPaddxRvx1reKR Check my SQL blog at: http://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 6809 SQL with Manoj
Primary Key (PK) Constraint in SQL Server
 
18:04
Primary Key (PK) Constraint in SQL Server Check my blog for more on Constraints and related sample SQL Queries: http://sqlwithmanoj.com/2010/11/23/integrity-constraints/ For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 15502 SQL with Manoj
SELECT statement in SQL Server
 
14:01
SELECT statement in SQL Server Check the whole "SQL Server Basics" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv14f3cWDhubPaddxRvx1reKR Check my SQL blog at: http://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 5027 SQL with Manoj
IDENTITY property (Part 2/3) Check and ReSeed IDENTITY value in SQL Server
 
05:43
IDENTITY property (Part 2/3) Check and ReSeed IDENTITY value in SQL Server Check my blog for more on IDENTITY property and related sample SQL Queries: http://sqlwithmanoj.com/2011/07/08/reseed-tables-identity-column-value/ For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 2123 SQL with Manoj
Unique Key (UK) Constraint in SQL Server
 
12:14
Unique Key (UK) Constraint in SQL Server Check my blog for more on Constraints and related sample SQL Queries: http://sqlwithmanoj.com/2010/11/23/integrity-constraints/ For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 1704 SQL with Manoj