Browsing articles in "Data"

Toronto SQL Server User Group PASS Summit Discount Code

image

 

Many Toronto User Group members will be attending the PASS Summit in November in Seattle Washington, including me.  If you work with SQL Server, this is the only community-driven event for SQL Server training, presentations, workshops and networking.

Would you like to join us?  Use our PASS Summit Discount code / Coupon / promo code:

CASUMG64

You can register now at  http://www.sqlpass.org/summit/2014/RegisterNow.aspx and use the code to save $150 off full registrations.  If you register before 27 June, you’ll get the best discount you can get right now and the Toronto User Group gets $50 to fund our meetings which start again in September.  That’s right: you save some dough and our user group gets funding for our upcoming season that starts in September 2014.

If you can’t register now, no worries.  You can still use our chapter code later. 

Feel free to share this information with colleagues, even the discount code.  The more the merrier. And the better you can love your SQL Server data.

Big Data, NoSQL and Data Modeling: Big Challenges in Data Modeling

Jun 24, 2014   //   by Karen Lopez   //   Blog, Data, Data Modeling, Database, Database Design, Events, NoSQL, Speaking  //  1 Comment

Database table

Big data and NoSQL have led to big changes In the data environment, but are they all in the best interest of data? Are they technologies that "free us from the harsh limitations of relational databases?" as I recently blogged about at Dataversity.net?

In this month’s webinar (register now), we will be answering questions like these, plus:

  • Have we managed to free organizations from having to do data modeling?
  • Is there a need for a data modeler on NoSQL projects?
  • If we build data models, which types will work?
  • If we build data models, how will they be used?
  • If we build data models, when will they be used?
  • Who will use data models?
  • Where does data quality happen?
  • Are there NoSQL technologies for which data modeling will never apply?

Finally, we will wrap with 10 tips for data modelers in organizations incorporating NoSQL in their modern data architectures.

Join NoSQL expert extraordinaire Dan McCreary ( blog ) and others (including YOU!) as we talk about the future of data modeling and data modelers this Thursday, 26 June, at 2PM EDT.

We’ll also have some prizes to give a way, so plan on attending live.

 

(BTW, don’t get me started on the lame modeling styles/naming standards in stock photography.  Maybe I should start making some for Getty Images?)

This Thursday, Big Challenges in Data Modeling: The Need for Speed #BCDModeling

May 20, 2014   //   by Karen Lopez   //   Blog, Data, Data Modeling, Events, Project Management, Speaking  //  1 Comment

 

clip_image001

22 May 2014, 2PM EDT
Register: http://www.dataversity.net/may-22-webinar-big-challenges-data-modeling/ 

It’s May, which sets this former Hoosier thinking of racetracks and Indy cars. I’m also a runner and that means I’m always thinking about pace and timings…and feeling guilty about not training hard enough.

This got me musing about how data modelers can speed up the data modeling process — not just during a development projects, but at all points in our work day. So let’s have a discussion about

In this month’s webinar, we’ll talk about:

  • The Need for Speed
  • Sprints, marathons and training
  • Race cars, horses, carts, and feet
  • Qualifiers and Races
  • Pace cars
  • Backseat drivers
  • Rules, tickets and enforcement
  • Fads, gadgets and automation
  • Red, yellow, green and checkered flags
  • How do you know when to stop racing?

 

Joining me in the discussion will be two wonderful panellists:

Donna Burbank

Donna Burbank, VP, Information Management Services at Enterprise Architects ( @donnaburbank )

Carol Lehn

Carol Lehn, MDM Database Designer at PepsiCo ( @lehnca )

And as usual, our attendees will have the opportunity to participate via chat and Q&A as our final panellist.

Register: http://www.dataversity.net/may-22-webinar-big-challenges-data-modeling/

Big Challenges in Data Modeling: Ethics & Data Modeling–24 April

Modeling with Graeme

I have a great topic and panel for this month’s Big Challenges in Data Modeling webinar on Thursday, 24 April 2014, 2:00 PM EDT. It’s free, but you have to register to get the log in information.

Ethical Issues in Data Modeling

We’ll be talking about the nature of ethics, data and data modeling.  I bet all of you have been placed in a tough situation before, either by other IT professionals or by business users who ask you to do something that you aren’t sure is ethical.  Maybe it’s legal, maybe it isn’t.  Maybe it’s about protecting data or data quality.

Some of the topics I hope we can discuss:

  • What is the nature of ethics?
  • How do ethics differ from morality? Legality?
  • Can ethics be taught?
  • Where does ego come into play here?
  • What about Codes of Ethics and Codes of Conduct?
  • Is there one right answer? Is there an always wrong answer?
  • What’s the difference between a whistleblower and a tattletale?
  • What tools do we have in making ethical decisions?
  • How should we deal with unethical co-workers? Management? Customers?
  • What does it all mean, anyway?

Ethical Situations in Data and Data Modeling

  • If the answer is always “it depends”, what does it depend on?
  • What if faster data means lesser data quality?
  • Have you ever been asked to falsify a status report?
  • Have you had to deal with someone else who provided incorrect information to a business user or management?
  • Have you ever been asked to look the other way when security policies are being broken?
  • Have you raised an issue of data protection that was ignored? Or minimalized?
  • What about using production data for testing and development?
  • What if the data is right, but the transformations or reporting is wrong?
  • What if it’s intentionally wrong or misleading?
  • Have you ever had to deal with someone else’s ego?
  • Have you escalated an ethical issue? What about a legal one? A moral one?
  • Do data modelers have distinct areas that we need to watch out for when it comes to ethics?
  • Have you ever left a job or project due to ethical reasons?

 

Panelists

Len Silverston (http://www.univdata.com/ | @lensilverston ), author of Universal Data Models I, II, III, speaker, coach, consultant, trainer.

 

 

Denny Cherry, (http://dcac.co/ | @mrdenny ) author of Basics of Digital Privacy, Securing SQL Server and other books, speaker, consultant and trainer.

 

 

Tamera M. ClarkTamera Clark (http://clarkcreations.net/blog/ | @tameraclark ) speaker, volunteer, Business Intelligence expert

 

Kerry Tyler, (http://www.airbornegeek.com/ | @airbornegeek ) speaker, volunteer, Business Intelligence Developer.

 

 

image

YOU! Our webinars consider attendees as panelists. You’ll have the opportunity to ask questions, chat with other attendees and tell your own stories. You can even arrive early and stay late for our pre-show and after-show discussions. 

 

 

Register now and bring your ethical questions and comments.

SQL Server 2014: New Datatype

Apr 1, 2014   //   by Karen Lopez   //   Blog, Data Modeling, Database Design, DLBlog, Fun, Parody, Snark, Space, SQL Server, WTF  //  18 Comments

image

Today is the general availability release date for the newest version of SQL Server, aptly named SQL Server 2014.  I’m excited about many of the new features being rolled out today, but the ones that will impact data architects, modelers and database designers are the new datatypes that will be introduced.  But first, for those of you who have their heads stuck in the deep piping and spit-managing of databases, some background about datatypes:

A datatype is a categorization of data items, based on the range and types of data that it can contain and a set of actions that can be validly taken against that data.

As such, applying a datatype to a column in a database makes it work as another type of constraint.  A tinyint column can’t hold my Starbucks name (Kitty) because it constrains the values to integers and only a subset of all integers, for example.

The number and type of datatypes (yes, I’m being meta there) varies depending on the strength and quality of the tequila the DBMS product management teams were drinking at their last Vegas Blow Out team building retreat, as called for in the ISO Standards for databases, AKA

ISO/IEC JTC 1/SC 32 – Data management and interchange.  

One of the things that developers and DBAs will tell you is that choosing the right datatype is important for performance reasons.  And by that, they mean the smallest datatype you can fit most of the data in. And maybe a bit smaller.  Soooo much bad info out there, I know.  When Knowledge Conquers Fear, we can love our data.  Thank the Cosmos you have me here to help you out.

What’s new in SQL Server 2014: A New Datatype

This new datatype is exciting for me as a data & space enthusiast.  The new feature finally allows modern database designers to properly specify the constraints for tracking time and location data in the same column. Yes, this means that your developers and DBAs no longer have to use comma-delimited values in their relational database designs when they need to track how much time and personal space they need to get up to speed on professional database design.  And it’s big enough to store that many man-hours.  Yeah. I said that.

BTW, it seems that Stack Overflow is *the* place to find info on how to implement comma-delimited values in database columns.  Kids, don’t get your database design knowledge from random forums on the Internet.

Anyway, back to the news!

The new feature makes so much sense with Microsoft’s push to the Cloud, it’s embracing of NoSQL technologies and all.  It’s AWESOME.

 

spacetime (Transact-SQL)

Defines a time and location in a universe.

SQL Server 2014

spacetime Description

Property

Value

Syntax

spacetime [(fractional seconds precision)], (universe, 5DGeometry)

Usage

DECLARE @MySpacetime spacetime (1000, 2014.12.0.2000.8,  image )

CREATE TABLE Table1 ( Column1 spacetime (1000, 2014.12.0.2000.8

image ) )

Time Range

to +∞ and beyond
(I hope you have lots and lots of memory and storage)

Space Ranger

@cmdr_hadfield

image

Universe Range

Please check data.NASA.gov for the up-to-date listing of known Universes Multiverses, as this changes beyond Microsoft control. There is no control. There is no center.

5DGeometry Range

[you’ll need a 5D monitor to view this range.]

Timezone offset range

Thank Venus, no, nope, never. We are scientists here. Use Multiuniversal Universal Time Coordinates (UTMC).

Daylight saving aware

Oh, for Carl’s sake. Do you really think something like spacetime needs to be sullied by DST?

Storage size

If you have to ask, you don’t ever need to use this datatype. Seriously.

Accuracy

+/- 10 Plancks. Depending on how far your server is from the Sun. Earth’s Sun, that is.

Default value

1989-05-15 12:00:00.1000  2014.12.0.2000.8 SNAGHTML5a35643

Calendar

Hubble

SQL Azure Windows Azure Dammit!
Microsoft Azure DB Support
Yes, of course.  But only in Premium plans and higher. 

 

Special Considerations and Gotchas

Some gotchas with this new datatype:

  • Due to the highly multi-dimensional, multiuniversal nature of this datatype, there isn’t any backwards compatibility.  Unless, of course, you can fold spacetime and go back and change earlier versions of SQL Server. But if you could do that, you wouldn’t be reading my blog, would you?
  • Just like the confusion over timestamps, you can’t really treat this like a date or time datatype.  It’s special.  And spatial. 
  • This means you can’t convert it to date, time, datetime, timestamp or spatial datatypes, either.
  • The 5D geometry thing is way too complex to explain in a single blog post.  But for those of you that managed to stick it out through some college level math, it involves parsecs (the correct usage of the term) and the double declining balance method of space depreciation.  In this first rollout of spacetime, the geometry completely ignores most OctoDeca Bands.  Except for Miller tracks.
  • You can’t use normal date and geometrical math on data in the columns. You can bend or fold the values, but since space has no center, and time has no beginning or end, spacetime has no beginning or end. It is infinite.  So the usual infinity rules apply.
  • This datatype is only available via O365, but that makes sense since as announced today, SQL Server 2014 is also only available via O365 subscriptions.
  • This datatype is only available at O365 plans at U3 and higher.  Wait, I don’t think I should have said anything about the new Universe O365 plans.  Forget I said anything.  That’s probably not going to be a rule in our universe.  Seriously.  No NDA broken.  I think.

 

Note

Some of this post may have been inspired by some bad veggie April Fish (poisson d’avril) I had last night.   If you want to get some real information about the new features of SQL Server 2014, you probably shouldn’t read random blogs on the internet on launch day.  Especially when it’s 1 April.

Did you catch all the special references in this post?  Let me know.

What about XP, Agile, SCRUM, Lean…? #EDW2014

Mar 31, 2014   //   by Karen Lopez   //   Blog, Data Modeling, Events, Speaking  //  No Comments

At the upcoming Enterprise Data World 2014, I’ll be doing a half-day presentation on Driving Development Projects with Enterprise Data Models

Here are a few teases for what we will be talking about:

image

image

image

 

The Abstract:

Monday, April 28, 2014
08:30 AM – 11:45 AM

Level: 
Intermediate

Join this session to see how data fits in real-world enterprise development projects. We’ll answer such questions as:

  • "Who does what?"
  • "Why are we doing this?"
  • "Will it slow things down?”
  • “Will it work with agile development?”
  • "Will I have to actually talk to a data architect?"
  • “What about the Cloud?”
  • "What are the biggest mistakes teams make?"
  • "Will I still have a job?"

The session will feature demos of common data modeling-to-database processes, including reverse engineering, forward engineering, generating DDL, alter scripts, and more. You will leave with 10 tips for making model-driven database development successful in your organization’s culture and environment.

Subscribe via E-mail

Use the link below to receive posts via e-mail. Unsubscribe at any time. Subscribe to www.datamodel.com by Email


Categories

Archive

UA-52726617-1