Change Data Capture is a new feature of SQL Server 2008 that can help you better handle your ETL systems. New author Suresh Yaram brings us an introduction to CDC and how it can be setup in your environment.
In this SQL School video, MVP Brian Knight dives into the Execute SQL task in Integration Services. You will learn how to add parameters to this task to customize its behavior.
For this Friday's poll, Steve Jones asks about what absolutes you might have in your job.
For this Friday's poll, Steve Jones asks about what absolutes you might have in your job.
For this Friday's poll, Steve Jones asks about what absolutes you might have in your job.
For this Friday's poll, Steve Jones asks about what absolutes you might have in your job.
Auditing data changes in your production environment is very important, especially if you are dealing with confidential information.
I'm designing a table and I've decided to create an auto-generated primary key value as opposed to creating my own scheme or using natural keys. I see that SQL Server offers globally unique identifiers (GUIDs) as well as identities to create these values. What are the pros and cons of these approaches?
Agile, or maybe even hyper-agile. Steve Jones talks about some challenges in the web 2.0 world.
When a project is completed, one of the next steps is to roll this project out to the production environment. However a good rollback process is important to ensure that you can remove those changes if there are problems. Longtime author David Poole talks about how he handles this.
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