Idera Software

Category: Positioning & Presence
Type: Page Metadata Change

Generated 35 minutes ago

New page title detected.

  • New: IDERA Community
  • Old: Expert advice on SQL server and SharePoint performance — IDERA blog

Idera Software

Category: Positioning & Presence
Type: Page Metadata Change

Generated 1 week ago

New page title detected.

  • New: Expert advice on SQL server and SharePoint performance — IDERA blog

Idera Software

Category: Positioning & Presence
Type: Page Metadata Change

Generated 1 week ago

Idera Software

Category: Content
Type: Youtube Video

Generated 2 weeks ago

Idera Software

Category: Content
Type: SlideShare Presentation

Generated 2 weeks ago

Slide Share presentations detected

  • Geek Sync I SQL Server 2016 Performance Tricks You Need to Know

    View the recording here: http://community.idera.com/live-events/events/f/289/t/23497 SQL Server 2016 has been out for six months, but not many people know the hidden secret tips to improve performance with this new version. In this fast paced, demo oriented, webcast we will talk about some of the high impact but unknown performance tuning features of SQL Server. Join IDERA and Pinal Dave as he ...

Idera Software

Category: Content
Type: SlideShare Presentation

Generated 2 weeks ago

Slide Share presentations detected

  • Quack Chat | Partitioning - Black Magic or Silver Bullet

    Many modern relational databases offer table and index partitioning - an advanced technique for breaking very large tables and indexes with millions to billions of rows into smaller buckets. But when and how should one use partitioning? What kinds of problems can it solve? What new problems does it introduce? In this session Bert Scalzo and Scott Walz will answer all these questions and more wit...

Idera Software

Category: Content
Type: Youtube Video

Generated 2 weeks ago

New videos detected

Idera Software

Category: Content
Type: Blog Article

Generated 2 weeks ago

New blog articles detected

  • IDERA Announces Rapid Database Extractor Free Tool

    We’ve recently released our latest free tool which is the first in the database development portfolio. With this new release, we now have 23 free tools to offer which is very exciting. Database developers with heterogeneous database environments typically have to use multiple database-specific tools to complete tasks that Rapid Database Extractor can execute in […]

Idera Software

Category: Content
Type: Youtube Video

Generated 2 weeks ago

New videos detected

  • Modelado y Arquitectura de Datos con ER/Studio

    En esta presentación, un ingeniero de IDERA nos mostrará cómo: - Crear nuevos modelos de datos de manera muy productiva - Documentar los proyectos de datos existentes con sólo unos clics - Soportar a múltiples plataformas desde un único proyecto - Aplicar cambios en su base de datos en un entorno administrado - Compartir modelos y metadatos con todos sin perder el control - Descubra rápidam...

  • Más Poder a Los DBAs y a Los Desarrolladores con DB PowerStudio

    Hoy en día los profesionales de bases de datos son desafiados a desarrollar y mantener bases de datos en múltiples plataformas. Esto no es una tarea fácil, ya que cada plataforma tiene diferentes maneras de lograr el mismo resultado. Usted está invitado a unirse a IDERA y entender cómo DB PowerStudio le puede ayudar en este desafío! Esto es lo que veremos: - Administración de bases de datos más...

Idera Software

Category: Content
Type: SlideShare Presentation

Generated 2 weeks ago

Slide Share presentations detected

  • Geek Sync I Does Data Modeling Have Business Value?

    Data modeling is an essential component of enterprise architecture that is often overlooked or underestimated in importance. Whether dealing with a single database or a combination of multiple platforms in a complex environment, data modeling provides meaning and value to the business and can serve as the foundation for a data governance or master data management initiative.

  • Geek Sync | Rewriting Bad SQL Code 101

    Jeffrey will cover ways to avoid people thinking your code is bad, some common coding fallacies, and presents two case studies on rewriting bad SQL. The first case study contains three iterations of code written by the instructor, the second case study comes from an eCommerce site that had a great idea but horrible execution.

  • Geek Sync I Practical Performance Tuning with SQL Wait Stats

    Every slow system has a resource bottleneck. Everybody wants to identify and resolve the performance issues related to those resources. SQL Server Waits and Queues can reveal your past, explain your present and predict your future. SQL Server Performance Tuning uses the Waits and Queues as a proven method to identify the best opportunities to improve performance. In this webcast, we will focus ...

  • Master Administration of Multiple Database Platforms with Ease

    As a DBA, are you challenged with managing multiple database platforms in your corporate environment? It’s hard enough to be an expert in one database, not to mention several different ones. You need a tool that can help you with the platform-specific details while giving you the ability to perform routine tasks quickly and easily. Join IDERA, Scott Walz and Bert Scalzo as they provide you with...

  • Geek Sync | Having Fun with Spatial Data

    In this session, you will learn how to create, procure and leverage spatial data. You will be made aware of tools you can use to integrate your own spatial data with a variety of public data sources such as the Census Bureau, National Weather Service, etc. Functions and T-SQL commands related to spatial data analysis will be demonstrated. We will end the session by using the geometry data type t...

  • Geek Sync | Learn the PowerShell Essentials on Error Trapping

    Do you want to learn how to trap and document error while running PowerShell scripts? This session will cover how to use and trap errors in your PowerShell script. We’ll be creating simple script providing some scenarios in trapping errors. At the same time, we are going to end up creating an error report.

  • Geek Sync |The Five Essential Scripts for Performance Tuning

    Performance Tuning is a complex subject and one of the most critical. Every business owner wants his server to run faster and every DBA wants to make sure that they know the tricks to improve the performance of SQL Server. This session crafted for all those DBAs who like to be hands-on while tuning their SQL Server.

  • Geek Sync I Agile Data Management vs. Agile Data Modeling

    Join IDERA and Joseph Maggi while he discusses some of the more heated debates in the data modeling world centered around the concept of agile data modeling. Much of this debate has its roots in a misunderstanding or at least conflicting views on what Agile is in the first place. Some view agile data modeling as a haphazard approach to database “design” while others view it as a way to get applic...

  • Geek Sync I Learn to Troubleshoot Query Performance in Analysis Services

    We often use Analysis Services because we "should" get better query performance than if we were querying data from our relational data sources. Analysis Services is very fast whether using cubes or tabular with simple queries requiring no tuning.

  • Geek Sync I The Essential PowerShell Tools for the Database Administrator

    In this session Maximo will be showing some available tools the DBA can use along with PowerShell. We’ll be integrating Visual Studio with PowerShell and at the same time using IDERA’s PowerShellPlus editor. At the end, we’ll build an SSIS package solution to execute our PowerShell script. It will be pack with interesting thing to do as well as help you accomplish your automation tasks.

  • Geek Sync I Need for Speed: In-Memory Databases in Oracle and SQL Server

    Microsoft introduced IN-MEMORY OLTP, widely referred to as “Hekaton” in SQL Server 2014. Hekaton allows for the creation of fully transactionally consistent memory-resident tables designed for high concurrency and no blocking. With SQL 2016, many of the original restrictions and limitations of this feature have been reduced. IDERA’s Vicky Harp will give an overview of this feature, including how ...

  • Geek Sync I Performance Tuning for DBAs New on the Job

    We’re all beginners at one point and time and we’ve all changed our jobs at some point. Joining a new organization can be overwhelming when on the very first day you’re assigned tasks in which you’re responsible for improving performance of the server. Starting a new job has a lot of new variables that you maybe not be familiar with, such as, infrastructure, business logic, server and file struc...

  • Geek Sync I Capacity Planning for Improved Uptime

    Before you go to bed at night, do you worry about a tempdb blowing up a thin-provisioned LUN? In this session we cover the most common elements in your environment that will cause you to lose sleep. This slide deck covers how to locate the current and future bottlenecks in your environment, as well as what capacity constraints are at greatest risk of impacting your uptime.

  • Geek Sync | 10 ER/Studio Productivity Tips to Help You Love Your Data Models

    Maybe you’ve been using ER/Studio for years, maybe you’re just getting started. Maybe you don’t even know where to start. You might be a full time data architect or an accidental database designer – either way, you’ll want to know about the settings and features to make your Mondays more tolerable and your Fridays more fun. In this session, Karen covers her 10 favorite tips and tricks for working...

  • Geek Sync | Understanding Oracle Database Security

    Database security is critical these days with all of today’s growing regulatory and privacy requirements. While application developers might build some basic access security into their code, ultimately the buck stops at the database as the last bastion or firewall against data theft. So what Oracle features should DBA’s know and consider using? How do they work? What overhead if any do they add? ...

  • Become an Insider: The Future of Uptime Infrastructure Monitor

    Join Beth Chauvin, Senior Product Manager for Uptime Infrastructure Monitor, for a 2015 year in review, but also what’s coming in 2016 including what’s in development right now with Uptime IM 7.7.

  • Geek Sync I Polybase and Time Travel (Temporal Tables)

    With the release of SQL Server 2016, Microsoft has included two features that could fundamentally change the way we look at Data Warehousing. The addition of Polybase for connecting to external data sources such as Hadoop and Azure Blob for native TSQL queries extends the reach of the DW. The Temporal Table feature creates all kinds of possibilities for implementing Type 1 and 2 dimensions as wel...

  • Geek Sync I The Essentials in Building Basic PowerShell Modules

    Following our last PowerShell Geek Sync, The Essentials to Tackling Basic PowerShell Functions, Maximo Trinidad will walk you through building on the basics of PowerShell modules. In this session you’ll learn the basics on how-to build PowerShell Modules. Previously, we’ve learned how to create functions with Maximo. This is the next step to collect and group together all your existing functions...

  • Avoid Corruption Nightmares within your Virtual Database

    Running DBCC CHECKDB on your databases is critical to avoid a potential nightmare. Ideally we do this regularly to find & fix corruption. However, because of the possible performance impact on server resources, sometimes it isn’t cost effective to run. Many companies actually forgo it; simply because they do not have the means to handle it. With SQL Virtual Database software, we can make it acces...

  • Geek Sync I Writing Effective Unit Tests

    Writing automated unit tests sounds simple enough. Instead of manually testing out your stored procedure, you just write a little bit of code to call the procedure and then make sure it did what it was supposed to do. It turns out, things in real life are not that simple. Join Sebastian during this educational webinar to learn how to avoid the pitfalls of an unmaintainable test-base. You will h...

Idera Software

Category: Content
Type: Youtube Video

Generated 3 months ago

Shall we increase our level of intimacy?

40,803,957 ideas and insights to help you find what’s next.

Log in Sign up

Shall we increase our level of intimacy?

40,803,957 ideas and insights to help you find what’s next

Create Free Account

Already a user?  Log in