Online Event – I got 99 problems but my backups aint one

Date: October 9, 2013

Noon Mountain

http://www.timeanddate.com/worldclock/fixedtime.html?msg=PASS+DBA+Virtual+Chapter++Meeting&iso=20131009T12&p1=75&ah=1

Presenter: Richard Douglas

Abstract:

In this session, you’ll gain invaluable guidance for optimizing your backup and recovery efforts. Richard Douglas will show you how to dramatically accelerate backups, perform faster recoveries, and ensure your organization’s critical data is always protected. Plus, you’ll learn tricks and tips to master database monitoring and benchmarking to achieve peak system performance.

Bio: Richard is a Systems Consultant for a vendor of SQL Server solutions where he specializes in SQL Server providing solutions and system health checks to organizations across the EMEA region. Richard has recently taken on the responsibility of being Editor in Chief of the community site Toad World which provides articles on SQL Server and a blog syndication service, other duties see him regularly presenting webinars to both US and EMEA audiences. He is also a keen member of the SQL Server community, he founded and runs a PASS affiliated chapter in the UK (www.SQLStudy.org) and is on the organizing committee for a national event called SQLRelay.

Note: we have changed platforms for the DBA VC meetings. If you want to attend the meeting, you must register at

https://attendee.gotowebinar.com/register/462894748761993986

After registering, you will receive a confirmation email containing information about joining the webinar. All registrants will be included in a drawing for a $50 Amazon gift card.

Note: the meeting will be recorded and available on the meeting archives page at dba.sqlpass.org about a week after the event.

Disabling and Enabling Indexes – Why You Should Consider Rebuilding Your NonClustered Indexes?

When a Clustered Index is disabled, all the NonClustered indexes on the same table are auto disabled as well.

However, when a Clustered Index is enabled, it does NOT automatically enable NonClustered index. So, you need to enable them one by one or REBUILD ALL.

Here is a script that can rebuild them all:

USE MyDatabase
GO
ALTER INDEX ALL ON MySchema.MyTable REBUILD
GO

The Leaf level of each NonClustered index is pointing to data pages in Clustered Index. Disabling the Clustered Index will not make NonClustered index pointing to data – it will be pointing to a disabled index instead. So, here is why auto disabling NonClustered Index is very reasonable and make sense!

Enjoy SQL Server!

~ Hossam

SQLServerPath is organizing the first SQLSaturday event in Middle East – SQLSaturday#208 in Riyadh, Saudi Arabia.

The first SQLSaturday event in the Middle East region (SQLSaturday#208) is going to be on Thursday 23-May-2013 in Riyadh, Saudi Arabia.

Eight local and international speakers will give 10 sessions in two tracks during this full day for FREE technical sessions related to SQL Server.

So far we have good number for registered people (male and female) and looking for you to be among them. If you are not registered yet, you can register here.

You may use event hash tag #SQLSatRiyadh to spread the word.

Don’t forget to spread the word and tell the world!

Important Links:

Riyadh SQLSaturday – Home Page

Registration Page

Event Location and Map

Event Schedule

Event Sponsors

[Arabic] Arabic post about Riyadh SQLSaturday#208 Event

[Arabic] What is SQLSaturday Event? Know more about the event in general.

See you soon at the event!

~ Hossam Alfraih

How you can make Joins on Uniqueidentifier and varbinary() columns with the optimal performance ..?!

We are usually talking about columns of data types such as  uniqueidentifier and varbinary()as they are inappropriate columns for Joins due to their bad performance so what we can do if no anywhere to go for our schema design without these data types and in the same time we need to join based on them in heavy queries with the optimal performance and with the least CPU/IO impact on your DB production server..

Here below is a real case of using uniqueidentifier everywhere in DB and see how it can be solved using Persisted Deterministic Computed Columns to get the optimal performance …

http://social.technet.microsoft.com/Forums/en-US/sqldatawarehousing/thread/907957dc-e67f-4be0-a77d-5ad60dd5a3d0

How to troubleshoot IO bottleneck cases on DB production Servers …?

Once it comes to talk about IO bottleneck cases, we are almost talking about the worst malfunctions for any DB production server either working on local storage or enterprise SAN storage that most of DBA get much worries about them coz they have almost much ambiguity that can be compromised hardly which ends up eventually with some standstill cases for production DB servers

Here below is a good guideline for any DBA to help him in troubleshooting such IO bottleneck cases, by the fastest ways and in the shortest time…

http://www.sql-server-performance.com/forum/threads/how-to-optimize-sql-server-performance-with-san.33762/

How to sync data between 2 different DBs with the least possible down time …?

How to sync data between 2 different DBs with the least possible down time …?

Lots of DB Developers & DB Analysts are wondering this how to sync data from an old DB with a poor schema design and low NF( normalization form ) to a new DB having a rich schema design and better NF ..

The WOW factor here is how to do that with the least possible down time …?

You can learn more at this thread below:

http://www.sql-server-performance.com/forum/threads/how-to-keep-maintain-data-in-two-not-identical-databases-via-one-application.33776/

How to rename linked server with a different name …?

How to rename linked server with a different name rather than the original name of SQL Server instance  …? You can learn more about it at the below thread

How you can remove different lookups exists at your Query execution plans…?

How you can remove different lookups exists at your Query execution plans…? you can read more at the below thread to speed up your queries significantly

http/www.sql-server-performance.com/forum/threads/bootstrap-lookup.33785/

How you can upgrade windows and SQL Server versions of a DB cluster ..?

How you can upgrade windows and SQL Server versions of your production DB cluster from SQL Server 2005 to SQL Server 2008 and from Win 2003 to Win 2008 R2 without any need to additional servers..?
You can learn more about it at the below thread:

Online Event – Memory Management in SQL Server 2012

Date: October 9, 2012

Noon Mountain time – http://www.timeanddate.com/worldclock/fixedtime.html?msg=PASS+DBA+Virtual+Chapter+Live+Meeting&iso=20121010T12&p1=75&ah=1

Presenter: Neil Hambly

Abstract:

SQL Server 2012 brings a wide range of changes from its previous versions – one key change is the way SQL Server memory is managed. With releases prior to SQL Server 2012, there were 2 memory managers, these have been merged into 1 with the latest version,
and that’s just the start of the changes for SQL Server memory. This session will dive into questions related to memory in SQL Server 2012.

Session Takeaways:
• Explore SQL Server 2012’s new memory architecture and learn how to diagnose memory performance issues
• Gain insight on memory pressure issues
• Discover settings to adjust the memory configuration levels and their impact

Bio:

Neil Hambly is a SQL veteran of more than 13 years, with expertise in SQL Server from Version 6.5 to the latest 2012 editions. He’s held database roles at major organizations, including the BBC, ABN AMRO, Accenture, as well as at a number of smaller companies. He’s currently serving as a Database Architect at MDSL, with prior roles as both a DBA and developer.

An active speaker and leader of the London Area SQL Server User Group (UK), Neil can frequently be seen at UK and international events. You can also find him sharing online via his blog, Twitter, and LinkedIn. When not presenting or organizing UG events, Neil is hitting the books and keyboard as he studies for the SQL Server 2008 MCM certification.

Door prize: There will be a raffle for a $50 Amazon gift certificate.  You do not need to register for the meeting, but if you want to enter the raffle, you must register at https://www.livemeeting.com/lrs/8000181573/Registration.aspx?pageName=2vk5v398vnbv91sp no later than 5:00 PM EDT on October 9th.

Live Meeting Linkhttps://www.livemeeting.com/cc/8000181573/join?id=627TDQ&role=attend

Note: the meeting will be recorded and available on the meeting archives page at dba.sqlpass.org about a week after the event.