SQL Server Path

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

By Hossam Alfraih, on May 18th, 2013

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 ..?!

By Shehab El-Naggar, on November 16th, 2012

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 …?

By Shehab El-Naggar, on November 10th, 2012

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 …?

By Shehab El-Naggar, on November 6th, 2012

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 …?

By Shehab El-Naggar, on November 3rd, 2012

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

http://www.sql-server-performance.com/forum/threads/reanme-linked-server.33784/

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

By Shehab El-Naggar, on October 31st, 2012

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 ..?

By Shehab El-Naggar, on October 28th, 2012

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:

http /www.sql-server-performance.com/forum/threads/upgrading-from-sql-server-2005-to-sql-server-2008.33771/

Online Event – Memory Management in SQL Server 2012

By Nabeel Derhem, on October 7th, 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 Link: https://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.

SQL Server Path Offline Event (4th of October)

By Nabeel Derhem, on September 29th, 2012

We’ve been cooking this for a while, and here it is. Our event will be held in Riyadh as a first step (Jeddah and Khobar, you’re next). We’ll be having four sessions stating with Hossam discussing the hows and whats of becoming a Database professional for students. The second session will also be a very interesting one for students and professionals, where Nabeel will introduce the audience to SSIS, its uses, and features. These two sessions will be giving in Arabic to ease the communications with the audience.

The third session with Kamal will be about Data Modeling, and I don’t think I need to add anything to how important this session is for everyone. Our last session will be an advanced one, where Shehap will discuss techniques to tune your T-SQL scripts in SQL Server.

If yo want to know more, click HERE

See you all soon.

Online Event – SQL Server Database Design Tips for Optimum Performance

By Hossam Alfraih, on August 25th, 2012

Date: Wednesday, August 29^th 2012

Time: 2:00 p.m. ET | 7:00 p.m. UTC/GMT | 10:00 p.m. KSA

Duration: 1 hour.

Session: SQL Server Database Design: Size DOES Matter

Speaker: Thomas LaRock

Abstract:
Great database performance starts with great database design. During the design process it is important to select your SQL Server datatypes wisely. Failure to do so will result in wasted disk space, additional I/O overhead, and decreased performance. There is also the risk that your design will not scale as well as it should. Unless you have unlimited hardware purchasing power, size matters.

Please join Sr. DBA Thomas LaRock (@SQLRockstar) for this live event to learn how smart, effective database design will ensure your databases perform at their peak efficiency. You will learn how to choose the best performing datatypes, how to measure their effectiveness, and how to correct bad datatypes decisions (decision that were not, of course, made by you.)

Bio:
Thomas LaRock is a seasoned IT professional with over a decade of technical and management experience. Currently serving as a Senior DBA for Confio Software, Thomas holds a MS degree in Mathematics from WSU. Thomas currently serves on the Board of Directors for the Professional Association for SQL Server (PASS), and is also a SQL Server MVP. Thomas can also be found blogging at http://thomaslarock.com and is the author of DBA Survivor: Become a Rock Star DBA (http://dbasurvivor.com).

Registration: Register Now

Enjoy SQL Server!

~ Hossam

Categories

Archives