PASS 2011 summit excitement

-

The PASS summit is an amazing event, it is fantastic to see more than 4000 SQL Server DBAs and BI developers from all over the world at the one place. Everyone here is talking SQL, joking SQL and breezing SQL. The most terrific thing about an SQL Server DBAs is that crazy and passionate light in their eyes when they talk about their job and an SQL Server in general.

I'm very new to the twitter world but here everything that happens on summit is always commented on twitter ( note the big screen on the photo - it's all twitting) , all the tricky questions and the funny remarks during the sessions, mentors criticizing notes and, of course, "thank you very much for a great session" comments as well as all activities like #sqlrun in the morning, #sqlawards , #sqlquiz and #sqlclinic during the day and #sqlkaraoke in the evening. Second day of the PASS was #sqlkilt day, many #sqlpeople were going around in kilts.



It's quite difficult to choose which lecture to attend because there are 15 at each timeslot and always at least 3 that looks like "the must". I have attended many, some of them were breathtaking, some were more interesting, some less, some were just to meet the mentors who actually write those books that we read, those sqlblogs and articles that we discuss. Towards the end of the day there are more and more people with melted brain were seen around. The absolute top winners of all sessions were:

  1. Pre-conf "All about execution plans" by Gail Shaw and Grant Fritchey
  2. Pre-conf "An enlightened approach to performan tuning" by Adam Machanic
  3. "Inside Tempdb" by Bob Ward
  4. "Important trace flags that every DBA should know" by Victor Isakov
  5. "More DBA mythbusters" by Paul Randal
  6. "Zen and Art of workspace memory" by Adam Machanic

The time flew so fast, summit is over and I’m back home, need somehow to stop Twitter addiction, cannot make myself stop following #sqlpass twits because this way I feel I’m still back there among this incredible #sqlfamily.

Comments

  1. IddoRonenNovember 14, 2011 at 12:04 AM

    Thanks maria,

    It seems you had a great time there.

    At least one of the sessions you mentioned (Victor Isakov on trace flags) can be found in previous PASS recordings, as listed here
    http://www.sqlserver.co.il/?p=3264

    ReplyDelete
  2. Geri ReshefNovember 14, 2011 at 12:04 AM

    How does it come you didn't tell us about your blog?
    I Promisse to read it from now on.

    ReplyDelete
  3. IddoRonenNovember 14, 2011 at 12:33 AM

    Thanks Maria,

    It seems you had a great time there.

    At least one of the sessions you mentioned (Victor Isakov on trace flags) can be found in previous PASS recordings, as listed here
    http://www.sqlserver.co.il/?p=3264

    ReplyDelete

Post a Comment

Popular posts from this blog

Unlocking Microsoft Fabric: A Simple Guide when you only have a personal account.

-
Image
" You cannot create a Microsoft capacity using a personal account. Use your organizational account instead." What a disappointment and frustration! I've been trying to set up Microsoft Fabric for a while now and figure out how to work around this error. I use my personal Gmail for an MVP subscription to learn and experiment with Azure services. When I visit app.fabric.microsoft.com and try to use my private Gmail address, I keep getting a similar message: It's frustrating because I'm eager to dive into Fabric and explore its capabilities. I would get the same error trying to set up Azure Data Catalog, PowerBI embedded, and more. What are the different account types and how do they differ? A work or school account is created through Active Directory or other cloud directory services, such as Microsoft 365. On the other hand, a personal account is one that's manually created for individual use, consisting simply of a username and password. After digging into ...
Read more

ETL to ELT journey: Break free your Transformations and discover Happiness and Data Zen

-
Every data integration pipeline consists of 3 stages: Data Extraction (E), Data Transformation (T) and Data Load (L) During the  Data Extraction stage, the source data is read from its origins: transactional databases, CRM or ERP systems or through data scraping from web pages. During the  Data Transformation stage, the necessary modifications are applied to the source data. This includes data filtering, enrichment or merging with existing or other source datasets, data obfuscation, dataset structure alignment or validation, fields renaming and data structuring, according to the canonical data warehouse model.  During the Data Loading stage, the data is stored in the pipeline destination, which could be a staging area, data lake or data warehouse. There are two principal methods for the data integration process: transferring it from where it originated to the destination, where the data will be used for analysis, ETL and ELT. The difference between ETL and ELT pipelines...
Read more

Coding is a rollercoaster of efficiency and eyebrow-raising discoveries.

-
Image
Data Engineers or Developers - many of us love to be gourmet chefs in the kitchen. When it comes to planning and design, we would rather throw all ingredients in the pot and see how it comes out.  Coding without a plan is like assembling a puzzle in a dark room. The result will most probably be unexpected and off the canvas. Whether you follow Waterfall or Agile development strategy, planning and design phases are non-negotiable and are essential to reduce development cycles and redo work. Once upon a time, one data engineer created an amazing piece-of-cake automation pipeline. This masterpiece had very complex logic, pulling data from multiple sources, and merging and persisting the data in a complex, incremental way. When the pipeline started to run successfully and automation flows worked, the data engineer got very excited and considered this development done. A few days later QA engineer found out that the result dataset was never created in the destination. Why has that ...
Read more