This paper discusses how to use several of these features by closely examining parts of the Example Application in the SQL Server 2005 Driver for PHP product documentation in MSDN. This paper assumes that the reader is familiar with programming in PHP, that the reader has a computer that meets the System Requirements listed for using the driver, and that the AdventureWorks example database is installed from CodePlex.
I am modifying a table and I need to add a column that must be defined as being unique. I see that SQL Server allows you to define a UNIQUE constraint on a column but I also see that you can create a unique index on a column. Which one should I use?
In this new SQL School video, MVP Brian Knight shows us how to get started with data mining and Reporting Services retrieving data from an Analysis Services cube.
How many times has someone asked you to determine how many instances of SQL Server are installed on your network? New author Sakthivel Chidambaram brings us a few tricks for keeping track of those installations.
Blogging is increasingly becoming a part of more and more people's lives. But to what extent should it be part of your corporate image? Steve Jones has a few comments about a very interesting blog he found.
This article explores how a DBA can administer and monitor Change Data Capture in SQL Server 2008
It's very important to capture trends of the sizes of your SQL Server 2005 database because it allows you to plan for future space needs, notice types of problems, and plan for time periods of heavy volume. I'll show you the simple method that I use to capture this information.
As DBAs, we don't often deal with the human interface side of the applications that we build, but it is important. And we want to be sure that anything we develop considers the end user's perspective. Steve Jones asks how much should this matter?
As DBAs, we don't often deal with the human interface side of the applications that we build, but it is important. And we want to be sure that anything we develop considers the end user's perspective. Steve Jones asks how much should this matter?
As DBAs, we don't often deal with the human interface side of the applications that we build, but it is important. And we want to be sure that anything we develop considers the end user's perspective. Steve Jones asks how much should this matter?
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Comments posted to this topic are about the item No Defaults Passwords Ever
Hi, We have low latency high volume system. I have a table having 3...
Comments posted to this topic are about the item The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?