Feeds:
Posts
Comments

Archive for the ‘SQLAuthority’ Category

My book co-author Rick Morelan is giving away SQL Queries Book and DVD set (valued at over $200) in his next webinar.

SQL Server is known for handing many requests at once and updating as new data comes in. If concurrency allows many things to happen at once, and locking prevents multiple users from changing the same piece of data at the same time… how do they work together?

Register for the webinar now to learn:

  • The different types of concurrency
  • How to identify blocking locks and choose between competing processes
  • Tools to profile the database, finding locks and wait times

Date and Time:
Tuesday April 23, 2013
7:00 AM PDT/10:00 AM EDT
11:00 AM PDT/2:00 PM EDT

Additionally DB Optimizer is an interesting tool and I personally use it for performance tuning experiments, do let me know if you are using it as well. I would like to know your feedback about the product.

Reference: Pinal Dave (http://blog.sqlauthority.com)

About these ads

Read Full Post »

It was a great day today as at a SQL Bangalore User Group we had an event “Women in SQL” day. This event was one of the milestone event as in India there was no UG in my knowledge had done an event where we appreciated “Women Power”. We had a very strong line up of the speakers and around 100+ people were there to appreciate the knowledge and presentation.

Shaivi Dave and Pinal Dave

SQL Bangalore is the most active SQL User Group in Bangalore and we have a vibrant and active community here. Here is the Facebook page where we are extremely active and here is the official website. Here was the agenda of the event. A big thank you to Pluralsight for offering USD 500 worth annual plus subscription to one of the winners of the event.

Shaivi Dave and Pinal Dave

  • Introduction to SSDT by Deepthi Anantharam – Microsoft
  • Usage of SQL Server 2012 express LocalDB by Chaitra Nagaraj – MVP ASP.NET
  • Working with SQL Server Maintenance Plans by Prabhjot and Shraddha – Microsoft
  • Migrating from Reporting Services 2008 to 2012 by Jaishree Karira (Independent Consultant)

Excellent participation of Technology Enthusiast

One of the surprise element which organizers were discussing ways to bring in the younger SQL Speaker to the stage and deliver some wisdom. We looked around and finally found a speaker who can talk a bit about SQL Server. The speaker we found was only 3 years and 7 months old and she was familiar with big data, SQL Server and basic syntax of the SQL Server. She also owns SQL Queries Books and learns SQL from Pluralsight. If you have not yet figured out by my narration she is my daughter – Shaivi Dave.

Women Power

It was indeed a matter of a proud for me as my own daughter was standing with me on stage and talking brief words on SQL Server in front of 100+ technology enthusiast with confidence. It was her debut stage appearance and I believe there will be many more in future. At this young age she likes to do everything what a young kid like to do but have a deep interest in SQL and Big Data. Here is a quick video which we had recorded during last month.

Shaivi Dave and Pinal Dave

Here are few of the photographs of the event.

Pluralsight Raffle Winner with all the rockstar speakers

Reference: Pinal Dave (http://blog.sqlauthority.com)

Read Full Post »

I have received a lot of inquiries about how to learn High Availability. Please reach out to my friends at Koenig Solutions.

The SQL Server 2012 offers a plethora of solutions for high-availability that assures 99.999% server and database Availability. These solutions enhance database and server availability, hide the failures of software or hardware and maintain application availability to curtail user downtime. It simplifies management and deployment of high availability systems with incorporated monitoring and configuration tools.  It also enhances performance and cost efficiency of IT utilizing up to four Active Secondary. An SQL Server 2012 High Availability course helps you develop capabilities that contribute in taking your career to new horizons. Some of the key capabilities are utilizing standby hardware to the fullest, implementing disaster recovery and high availability and raising the total application uptime significantly.

UPDATE: Since the blog post I have received a lots of inquiries about how to learn High Availability. Please reach out to my friends at Koenig Solutions.

SQL Server 2012 High Availability Features

  • AlwaysOn Availability Groups- This is a feature of enterprise level that helps in maximizing user database availability. It entails the Server instances of SQL to exist in WSFC (Windows Server Failover Cluster) nodes.
  • AlwaysOn Failover Cluster Instances - This feature influences work of WSFC (Windows Server Failover Cluster). It offers high availability locally using the redundancy feature at the level of the server-instance.
  • Database Mirroring- It enhances DB availability by providing support to instantaneous failover. DB mirroring can easily be employed for maintenance of a single standby DB or mirror DB, for an equivalent production DB which is called a principal DB.
  • Log Shipping-It executes at the DB level. Users can maintain warm standby DBs (or secondary DB) for just one production DB, called the primary DB.
  • Multi-site Clustering – Various enterprises have their data centers located in multiple locations. The main reason for such a step is to maintain redundancy and use a secondary data center for disaster recovery. In this way, organizations can protect their site from failure; whether it is infrastructure, power, network or any other on-site disaster.

Several solutions are there that have executed failover clustering of SQL Server and Windows Server with the multi-site model.  Multiple nodes are included in a multi-site failover cluster. These nodes are scattered across data centers or various physical sites, aiming to offer availability through data centers if a disaster occurs at any site. At times, multi-site failover clusters are considered as multi-subnet clusters, stretch clusters or failover clusters that are dispersed geographically.

High Availability and Disaster Recovery Methodologies

Mastering the Disaster Recovery and High Availability capabilities in SQL Server 2012 environment helps add on to an IT professional’s existing skill-set and allows them to enjoy a promising career ahead. You can build the competencies necessary for a database administrator, developer or architect to understand and manage SQL Server 2012 internal infrastructure. Here are a few methodologies for high availability and disaster recovery-

  • Easy monitoring of the high availability configuration with AlwaysOn dashboard. It is an illustrative configuration to keep your DB up to the mark.
  • In case a failover happens, it helps in controlling the same. Also, it helps to remove false instances and DB failover.
  • Setting up Availability Group will ensure multiple database failover as a single unit. This ascertains that the application has all databases available, up and running.
  • With Availability Group Listener, you get a comprehensive set of alternative choices and a faultless application failover.

SQL Server 2012 High Availability Benefits

SQL Server 2012 has developed a platform which brings you a good amount of benefits that can add to your SQL server set up. These benefits include-

  • Diminished cost of Hardware without shared storage using AlwaysOn.
  • For performance improvement, secondary replica can take the load of performing backups rather than unnecessarily burdening the primary server.
  • With the AlwaysOn High Availability feature, availability of your applications is enhanced.
  • Automated page repair and high latency system support.
  • Provides confidence to deliver in mission critical situations.

SQL Server 2012 High Availability is a new course which can prove to be a feather in the cap of IT professionals. They can further their skills in High Availability and Disaster Recovery in SQL Server 2012 set up. SQL Server 2012 offers you everything required for addressing data dependability and availability at correct time and correct price at every level of the enterprise. With this, you will learn various techniques for leveraging SQL Server technologies for acquiring high-availability of database solutions.

I have received a lot of inquiries about how to learn High Availability. Please reach out to my friends at Koenig Solutions.

Reference: Pinal Dave (http://blog.sqlauthority.com)

Read Full Post »

TechEd is the premier event from Microsoft and it is always pleasure to be part of the TechEd. This year I attended my fifth TechEd and I had presented at this event 4th time in the row. Presenting at TechEd is fun as there is a totally different level of pressure when presenting at this event. This year TechEd India was in two cities and it was double the fun.

Pinal presenting at TechEd India 2013

Pinal presenting at TechEd India 2013

TechEd Bangalore was on 18-19 March, 2013 and TechEd Pune was on March 25-26, 2013. I had presented 2 sessions at both the cities, total 4 presentation in TechEd India 2013.

Pinal presenting at TechEd India 2013

Pinal presenting at TechEd India 2013

Here is the title and abstract of the sessions I presented.

Pinal presenting at TechEd India 2013

Pinal presenting at TechEd India 2013

SQL Server Performance Troubleshooting: Ancient Problems and Modern Solutions

Audience at TechEd India 2013

Audience at TechEd India 2013

Many believe Performance Tuning and Troubleshooting is an art which has been lost in time. The truth is that art has evolved with the time and there are more tools and techniques to overcome ancient troublesome scenarios. There three major resource when bottlenecked creates performance problem: CPU, IO, and Memory. In this session we will focus on High CPU scenarios detection and their resolutions. If time permits we will cover other performance related tips and tricks. At the end of the session attendee will have clear ideas and action items regarding what to do in when facing any of the above resource intensive scenarios.

Pinal presenting at TechEd India 2013

Pinal presenting at TechEd India 2013

Pinal presenting at TechEd India 2013

Pinal presenting at TechEd India 2013

SQL Server Indexes – The Unsung Hero

Audience at TechEd India 2013

Audience at TechEd India 2013

Pluralsight Team Present at TechEd India 2013

Pluralsight Team Present at TechEd India 2013

Slow Running Queries are the most common problem that developers face while working with SQL Server. While it is easy to blame the SQL Server for unsatisfactory performance, however the issue often persists with the way queries have been written, and how Indexes has been set up. The session will focus on the ways of identifying problems that slow down SQL Server, and Indexing tricks to fix them. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

Pluralsight Famiy - Pinal, Nupur, Shaivi and Aaron Skonnard

Pluralsight Famiy – Pinal, Nupur, Shaivi and Aaron Skonnard

There are three major reasons I like to go to any events – 1) Community 2) Education 3) Friends. Just like every year I had a great time attending this year’s TechEd India 2013 event and I was able to meet many of my friends and engage with the community at large. I hope you enjoy the list this photo journey.

SQL Friends - Vinod, Balmukund and Pinal

SQL Friends – Vinod, Balmukund and Pinal

SQL Friends - Vinod, Pinal and Deepthi

SQL Friends – Vinod, Pinal and Deepthi

Additionally, my employer Pluralsight had a booth in the exhibition hall and I had a great time standing at the booth and engaging with community. Thanks to everyone who attended my session as well stopped by Pluralsight booth. It was a great event and I had a great time.

SQLAuthority Family - Pinal, Shaivi and Nupur

SQLAuthority Family – Pinal, Shaivi and Nupur

Reference: Pinal Dave (http://blog.sqlauthority.com)

Read Full Post »

HP has recently released a new product called Project Moonshot.  For anyone interested in databases, server systems, or cloud computing, the description of this new option was intriguing.  On its most basic level, Project Moonshot is a scalable server system, available in small units that are easy to enlarge and can run a variety of databases and clouds – anything you can think up.

Update: Don’t forget to scroll all the way down and read call for action. I value your opinion about NuoDB.

Basics of Project Moonshot

Here are the basics:  Moonshot consists of interchangeable and interlockable servers that are much smaller and more energy efficient than traditional models.  A single Moonshot unit is 4.3U tall and can hold 45 servers, which connect together with 1G ethernet (between individuals) and 10G Ethernet (for the whole system).  The systems, though, are available for purchase individually, configured with an Intel Atom S1260 processor, 8 G of memory and 200GB SSD or 500GB HDD.

Obviously this doesn’t appear to be a server to knock anybody’s sock off, but once you start scaling up, the possibilities are endless.  This system can scale up to 180 nodes in a single unit.  The end game with this kind of system is to provide different for servers for different jobs (like computation, storage, or memory).  You can put 45 units into a 4.3 rack-unit, and suddenly you have the computing power to reckon with, and it still energy efficient.

NuoDB and Project Moontshot

I’m sure a lot of minds are racing right now, thinking up ways to use this new technology.  Well, NuoDB certainly was.  They have been test driving this new system for the past few weeks, and have come up with some unique trials to best utilize and test Moonshot.  NuoDB designed tests to help showcase what they do best: scalable and cloud databases.

NuoDB took a real world situation in mind.  In the real world, hosts have multiple websites (like blogs) that all gets steady but low traffic.  However, if a blog is lucky, it will start attracting a lot of attention.  Attention = traffic.  A lot of traffic can seriously slow servers down if there is not enough computing power dedicated to them.  That is where a scalable system like Moonshot comes into play.  NuoDB also implemented some of their own techniques into the tests to show the full integration possibilities of Moonshot.

For example: hibernating and waking databases.  By keeping some computing power “in reserve,” Moonshot helps administrators take full advantage of all the database, assigning rules to govern when and how memory is used.  For high traffic sites or times, more power is parceled out for those needs, and less is used when less is needed.  The idea seems simple, but implementation required the Moonshot Project for it to become a reality.

This is a simple overview of a long-ranging project that looked at many different variables and what Moonshot was capable of under different circumstances.  The result, though, was that even when running 7200 active databases, they were only using about 70% of the system, leaving a huge percentage of power for extra growth and capacity.  Check out the NuoDB website for more details about this exciting new project!

Call for Action

Download NuoDB and try out their new innovation. The installation and download is extremely easy. I will be very interested to know what is your experience with NuoDB.

Further Reading

NuoDB team have been writing lots of interesting blog post on the subject of Moonshot. I strongly suggest you to read them.

Reference: Pinal Dave (http://blog.sqlauthority.com)

Read Full Post »

« Newer Posts - Older Posts »