We published a very interesting article about data warehousing in the SQL Server Standard awhile back. However the article was abridged and the author, a very respected data warehousing professional asked that we publish the entire thing here. So we bring you Harsh Bhaiya's very popular ETL treatise.
If business today is data, then the entire enterprise is in the capable hands of you, the SQL Server DBA. Before you panic, check out Grant's detailed dissection of SQL 2005 backup and recovery regimes.
Pop provides a cunning, trigger-based technique for auditing the activity on SQL Server tables
Among the most common tasks that have not yet been discussed in this series is the Send Mail task, which will be the topic of this article.
In SQL Server 2005, object ownership will have a different meaning, but since most of us work with SQL Server 2000, Kathi Kellenberger has written a good introduction to understanding how object ownership works and why you might want to follow certain practices.
With a new name, new capabilities, and a new focus, the product formerly called SQL Server Mobile Edition expands its reach to small-footprint desktop applicationsand it's free!
In response to an editorial on eliminating tape in favor of disk backups, new author Tim OPry brings us a look at his environment and the process by which they eliminated the need for tape in their backup scheme while maintaining a well thought out disaster plan.
It's nice to have little amenities in your development tools. They make for easier development and can save you a little time. Synonyms is one of those tools.
Part 3 of Vincent Rainardi's data warehousing series looks at some of the situations and challenges of loading a fact table in a data warehouse.
In response to a number of suggestions, we have setup new forums where you can ask and comment about the various third party products that you use with SQL Server.
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
How I used AI for this postChatGPT to generate images based on info specifically...
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Comments posted to this topic are about the item When the Token Meter is...
Comments posted to this topic are about the item Understanding Temp Tables and Table...
Comments posted to this topic are about the item The Data API Builder MCP...
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers