Keeping track of the performance of your SQL Servers requires metrics. There are many methods for doing this, but some type of automated process is essential these days with DBAs managing many servers. New author Allen White brings us a technique for doing this using SMO, the replacement for DMO in SQL Server 2005.
2006-11-22
5,983 reads
XML really makes it easy to move data from here to there and from there to here. However, eventually the data needs to be stored somewhere, most likely in a relational database. Here is how Edmond Woychowsky gets data from an XML document into a relational database.
2006-11-22
2,803 reads
New author Jambu Krishnamurthy brings us a look at table variables and how they differ from temporary tables in SQL Server 2000.
2006-11-21
16,963 reads
In this lesson, we will expose another useful function in the MDX toolset, the .Ordinal function. The general purpose of the .Ordinal function is to return the ordinal value of a specified dimensional level.
2006-11-21
2,460 reads
Setting up replication can be fairly easy, but deviating from the follow-the-wizard approach can be tricky. New author Claudia Rego brings us a primer on setting up transactional replication without requiring an initial snapshot.
2006-11-20
8,600 reads
Part III of the article series illustrates how to partition an existing table with data into four different file groups.
2006-11-20
3,077 reads
SQL Server 2000 and Access databases can be configured to work closely together. If you find that the Access storage format is not handling your needs and an upgrade is needed, you need not through away all of your access development. Instead, you can link Access tables to underlying tables in SQL Server and improve your application by using SQL Server as the backend for your Access project. Author Kathi Kellenberger brings us her second articles in an Access series looking at Linking tables to
2006-11-17 (first published: 2005-02-23)
45,552 reads
Web synchronization in SQL 2005 enables highly secure synchronization of your merge subscriptions. This feature has been in high demand for many years, and Microsoft has finally delivered. This feature is difficult to deploy, however, so Hilary Cotter provides a tutorial on how to set up this complex feature.
2006-11-17
2,451 reads
As DBAs we try our best to appropriately size a SQL Servers to match the anticipated load. But things change over time and we may find that some databases are overloading the server. When it's time to move your database to a new home on another server, Paul Mu brings us a technique for doing so.
2006-11-16
15,622 reads
Data compression is a great method for maximizing data storage space and making data communication faster. However, compression and decompression of binary data sometimes can be quite tricky. Learn a few useful data-compression techniques.
2006-11-16
1,945 reads
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Comments posted to this topic are about the item Hyperscale Replicas I
Comments posted to this topic are about the item The End of Summer
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers