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

SQL Awesomeness: Finding a QUALIFY query clause in the depths of the database ocean

-
Image
After so many years of writing SQL queries, I cannot believe I never came across a QUALIFY query clause. It feels like discovering a treasure in the depths of the database ocean. Even ChatGPT was not aware of it! QUALIFY query clause was invented by Teradata and is not a part of SQL Standart but apparently, multiple database vendors are supporting it, for instance, Snowflake and Databricks. QUALIFY clause solves the challenge when applying a window function as a query filter. SQL Standart and most database vendors will not allow to run of a window function as a part of a WHERE clause because window functions get evaluated after the HAVING clause. We typically create a CTE or subquery adding a window function to be able to filter on a it at a later query stage. Here is an example of how you can use QUALIFY to piece-of-cake filter on the window function.  I will use the Snowflake database, as an example. Let us consider that we have a list of queries and we need to find the last query ex
Read more

Look back and realize how far you came

-
Image
It appeared out of nowhere while I was having a strong argument with the ton of dust that had taken over my computer room. My former favourite book, "Advanced Transact-SQL for SQL server 2000" brought an upset look to my face, the one I usually get from our NetApp admin. He usually gives me such a look when I ask him for more disk space. At the time of SQL 2000 there were far less good SQL books available than today and amazing SQL programming tricks were living on Itzik’s book pages; and, similar to the Rubeus Hagrid’s “The Monster Book of Monsters” it attacked anyone who attempted to open it, unleashing wild and exciting brilliant ideas. Nowadays there are a lot of SQL books but not all of them are worth reading. Some of them should be strongly avoided and if you touch them you should immediately wash your hands and have a drink or three. A few month ago I was asked to technically review some new SQL Server book. Reading their missleading claims of how the optim
Read more

The Greatest Reasons to use or not to use a Centralized Data Access Architecture

-
Image
When developing a modern Data Platform Layer, one of the main decisions is whether to opt for centralized or decentralized data access architecture.  There is no “one-fits-all” solution, both have advantages and disadvantages. A Centralized Data Access Architecture would usually mean duplicating data from the operational layer into the analytical layer and applying various transformations to data to support and speed up data analytics. Operational online transaction processing Layer , where all microservices and their operational databases are located. Analytical Data Layer , where we would have data lakes that support data Scientists' work and a data warehouse, that supports Business Intelligence. Transformations, ETL or ELT data pipelines , which are moving data from the operational layer into the analytical layer. I f we opt for a Centralized Data Access architecture, what would be the benefits and the drawbacks? CONSISTENCY : consolidating data into a central location can
Read more