Idera Software
Idera Software
SlideShare Presentation
  • When starting a data governance initiative, the stakeholders may not fully grasp the complexity of the data architecture or know how to define the processes needed to implement a governance program. In fact, data governance may mean different things to the business stakeholders versus the technical stakeholders. Data architects need to collaborate with the business team to create business process...

Idera Software
Idera Software
SlideShare Presentation
  • Using Execution Plans to performance tune SQL Server queries can be a great starting point to help a database application run optimally. Execution Plans have been around for some time now and Microsoft has improved the interface and extra tools with every release. Join IDERA and Thomas LeBlanc as he walks through the history of execution plans. The progression will be to Scans and Seeks while di...

Idera Software
Idera Software
YouTube Video
Idera Software
Idera Software
SlideShare Presentation
  • When we design indexes, we often think about speeding up a specific query. But index tuning is important for larger reasons, too: well tuned indexes reduce the memory footprint of your workload, allowing greater concurrency and scalability for your application. Join IDERA and Microsoft Certified Master Kendra Little for this investigation into how the indexes selected by a query impact memory in...

Idera Software
Idera Software
SlideShare Presentation
  • Every new release of SQL Server brings a load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2016 and 2017 are perfect examples of releases with many new and beneficial features. Join IDERA and Pinal Dave as he covers the new features in SQL Server 2016 / 2017. Pinal will walk through adaptive query plans, batch mode adaptive join, new cardinality estima...

Idera Software
Idera Software
SlideShare Presentation
  • Long gone are the days where the only architecture decision you had to make when scaling an environment was deciding which part of the datacenter would store your new server. There is a dizzying array of options available in the SQL Server and Azure ecosystems and those are evolving by the day. Is “the cloud” a fad? Are private datacenters a thing of the past? Could both questions have a kernel o...

Idera Software
Idera Software
SlideShare Presentation
  • Databases are often like the big bang, suddenly they just exist, right? Well, not really, someone had to do the due diligence and design them conceptually then come up with a physical model for implementation. If it’s a transaction database, then we're done and the application connects and, voila, data starts filling our database. But in other situations such as business intelligence, analytics, ...

Idera Software
Idera Software
SlideShare Presentation
  • Many information technology professionals may not recognize it, but the bulk of their work has been and continues to be nothing more than database migrations. In the old days to share files across systems, then to move files into relational databases, then to load into data warehouses, and finally now we're moving to NoSQL and the cloud. In the presentation we'll delve into the ever growing and i...

Idera Software
Idera Software
SlideShare Presentation
  • Having proper backups for your SQL Server databases is your last line of defense when things go wrong. The most important job of a DBA is to be able to recover the data in the event of a disaster, whether that is a user deleting a record or a hardware failure. To come up with a good backup and restore strategy, a DBA will need to define a Service Level Agreement (SLA) for each system. Join Trac...

Idera Software
Idera Software
SlideShare Presentation
  • We have new ways to force execution plans in SQL Server. In SQL Server 2017, you can even let SQL Server temporarily force query plans for you and test if it works well! In this session, you'll learn how forcing plans with Query Store compares with the older technology of Plan Guides. You'll learn how to tell when a plan has been forced, what "morally equivalent plans" are (and why they're a go...

Idera Software
Idera Software
SlideShare Presentation
  • You have a new SQL Server. What do you need to set up from a security perspective? What should be audited? What are the things you need to consider when building that initial security profile? In this session we’ll look at the bare bones minimum things you need to secure and audit. Then we’ll look at the right questions to ask to determine where you go from there. Are there any regulations you’...

Idera Software
Idera Software
SlideShare Presentation
  • Deoxyribonucleic acid (DNA) is the fundamental building block that specifies the structure and function of living things. The information in DNA is stored as a code made up of four chemical bases in which the sequencing determines unique characteristics, similar to the way in which letters of the alphabet appear in a certain order to form words and sentences. Organizations can also be regarded ...

Idera Software
Idera Software
SlideShare Presentation
  • Database security is arguably the most important part of an information security program that many people aren’t paying attention to. Some might assume that network or server security controls are adequate to protect databases. They’re not. Furthermore, gaps in IT governance processes often lead to security policies that aren’t enforced which can directly impact database systems. This is not only...

Idera Software
Idera Software
SlideShare Presentation
  • Data governance helps to ensure that an organization's information assets are efficiently managed across the enterprise, which is most effective when everyone uses the same language and terminology to create a common context. When corporate systems have very different semantics, it can cost a lot of time and money to reconcile the inconsistencies. Yet, the vast majority of enterprise-wide data ef...

Idera Software
Idera Software
YouTube Video
  • IDERA Rapid SQL is the intelligent SQL integrated development environment (IDE) empowering database developers and database administrators (DBAs) to create high-performing SQL code on all major database management systems (DBMSs) from a single interface. This toolset simplifies SQL scripting, query building, object management, debugging and version control while gaining instant insights on perform...

Idera Software
Idera Software
YouTube Video
  • Precise for Sybase gives DBAs the application performance management they need to proactively monitor, analyze, and tune Sybase instances, including Sybase Replication Servers. Precise for Sybase identifies performance problems of business applications and helps solve them. It includes out-of-the-box reports for both technical and business users, enabling historical performance analysis and proact...

Idera Software
Idera Software
YouTube Video
  • Precise for SQL Server is designed specifically to keep your SQL Server database environment available and performing at peak efficiency. It captures, measures, and analyzes performance metrics from all critical system components and helps you detect and correct the root causes of problems before end users are affected. Precise for SQL Server provides high-level visibility across multiple SQL Serv...