Working With Numbers in PHP
One of the most important things to consider in using arithmetic operators is operator precedence, that is, the order in which the operations are performed. 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 ...
Microsoft SQL Azure - Microsoft Takes SQL Databases to the Clouds
SQL Azure provides data storage in the cloud, much like Amazon S3 and many Google Apps. One of the big advantages for SQL Azure is that relational queries can be made against data stored in the cloud, regardless of whether they are structured. More ...
The Entity-Relationship Model
After you have a data model that meets the organizations business requirements, the easiest way to transform that model into a relational database is to first transform that model into an entity-relationship model. 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 ...
Language Integrated Queries (LINQ) and Visual Basic
LINQ is a better version of SQL - it is a part of ADO.NET and is integrated with VB.NET. LINQ now has the long missing option of using Visual Basic functionality in the data selection process. 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 ...
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 ...
Introduction to SQL Database Design
A Database is the storage of data in what are called tables. Without knowing what kind of data you are planning on storing, you will not know how to create the tables. 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 ...
