(Gregory A. Larsen) Are you using the standard port number 1433 for communicating with SQL Server 2005? Have you considered setting up SQL Server to listen on a different port number than 1433? Well I did. In this article, I will discuss how I did it and the issues I came across when I setup up SQL
Other News
SQL Server The Truth – Instant file initialisation
(Simon Sabin) This is the first in a series of posts that are aimed at dispelling myths and beliefs as to how SQL Server operates. I have interviewed too many people and have been in too many sessions where statements are made as though they are fact when in reality they are not. Often the reason is
Active/Active clusters in SQL Server
(Hilary Cotter) Multi-instance, Active/Active SQL Server cluster design is an involved process. To optimize high availability and performance, you must consider a number of components in ensuring both instances can run on a single node. I’ll walk you through these considerations including options fo
FIX: The operation takes a long time to finish when you rename a control by using the Properties window in Visual Studio 2005
In Microsoft Visual Studio 2005, you rename a control by using the Properties window in the designer. When you do this, the operation takes a long time to finish.
Creating table partitions in SQL Server 2005
(Tim Chapman) In the database world, partitioning is the horizontal splitting of rows in a table or index defined on a table in separate, smaller logical units. In fact, every table in SQL Server 2005 has at least one partition. You are essentially breaking one table or index up into smaller tables
Tip #5: FAST REFRESHing of Oracle Materialized Views containing Sdo_Geometry columns
(Simon Greener) I will edit this over the next few weeks but I have been doing quite a bit of work on FAST REFRESHing of materialized views based on tables with SDO_Geometries.
An idea: create ha_trace tracing storage engine
(Sergey Petrunia) Our exprience in solving query optimizer problems shows that a good chunk of optimization problems are incorrect choice of join order. The most frequent causes of the problems are –Table engine returns index statistics or records-in-range numbers that are very far from reality;
Day 30 as DBA – Your Suggestions?
Keeping Up With SQL Server One of the issues I have with SQL Server, or managing them and the other things you have to do daily anyway, is that keeping on top of errors, logs and such is a LOT of information to keep track of. If you add to that the fact that you want to keep up with […]
Day 30 as DBA, Call for Questions for DBAs
Webcast: Day 30 as DBA This follow-on to the Day 1 as DBA show will go into the things you can do now that you’re semi-established in your routines. Daily maintenance, auditing, security checks, best practices and more. There is a lot to consider and think about when you’re putting a good foundation in place for your systems, we’ll cover […]
Using the ASP.NET AJAX ScriptMethodAttribute to Return XML Data
(Dan Wahlin) Web Services provide a convenient way to pass data between AJAX applications and a server. ASP.NET AJAX provides an excellent infrastructure for Web Service integration into AJAX applications and makes it all cross-browser through incorporating JSON into the mix. While JSON is compact