SQL SERVER 2014 CTP1

Hi,

SQL Server 2014 CTP1 is here.  SQL Server 2014 delivers mission critical performance across all workloads with in-memory built-in, faster insights from any data with familiar tools, and a platform for hybrid cloud.

Microsoft SQL Server 2014 builds on the mission-critical capabilities delivered in the prior release by providing breakthrough performance, availability and manageability for your mission critical applications. SQL Server 2014 delivers new in-memory capabilities built into the core database for OLTP and data warehousing, which complement our existing in-memory data warehousing and BI capabilities for the most comprehensive in-memory database solution in the market.

SQL Server 2014 also provides new disaster recovery and backup solutions with Windows Azure, enabling customers to use their existing skills with the on-premises product offerings to take advantage of Microsoft’s global datacenters. In addition, SQL Server 2014 takes advantage of new Windows Server 2012 and Windows Server 2012 R2 capabilities to give you unparalleled scalability for your database application in a physical or virtual environment.

Click here to download SQL SERVER 2014 CTP1

Will come back with more information.

Enjoy

Transparent Data Encryption Inside and Out In SQL 2012 Webinar

Guys,

If you are keen to know more about TDE (Transaction Data Encryption) then watch this webinar from Pragmatic.

Speaker: Bradley Ball

Security is a very important part of your job and in how data is utilized. We have many tools to make data more secure, and starting in SQL 2008 we were able to add Transparent Data Encryption to that list. Find out What it does and What it doesn’t do, How it effects Read-Only Filegroups, Performance, Compression (Backup and Row/Page), What the X.509 Encryption Standard is and Why you should be careful of what you store and where, and other Advance Features as well as some tips on how to manage it.

Click here to watch it.

Happy Learning

Sudhir

How to manage Big Data, Tips and Tricks Webinar

Guys,

Do you have big data to manage in your database, then watch this webinar to ensure you take care of big data properly.

Speaker: Jorge Segarra

In this session join Jorge Segarra as he dives into Big Data: What it means, if you’ve got it and how to handle it. Jorge will Explore how data is growing in the enterprise, review challenges and current best practices for handling large data volumes in BI, look at industry solutions that help enable massively parallel processing, and help you understand how to take your organization’s data to the next level.

Click here to watch it.

Happy Learning

Sudhir

Test Driven Development (TDD) in C# using NUnit Webinar

Guys,

This will be interesting. If you are keen to know about Test Driven Development (TDD) in C# using NUNIT. Then this is the webinar for you.

Speaker: Mark Brown

We will provide an introduction to the practice of test driven development, how it compares to unit testing, and what it does not cover. We will build an example using test driven development to illustrate its use. We will identify other types of testing and the tools used for them.

Click here to watch it.

Happy Learning

Sudhir

Performance Tips and Tricks with SQL Server, real cases with developers Webinar

Guys,

Watch this webinar on "Performance Tips and Tricks with SQL Server, real cases with developers" This got real case scenarios & various options that can be used on a daily basis.

Speaker: Nabeel Derhem

Application developers don't care much about how SQL Server executes their queries as long as they get what they want. This session introduces common real case scenarios where developers end up with troublesome queries and bad performance. Explanation is linked to a discussion of alternative effective ways to handle such scenarios.

Click here to watch it.

Happy Learning

Sudhir

Performance Tuning SSIS Webinar

Hi,

To understand various options to improve performance of a SSIS package, watch this webinar from Pragmatic work.

Speaker: Shawn Harrison

SSIS is a powerful ETL tool, but by nature ETL developers are always looking for better performance. In this hour long presentation Shawn will cover many basic options and features that you can use to performance tune any SSIS package. Who wouldn’t want better package performance?

Click here to watch it.

Happy learning

Sudhir

SQL Server 2012 SSIS: New and Improved Features Webinar

Guys,

Watch this webinar to find out what's new in SSIS in SQL Server 2012.

Speaker: Anish Sana

With SQL server 2012 release around the corner, there’s been a hype around the new features that comes with this awesome release. For this webinar we’ll be touching on some of the new features in SQL Server 2012 SSIS and how that will improve on development as well as look into the enhancements made to existing features from the previous versions.

Click here to watch it.

Happy Learning

Sudhir

Master Data Services in SQL Server 2012 Webinar

Guys,

Another webinar on Master Data Services in SQL Server 2012 by pragmatics.

Speaker: Arie Jones

Most DBAs at one time or another have been taught the importance of master data management(MDM), which is comprised of a set of processes and tools in order to keep your non-transactional data in a consistent state. However, with today’s fast paced environment and tightening budgets most DBAs lack the resources to properly implement it. With the upcoming release of SQL Server 2012, Microsoft has taken their second swipe at providing a tool known as Master Data Services(MDS) to aid the DBA in this endeavor. In this session, you will learn the how Master Data Services is implemented in SQL Server 2012, setting up models, working through the Excel plug-in, and utilizing DQS and business rules to help with that dirty data. This session will definitely be an eye opener for some that were on the fence with the first release and those that are coming into the platform with a fresh set of eyes!

Click here to watch it

Happy Learning

Sudhir

Introduction to PowerPivot webinar

Guys,

Powerpivot / Self Service BI is an excellent tool for BI purpose. Here is a webinar on "Introduction to PowerPivot" from Pragmatic Works.

Speaker:  Brian Knight

In this session, you’ll learn how to use PowerPivot to create self-service analytics in your organization. You’ll see how Office 2010 and SQL Server 2008 R2 will help your users answer their own questions and bring together datasets that may be heterogeneous like a SQL Server table and data feed from a website. Then, you’ll see how to take that data and create a striking report for your end users and collaborate with the data in SharePoint.

Click here to watch it.

Happy Learning

Sudhir

Introduction to Master Data Services Webinar

Guys,

It's been long since Microsoft introduced MDS. To understand the basics of it, we can watch webinar on "Introduction to Master Data Services" by Pragmatic works.

Speaker: Jose Chinchilla

In this session, Jose will do an overview of Master Data Services and how it can be leveraged with SSIS and SharePoint 2010 to accomplish a Master Data Management framework. Jose will cover concepts like models, entities, attributes and attribute collections, explicit and derived hierarchies, subscription views and business rules. Jose will also demo how to load an MDS entity with SSIS and how to kick start a workflow process in SharePoint 2010 when a business rule is not met.

Click here to watch it.

Happy Learning

Sudhir

Introduction to Design Patterns Webinar

Guys,

To understand basics of Design Patterns, we can watch webinar on "Introduction to Design Patterns" from Pragmatic works.

Speaker: Ben Evans

What is a design pattern? Why would I need it? Well in this session these topics will be covered as we explore a few of the common patterns and why you should know about them.

Click here to watch it.

Happy Learning

Sudhir

SQL Server Internals and Architecture Webinar

Guys,

This is one of the best webinars if you are keen to know about "SQL Server Internals and Architecture"

Speaker: Kevin Kline

This fast paced session will take you through many aspects of the internal operations of SQL Server. if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:What’s different about 32- and 64-bit systems? What are the various areas of memory inside of SQL Server? How are queries handled behind the scenes? What does SQL Server do with procedural code, like functions, procedures, and triggers? What happens during checkpoints? Lazywrites? How are IOs handled with regards to transaction logs and database? What happens when transaction logs and databases grow or shrinks?

Click here to watch it.

Happy Learning

Sudhir

Introduction to PowerPivot Webinar

Guys,

Watch this webinar on "Introduction to PowerPivot" from Pragmatics.

Speaker: Devin Knight

Come join Devin as he explores the new PowerPivot technology, how to configure and get it up and running and build exciting reports in a very short amount of time. This will be an all demo session and lots of fun!

Click here to watch it.

Happy Learning

Sudhir

SQL Server Data Compression Webinar

Guys,

To understand SQL Server Data Compression, watch this webinar from Pragmatic Work.

Speaker: Kathi Kellenberger

SQL Server data compression was introduced with 2008. Of course, compression can save you storage space, but many DBAs do not know that you can get a performance boost from compression as well. By attending this webinar, you will learn about the two levels of compression, how to estimate the benefits of compression, and how to implement it.

Click here to watch it.

Happy Learning

Sudhir

SSIS 2012 Administration Webinar

Guys,

Another webinar on "SSIS 2012 Administration" from Pragmatic works.

Speaker: Mike Davis

In this session you will Learn how to deploy, secure, execute and monitor SSIS packages in the new SSIS 2012. Learn how to use the new SSIS catalog and understand the new SSISDB. Afterwards you will have a thorough understanding of SSIS administration in SQL 2012.

Click here to watch it.

Happy Learning

Sudhir

Optimizing SQL Server 2012 Webinar

Guys,

Another webinar on "Optimizing SQL Server 2012" by Pragmatic Works.

Speaker: Gareth Swanepoel

An "accidental DBA" is a SQL Server administrator who has been thrust into the task without having the experience or know how required to keep SQL running at peak performance. This is not their fault and is purely due to the fact that they have not been exposed to it before. If you are a DBA and find yourself wondering how hardware changes affect performance or have questions relating to the performance implications of partitioning or compression, then this session is for you. I will be exploring topics such as Memory configuration, CPU options and IO considerations.

Click here to watch it.

Happy Learning

Sudhir

Getting Started with SSRS 2012 Webinar

Guys,

Here is another webinar on "Getting Started with SSRS 2012" by Pragmatic works.

Speaker: Chris Albrektson

In this session Chris will give an introduction to reporting with Microsoft SQL Server Reporting Services (SSRS) 2012. You’ll learn everything you will need to know to get started when creating your first reports using the latest release of SSRS. During this session we will also discuss and review the latest features and updates that have been included such as Power View, Data Alerts, Rendering Formats, and SharePoint integration.

Click here to watch it.

Happy Learning

Sudhir

Using the Change Data Capture in SQL Server 2012 Webinar

Guys,

Here is another webinar from Pragmatic Works on "Using the Change Data Capture in SQL Server 2012"

Speaker: Shawn Harrison

Do you have problems keeping data in sync? Do wish there was an easy way to consistently insert, update and delete data between source tables? Well, this webinar is for you. In this session, Shawn will explain the Change Data Capture and demonstrate how it’s used. Come see how little effort you will have to put forth when keeping your data in tune!

Click here to watch it.

Happy Learning

Sudhir

Intro to SSIS for Newbies and Beginners: Building Your First Package Webinar

Guys,

Here is another webinar from Pragmatic works on "Intro to SSIS for Newbies and Beginners: Building Your First Package"

Speaker: Anthony Coleman

SSIS is a powerful tool and at first glance looks very intimidating. If you are new to BI or on the fence about learning SSIS fear no more. In this session for newbies and beginners Anthony will introduce you to the SSIS development environment as well as common terms and concepts that one needs to know. He will then take it a step further and build an SSIS package using a real world example! Why wouldn’t you want to learn how to use this powerful tool?

Click here to watch it.

Happy Learning

Sudhir

Creating your first Control Flow Task in SSIS Webinar

Guys,

Another webinar from Pragmatic Works on "Creating your first Control Flow Task in SSIS"

Speaker: Chris Rock

In this webinar Chris will show you how to create your first control flow task. You will discover how to create a reusable component that can be used to send html emails within SSIS

Click here to watch it.

Happy Learning

Sudhir

Introduction to Parameters in SSIS 2012 Webinar

Guys,

Another webinar from Pragmatics Work on "Introduction to Parameters in SSIS 2012"

Speaker: Shawn Harrison

SSIS 2012 has introduced many changes and new features. Join Shawn as he explores the uses and possibilities of parameters in SSIS 2012. Learn the differences between the different types of parameters and how they are used in the new deployment models (Package deployment and Project deployment).

Click here to watch it.

Happy Learning

Sudhir

Page and Row Compression Internals in SQL 2012 Webinar

Guys,

Another webinar from Pramatic Works on "Page and Row Compression Internals in SQL 2012"

Speaker: Bradley Ball

Page and Row Compression are powerful new tools. Vardecimal shipped with SQL 2005 SP2, Page & Row with SQL 2008 RTM, and Page & Row with Unicode Compression with SQL 2008 R2. In SQL 2012 we add Spatial Data Types. Get an overview into how each version of compression works internally. Learn how your Allocation Units will determine if your data is a candidate for compression. Understand how your tables Update and Scan pattern’s affect the compression types you should consider. And what you should you take into consideration for additional overhead.

Click here to watch it.

Happy Learning

Sudhir

Storage Performance for SQL Server Databases Webinar

Guys,

Here is another webinar on "Storage Performance for SQL Server Databases" from Pragmatic works.

Speaker: Kevin Farlee

For any database system, once you’ve properly designed and tuned the queries, much of your application performance will be governed by the configuration and specifications of your IO system. We’ll go over the building blocks and characteristics of modern storage systems, where potential bottlenecks exist, and what to do about them. We will discuss common pitfalls and best practices for designing storage systems. Finally, we’ll walk through a real-world example putting all of this in practice.

Click here to watch it.

Happy Learning

Sudhir

SSIS 2012: More Than Just a Pretty UI

Guys,

Another Webinar on "SSIS 2012: More Than Just a Pretty UI"

Speaker: Steve Wake

SSIS 2012 added rounded corners and Undo/Redo to the designer, but what else was added to make this worth the upgrade? In this webinar there will be as many demos of the new features as can be fit into the time provided. Along with the rounded corners, you will also see the changes to deployment, SSIS catalog database, metadata/XML updates, Parameters, logging updates, Data Taps, ODBC support, script debugging, PowerShell interface and as many others as we can get through. If you haven't seen what has been updated in SSIS 2012, this will be the presentation to cover the most!

Click here to watch it.

Happy Learning.

Sudhir

Optimising SQL Server 2012- Part 2

Guys,

Here is a very useful session on "Optimising SQL Server 2012- Part 2"

Speaker: Gareth Swanepoel

An "accidental DBA" is a SQL Server administrator who has been thrust into the task without having the experience or know how required to keep SQL running at peak performance. This is not their fault and is purely due to the fact that they have not been exposed to it before. This is a follow-on to a previous webinar and I will continue to explore the process of designing and building your SQL Server for optimal performance. I will be exploring topics such as IO considerations, database file placement, partitioning, compression, and many other performance optimisation tricks.

Click here to watch it now.

Happy Learning

Sudhir

How SQL Server Replication Works Webinar

Guys,

There is a new webinar on "How SQL Server Replication Works" from pramatic works.

Speaker: Chad Churchwell

This session will dive into the different types and describe how replication works internally for snapshot, transactional, and merge replication. Also I will cover the difference in push vs pull subscriptions. Also there will be some design decisions covered when creating a replication topology.

Click here to watch it now.

Happy Learning

Sudhir

New T-SQL Features in SQL Server 2012 Webinar

Guys,

Watch this webinar by Kathi Kellenberger on New T-SQL features of SQL Server 2012.

The SQL Server 2012 release has something for everyone: Column Store Index, AlwaysOn Availability Groups, Power View and more. I bet you haven’t heard about all the great new T-SQL features! Attend this webinar to learn about the Sequence Object, new functions, THROW, and more!

Click here to watch it now.

Happy Learning
Sudhir

Inside the Query Optimizer Webinar

Guys,

Pramatic works has come up with another webinar on "Inside the Query Optimizer Webinar"

Schedule : Thu, Jan 10, 2013 9:30 PM - 10:30 PM IST

When it comes to SQL Server one of the biggest request you hear is “How can I make my Query Run FASTER!?”.  The answer understanding the first step in that process Is understanding the Query Optimizer.  Understanding the Optimizer beings with knowing the Rules. The way our queries are written reflect directly on the output that we get. In this session we will look at the rules in SQL Server, write queries to show those rules in action, and walk out with a better understanding of how the Optimizer works.

Speaker: Bradley Ball

Click here to register.

Happy Learning
Sudhir