| A community of more than 1,600,000 database professionals and growing |
| | | Have You Designed a Database from Scratch? One of the things that I try to regularly promote is the #SQLNewBlogger project from Ed Leighton-Dick (and #SQLNewBlogger hashtag on Twitter). In keep a column open scanning for the tag and try to respond to those that post. I also write a series of posts under that tag, mainly beginner type posts, that showcase things I think are good, basic topics that I'd want a DBA or developer to know about SQL Server. These are exactly the types of posts that you write for your next resume (or next hiring manager). I saw recently someone begin their blogging journey with a new post about designing a database. What struck me was this person with a lot of experience noted they had never designed a database from scratch. I'm sure that most of you have worked with a database, and have even modified various objects inside of a schema. Certainly you've changed the code of stored procedures or functions. I'm even sure many of you have modified tables, adding columns where you need them. After all, that's a favorite first technique for many people that need a place to store data. Probably the majority of you have built tables, at least temporary tables. I'm sure you spent a few minutes thinking about the columns, datatypes, etc. I'd also hope that most of you have added indexes and constraints to tables. Those are certainly skills that more people should better understand, especially the developers that work on software powered by SQL Server. Above all, please learn how to index OLTP tables. However, have you designed a database from scratch? Not a standalone database, but a database the actually has an API or application built against it. Have you tried to use the database and found places where your modeling was lacking? Did others complain about your design? I know that lots of school coursework requires people to design parts of a database, but what about a full, complete database. One that fulfills the requirements to actually manage a set of data well? I've done a few, though admittedly, with input and help from other DBAs and developers. I am better for that, and I think that a good design requires some interaction and input from others. With that in mind, whether you've built one or now, what about tackling this as a project for your own blog? Certainly there are some good problem sets out there, but I'd actually give you a new one if you'd like. The SQL Saturday site for PASS has a database behind it. How would you design a database, given the requirements that you need to support that site, and actually generate out the XML feed for the Guidebook app? Maybe that would be a fun, multi-part series that looks at your decisions for the various entities required. You'd learn something and get lots of feedback. If you're like to publish a series here at SQLServerCentral, let us know. We'd love to have some design series on databases that back applications, especially if you have a side project with an application. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| | The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.2MB) podcast or subscribe to the feed at iTunes and LibSyn. The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT | | | | Feeling the pain of managing & deploying database changes by hand? New Redgate ReadyRoll creates numerically ordered SQL migration scripts to take your schema from one version to the next. Try it free. |
| | | | SQL Toolbelt – everything you need to work with SQL Server Redgate’s SQL Toolbelt contains the industry-standard tools you need to make you and your team more productive, to protect your data and manage performance, and to include your database in agile processes. Find out more and download your free trial. |
| | | | Database Lifecycle Management for ETL Systems Few databases are self-contained. They take data from other sources, and publish them to downstream consumers of data. These ETL processes tend to grow in an unplanned organic way and so tend to cause trouble both in production and in deployment. Matthew Skelton explains how Database Lifecycle Management can help teams ensure that ETL systems meet all requirements. Read article now. |
|
|
|
| | | | | Jason Shadonix from SQLServerCentral.com The concept of a synonym was introduced in SQL Server 2005. Synonyms are very simple database objects, but have the potential to save a lot of time and work if implemented with a little bit of thought. This article discusses what exactly a synonym is, and a few examples of how to use them. More » |
| | Additional Articles from SimpleTalk You can mould PowerShell to the way you want to work, with all the settings and modules that you require, by using the profiles. Profiles are PowerShell scripts that run at startup, and once you have understood where they are and when each is used, they have a whole range of uses that make using PowerShell a lot more convenient. More » |
| | From the SQLServerCentral Blogs - The RGESteve Jones from SQLServerCentral BlogsI first heard this little acronym from Grant Fritchey. He used it when talking about backups and restores, and I... More » |
| | Andy Warren from SQLServerCentral Blogs I hope when you’ve read all of this post that you’ll think that I’ve added to the discussion and not... More » |
|
|
| | | Today's Question (by Steve Jones): I have this JSON document: { "firstName": "John", "lastName": "Smith", "age": 25, "address": { "streetAddress": "21 2nd Street", "city": "New York", "state": "NY", "postalCode": "10021" }, "phoneNumber": [ { "type": "home", "number": "212 555-1234" }, { "type": "fax", "number": "646 555-4567" } ] } If I want to query this document (stored in a variable @d) for the complete address, which path would I include in place of XXX in they query below: SELECT * FROM OPENJSON(@d, 'XXX') |
Think you know the answer? Click here, and find out if you are right. We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: JSON. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| Yesterday's Question of the Day |
| | |
| | | | S M from SQLServerCentral.com This script uses the Exchange snap-ins to send email. Open Powershell ISE. Copy the script and add the correct email addresses. More »
|
|
|
| Database Pros Who Need Your Help |
| | Here's a few of the new posts today on the forums. To see more, visit the forums. Maintaining Latin characters in SQL BULK INSERT with Format File - I'm trying to import a .CSV file into a SQL Server table using a BULK INSERT with a format file.... Change Port of a Default Instance - I'm trying to test changing the port on a default instance to something other than 1433. I don't want to... SQLCMD 2014 using NTLM instead of Kerberos - We are having an issue on multiple servers where running the below command using the 2014 version of sqlcmd.exe returns... converting UDF to be memory optimized - Hi, I have been reading links relating to the fact that instead of using table variables, then I should be... Scalar Function - Format Numbers - Hi I have this function [quote] CREATE FUNCTION [dbo].[fnFormatMobileNumber] (@phone VARCHAR(15)) RETURNS VARCHAR(15) AS BEGIN DECLARE @Formatted VARCHAR(15) IF (LEN(@phone) > 10) SET @Formatted = '0' + SUBSTRING(@phone,3,9) ELSE SET... Tables, Primary Keys and Clustered Indexes - It has always been my opinion and understanding that the best way to build a table is to start with... Update a column in one table based on a not null value in a joined table - I am doing a left join and I'd like to update a Boolean column in the left table based on... sql server read consistency how to maintain which update it - hi can any one explain when one update statement access a record and select statement want to access the same... Missing filenames/locations for full backups in the restore dialogue - Hi all, I have created maintenance plans and scheduled them to backup the transaction log every hour and make full backups... peer to peer replication PK violation issue. - I have configured peer to peer replication for two nodes. i have initialised the subscription from backup. Both the nodes are sync... Cannot Start SQL SERVER AGENT - My login Dom1\mylogin is added to the sysadmin role but when I try to run the SQL Server Agent I... Convert snippet from VBA to SQL - Hello, I have a small If statement that I would like to ask for help to convert it to SQL... Gaps and Islands with previous possible values - Hi there, [code="sql"] create table TestData (ID int, TestDate date, Score int) insert into testdata Values ('1','1-Jan-16','10') insert into testdata Values ('1','5-Jan-16','15') insert into testdata Values... Concatenate strings - In my sample code, at the end i want @database to be A,B,C. I am not able to concatenate them. [code="sql"] DECLARE... Cannot enable Database Mail XP - I'm trying to turn on Database Mail. I set the flag in db_config, did the reconfigure, and for good measure stop/started... How to get this lay out by GROUPING? - Hi Friends, I need to group few of the columns to show in the report as single entry since it can... How to set up a ODBC data source in SSIS to extract from Intersystems Cache database? - I'm running SQL Server 2005 SSIS and trying to extract data from an Intersystems Cache database. My connection is through... Case SQL statement - I am editing a case statement and it seems the last section using .5 is not being used. Can you... SQL in SSIS - I have an SSIS package where I gather servernames within execute sql task. Then I have a for each loop which... Spam Spam Bacon and Spam - Wow the spam is just raging out of control again. It seemed to be under control for a few months... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected]. | This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here. | This transmission is ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected] |
|
|
