Sessions Accepted for DevTeach Vancouver BC

Today I learned that two of the sessions that I proposed for Vancouver DevTeach were accepted.

This event taking place on December 2nd to 4th 2013 at the Vancouver Sheraton Wall Center Hotel. It will have 3 full days of main conference (Dec. 2-4). Don’t miss this Vancouver DevCon!

The first session:

Using FILESTREAM and FILETABLES in SQL Server

Steve Stedman – SQL341
Configuring and Using FILESTREAM and FILETABLES in SQL Server Developers love to use SQL Server to store files, but this causes headaches for the DBA, finally a reasonable solution for file storage in SQL Server FILETABLES and FILESTREAM. SQL Server 2008 and 2012 add the new features of FILESTREAM and FILETABLES. Learn how to configure and manipulate files in your SQL Server with FILESTREAM, then learn how to do everything that FILESTREAM sounds like it should do with FILETABLES. With FILETABLES inserting is as easy as drag and drop.

And the second:

SQL Server Performance for Developers

Steve Stedman – SQL327
For the .NET programmer, Visual Basic programmer or PHP programmer, if you are accessing a SQL Server database there are some things you should know to performance tune your queries. Learn how to improve query performance with Indexes, how to properly use parameterized queries, using the query analyzer, and avoiding common SQL Server performance pitfalls.

This should be fun. I always enjoy spending time with the #SQLFamily to the North.  Where I live, even though it is in the United States, Vancouver is the closest large city at only 44 miles from home, where Seattle is 97 miles form home for me.

Introducing the Joes2Pros Academy

The new Joes2Pros Academy has just launched. The Academy provides an interactive classroom experience that can be accessed on your own time as you need it. This site has high quality content, quizzes and exams. Click play to watch the video below for more information on the Joes2Pros Academy.

Students can interact with other students and instructors to get the best experience out of the Joes2Pros Academy.

Courses offered in the following areas:

  • SQL Server Administration
  • SQL Server Developer
  • SQL Server BI
  • SSRS
  • AlwaysOn
  • C#
  • and more

The Joes2Pros Academy helps you take the journey from average Joe to technology Pro.

As an instructor in the Joes2Pros Academy I have been able to learn a great deal from the other instructors.  I recommend taking a look and at least trying out the free 3 day trial.

SQL Sunday Fun – Word Search with New T-SQL 2012 Functionality

 

 

new_sql2012_word_jumbleClick on the grid to enlarge, then print it.

Find the following words in the grid up, down, left, right, horizontal, vertical, and diagonal.

ROWS  RANGE  PRECEDING 
FOLLOWING  UNBOUNDED  IIF 
CHOOSE  OFFSET  FETCH 
FORMAT  CONCAT  SEQUENCE 
PARSE  TRYPARSE  TRYCONVERT 
THROW  LEAD  LAG 
FIRSTVALUE  LASTVALUE  PERCENTRANK 
CUMEDIST  PERCENTILEDISC  PERCENTILECONT 

NOTE:  some of these terms normally have an underscore in them, but for the purpose of the word scramble the underscores have been omitted.

 

Related Links:

SEQUENCE object

CHOOSE function

Analytics - Analytic Functions – PERCENT_RANK

Analytics PERCENTILE_DISC and PERCENTILE_CONT

IIF function in TSQL.

TSQL Analytic Functions LEAD and LAG

OVER clause with ROWS PRECEDING and FOLLOWING in TSQL 2012

OFFSET / FETCH in a SELECT statement

Cumulative Distribution Function (CDF) or as it is known in TSQL CUME_DIST()

 

 

SQL Sunday Fun – Word Search with SQL Server DBCC Commands

SQL_DBCC_Commands

The following DBCC commands are all hidden in the word search.  Be aware, some of the DBCC commands are undocumented.

CACHESTATS CHECKCATALOG CHECKCONSTRAINTS
CHECKDB CHECKFILEGROUP CHECKIDENT
CLEANTABLE DROPCLEANBUFFERS FLUSHPROCINDB
FREE FREEPROCCACHE FREESESSIONCACHE
FREESYSTEMCACHE INDEXDEFRAG OPENTRAN
OUTPUTBUFFER PAGE PROCCACHE
SHOWCONTIG SHRINKDATABASE TRACEON
TRACESTATUS UNPINTABLE UPDATEUSAGE
USEROPTIONS

END OF PUZZLE ————————-

See also:

For more information on DBCC Commands:

SQL Sunday Fun – Word Search with SQL Server Keywords

SQL_KeywordsThe following SQL Server keywords are hidden in the word search puzzle. Find them all!

ALTER BETWEEN CLUSTERED
COLUMN COMMIT CREATE
DATABASE DEFAULT ELSE
END EXECUTE EXIT
FOR FUNCTION GRANT
IDENTITY INSERT KEY
NOCHECK NONCLUSTERED NULL
OFFSETS OPENDATASOURCE OPENQUERY
OPENROWSET OPENXML OPTION
OVER PIVOT PRIMARY
PROCEDURE RAISERROR RECONFIGURE
REPLICATION RESTORE RETURN
RIGHT ROLLBACK ROWCOUNT
SELECT SET STATISTICS
THEN TRAN TRANSACTION
TRIGGER TRUNCATE UNIQUE
UPDATE USER VALUES
VIEW WAITFOR WITH

SQL Server Crossword Puzzle

SQL Crossword

Across

2. Management Studio
5. The database that is used as a template when creating a new database
6. Using a backup
7. Reporting Services
9. An index that rearranges the structure of a table
12. The underlying structure of an index
13. Common Table Expression
20. Making queries run faster
21. An index that doesn’t change the structure of the table
22. The often misunderstood go-faster switch

Down

1. A data type to hold international strings
2. A type of join where the left and right tables are the same table
3. The option used in a CTE that needs to recurse more than 100 levels
4. A type of join that produces a Cartesian product
8. A derived table
10. Not the consistency checker
11. The concept of everything a query needs being available in the index
14. Sometimes called the upsert
15. High Availability
16. Binary large object
17. Transact SQL
18. the two transactions collide
19. Codename for SQL Server 2012

Print the crossword puzzle and fill it in on paper.  The solution will be posted in a couple days.