SoCal Code Camp

We will be getting back to the basics of Microsoft SQL Server and looking in depth at all of the object types within SQL Server as well as the commands to work with them. All to often people focus on the advanced high end parts of SQL Server without getting a good grounding in the basics of SQL Server.

Tag: SQL Server
Interested: 43

We will be getting back to the basics of Microsoft SQL Server and looking in depth at all of the object types within SQL Server as well as the commands to work with them. All to often people focus on the advanced high end parts of SQL Server without getting a good grounding in the basics of SQL Server.

Tag: SQL Server
Interested: 41

My apologies as I am down with a nasty flu and will not conduct this presentation. For those of you interested, a more comprehensive version of this presentation will be given by me at the Inland Empire .NET User Group on March 9th. Additional details can be found at http://www.iedotnetug.org soon. Data mining features of SQL Server 2008 provide effective analytical capabilities for your next generation applications. The intent of this presentation is to provide plenty of examples to show you SQL Server 2008 predictive environment and its features. Embedding Analytical reports within your desktop applications is also ceovered.

Tags: SQL Server | Data Mining
Interested: 38

With the release of SQL Server 2008 and SP1, a lot of shops are looking at how they can migrate and move to the latest version. One of the big questions is what features as I developer can I take advantage of? This session is intended to answer those questions. SQL Server 2008 has many features for you to take advantage of such as Table Valued Parameters, Merge, Grouping Sets and Spatial Data Types to name just a few. We will walk thorugh all of the new features for Developers in SQL Server 2008 and how you can use them in your environments.

Tags: SQL Server | Database
Interested: 36

This second session of what's new in SQL 2008 R2 will focus on all features that are not part of SSRS. We will cover features such as Application and Multo-Server Management, PowerPivot, and StreamInsight.

Tags: SQL Server | SQL 2008 R2 | Database
Interested: 18

With the upcoming release of SQL Server 2008 R2 there are a bunch of new features for SQL Reporting Services. We will explore some of those new features such as Paging Enhancements, Shared DataSets, Report Parts, ATOM Feeds and many more. If you want to see what is coming, this is the place.

Tags: SQL Server | SQL 2008 R2 | Database
Interested: 29

In this session, we will talk about CLR User-Defined Data Types. Code will be shown in C# that is a data type for an e-mail address using Visual Studio 2008. A database will be created and CLR integration will be turned on using T-SQL code. The CLR User-Defined Data Type will then be tested using T-SQL code. Implementing Domain Integrity, we will use the CLR function inside Check constraints to validate e-mail addresses against a regular expression. We will first create a test table then try to add the Unique constraint on the test table email address column. Creating DML Triggers and Testing Data Integrity, we will create an AFTER DML trigger also test all the data-integrity checks we implemented.

Tags: T-SQL | SQL Server 2005 | SQL Server | SQL
Interested: 23

In this session, we will talk about returning data from a SQL SERVER database using the SELECT statement. This is for those of you who are new to SQL SERVER 2005 T-SQL query language. We will SELECT specific columns for every row, selective querying using a basic where clause using operators and expressions, ordering results, grouping data and using distinct in aggregate functions. We will then go into querying from more than one data source using inner joins and outer joins. We will also review how to modify data using the T-SQL INSERT, UPDATE, and DELETE commands. We will review the basics of each command and cover specific techniques such as inserting data from a stored procedure.

Tags: T-SQL | SQL Server 2005 | SQL Server | SQL
Interested: 14

We will be looking at some of the advanced features of SQL Service Broker as well as some of the advanced techniques which can be used to maximize the performance of the SQL Service Broker.

Tag: SQL Server
Interested: 16

Learn about geolocation throughout the Microsoft development platform, from the database through the application layers, in the browser and beyond. Examples will be shown to demonstrate the potential of integrating location data in your own applications. Learn about recent developments (such as the W3C Geolocation API and Bing Maps Silverlight support) and how you can leverage them today.

Tags: SQL Server | JavaScript | GPS | geolocation | C# | Bing Maps
Interested: 16

Microsoft SQL Server 2005 and 2008 include a fantastic feature that few people understand or use. That feature is the Microsoft SQL Server Service Broker. The SQL Service Broker is one of the least used features within the database engine, and that lack of use is simply from last of knowledge about the feature. In this session we’ll dig into how to configure the service broker for not only intra-database message queuing, but database to database queuing as well as server to server database queuing. We will also dig into a real life scenario where the SQL Server Service Broker was used to do ETL from an OLTP database to an OLAP database in near real time for near real time reporting. By the end of this session you'll understand where SQL Service Broker is the right fit to be used, and you'll hopefully be ready to deploy it within your environment.

Tag: SQL Server
Interested: 31