Browsing articles tagged with " Event"

Join me at DellWorld 2016 in Austin, TX

Aug 15, 2016   //   by Karen Lopez   //   Blog, Cloud, Data, Data Modeling, DLBlog, NoSQL, Professional Development, SQL Server  //  1 Comment

Dell World 2016 logo
I will be attending DellWorld 2016 as an influencer/media/analyst participant. This means that I’ll get access to the regular sessions, plus special engagements with product teams to see what they’ve been working on recently and what they want to do in the future. I’ve attended a couple of Dell on-site events and am looking forward to talking to key customers and real-world, hands-on data professionals. Also, doesn’t everyone want to visit Austin as much as possible?

If you will be attending Dell World, let me know. I hope we can #selfie. Or just have a real conversation. Or we can get breakfast tacos.

TECHunplugged Austin 2016

Feb 2, 2016   //   by Karen Lopez   //    //  No Comments

On 2 February I’ll be speaking at TECHUnplugged Austin, Texas. This event, which has free registration, focuses on how technology innovation is changing business and IT.

TECHunplugged logo

TECHunplugged is a full day conference focused on cloud computing and IT infrastructure.

Its innovative formula combines three essential parts of the industry for an exceptional exchange of information, insights and education:

– A group of independent, insightful and well-recognized influencers
– Leading disruptive technology vendors,
– End users who manage rich technology environments.

The ultimate goal of TECHUnplugged Conference is to bring quality information to IT decision makers by bringing them together with independent influencers and industry vendors, to engage, debate and be informed through open discussions on topics such as IT infrastructure, virtualization, cloud computing and storage.

I’m going to be talking about how data has changed over the years and how data quality issues can become obstacles to business innovation.

If you are in IT and would like to attend, use the registration form below. If you use my special code, you’ll be entered to win a special prize of an Amazon Echo (I SO LOVE MINE!) at the event.

My promotional code is:


Yes, all lowercase.

Hope to see you there!

7 Databases in 170 Minutes: Workshop at NoSQLNow!

Jan 26, 2016   //   by Karen Lopez   //   Blog, Database, Database Design, DLBlog, Events, NoSQL, Speaking, Training  //  No Comments


My friend Joey D’Antoni ( @jdanton | blog ) and I will be giving a workshop at NoSQLNow! about new database and datastore technologies like Hadoop, Neo4j, Cassandra, Vertica, Document DB, and others.  This will be a fast-paced, demo-heavy, practical sessions for data professionals.  We’ll talk about where a modern data architecture would best use these technologies and why it’s not an either/or question for relational solutions in a successful enterprise. And, as always, our goal is to make the time we spend fun and interactive.   This session will be a great starting point for some other session on Monday that go into data modeling for NoSQL as well as for all the other in-depth, database-specific talks the rest of the week.

Sunday, April 17, 2016

imageWe’ve been busy keeping relational data consistent, high quality, and available. But over the last few years, new database and datastore technologies have come to the enterprise with different data stories. Do we need all our data to be consistent everywhere? What does data quality mean for analytics? Will we need relational database?

Learn how traditional and new database technologies fit in a modern data architecture. We will talk about the underlying concepts and terminology such as CAP, ACID and BASE and how they form the basis of evaluating each of the categories of databases. Learn about graph, Hadoop, relational, key value, document, columnar, and column family databases and how and when they should be considered. We’ll show you demos of each.

Finally, we will wrap up with 7+ tips for working with new hybrid data architectures: tools, techniques and standards.


Use code “DATACHICK” to save:

$100 off for  Tutorials Only + Seminar Only Registration and $200 off for Full Event, Conference+Tutorials, Conference +Seminar, and Conference Only Registration.

Super early registration ends 29 January, so take advantage of both discounts now (yes, they stack!).

Join us at #SQLBits: Designing for Performance Training, with Video and Snark

Jan 6, 2015   //   by Karen Lopez   //   Blog, Database, Database Design, DLBlog, SQL Server  //  No Comments
At SQLBits

I’m excited to announce that Thomas LaRock (@sqlrockstar | blog) and I will be presenting a full-day Training Day (PreCon) at SQLBIts XIV in London, UK.

Our session, Designing For Performance: Myths and Misunderstandings, is going to feature hands-on labs, exercises and lots of challenges to help you master your own SQL Server superpowers. It will be held on Thursday, 5 March 2015. Registration is open NOW.





Everyone agrees that great database performance starts with great database design. So why do so many poorly designed databases exist in the world? Attend this session to understand why bad designs will always exist, what you can do to avoid them, and how best to work with them when needed.
Discussion topics will include:

  • Server/Infrastructure design
    • VM/Server configuration
    • Physical file layouts
    • HA/DR options
    • Archiving
  • Database/Table design
    • Table design
    • PK/FK choices
    • Index strategies
  • Benchmarking
    • Monitoring for performance
    • Control reports

Attendees will leave this session with an understanding of the following:

  • Why common issues are so common
  • How to better anticipate issues before they happen 
  • How to deploy and implement design choices that benefit everyone
  • Proper performance benchmarking and control reports


SQLBits Superheroes


This will be my 3rd SQLBits conference,  They are a lot of fun and jam-packed full of learning and networking.  As you can see from the video above, Tom and I will also ensure that you aren’t just sitting through 8 hours of bullet points and sparse slides with funny pictures.  We’ll be talking about what design approaches work in what situations and all the myths and misunderstandings out there about database design and configurations.

Register now and engage your own superpowers. Or just stand there looking pretty.  It’s up to you.

Get Your Data Lovin’ On: SQL Server 2012 Virtual Launch Event

Mar 6, 2012   //   by Karen Lopez   //   Blog, Events, Professional Development, SQL Server  //  No Comments


On Wednesday, 7 March Microsoft is holding a virtual launch event for the newest version of Microsoft SQL Server to be released on 1 April.  You want to be there.  Yes, even you data architects, business analysts, project managers, enterprise architects and other IT professionals working in the upper rows of the Zachman Framework.  Why?  Because there are many new features in SQL Server 2012 made just for you:

  • Master Data Services
  • Data Quality Services
  • BI Semantics
  • Self Serve BI
  • Hadoop integration
  • New Data Tools
  • New datatypes, database objects and other design features like ColumnStore Indexes.

MVP Lovin’

You’ll have access to SQL Server MVPs who will be standing by to take your questions and chat about the new features we are most excited about. I’ll be working at these Topic Pods:

  • Application Development, Beyond Relational, Connectivity at 6 PM ET / 3 PM PT
  • Business Intelligence & Enterprise Information Management at 9 PM ET / 6 PM PT

If you register for the event, you can stop by and chat with some awesome SQL Server MVPs and me about some of the newest features of SQL Server. 

Prize Love

Unlike that other launch that is happening tomorrow, at the SQL Server Launch you can earn some really great prizes: cash gift cards, SQL Server Gear, and Xboxes.  So the more you watch, the more you engage, the more you can win.  Cash, Swag and Gaming.  What more could you want?

Lovin’ Just for You

While I think non-DBA types can get a lot out of the overviews of all the new features, I think developer and  data professionals will find these agenda items the most applicable:

Blazing-Fast Performance: A Technical Best Practices Tour with ColumnStore Index
Go behind the scenes with SQL Server engineers for a quick technical tour of the ColumnStore Index feature and an introduction to best practices for achieving astonishing performance with your ColumnStore Indexes.

Blazing-Fast Performance: Explore FileTables, Full-Text Search and Semantic Search for Faster, More Meaningful Results Across Unstructured Data
80% or more of the data produced and stored are so called unstructured documents and are often not stored in the database, but often need to be managed in conjunction with relational data. In order to facilitate the storage and management of unstructured data, SQL Server has evolved from storing blobs to providing a sophisticated integration with the Windows Filesystem and provides rich services over such data to provide an interesting and compelling application development experience. This presentation introduces the new unstructured data processing capabilities of SQL Server 2012 that provide full Windows application-compatible file management over files stored in SQL Server as well as the services to unlock the information in such data such as the extensions and improvements to Full-Text Search and the introduction of semantic similarity search.

Organizational Compliance: Using the New Security Features and Audit Enhancements to Increase Compliance Policies
Introduction to new security features in SQL Server 2012 such as User-Defined Server Roles and enhanced Auditing to increase organization compliance.

Peace of Mind: Quick Tour Through the New SQL Server Migration Assistant
In this session we will review SSMA modules that automate assessment, schema conversion, data migration and testing of Oracle and Sybase migrations to SQL Server 2012.

Unlocking the Value of Big Data with Microsoft Business Intelligence
Klout is a ground-breaking company that extracts signals from social networks to determine which people are most influential. Hadoop is a core part of how Klout captures and processes over 3 billion signals daily, however translating and analyzing these signals into meaningful information requires a scalable and cost effective business intelligence solution. That’s where Microsoft SQL Server 2012 comes in, delivering “speed of thought” ad hoc queries, with response times of under 10 seconds on 35 billion rows of data. Learn more about Big Data and BI best practices in this session.

Rapid Data Exploration: Empowering End User Insight Through Rapid Data Exploration and Visualization with Power View
Introduction to Power View, the new thin, self-service ad hoc reporting tool. In this session we will highlight its main features, scenarios, show a demo, and discuss its relationship to other products in the BI stack (SharePoint, Excel).

Rapid Data Exploration: Powerful Self-Service Analysis with PowerPivot
Get a taste of what’s new in PowerPivot, the self-service BI experience that enables information workers to build their personal and team BI applications within the familiar environment of Excel: This session will provide a quick introduction to PowerPivot, followed by demos highlighting the top 5 new modeling features delivered with the release of SQL Server 2012.

Managed Self-Service BI: End User Created, IT Managed
Introduction to the BI continuum – IWs using the familiar tools like Excel, IT retaining control and governance of the workbooks. We will show how IT can manage the system in SharePoint, and how self-service BI solutions transition to managed corporate BI solutions.

Credible, Consistent Data: Going Under the Hood with the New BI Semantic Model
Introduction to the BISM, position tabular and multidimensional types of models. We will show how easy it is to create a model in PowerPivot, show how Power View is leveraging it, and highlight how easy is it to go from an individual workbook to the enterprise IT governed BI solution.

Credible, Consistent Data: Improving Data Quality with the New Data Quality Services
No matter how brilliant your BI tools are, it’s garbage-in-garbage-out. This session will give an overview on the new Data Quality Services product in SQL Server 2012. Come watch this important scenario to learn how to position, sell, and demo the new DQS product.

Credible, Consistent Data: Empowering IW / Data Experts to Efficiently Manage Important Data with the New Master Data Services Add-In for Excel
Introduction to the improvements and new functionality in the SQL Server 2012 release, empowering IW to curate the organization’s important data, maintaining it accurate and relevant through its lifecycle, via easy model creation and validation.

Credible, Consistent Data: Introducing New Team-based Data Integration with Integration Services
There are plenty of new features for SQL Server Integration Services (SSIS) in SQL Server 2012 that make it a very compelling release for your customers. This session will cover some of the highlights of the release, including the new Change Data Capture functionality. We will demonstrate how to bring together key components needed to build an effective ETL framework using SSIS. This reusable framework will show off the new functionality and productivity enhancements for existing users, and present a compelling story for customers who have never seen or used SSIS before. We will cover the end-to-end lifecycle of an SSIS solution, including how to maintain and manage the framework once it has been deployed into production.

Scalable Analytics & Data Warehousing: Fast Track for SQL Server 2012
Fast Track for SQL Server 2012 has significant improvements, leveraging exciting new enhancements in SQL Server 2012 like the new ColumnStore Index feature. You will also see how Fast Track partners are working with the SQL Server team to transform the latest enhancements in server and storage technology into highly optimized data warehouse Reference Architectures.

Big Data Analytics with Apache Hadoop and SQL Server 2012
In this session we will explore Apache Hadoop on Windows Server and Azure and powerful insights we can generate integrating with SQL Server.

There are more sessions, so be sure to check them all out.  I hope you register and learn how you can Love Your Data with SQL Server 2012.  See you there.

Subscribe via E-mail

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