VIEW, Pugh, Barney McGrew…

Trumpton…Cuthbert, Dibble, Grub.

I never ceases to amaze me that there is always that little bit of SQL Server functionality that you didn’t know about. Some of it good and some of it bad, some of it just meh…

The other day I was stumbling around a new environment, when I decided to use the GUI to script out an existing set of views when I saw something that had me scratching my head. Underneath the actual view definition was the following (some names removed to protect the innocent)…

----------------------------------
-- note view definition removed --
----------------------------------
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1',
@value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "Customer"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 114
               Right = 227
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Order"
            Begin Extent =
               Top = 6
               Left = 265
               Bottom = 114
               Right = 492
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo',
@level1type=N'VIEW',@level1name=N'omsPerMonth'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount',
@value=1 , @level0type=N'SCHEMA',@level0name=N'dbo',
@level1type=N'VIEW',@level1name=N'omsPM'
GO

So after a few tests it turns out that when you create SQL Server Views using the SQL Server Management Studio View Designer, SSMS automatically generates and adds these properties to the view behind the scenes to aid the Designer for re-editing purposes. Please bear this in mind when generating scripts for deployment into your staging environments, whilst there doesn’t appear to be any performance drawbacks to this extra meta-data, it is messy and (imho) not best practice to redeploy into production.

Posted in development, gui, SQLServerPedia Syndication, ssms, tsql | Leave a comment

Who is watching the Watchmen?

smileyIt is funny, but when I first decided to put myself forward for the Nominations Committee this year, I didn’t realize that the whole process would turn into a Campaign for Election. It really goes against much of what I stand for and is not really what I believe the Community is truly about. My involvement with community efforts, whether they be PASS related or not, are done so because I believe that my input (if required) would be beneficial to the cause that  I am offering to invest my time, efforts and possibly finances into. I am not seeking publicity, nor am I interested in promoting any personal ventures, Companies or other self-serving interests into those efforts. What I *am* interested in, is that this ‘thing’ we all are part of benefits from my investment, whatever that may be. That is surely the whole purpose of being a volunteer? I volunteer my time and effort to you, so that you can benefit -not me.

So rather than talking about issues that affect us all and problems we face (not just with our Chapters or SQLSaturdays or Communities at large), we instead are focused on running a Campaign to get ourselves elected to a position on the Nominations Committee by talking about ourselves and why we believe we are the best person for the job. Not only is this impossible to ever know who is/was the best, but for me it kind of misses the point.

Lets stand for these positions based on what you will do for it rather that what it can do for you!

So before I go any further I want to put on record that I think there are some great candidates on the NomCom slate this year. Make sure that you vote for those people who will contribute selflessly and represent your views the way you expect. And if this isn’t me then make sure you find someone who will. Please check out my fellow candidates here.

Last year I watched the whole process of the Nomination Committee election and eventual Board of Directors selection with mixed feelings. Due to other personal commitments I was sadly forced to watch NomCom and the Board of Director elections from afar, but I watched it all with great interest, and made sure I listened in on the live #passvotes twitter stream and audio broadcasts.

I confess that as time went on, I grew more frustrated and disappointed with proceedings and decided that this year I needed to participate to either help give a voice to those things that are bothering me and add a new perspective to the elections or at very least gain further insight into the whole process.

One thing that I am looking for is Directors who are not afraid to make unpopular decisions (as long as they are made for the benefit of the PASS membership) whatever they may be, but also for them not just to have fresh ideas, but also to be ready to rethink old ones.

For those of you who know a little bit about the recent(ish) history of the PASS election process, the need for a Nominations Committee with a transparent and fair process in order to scrutinize and put through Board of Director candidates for the public slate will be obvious. However, as far as I can see, the system is far from perfect and I do wonder if we can do better?

Starting off with the Nominations Committee elections, I commend PASS for making it open to all its members and allowing essentially anyone to have the ability to put themselves forward as a candidate but one thing that particularly strikes me about this is that there isn’t really any established criteria in place for potential candidates to fulfill before putting themselves forward. Is this a good thing or should NomCom candidates have proven track records? How could this be governed and does anyone really care?
While I am sure that behind the scenes this kind of scrutiny does go on, why not make the full extent of this criteria public?

Potential NomCom candidates are themselves put onto a slate for the public vote, and this is now the stage of the election process where we currently find ourselves. Something that is not quite clear to me though, is that *if* a NomCom committee is felt necessary to slate the PASS BoDs, then why doesn’t the NomCom committee themselves require their own NomCom Committee ad-infinitum? Yes I agree, this proposal sounds a little daft but then I think it poses questions about the requirement and purpose of NomCom for the BoD itself. The current process doesn’t quite feel right or joined up to me.

pythonI think we also need to debate exactly what the role of the NomCom is. In my opinion the committee shouldn’t be there to determine or influence a candidates success or failure, but simply be there as an administrative effort providing feedback to weed out BoD candidates that do not meet certain criteria. It is important therefore to DEFINE exactly what that criteria is. Certainly we should be encouraging BoD applications from all around the World not discouraging them, which moves me nicely onto my final point.

With some of the recent good work in expanding the PASS brand globally, am I the only one that has noticed a complete lack of BoD candidates last year of Community contributors from other continents? I watched with disbelief when the BoD slate was announced, only to see that we had 4 candidates from the U.K and the rest from the U.S (and lets not forget last years or this years NomCom candidates)! What about Russia, Portugal, Italy, Germany, India, Turkey, South Africa, Poland, Israel, Austria, Singapore or even a Country closer to PASSHQ? Brazil or Mexico anyone? I know of many people in some of these regions who would make excellent Directors on the Board so where are they? Why aren’t they putting themselves forward or (worse) not making the slate?
Unfortunately I am not near enough to the process to understand why we didn’t have any candidates on the BoD slate. When I raised this concern last year I was told it was because there wasn’t any candidates, but if that is the case, we need to encourage them to apply. We need their ideas, we need their views and we need their membership.

I could go on and on about these and many more points, but for now, they are not important. If you want me on NomCom then I will represent all of these issues and any you raise to the best of my ability. I want people to apply to the Board of Directors for all the right reasons and make a difference for the good of all. Let’s try and make this happen, I know we can!

p.s.

If you are interested then you can access my application form for NomCom from here.

Posted in Community, personaldevelopment, sqlpass, SQLServerPedia Syndication | 2 Comments

Your Country Needs You! PASS NomCom is announced.

your-country
(Please also check out my latest post on the NomCom election found here)
If you haven’t already heard, the official slate for the 2014  NomCom committee has been finalized and published by the Professional Association for SQL Server (that’s PASS to you and me) and can be found on their website via this link. You can check out the list of 11 candidates (and how to vote) in which I am very pleased to announce I am one of them having decided to put myself forward this year for reasons that will become clearer in future posts.

For now, I would like to extend a very huge welcome and congratulations to my fellow candidates and I am pleased to be in their esteemed company during this process and listen to their ideas and comments they have. I personally already know many of them and believe that they are great possible representatives for PASS and its members.

For those of you who may be unfamiliar as to what exactly the Nominations Committee (NomCom) is or its purpose, I shall do my best to explain. Put simply,  each year NomCom is responsible for putting forward a slate of suitable candidates for the Board of Director (BoD) public voting process. Those successful BoD candidates elected from the public vote will then serve an initial term of two years. However prior to all this, the NomCom candidates are themselves chosen via a public yearly vote from a slate of candidates and therefore YOUR support and involvement in the whole BoD elections starts NOW!

Regardless of WHO you want or your Country of origin, it is important to start making your voice heard for the good of the SQL Server Community at large. Please get involved, update your profile and start understanding who you should elect to NomCom (and why) and ultimately who you want to elect as a future BoD.

Posted in Community, personaldevelopment, sqlpass, SQLServerPedia Syndication | Leave a comment