Application Developers don’t own their data
As a data guy, I always smile when application developers refer to ‘their’ data. If only it were that simple.
The Product Centric Career
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.
Why Primary Keys can be important on large tables
I inherited a database that was getting large and not performing well. After adding primary keys life got better.
Developer Week - Nuremberg, Germany
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
Experiments with NEO4J: Using a graph database as a SQL Server metadata hub
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
Lockdown or Let Them Free
Do we take security too far? Are we creating unnecessary rules for those that need to use the resources we support? Steve Jones talks today about security and how we might want to approach it when handling rights for developers.
Running SQL Server Databases in the Amazon Cloud (Part 1)
In this tip, Sadequl Hussain outlines what's involved in rolling out a SQL Server instance in RDS. In subsequent tips, he will explore what features it offers and what shortcomings it has.
Less and Less Visual
Phil Factor ponders the preponderance of text in current database tools, and asks what happened to our glorious graphical future?
Continuous Delivery and the Database
Continuous Delivery is fairly generally understood to be an effective way of tackling the problems of software delivery and deployment by making build, integration and delivery into a routine. Phil Factor explains why he's an enthusiast for databases being full participants in this story, and suggests practical ways of doing so.
Blogs
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers