Use Perfmon and SQL Profiler Together to Troubleshoot SQL Server Performance Issues
A great technique for troubleshooting SQL Server performance issues is to use Perfmon and SQL Profiler together. Each tool give you insight into what is happening with your database server, but combined they can narrow down your performance issue to specific events or statements. More ...
Common Features of NoSQL
Four core features of NoSQL apply to most NoSQL databases: a schema isn't required, no relationships between records, cheap off-the-shelf servers can be used, database can be distributed accoss servers. More ...
How to Connect to an Unresponsive SQL Server: Direct Admin Connection
When SQL Server stops responding but is still, the first impulse is to reboot SQL Server. This may stop the symptom, but will not tell you anything to help you prevent the cause. More ...
Working With Strings in PHP
Computer programs usually work with some form of data. One of the most common forms of data used in PHP is a text character or an array of text characters. An array of text characters is called a string. More ...
Gettting Started With MySQL Database
MySQL is a powerful relational database management system. The fact that MySQL is used by many major organizations such as Yahoo, NASA and the U.S. Census Bureau proves that it can outperform the big name database management systems. More ...
SQL 2012 Data Tools
Data Tools (SSDT) is a tool set designed for use by Microsoft with SQL Server and SQL Azure to facilitate database design. Features include business intelligence (BI) tools, rapid data discovery, and data warehousing, among others. More ...
Build Relational Databases in Seven Steps
Many web applications revolve around a relational database. So to create a good application design, you should always create a good database design. Database design is a step-by-step process. More ...
Database Management Basics - What You Need to Know
When they start throwing terms around like schema, SQL, transaction processing or relational design, wouldn't you like to understand what they're talking about? More ...
Run PHP From Flash Key With Server2go
Do you want to learn (or teach) PHP and / or MySQL, but don't want to install a web server + PHP + database on your PC? Server2go is a neat little application that you can put on a USB flash drive and run your PHP MySQL webpages from there. More ...
Entity-Relationship Diagrams
An entity-relationship (ER) model represents the structure of a database, where data equates to entities (or objects) that are linked by relationships expressing dependencies and requirements. More ...
