Source control will allow you to maintain branches in the development of your database, but the subsequent merge isn't pain-free. How can the database developer support the rapid development and delivery of features in an application? Versioning, branching and merging is part of the solution, but what about the rest of the solution?
Today we have a guest editorial from Sarah Wagner that thanks all the people that have helped her become a better DBA.
Here is a short How To article on querying for permissions in a SQL Server database
Since many environments haven't committed to using a source control system, identifying mismatched objects can offer a challenge. Tim Smith offers a solution.
As a data guy, I always smile when application developers refer to ‘their’ data. If only it were that simple.
How did you fall in into your particular career? Was it because of a product? Andy Warren talks about his career evolution and how often we become trapped by the products we work with.
I inherited a database that was getting large and not performing well. After adding primary keys life got better.
It's Developer Week in Nuremberg July 14-17. There are a couple of great speakers at this event, like Constantin Small and Sascha Dittmann. Register while space is available
NEO4J, the graph database, can be used to provide answers that are very tricky for relational databases, including providing diagrams to show how SQL tables relate to each other, and the shortest chain of relationships between two tables, as David Poole demonstrates
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers