|
Home
Browse Sections
Recent Searches
|
|
|
| You are here : HOME > SQL |
 |
 |
SQL For Dummies
Price : $29.99 $16.00
Average
Customer Rating : Not
yet rated |
|
Customer Review :
No review yet |
 |
Microsoft® SQL Server® 2008 Internals (Pro - Developer)
Price : $59.99 $33.77
Average
Customer Rating : Not
yet rated |
|
Editorial Review :
Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes—and capture the product’s full potential. Discover how SQL Server works behind the scenes, including:
- What happens internally when SQL Server builds, expands, shrinks, and moves databases
- How to use event tracking—from triggers to the Extended Events Engine
- Why the right indexes can drastically reduce your query execution time
- How to transcend normal row-size limits with new storage capabilities
- How the Query Optimizer operates
- Multiple techniques for troubleshooting problematic query plans
- When to force SQL Server to reuse a cached query plan—or create a new one
- What SQL Server checks internally when running DBCC
- How to choose among five isolation levels and two concurrency models when working with multiple concurrent users
Customer Review :
No review yet |
 |
Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services (Wrox Programmer to Programmer)
Price : $49.99 $25.00
Average
Customer Rating : Not
yet rated |
|
Editorial Review :
A unique book-and-video package for learning Microsoft SQL Server Integration Services If you need a practical, hands-on introduction to Microsoft SQL Server 2008 Integration Services (SSIS), this book and video package from foremost SSIS authority Brian Knight gets you thoroughly up to speed. Each lesson in the book includes three major components: a thorough description of how each SSIS feature or process works; a tutorial that walks you through the process or technique; and a video lesson that demonstrates it. If you take full advantage of this comprehensive package, you will gain enough experience to tackle your first SSIS project with confidence. - SQL Server Integration Services 2008 (SSIS) builds on the revolutionary database product suite first introduced by Microsoft in 2005 and is a powerful tool for performing extraction, transformation, and load (ETL) operations essential to data warehousing
- If you're just learning SSIS, the step-by-step tutorials in this book and DVD training package will ready you to tackle your own first project
- Every lesson in the book is supplemented by instructional video on the DVD
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Customer Review :
No review yet |
 |
High Performance MySQL: Optimization, Backups, and Replication
Price : $49.99 $27.29
Average
Customer Rating : Not
yet rated |
|
Editorial Review :
How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover. Updated to reflect recent advances in MySQL and InnoDB performance, features, and tools, this third edition not only offers specific examples of how MySQL works, it also teaches you why this system works as it does, with illustrative stories and case studies that demonstrate MySQL’s principles in action. With this book, you’ll learn how to think in MySQL. - Learn the effects of new features in MySQL 5.5, including stored procedures, partitioned databases, triggers, and views
- Implement improvements in replication, high availability, and clustering
- Achieve high performance when running MySQL in the cloud
- Optimize advanced querying features, such as full-text searches
- Take advantage of modern multi-core CPUs and solid-state disks
- Explore backup and recovery strategies—including new tools for hot online backups
Customer Review :
No review yet |
 |
Microsoft SQL Server 2012 Reporting Services 4/E
Price : $50.00 $25.94
Average
Customer Rating : Not
yet rated |
|
Editorial Review :
The Definitive Guide to Microsoft SQL Server 2012 Reporting ServicesCreate, deploy, and manage business intelligence reports using the expert tips and best practices in this hands-on resource. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2012 Reporting Services, Fourth Edition covers the complete process of building and distributing reports and explains how to maximize all of the powerful, integrated SSRS capabilities, including the new and enhanced features. A detailed case study and sample reports are included in this practical reference. - Plan for, install, configure, and customize SQL Server 2012 Reporting Services
- Retrieve data with SELECT queries
- Generate reports from the Report Wizard and from scratch
- Enhance your reports with charts, images, gauges, and maps
- Add value to reports through summarizing, totaling, and interactivity
- Build reusable report templates
- Embed Visual Basic, .NET functions and subreports into your reports
- Enable end-user access to reports via the Report Server and its Report Manager web interface
- Integrate SSRS reports with your own websites and custom applications
- Follow along with sample reports from the book's case study
Customer Review :
No review yet |
|
More
Results : [First] [Prev] 1 | 2 | 3 | 4 | 5
|
|
Questions & Answers
Question : What sort of SQL injection attacks is the MS Access ODBC Driver susceptible to?
Okay I'm replacing all apostrophes ' with double apostrophes '' (not quote marks, two apostrophe characters). This seems to prevent most of my attempts to insert any SQL fails. Can anyone think of any way to insert SQL?
Answer:
Remove NULL characters from input. SQL NULLs are not the same as programming/scripting NULLs, and they may be put in to terminate a line by exception (overflow errors), allowing for the double dash ( e.g.: -- SQL single line comments) to be inserted, which in turn can allow for arbitrary code to follow...Check this page: http://msdn.microsoft.com/en-us/library/ms161953.aspx . They explain it better than I can.
|
Question : Where can I upload an sql database to test?
My website hosting provider doesn't offer mysql services. I've been working with wamp and just want to see if I can work with an online sql database.
Answer:
if you just want to test it then you can apply a free hosting here:http://byethost.com/index.php/free-hostingit support php & mysql.
|
Question : Who uses SQL, What do they use SQL for in the world, When is it appropriate to use SQL database?
Where do you find SQL database servers and how is it implemented? Why do we use SQL vs. Access Query builder or some other form of database system, pros and cons of using SQL?I know there are a lot of questions, but i would like to learn more about SQL - can someone please guide me about this information?
Answer:
SQL stands for Standard Query Language, it is an ANSI standard language that is the basis for most of the large relational databases. It's a relatively small subset of the implmentations available from people like Oracle, Microsoft (SQLServer) and MySQL. They are all different but generally, if you know one, learning the other is fairly easy.The question is not when do you use a SQL database but when do you move to a relational database. My general rule of thumb is that smaller database systems like Access are fine for personal use but when you start writing applications for multiple people, you need to move to a better class of database and that would be a relational database. If you're going to be a database programmer, learn SQL. You can't go too far wrong that way.
|
Question : SQL???????????????????????
who knows a way to learn sql quickly and just the basics of sql
Answer:
The best way is to install a database ( Anything from MySQL to Oracle all have free downloads ) install an IDE ( Eclipse is OK, SQL Developer is really good for Oracle - again both are free to dowload and use ) and then have a go.There are also some web sites which allow you to try SQL online ( http://www.w3schools.com/SQl/default.asp has a tutorial and also a try it type page )Main thing is to understand your data - how things link together and what the data represents. If you know that it makes more sense why you would want to process it in certain ways, or how you can extract data for a given purpose.
|
Question : What application should I use to start learning SQL?
I am moderate with HTML, CSS and want to practice using SQL. What is the best program to begin working on this. I will be downloading the program with torrents, so I have access to pretty much anything. Thank you for your help.
Answer:
Depends on what program you're using to control SQL, and which SQL you're using.I decided on MySQL, using PHP.I recently learned PHP using Adobe Dreamweaver. It's a pretty cool program, except it's super heavy on CPU usage, for no apparent reason.Also you'll want WAMP server to test your MySQL database and PHP programs.If you have some OOP (Object Oriented Programming) experience, such as C++ or Java, and you're very committed, you can learn PHP completely in about 2 or 3 weeks.I learned by following along with the free flash tutorials from this site. It was absolutely fantastic, and I am amazed it's free.http://www.killerphp.com/It's tough, but if you watch the video tutorials from start to finish, and code alongside, you'll finish knowing everything you need to know about using PHP with SQL.Feel free to Email or IM me any questions about it.Email: kaptinn@gmail.comAIM: Kaptinn KyleMSN: kaptinn@gmail.comYahoo IM: kaptinn@ymail.com
|
Question : what IS the difference between oracle and Sql?
i know Sql. In my resume i have mentioned it as oracle by mistake. I fear if the interviewer asks me the questions from oracle instead of Sql . IS there really lot of difference between Sql and oracle .
Answer:
For a programmer there is very little difference (Google "Oracle specific SQL")Still, read some on Oracle before your interview...
|
Question : How do I set up SQL Server so I can access it from another computer over a network?
I want to be able to access my SQL Server on my computer from another computer on the network.Both computers have SQL Server installed now I just need to know how to configure the Host system and what ports I need to open on the firewall for example.Thanks.
Answer:
To access from computer A to computer B, you can register/Connect B on A. default port 1433. SQL Server 2000: on Computer A, open Enterprise Manger, right click SQL server group-->New SQL server registration.. follow the instruction.. SQL 2005 SQL Server Mangement Studio, just connect computer B directly or register...If you want to join database tables between computer A and computer B, your best answer is to create linked server. on SQL 2000: security->linked server-->new linked server; on SQL2005: server objects-->linked server... From any database in computer A, You can refer or join tables on computer B as linkedserverB.dbname.dbo.tablename
|
Question : SQL Server: How do I determine the security group through which a user is granted permission?
In SQL Server, a user in my domain is able to access a database because they are a member of a particular security group. How can I determine the security group that this user is a member of and therefore is gaining access?
Answer:
From your question, I'm a little unsure of what you mean by security group. If you mean group on the domain, you'll need to obtain a list of groups the user is assigned to (Active Directory?) and then trace these back to your server to see which group has been granted access.If you mean SQL Server security group, without knowing which version of SQL Server you have installed these instructions may be incorrect but I'll assume you have a 2005 instance.Log on to the server in Management Studio and then expand the "Security" folder. You can then expand the "Logins" folder which will list the domain users (and groups) that have access granted for parts of the SQL Server. Double clicking the user (or group) will then allow you to configure the access in further detail and also view the server roles for that user.As another approach, you could also right click on the server instance in Management Studio, view Properties and then look at the permissions tab (it should be the last one on the list). This will also allow you to view the user permissions.Hope this helps.
|
Question : Is it slower to close and open a SQL Server connection instead of keeping it open?
Hi! I'm developing an application with VB.NET which will be connecting to a SQL Server database, no other application will be connected to the database so I've got the following question: How will it be faster: closing and opening a connection when needed or keeping the connection open? I know that when many users connect the first option is better but since It will be only one user, which option is the best one?Thanks and blessings since now!
Answer:
Hi,What is the latency between the app server and the database? If the two servers are connected together on the same 100Mbps or better switch, you'll do fine with the non-persistent connection. However, if your app server is in one data center and the other elsewhere consider using a persistent connection.Regardsjoe@unixy.netFully Managed Dedicated Servers and Virtual Machines - http://www.unixy.net
|
Question : sql???!!!?
i used a Vector object in java prgramming and an ecxeption "array endex out of bound " occured when i wanted to fill it with integer elements, what should i do???plz help....thanks...
Answer:
Perhaps you are assigning a negative number to your index, or you told the program to access an index which isn't there, test the program by printing the index numbers the program is being assigned, and find out where your variables are in the vector, good luck!
|
Powered by Yahoo! Answers
|
|
