Extended support for SQL Server 2005 ends on April 12, 2016.
This means that if you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates. Now is the time to upgrade to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure.
Join Rodney Landrum, Senior SQL Server Consultant and Microsoft MVP and Michael McCracken, HOSTING Director of Advanced Solutions, as they discuss key benefits to moving to a SQL Server 2014 and key considerations to take into account when migrating your databases.
Join our webinar and learn new ways to optimise SQL Server leveraging idle cores to improve the responsiveness of highly concurrent, I/O-intensive OLTP workloads. It’s surprisingly simple.
We also have a special guest, Mike Prince, Senior SQL Server Consultant from Ultima Business Solutions, who will share his experiences testing MaxParallel in SQL environments.
The end of Extended Support for SQL Server 2008 and 2008R2 is coming faster than you know, as of July 2019. It’s important that your organization takes the necessary steps so you’re prepared for the migration.
A database migration is not always straightforward and requires preparation, testing and implementation and these processes could take up to 9 months depending on environment size.
In this webinar, Jeff Duncan will discuss the steps that you need to ensure that you have the smoothest migration to the SQL Server 2016 and beyond.
Looking for more performance from your virtual environments? Attend this live webinar to learn how to get the most out of your virtual SQL servers.
Join our resident SQL Expert, Paul Haddow, for valuable insights in optimising the performance and tuning of Physical & Virtual SQL Servers and your virtual environments.
First aired Nov. 21,2013. Now, more than ever, business requirements are demanding 99.999% system availability. Anything less impacts the company's credibility and revenue. Join HOSTING and XTIVIA, in an engaging presentation on the nuances of architecting and deploying a highly available, world-class MS SQL Server solution. XTIVIA’s Senior SQL Server Consultant and Microsoft SQL Server MVP, Chris Shaw, will bridge the gap between business requirements and technology solutions.Read more >
Join Michael McCracken, HOSTING Director of Professional services and Dave Bermingham, Microsoft cloud and Data Center MVP, to examine the TCO of high availability and disaster recovery protection for SQL Server deployments with surprising results. They will cover:
-How to save thousands of dollars by reducing licensing and hardware costs while still delivering complete HA and DR protection
-How to create a failover cluster using SQL Server standard edition
How to create a Windows cluster in a cloud without the need for shared storage
Learn new ways SQL Server can leverage idle cores to improve the responsiveness of highly concurrent, I/O-intensive OLTP workloads.
It’s surprisingly simple.
This demo of the Vexata VX-100F scalable storage system using NVMe SSDs via Fibre Channel running SQL server analytics, illustrating how database administrators can accelerate data loads via system read bandwidth that exceeds 46 gigabytes per second. Overall, the Vexata VX-100F increases server performance by up to 10x delivering faster, more accurate insights while dramatically reducing data center TCO.Read more >
Skyrocketing Oracle licensing costs, coupled with powerful feature and performance advances in the SQL Server database engine, has resulted in a growing shift towards the Microsoft database offering for those companies looking to change platforms. While SQL Server and Oracle have their place for certain uses and applications, there is a large number of scenarios where companies can choose one platform or the other. However, migrating from an existing platform to a new one is not a trivial task. Despite this complexity, we’ve seen an ever increasing number of consulting opportunities from customers migrating away from existing Oracle environments to the SQL Server equivalent. In this Webinar we will explore the reasons, potential ROI, and the initial risks and high level technical considerations that need to be made when pursuing this route.Read more >
If your organization is reliant on a rapidly aging version of SQL Server, you need to join SQL Server experts Michael McCracken from HOSTING and Rodney Landrum, a Microsoft SQL Server MVP, from Ntirety for this in-depth discussion of the hows, whys and whats of upgrading from Microsoft SQL Server 200X to SQL Server 2014. The interactive webinar will cover:
•The benefits of upgrading
•Considerations to understand
•How to smooth the transition
•Q & A
Matt Henderson, Director of Microsoft Technologies, discusses the benefits and value of the Vexata system for SQL. https://www.vexata.com/products/Read more >
Successful analytics and transactional systems start with proper architectural principles and considerations. This webinar will be a detailed walkthrough of all the software and hardware infrastructure below the database server. It will explain how each layer affects database workloads as well as give tools and metrics for determining optimal architectural configurations.
From this webinar you will learn:
• How to design SQL server infrastructures for optimal performance
• How the software and hardware infrastructure affect database performance
• Tools and metrics to determine appropriate hardware allocations. For example, how many CPU cores, data volumes, tempdb files or GBs of memory are needed for your workload.
• Tools and metrics to find current bottlenecks, inside and outside of the database server
• Tools and best practices for monitoring all layers
Presented by Matt Henderson, who has over two decades of experience in designing high-performance database platforms and over five years working with the latest all-flash storage technologies. He currently is the Director of Microsoft Technologies at Vexata where he helps customers optimize and scale their mission-critical databases.
Applications show intelligence when they can spot trends, react to unusual events, predict outcomes or recommend choices. Applications can also benefit when intelligence is applied to their underlying databases to optimize their performance. Most everyday apps, from consumer to enterprise, can deliver greater customer or business benefit by learning from user behavior and other signals and delivering that value quickly and consistently.
In this session we’ll take a pragmatic look at introducing real, useful data-driven intelligence into apps by walking through services, code and data needed to make it happen. We will also look at how Azure SQL Database continuously evaluates your data, learning and adapting to your application, and provides performance-improving recommendations tailored to your specific workload.
In this webinar you will learn:
- How to instrument your app to collect telemetry and start a feedback loop.
- How to add an intelligent behavior to your app with AI.
- How to add search and recommendations to your app.
- How automatic tuning and Intelligent Insights in SQL Database can improve your application’s performance.
Customers seeking to move their Microsoft SQL Server databases to the Amazon Elastic Compute Cloud (Amazon EC2) environment rely on Datavail for solutions that include remote database migration, administration, support, maintenance, and management services. Among the challenges customers face when transitioning their SQL Servers to Amazon Web Services (AWS) are concerns about lack of control, understanding the risks involved, and security and compliance. Customers choose to operate SQL on EC2 because they can manage their own database support for all maintenance areas. It is also customizable, meets high performance needs for replication and discovery, and is highly available. They work with Datavail because their monitoring, measurement, and support services are always available.
Sony DADC New Media Solutions, a large digital media company, discovered they could migrate their SQL Servers to AWS and run them using an Amazon EC2 solution allowed them to replicate their SQL Server environments in multiple AWS Availability Zones (AZ), meaning that if a node failed in one AZ, it could be replicated in another to ensure almost no downtime and improved performance.
Join us to Learn:
Best practices for providing highly available database solutions using EC2 on AWS
Gain insight into scenarios which migrating SQL Servers to AWS and using EC2 is the recommended course of action
How Sony DADC New Media Solutions reduced their Storage dependency by migrating to AWS using solutions and architecture from Datavail
Learn how SQL Server on AWS gives you complete control over every setting, without the maintenance, backup and patching requirements of traditional on-site solutions. Discover how to provision and monitor your SQL Server databases in both Amazon RDS and Amazon EC2, and how to optimise scalability, performance, availability, security and disaster recovery.Read more >
In this webinar, we will explain how running SQL Server on AWS gives you complete control over every setting, without the maintenance, backup and patching requirements of traditional on-site solutions. Learn how to provision and monitor your SQL Server databases in both Amazon RDS and Amazon EC2, and how to optimise scalability, performance, availability, security and disaster recovery.Read more >
Microsoft SQL Database Backup using Dell EMC Data Domain Boost TechnologyRead more >
Is your flash system up to the challenge? Attend this webinar and learn how you can optimize your SQL Server performance. Hear how the pros pinpoint performance bottlenecks and leverage the latest advancements in storage technology to decrease access latency and IO wait times. By the end of the webinar you’ll have the tools and information you need to recommend the best approach for your SQL Server environment.Read more >
SQL injection attacks enable attackers to tamper with, delete or steal sensitive data from corporate databases. In this webinar, Zach Jones, senior manager for static code analysis from WhiteHat Security’s Threat Research Center, will discuss SQL injection attacks and how to best defend against them.
In this webinar, we will:
- Provide examples of vulnerable code
- Discuss data boundary concepts between input and target interpreters
- Explain the differences and advantages of using parameterized queries versus custom stored procedures
- Discuss the pitfalls of using selective parameterization or trying to sanitize inputs by escaping or encoding them manually
WhiteHat Security has extensive experience working with customers to identify and fix the latest web application vulnerabilities. Join us to gain a deeper understanding of common web application vulnerabilities, get expert technical advice on defensive tactics, and learn best practices to safeguard your apps from being exploited.
For decades, traditional relational databases have been the primary choice for data storage and persistence. These database systems continue to rely on monolithic architectures and were not designed to take advantage of cloud infrastructure. These monolithic architectures present many challenges, particularly in areas such as cost, flexibility, and availability.
In 2016, Amazon Web Services Premier Partner, 2nd Watch, performed an analysis on the amount of AWS billing data that they had collected, and the number of payer accounts they had processed over the course of the previous year. The results of that analysis revealed that their single MS SQL server instance could no longer support the rapid pace at which the company continues to grow and on-board new clients.
Join AWS Premier Partner, 2nd Watch, for a live webinar on Migrating Microsoft SQL Server to Amazon Aurora on Monday, June 26 at 10am PST / 1pm EST and hear how they successfully migrated their Microsoft SQL Server to Amazon Aurora to help them meet customer demands and prepare for future growth.
Are you ready to run reports 10 to 100 times faster?
Microsoft's latest SQL Server advancements, available both on-premises and in the cloud, include blazingly fast in-memory online transactional processing (OLTP), in-memory columnstore, and massively parallel processing (MPP) capabilities.
Join this webcast to:
- Improve reporting speed by 10 to 100 times by tapping into these industry-leading modern data platform features
- See how other government organizations have upgraded to modern technology
- Find out how those entities can now provide faster, more efficient reporting capabilities to their organizations
Dynamic data performance, built-in intelligence and scalability brings Azure SQL to the forefront for app developers. With layers of abstraction, your traditional health metrics can be misleading when it comes to understanding how your Azure SQL workloads are truly performing, and in turn, impacting your development timelines. In this webinar with SelectStar’s Mike Kelly, learn how you can optimize the performance of your Azure SQL performance – and in turn, drive better development in the process.
The webinar will also cover:
Key trends driving Azure SQL as a leader in the app development space
Why your Azure SQL performance may lack – and how to fix it
How to augment monitoring for key elements like DTUs and service groups for maximum performance
Data platform specialists are talking.
Hear from Microsoft data platform specialists on some of the newest SQL and data warehousing capabilities in Azure and SQL 2016.
Join this webcast to:
- Review the new hybrid capabilities available in SQL 2016
- Learn about new security features including Dynamic Data Masking
- Explore scaling and performance options
- See how to track changes to your data with Temporal Tables
This webcast is part of our Explore weekly hot topics on Microsoft Azure webcast series. Sign up for this session, or the entire series today!
Join Midd Carmack, Product Manager and Mike Donaghey, Manager of Database Administration at TierPoint along with Matt Aslett, Research Director for Data Platforms and Analytics at 451 Research, as they discuss the latest high availability capabilities in SQL Server 2016, how to architect to take full advantage of those features, and implications for a robust disaster recovery plan.
Midd brings over 20 years of IT Infrastructure, Operating System and Database administration and product management experience to the discussion and will provide an overview of TierPoint as a Managed Services Provider and the company’s Hybrid IT strategy.
Matt will explore the latest high availability capabilities in SQL Server 2016, including database mirroring, log shipping, availability groups, and failover clustering. In addition to reviewing the capabilities of each of these approaches, this session will also include a perspective on their relative merits and use-cases. Matt will also explore the drivers for managed database services, versus hands-on database administration, in delivering the goals of a database high availability strategy.
Mike’s experience spans 15 years working with managed database clients to design and manage SQL implementations for a variety of industries, including healthcare, financial and manufacturing. Mike will offer technical perspective on implementing SQL capabilities to optimize disaster recovery protection and budget considerations. He will use case study examples describing the challenges and business requirements for a variety of SQL installs, along with strategies for solving those problems using the DR/HA features available with SQL Server today.
Join Rodney Landrum, Consulting Services Manager at Ntirety, a division of HOSTING, as he demonstrates his favorite features of the latest Microsoft SQL Server 2016 Service Pack 1.
During the webinar, Rodney will touch on the following:
• A demo of his favorite new features in SQL Server 2016 and SP1 including:
o Query Store
o Database Cloning
o Dynamic Data Masking
o Create or Alter
• A review of Enterprise features that are now available in standard edition
• New information in Dynamic Management Views and SQL Error Log that will make your DBA's job easier.