T-SQL TUTORIAL
Duration : 0:9:51
SQL SERVER Tutorial – T-SQL: LIKE – BETWEEN – COMMENTS – NULL VALUES – AND/OR/NOT
SQL SERVER Tutorial – T-SQL: REPLACE & STUFF – LEN, LEFT, RIGHT – CHARINDEX
T-SQL TUTORIALSQL SERVER Tutorial – T-SQL: Built-in Functions – Working with NULLS – COALESCE – ISNUMERIC
T-SQL TUTORIALSQL SERVER Tutorial – T-SQL: Updat a row – Update multiple rows- Update Another Table
T-SQL TutorialHTTP POST request from xp_cmdshell?
I want to execute POST request from TSQL,
like: www.x.com/Update.aspx?client_no=12&name=new_name.
How can I make use of xp_cmdshell procedure?
Any suggestions?
I’ve not done shelling from SQL (we do scheduled jobs via task scheduler), but simply prefixing ‘http://’ will shell the browser.
However, if what you are trying to do is get SQL to do a parameterized call to a web server, I really can’t recommend this approach. A web browser needs a user context, and has a fair bit of overhead.
Using the new SQL 2005, you could write a .NET DLL that sends a WebRequest, and then register the DLL as a .NET stored procedure. Then just call the SP. You won’t need a user context, and it won’t do end-user style threading, it will run in-process.
Otherwise, keep SQL Server out of the Http request business. It really shouldn’t be doing that anyway. That’s a middle tier task if I’ve ever seen it.
SQL SERVER Tutorial – T-SQL: SELECT STATEMENT – ALIASING – CONCATENATING – WHERE
T-SQL TutorialWhat should I know as a SQL Server systems administrator?
My background is in accounting and I am a CPA.
On Monday, the IT Department told my boss that they would prefer that I become the system administrator for our ERP system called Vision. Its a program used company-wide to process everything from Timesheets to Accounts Payable to Marketing Opportunities.
I have no training in IT. I do know how to run TSQL queries and have created some useful stored procedures for the database. I have also created some reports using SQL Reporting Services.
What type of training/certification do you recommend?
It depends on exactly what your role is going to be, you’ll need to be sure what the IT department are actually handing you.
If you’re responsible for actually keeping the application up and running you’re immediate focus wants to be on system health monitoring, performing backups and making sure you know how to recover from errors. For these you want to be looking for courses that lead you to the Microsoft Certified Technology Specialist (MCTS) in SQL Server.
If on the other hand, the IT department are going to continue looking after the servers, and want you to handle the general administration of Vision, then you’re more likely to need to know how to set up users, control permissions, and when to implement version upgrades etc. These I’d expect are going to be handled by Vision specific functions rather than SQL Server, so you’d need to be looking at training offered by the Vision suppliers.
Adding Text to a Jpg image?
I need to embed text into an image
using either Server side Script or DLL, API calls or TSQL ! etc
This is not putting text on top of an image in an HTML page its similar to adding a permanent watermark.
Can someone supply the code ?
Thanks in advance
I did this in C# /.NET
Essentially…every time someone uploaded a image…the code dynamically makes sure to make a thumbnail for it for preview purposes…including resizing the image and adding text to it.
Good tutorial below:
http://www.codeproject.com/csharp/watermark.asp
SQL SERVER Tutorial – T-SQL: Create Temp Table – Bulk Insert
T-SQL TutorialNeed Tuitoring SQL SERVER?
Hi guys,
i need a tuitor, who will teach me TSQL and a little about SQL server adminibstration.I know alot but i need some experience guy to clear my concept.Any PAKISTNAI GUY can help me this.
I will pay the tuition Fees.
Thanks
Ive worked SQL Server for many years. Feel free to email me your questions. If you are learning from the ground up I suggest a more formal type school.