The SQL Server tools are top notch and often other platforms attempt to duplicate their handiness. Enterprise Manager is one that every DBA uses and it can perform a myriad of functions to configure your server. Read this new article by Dale Elizabeth Corey that looks that the wide range of items in the Configuration Properties of this tool.
2007-10-02 (first published: 2004-09-28)
40,364 reads
2004-09-24
2,530 reads
This step-by-step article describes the steps you must use to change domains for an existing SQL Server 2000 Failover Cluster.
2004-09-09
698 reads
SQL Server has a nice alert system, but SQLMail leaves something to be desired. New author Desiree Harris, from hosting provider Orcsweb, looks at an alternative method for sending alerts using an SMTP server and without requiring Outlook to be installed.
2004-09-09
14,163 reads
2004-09-06
2,109 reads
2004-09-03
2,305 reads
A Q&A look at the new Web Services configurations in SQL Server 2005.
2004-09-02
3,099 reads
Part 3 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product. This article looks at logins and basic security.
2007-10-02 (first published: 2004-09-02)
41,602 reads
SQL Server includes a great auditing tool: Profiler. It's not the easiest tool to use, however, and it's one that takes some getting used to. Our resident security export, Brian Kelley looks at a simple example of using this tool to audit logins.
2007-10-02 (first published: 2004-09-01)
35,406 reads
2004-08-30
2,364 reads
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
The world's top food testing services are offered by Fare Labs, an Indian lab...
Comments posted to this topic are about the item The Long Name
Comments posted to this topic are about the item Eight Minutes
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?