Boise SQL Server User Group

Common Table Expressions and Unit Test for SQL


Next Meeting: Jan 9th, 2018   4:30 PM.  

Location: Microsoft office in downtown Boise


Meeting details:

We have two presentations for you this month.

First Denzel Boggs will be doing a presentation on Common Table Expressions (CTE).
A common table expression (CTE) can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query.

Then Chris Frye will be doing a presentation unit testing in SQL using tSQLt. "tSQLt" is an open source Database Unit Testing framework for SQL Server.

 

 

Other Events

 



Welcome to the Boise SQL Server Users Group Website

 

 

 TitleDescriptionSize Created Date
Always on Availability GroupsKevin Snow's Powerpoint on Always on Availability Groups.1.17 MBDownload6/12/2014
Resource GovernorPowerpoint of the Resource Governor76.71 KBDownload7/29/2011
Data Architecture, Data Governance, and Success! Success is not static, and continued success requires continued growth. Data Architecture and Data Governance can help manage that growth, but they usually require cultural changes. This talk will cover the basic levels of Architecture Maturity, and the 570.07 KBDownload5/14/2014
New Features in SQL Server 2008 and 2012 Tim Roger's presentation on New Features in SQL Server 2008 and 2012.536.47 KBDownload1/16/2014
Resource Governor ExampleExample2.90 KBDownload7/29/2011
MAXDOPPresented By Cindy Gross2.90 KBDownload2/15/2011
Free Trial of Azure UnknownDownload11/24/2010
SQL Azure For The DBAKate Baroni slide deck from Boise SQL Sever Users Group November meeting.2.90 KBDownload11/24/2010
Inside SQL Azure UnknownDownload11/24/2010

Please visit our sponsors    

     
     

 

Our Meetings begin at 4:30 pm and last until roughly 6:00 pm.  Refreshments are usually available, dependent upon our sponsors.





 

We have meetings on the second Tuesday of every month except December.  Our group "usually" meets (unless indicated otherwise) at the Microsoft Offices on the 6th floor of the Idaho Independent Bank Building.  Remember to park in the dirt lot across the street.



***Address***

401 W. Front Street

6th Floor N. Fork Room

Boise, ID

 

If you would like to subscribe to our email list and receive emails about group meetings and events please go to the PASS website: https://www.sqlpass.org and register for our users group.

 

 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids