How many times have you tried to save a sales order to your database? For many DBAs this is a common scenario and one of the challenges is the many round trips for the various line items. Jacob Sebastian brings us the first part of a four part series looking at how you can use XML to reduce the round trips in SQL Server 2000.
In this session by Brian Knight, he shows you how to create a proxy account for SQL Server Agent to use. Proxy accounts and SQL Server 2005 credentials help you impersonate another Windows account in Agent.
The people that develop SQL Server are very interesting in addition to being some of the top software developers around. Steve Jones
continues with his look behind the development team with an interview with Sameer Tejani.
SQLMaestro has a new version and is offering a discount to SQLServerCentral.com members.
Recent installments of our series dedicated to SQL Server 2005 Integration Services have discussed individual Control Flow tasks. This installment covers one of the few remaining items in this category, the Bulk Insert task.
Data warehousing is being used more and more everyday and longtime data warehouse DBA Janet Wong brings us a short look at
her first project and some thoughts about warehousing in general.
In Part 1 of this extensive series, Wes Dumey starts some of the core concepts of data warehousing. In this video he covers what a data warehouse is, why companies use them and what are some of the key components.
In response to the first part, new author Richard Gardner brings us a few more issues that you should be aware of when planning
your data warehouse.
A short look and some notes from the SQLServerCentral.com site migration.
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Hi, we put together an extract that runs every 15 minutes against what i...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Comments posted to this topic are about the item Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers