Dinesh's Blog :::: Being Compiled ::::

Friday, January 3, 2014

Demo links for SS SLUG Dec 2013 - Brain Bashers

Demo 1: Filtering DateTime values – SS SLUG Dec 2013 – SQL Brain Bashers - Demo I

Demo 2: How SQL Server interprets two-digit years as four-digit years – SS SLUG Dec 2013 – Brain Bashers - Demo II

Demo 3: Best way to pass datetime values to SQL Server – SS SLUG Dec 2013 – Brain Bashers - Demo III

Demo 4: Can we commit inner (or nested) transactions?– SS SLUG Dec 2013 – Brain Bashers - Demo IV

Demo 5: http://dinesql.blogspot.com/2010/02/understanding-grouping-sets.html

Demo 6: Are you calculating Average correctly?

Demo 7: DBCC CHECKIDENT does not reset identity value as you need?

Demo 8: Ordering the result of Views – SS SLUG Dec 2013 – Brain Bashers - Demo VIII

Link for the presentation: {Pending}

Posted by Dinesh Priyankara at 8:35 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
View mobile version
Subscribe to: Post Comments (Atom)

Search This Blog

About Me

My photo
Dinesh Priyankara
Colombo, Sri Lanka
Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and business intelligence related projects. He is the Founder/Principal Architect of dinesQL (Pvt) Ltd and he consults, teaches and runs training programs on data related solutions and subjects.
View my complete profile

Pageviews last month

Top 50 sql server blogs

Top 50 sql server blogs
Top 50 sql server blogs

Blog Archive

  • ►  2023 (4)
    • ►  June (1)
    • ►  May (3)
  • ►  2022 (2)
    • ►  April (2)
  • ►  2020 (11)
    • ►  October (1)
    • ►  June (3)
    • ►  May (1)
    • ►  April (5)
    • ►  March (1)
  • ►  2019 (2)
    • ►  April (1)
    • ►  February (1)
  • ►  2018 (6)
    • ►  July (1)
    • ►  June (1)
    • ►  February (1)
    • ►  January (3)
  • ►  2017 (108)
    • ►  October (6)
    • ►  September (9)
    • ►  August (5)
    • ►  July (2)
    • ►  June (11)
    • ►  May (23)
    • ►  April (4)
    • ►  March (12)
    • ►  February (25)
    • ►  January (11)
  • ►  2016 (171)
    • ►  December (23)
    • ►  November (18)
    • ►  October (19)
    • ►  September (25)
    • ►  August (9)
    • ►  July (23)
    • ►  May (24)
    • ►  April (12)
    • ►  February (1)
    • ►  January (17)
  • ►  2015 (200)
    • ►  December (20)
    • ►  November (14)
    • ►  October (11)
    • ►  September (22)
    • ►  August (22)
    • ►  July (21)
    • ►  June (21)
    • ►  May (21)
    • ►  April (18)
    • ►  March (19)
    • ►  February (7)
    • ►  January (4)
  • ▼  2014 (56)
    • ►  October (2)
    • ►  September (2)
    • ►  June (11)
    • ►  May (3)
    • ►  April (6)
    • ►  March (5)
    • ►  February (16)
    • ▼  January (11)
      • SQL String concatenation with CONCAT() function
      • Business Intelligence: Dimensional Modeling - Do w...
      • Video link for SS SLUG Dec 2013 - Brain Bashers
      • Can a query derive benefit from a multicolumn inde...
      • Why column aliases are not recognized by all clauses?
      • SQL Server Management Studio – Five ways of execut...
      • Analysis Services: Exception of type 'System.OutOf...
      • Versions and Service Packs of SQL Server (2012, 20...
      • Demo links for SS SLUG Dec 2013 - Brain Bashers
      • Why SQL Server splits the page? I am changing an i...
      • Ordering the result of Views – SS SLUG Dec 2013 – ...
  • ►  2013 (21)
    • ►  December (5)
    • ►  November (1)
    • ►  October (7)
    • ►  September (1)
    • ►  August (4)
    • ►  June (3)
  • ►  2012 (3)
    • ►  September (1)
    • ►  August (1)
    • ►  January (1)
  • ►  2011 (32)
    • ►  November (1)
    • ►  September (1)
    • ►  August (1)
    • ►  July (3)
    • ►  May (3)
    • ►  April (7)
    • ►  March (3)
    • ►  February (4)
    • ►  January (9)
  • ►  2010 (79)
    • ►  November (8)
    • ►  October (9)
    • ►  September (5)
    • ►  August (4)
    • ►  July (6)
    • ►  June (8)
    • ►  May (14)
    • ►  April (6)
    • ►  March (11)
    • ►  February (6)
    • ►  January (2)
  • ►  2009 (42)
    • ►  December (4)
    • ►  November (9)
    • ►  October (4)
    • ►  August (7)
    • ►  July (1)
    • ►  May (5)
    • ►  February (4)
    • ►  January (8)
  • ►  2008 (13)
    • ►  December (10)
    • ►  November (3)

Read new stuff..........

  • Journey to SQL Authority with Pinal Dave

Popular Posts

  • SQL Server Sleeping Status and Connection Pooling
  • Configuring Reporting Services 2008 R2 in SharePoint 2010 Integrated Mode – Part I
  • When was my SQL Server Database last accessed?
  • Reporting Services 2008: Showing HTML content, and what it really renders
  • Configuring Reporting Services 2008 R2 in SharePoint 2010 Integrated Mode – Part II
  • Cannot login to SharePoint 2010 site when the Host Header is set
  • How to Connect HDInsight using Putty
  • How to find NT Service\MSSQLSERVER and NT Service\SQLSERVERAGENT accounts?
  • Database Normalization - 1NF, 2NF, 3NF, BCNF, 4NF and 5NF with examples
  • Script for creating DimTime Dimension Table and populating data

Places I visited

Places I visited
Ruwanwelisaya - Sri Lanka
Awesome Inc. theme. Powered by Blogger.