- Видео 20
- Просмотров 124 998
Database Tales
США
Добавлен 5 янв 2020
Sharing over 16 years of experience working with multiple databases, languages and methods to manage and transfer data.
Please visit the DBTales.com website for more articles and information.
Please visit the DBTales.com website for more articles and information.
Powershell Dates With Get-Date and Last Day of the Month
A short overview dealing with Dates in Powershell, using strings and the Get-Date object. Including an example that finds the last day of the month.
www.dbtales.com
www.dbtales.com
Просмотров: 598
Видео
Powershell Foreach Loop | Example
Просмотров 3443 года назад
We look at a simple use of the foreach loop in Powershell using a SQL query as a record source. Including a few IF statements to boot. www.dbtales.com
Create a DataTable using Powershell
Просмотров 6 тыс.3 года назад
We create a new DataTable using Powershell and the default datatypes. We define columns and populate the Data Table using a SQL query that grabs database details. www.dbtales.com
Learn SQL Commands | CASE Statement
Просмотров 804 года назад
4. Example tutorial using the SQL CASE statement and working with strings. This tutorial is for beginners to the T-SQL language.
Learn SQL Commands | DATES and Formatting
Просмотров 384 года назад
3. We review basic functions for working with dates, pulling out items such as the week, day or month name form a date field. Functions reviewed include GETDATE(), DATENAME(), GETUTCDATE(), YEAR(), MONTH() and DAY(). This video is for the beginner with the SQL language.
Learn SQL Commands | Strings and Characters
Просмотров 784 года назад
2. Examples of common string functions used to work with characters in a string field. Commands reviewed include LEN(), RIGHT(), LEFT(), SUBSTRING() and CHARINDEX().
Learn SQL Commands | SELECT and Math
Просмотров 1134 года назад
1. We go over the basics of querying tables. Learning SELECT and aggregate functions as well as simple math. This video is targeted to beginners.
SSIS Multiple Excel Files Import | using foreach object
Просмотров 13 тыс.4 года назад
Tutorial showing how to import multiple excel files into a SQL table using the foreach container and variables. The Microsoft Access Objects may be required to perform this tutorial. www.dbtales.com
SSMS export to CSV | using grid and wizard
Просмотров 1,3 тыс.4 года назад
Tutorial and example how to export to a comma separated file using sql server management studio (SSMS) and save as a CSV file from the grid or export using the wizard. We change to the pipe delimiter and demonstrate saving a query in SSMS as a CSV file. www.dbtales.com
SQL Restore Database From .BAK File | with Different Name
Просмотров 6 тыс.4 года назад
Tutorial example to restore multiple databases to the same instance from the same backup file. We walk through the GUI restore setup and then use scripts to change the database name and file names during the restore process. www.dbtales.com
SSIS Lookup Transformation Example | Match and No Match
Просмотров 14 тыс.4 года назад
This is a short example tutorial on the lookup transform object in SSIS. The Lookup is used to match or no match records with a destination and route the source records through the related path. We also try matching multiple columns to demonstrate the Lookup can match using more than 1 column. www.dbtales.com
SSIS Parameters and Variables | connection strings and sql command
Просмотров 17 тыс.4 года назад
We review how to use parameters to make the connections manager settings dynamic. We also use a source query to show how a variable (parameter) can dynamically be assigned to change the source records in the sql query. www.dbtales.com
SSIS Excel to SQL Server Table
Просмотров 2,7 тыс.4 года назад
Using SSIS we import an Excel spreadsheet into a new SQL table. The table is created during the SSIS package development. The "Microsoft Access Engine Redistributable" needs to be installed only if you do not have Office installed. Also, most companies will not install Office on a production server so this is how your server admin can add the objects to your SSIS server. www.dbtales.com
Learn SQL Server Management Studio | Beginner
Просмотров 1544 года назад
Some of the basics and commonly used functions in Microsoft SSMS. This is best for the beginner. www.dbtales.com
SQL Server Yes/No Field | Type
Просмотров 14 тыс.4 года назад
The SQL Server Yes/No Field or binary and tinyint alternatives. We quickly review the datatypes for a flag or boolean field and using INT or tinyint as an alternative. www.dbtales.com
How to find SQL Server instance name | port and services
Просмотров 2,3 тыс.4 года назад
How to find SQL Server instance name | port and services
What is a SQL Server instance (non-technical) | beginner
Просмотров 4,8 тыс.4 года назад
What is a SQL Server instance (non-technical) | beginner
Powershell SQL Connection | Execute Queries
Просмотров 23 тыс.4 года назад
Powershell SQL Connection | Execute Queries
SQL Server Network Configuration | Named Instances, ports and protocols
Просмотров 12 тыс.4 года назад
SQL Server Network Configuration | Named Instances, ports and protocols
you are fantastic man
Really clear explanation, brilliant video
This is the most honest-to-God video on the internet on the topic. You are a good man, you are an honest man, you are definitely a smart man. Whatever you said in the video, I got it in one go, didn't have to google search to unpack what you said. Thank you, Sir. God bless you!
Huy Đinh chưa coi này sao làm được em?
Phụng bless you
Thank you, gracias!!! me estaba volviendo loca!
This video is exactly what I need to understand. 🎉
Finally a very well explained process on loops; I used it for Ms Access files and worked too
so can we email the results of the poweshell output via email if it meets certain conditions?
thanks for the tip. is the connection closed automatically?
what about an ODBC connection how can we map the parametre?
what is the purpose to install ms access redistributed? what if didnt install it ?
Office objects, like Excel, are usually installed on a workstation because Office apps are already there and licensed (Word, Excel, Powerpoint etc.). The Server does not have Office installed so they provide these objects so you can run the SSIS package on the server and create an Excel file, just like you do on your workstation.
Nice clear concise tutorial, thanks!😊
Glad it was helpful!
Thanks a lot for sharing this tutorial!! I keep having issues because the Excel Source task couldn't read files with multiple names but now the issue has been fixed!! Again thanks a lot!!!
activeer windows
Very helpful, and covered the exact questions I had, which were missed in some other videos I watched.
thanks dude
When I run this with the start button, it just hangs / does nothing. When I execute just the container, it displays the first file, and then the DFT does nothing (if I use a data viewer, it does not read the excel file). Any guesses what needs to change?
How connect SQL developer to power shell please help me it's urgent
What would you do if the worksheet structure is the same but the sheetname is different in each excel file? it always matches the file name
@javierrodriguez3624 hey man, I have the same problem, sheet name changes with each file. I am wondering if you found a solution to this?
Thanx man , well explained 👍
Thank you so much, after spending lots of hours , I found your video and solved multiple excel data transfer problem :)
Thanks 👍🏻👌🏻
Thank you, it helped a lot my friend
It helped!
didn't know trump was a data engineer 🐙
Good beginner information. Thank you DB Tales. Volume is low, muffled.
Noted!
Turn up the volume. My car audio can’t go any higher. I can’t even hear.
Will do, I may re-record many of these with a good mic
Thanks for the explanation. I don't have the button to add parameters in the connection manager. Do you know why?
The User Defined Parameters are located in a sub-tab,.. [Control Flow] - [Data Flow] - [Parameters] After you create it there, go to the Connection Manager Properties and Expressions. Choose a Property to assign this parameter to; like "ServerName", and then click the 3 dots "..." The Parameter should be there called "User::myparameter"
Hi, great video. Is there a way to schedule the script to run ever night. ex to a dev DB
You could Drop the DEV DB, and use a Linked Server to grab the Backup file location from a remote DB server (PROD) and restore it to the DEV SQL instance. In my opinion it might be better to use Powershell on a Utility server to collect the backup path and then schedule a restore automatically.
I got this working in VS, but when deploy it I get an error about the ACE OLEDB 12 driver not being installed. Does anyone know what would cause this to throw an error in SQLServer but not VS?
The server may need the Office objects installed.. (NOT Full Office App) just the objects to create the Office files. Google "Microsoft Access Database Engine Redistributable "
Create a Job in SQL Server Agent. When creating Steps of the Job, go to Settings of the Step. There must be an checkbox with option to execute the job in 32-bit runtime. Put a check on it. It will execute the 32-bit SSIS package with the right 32-bit driver.
Thanks alot it worked with me after I listen many videos which are doesnt work , could you tell me please how to upload a sql database file into spark or hbase
i have large query in text file so how to execute that?
This is one of those "it depends" questions. If the file is too large for SSMS to load and execute then you can use the command line tools to execute it. try looking at: learn.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-ver16
How can I make my SISS project automatically run , sir ?
Look into setting up an SSIS Catalog to publish your package to. The package can be hosted there and then scheduled via SQL job.
loved your voice and cliarity on the subject. Please continue making small topics intro just like above. Subscribed .. yes sir, I did.
Great video. Very clear, step by step and easy to understand. It helps me a lot. Thanks!
Very helpful, thank you.
Nice...
Good job Teddy 🎉
Thanks! 😃
Thanks for clearly explaining this!!!
NICE INFORMATION
very precise , thanks
thank you !
You're welcome!
great
Great Tuto! Thank you
can you please show how to use this with an Oracle DB?
Very well explained.
Great video! Thank you! I am surprised you didn't have to do datatype conversion from excel Unicode datatype to non-Unicode datatype!
It's a good point. For those reading this comment you may run into an issue with the nvarchar datatype regarding unicode. In the past I usually CAST the field as a varchar.
@@databasetales3562 Hey I really liked you video, is there one where you do the exact same as this video but you also use a dynamic naming convention of the files and incorporate that in your variable. like 112024_CCC for November and 122024_CCC for December but that they are all in the same folder. SO the variable will automatically change to the correct MonthYear and look for that specific string within the name of the file. I can give examples if what I said was too convoluted.
THANK YOU SO MUCH. I had no idea what I did wrong at 5:44, thank you for showing.