Blog: SQL Server

"Cool" New Courses for Entity Framework

By Brian Ewoldt

We've joined forces with our Yeti instructor, Don Kiely, to create two new Entity Framework 6.1 courses for you.

This blog entry was originally posted January 28, 2015 by Brian Ewoldt

Entity Framework SQL Server


Transaction Support in Integration Services

Excerpt by Don Kiely

A transaction is a core concept of relational database systems.

This course excerpt was originally posted March 25, 2014 from the online courseware SQL Server 2008: Integration Services by Don Kiely

SQL Server


SQL 2012: Developer: NULLs and SqlBoolean

By Frank Tillinghast

When integrating T-SQL with the CLR, remember to declare variables, parameters, and return values of data types exposed through the System.Data.SqlTypes namespace.

This blog entry was originally posted March 06, 2014 by Frank Tillinghast

SQL Server SQL Developer


SSRS 2008: Reporting Services and SharePoint

By Paul Litwin

SQL Server 2008

This blog entry was originally posted February 27, 2014 by Paul Litwin

SSRS SQL Server SharePoint


SQL Server 2008: The BIDS Interface and Components

Excerpt by Don Kiely

SQL Server Integration Services is not the only member of the Microsoft Business Intelligence suite to use BIDS for development.

This course excerpt was originally posted February 13, 2014 from the online courseware SQL Server 2008: Integration Services by Don Kiely

SQL Server


SQL 2012: Aggregates

Excerpt by Don Kiely

One of the more exciting types of SQLCLR code modules is custom aggregates.

This course excerpt was originally posted January 08, 2014 from the online courseware SQL 2012 Developer, Part 06 of 13: Advanced SQL CLR by Don Kiely

SQL Server SQL Developer


Isolation Levels and Transactions - Microsoft SQL

Excerpt by Don Kiely

An isolation level defines how much a transaction is isolated from changes made by other, concurrent transactions.

This course excerpt was originally posted January 01, 2014 from the online courseware SQL 2012 Developer, Part 08 of 13: Advanced T-SQL Queries by Don Kiely

SQL Developer SQL Server


Choosing the Right Action - Microsoft SQL Server 2012

Excerpt by Don Kiely

The job of the action invoker to select the appropriate action method is more complicated than may appear on the surface.

This course excerpt was originally posted December 11, 2013 from the online courseware SQL 2012 Developer, Part 08 of 13: Advanced T-SQL Queries by Don Kiely

MVC ASP.NET SQL Server


Domain Centric Modeling - Microsoft SQL Server 2012

Excerpt by Don Kiely

When the first version of Entity Framework came out, it included support for database-first design, which would reverse engineer an existing database and build a model for you.

This course excerpt was originally posted December 09, 2013 from the online courseware SQL 2012 Developer, Part 01 of 13: Views by Don Kiely

Entity Framework SQL Server


Types of Spatial Data

Excerpt by Don Kiely

SQL Server includes two spatial data types-Geometry and Geography-that encapsulate the database's support for spatial data.

This course excerpt was originally posted November 25, 2013 from the online courseware SQL 2012 Developer, Part 09 of 13: Advanced Data Types by Don Kiely

SQL Server


The HierarchyID Data Type

Excerpt by Don Kiely

As the name suggests, relational databases are best at storing and retrieving relational data.

This course excerpt was originally posted November 22, 2013 from the online courseware SQL 2012 Developer, Part 08 of 13: Advanced T-SQL Queries by Don Kiely

SQL Server


The Stages of Query Compilation

Excerpt by Don Kiely

Compiling a query involves three stages: parsing, algebrization, and optimization.

This course excerpt was originally posted November 13, 2013 from the online courseware SQL 2012 Developer, Part 07 of 13: Design and Deployment by Don Kiely

SQL Server


Advanced Query Techniques

Excerpt by Don Kiely

The T-SQL INSERT, UPDATE, and DELETE statements provide a lot of power and flexibility for maintaining data in a relational database.

This course excerpt was originally posted October 01, 2013 from the online courseware SQL 2012 Developer, Part 08 of 13: Advanced T-SQL Queries by Don Kiely

SQL Server


LINQ to SQL Read-Only Queries

Excerpt by Ken Getz and Robert Green

If you are looking for maximum performance, you can execute your queries in read-only mode.

This course excerpt was originally posted October 01, 2013 from the online courseware LINQ Using Visual C# 2010 by Ken Getz and Robert Green

C# SQL Server LINQ


LINQ and Relational Data

Excerpt by Ken Getz

At its most basic level, LINQ provides the ability to query any data source that supports the IEnumerable or generic IEnumerable(T) interface.

This course excerpt was originally posted September 20, 2013 from the online courseware Windows 8 Using XAML, Part 09: Views, Binding, and Templates by Ken Getz

SQL Server


Roots of SQL Server Data Tools

Excerpt by Don Kiely

Microsoft has long supported application database development with features built into Visual Studio, ranging from support for data access to the ability to create a connection to a database and manipulate database objects and data in simple ways.

This course excerpt was originally posted September 20, 2013 from the online courseware SQL 2012 Developer, Part 06 of 13: Advanced SQL CLR by Don Kiely

SQL Server Visual Studio


SQL 2012 Developer: Aggregates

Excerpt by Don Kiely

One of the more exciting types of SQLCLR code modules is custom aggregates.

This course excerpt was originally posted September 11, 2013 from the online courseware SQL 2012 Developer, Part 06 of 13: Advanced SQL CLR by Don Kiely

SQL Developer SQL Server


Schemas and Naming in SQL Server

Excerpt by Don Kiely

Whenever you execute a data selection query in SQL Server, you'll be accessing one or more database objects, so it is important that you understand how things are named.

This course excerpt was originally posted September 03, 2013 from the online courseware SQL Server 2012, Part 8 of 9: T-SQL Select, Where, and Clauses by Don Kiely

SQL Server


Introduction to Stored Procedures

Excerpt by Don Kiely

A stored procedure is a batch of Transact-SQL (T-SQL) code that is saved internally in SQL Server as a database object.

This course excerpt was originally posted August 14, 2013 from the online courseware SQL 2012 Developer, Part 02 of 13: Stored Procedures by Don Kiely

SQL Server


Overview of Transact-SQL (T-SQL)

Excerpt by Don Kiely

Transact-SQL is the SQL Server implementation of SQL, a standard codified by the American National Standards Institute (ANSI) and also adopted by the International Organization for Standardization (ISO).

This course excerpt was originally posted July 29, 2013 from the online courseware SQL Server 2012, Part 7 of 9: Introduction to T-SQL by Don Kiely

SQL Server


SQL Security Fundamentals: Changing the Execution

Excerpt by Don Kiely

You don't always want the caller's permissions to be used to validate permissions in a broken ownership chain.

This course excerpt was originally posted June 21, 2013 from the online courseware SQL Server 2012, Part 5 of 9: Security Basics by Don Kiely

SQL Server


SQL 2012 Default Schemas for Users

Excerpt by Don Kiely

SQL Server doesn't automatically create a schema with the same name as the user when you create a user. Instead you have to explicitly create it.

This course excerpt was originally posted June 04, 2013 from the online courseware SQL Server 2012, Part 5 of 9: Security Basics by Don Kiely

SQL Server


SQL 2012 Roles, Permissions, and Schemas

Excerpt by Don Kiely

The relationship of roles, permissions, and schemas is an important security concept in SQL Server.

This course excerpt was originally posted May 31, 2013 from the online courseware SQL Server 2012, Part 5 of 9: Security Basics by Don Kiely

SQL Server


User-Defined Server Roles in SQL Server 2012

Excerpt by Don Kiely

A long awaited security feature in SQL Server 2012 has been user-defined server roles.

This course excerpt was originally posted May 30, 2013 from the online courseware SQL Server 2012, Part 5 of 9: Security Basics by Don Kiely

SQL Server


Contained Databases in SQL Server 2012

Excerpt by Don Kiely

Contained databases is an interesting new part of SQL Server 2012. This isn't directly a security feature as such, but it implements a new authentication feature and so has a security element.

This course excerpt was originally posted May 29, 2013 from the online courseware SQL Server 2012, Part 5 of 9: Security Basics by Don Kiely

SQL Server


Understanding Logins with SQL Server

Excerpt by Don Kiely

SQL Server logins are not part of Windows-they are saved in and managed by SQL Server.

This course excerpt was originally posted May 28, 2013 from the online courseware SQL Server 2012, Part 5 of 9: Security Basics by Don Kiely

SQL Server


Windows Logins via Transact-SQL

Excerpt by Don Kiely

Transact-SQL provides full support for creating logins by using the CREATE LOGIN statement.

This course excerpt was originally posted May 23, 2013 from the online courseware SQL Server 2012, Part 5 of 9: Security Basics by Don Kiely

SQL Server


SQL Server Security: The Threats

Excerpt by Don Kiely

Relational databases are used in an amazing variety of applications with connections from a dizzying array of clients, ranging from handheld devices to mainframe Web service applications.

This course excerpt was originally posted May 21, 2013 from the online courseware SQL Server 2012, Part 5 of 9: Security Basics by Don Kiely

SQL Server


SQL Server 2012: Using Snapshot Isolation

Excerpt by Don Kiely

As discussed in our previous article, concurrency that is based solely on locking can cause blocking and deadlocking problems.

This course excerpt was originally posted May 17, 2013 from the online courseware SQL Server 2012, Part 9 of 9: T-SQL Working with Data by Don Kiely

SQL Server


SQL Server 2012: Blocking and Deadlocks

Excerpt by Don Kiely

When you modify data in SQL Server, it is important to understand how isolation levels and locking can affect performance and concurrency.

This course excerpt was originally posted May 16, 2013 from the online courseware SQL Server 2012, Part 9 of 9: T-SQL Working with Data by Don Kiely

SQL Server


Updating Large Value Types with UPDATE .WRITE

Excerpt by Don Kiely

SQL Server provides an UPDATE .WRITE Transact-SQL statement to perform partial updates on columns that are defined as varchar(max), nvarchar(max), or varbinary(max).

This course excerpt was originally posted May 10, 2013 from the online courseware SQL Server 2012, Part 9 of 9: T-SQL Working with Data by Don Kiely

SQL Server


SQL Server 2012: Creating a New Table with SELECT INTO in T-SQL

Excerpt by Don Kiely

The SQL standard draws a distinction between Data Manipulation Language (DML) and Data Definition Language (DDL).

This course excerpt was originally posted May 07, 2013 from the online courseware SQL Server 2012, Part 9 of 9: T-SQL Working with Data by Don Kiely

SQL Server


T-SQL Fundamentals: Outer Joins

Excerpt by Don Kiely

One of the fundamental concepts of relational databases is the normalization of data into tables, or sets, of similar data. Different data elements are grouped into separate tables.

This course excerpt was originally posted May 02, 2013 from the online courseware SQL Server 2012, Part 8 of 9: T-SQL Select, Where, and Clauses by Don Kiely

SQL Server


T-SQL: TOP Values

Excerpt by Don Kiely

A general best practice of data selection queries is that you never want to return more data from the database server than you're going to use.

This course excerpt was originally posted April 29, 2013 from the online courseware SQL Server 2012, Part 8 of 9: T-SQL Select, Where, and Clauses by Don Kiely

SQL Server


T-SQL: Counting Rows & Column Data

Excerpt by Don Kiely

One of the primary purposes of a relational database is to summarize information. Other than for data entry, you will rarely look at individual orders.

This course excerpt was originally posted April 25, 2013 from the online courseware SQL Server 2012, Part 8 of 9: T-SQL Select, Where, and Clauses by Don Kiely

SQL Server


The Sky's the Limit with the T-SQL WHERE Clause

Excerpt by Don Kiely

You will rarely want SQL Server to return every row in a table. The most efficient queries retrieve only the data you will actually use-no more, no less.

This course excerpt was originally posted April 23, 2013 from the online courseware SQL Server 2012, Part 8 of 9: T-SQL Select, Where, and Clauses by Don Kiely

SQL Server


T-SQL: Using the SELECT Statement for Naming Columns

Excerpt by Don Kiely

One of the most versatile statements in all of T-SQL is the SELECT statement. It's guaranteed to become your go-to tool for retrieving data stored in SQL Server.

This course excerpt was originally posted April 18, 2013 from the online courseware SQL Server 2012, Part 8 of 9: T-SQL Select, Where, and Clauses by Don Kiely

SQL Server


T-SQL: The WAITFOR Statement

Excerpt by Don Kiely

Syntax that controls the flow of statement execution is an essential feature of any procedural programming language.

This course excerpt was originally posted April 15, 2013 from the online courseware SQL Server 2012, Part 7 of 9: Introduction to T-SQL by Don Kiely

SQL Server


T-SQL: DATEADD and DATEDIFF Functions

Excerpt by Don Kiely

Date and time functions perform operations on date and time values to return a string, numeric, or date/time value.

This course excerpt was originally posted April 11, 2013 from the online courseware SQL Server 2012, Part 7 of 9: Introduction to T-SQL by Don Kiely

SQL Server


T-SQL: PATINDEX Function

Excerpt by Don Kiely

In a previous article we discussed the REPLACE and STUFF functions. This article takes a look at PATINDEX, which supports wildcard characters and other regular-expression-like features for a pattern search.

This course excerpt was originally posted April 09, 2013 from the online courseware SQL Server 2012, Part 7 of 9: Introduction to T-SQL by Don Kiely

SQL Server


T-SQL: REPLACE and STUFF Function

Excerpt by Don Kiely

All programming languages include functions for manipulating strings. This article shows how to use REPLACE and STUFF, some of the most common ones in Transact-SQL.

This course excerpt was originally posted April 05, 2013 from the online courseware SQL Server 2012, Part 7 of 9: Introduction to T-SQL by Don Kiely

SQL Server


T-SQL: COALESCE Function

Excerpt by Don Kiely

Working with null values is a common task when you allow columns to contain nulls. For example, by default, nulls in aggregates are ignored, but this may not always be the behavior you want.

This course excerpt was originally posted April 02, 2013 from the online courseware SQL Server 2012, Part 7 of 9: Introduction to T-SQL by Don Kiely

SQL Server


T-SQL: STR Function

Excerpt by Don Kiely

The STR function is another way to perform a specific conversion: It returns a string from a numeric expression.

This course excerpt was originally posted March 29, 2013 from the online courseware SQL Server 2012, Part 7 of 9: Introduction to T-SQL by Don Kiely

SQL Server


Transact-SQL and Data Types

Excerpt by Don Kiely

Some programming languages are quite forgiving about implicitly converting data types in expressions and computations.

This course excerpt was originally posted March 27, 2013 from the online courseware SQL Server 2012, Part 7 of 9: Introduction to T-SQL by Don Kiely

SQL Server


Transact-SQL Programming: Batches and Scripts

Excerpt by Don Kiely

A batch is a collection of SQL statements that SQL Server processes as a single unit.

This course excerpt was originally posted March 25, 2013 from the online courseware SQL Server 2012, Part 7 of 9: Introduction to T-SQL by Don Kiely

SQL Server


Computed Columns in SQL Server Management Studio (SSMS)

By Don Kiely

Computed columns in SQL Server Management Studio (SSMS) allow you to configure a column within a table that automatically calculates a value based on an expression that can include references to other columns.

This blog entry was originally posted December 18, 2012 by Don Kiely

SQL Server


Protecting Your Data in SQL Server

By Don Kiely

The transaction log is fundamental to the way SQL Server works and is created automatically when you create a new database or attach an existing database that doesn't yet have a log file.

This blog entry was originally posted December 10, 2012 by Don Kiely

SQL Server


Tools for Writing T-SQL Queries in the Microsoft World

By Don Kiely

Most modern code development environments have support for writing code. In the Microsoft world, one of the primary tools is IntelliSense.

This blog entry was originally posted December 07, 2012 by Don Kiely

SQL Server


SQL Server Management Studio: Displaying Multiple Code Windows

By Don Kiely

You have several options for viewing and manipulating multiple code windows.

This blog entry was originally posted December 06, 2012 by Don Kiely

Windows SQL Server


SQL Server Management Studio: Displaying and Filtering Objects

By Don Kiely

SQL Server Management Studio displays server and database information in Object Explorer, which presents information about database objects in a treeview.

This blog entry was originally posted December 03, 2012 by Don Kiely

SQL Server


SQL Server Processors & Security Options

By Don Kiely

SQL Server 2012 supports multiple processors if they are available on the server.

This blog entry was originally posted November 30, 2012 by Don Kiely

SQL Server Security


Installing Multiple Instances of SQL on a Single Computer

By Don Kiely

One of the most powerful features of SQL Server is the ability to install multiple instances of the SQL Server relational database engine on a single computer.

This blog entry was originally posted November 28, 2012 by Don Kiely

SQL Server


SQL Server Data Tools (SSDT): A Great Set of Tools for Database Dev

By Don Kiely

Microsoft introduced a new set of database development-oriented tools in SQL Server 2012, called SQL Server Data Tools.

This blog entry was originally posted November 26, 2012 by Don Kiely

SQL Server Visual Studio


Finding SQL Server Problems

By Don Kiely

The Activity Monitor in SQL Server 2012 gives you a view into the current activity in the SQL Server instance.

This blog entry was originally posted November 21, 2012 by Don Kiely

SQL Server


SQL Object Search Box: Finding a Needle in a Haystack Made Easy

By Don Kiely

A medium sized database can easily have hundreds or thousands of objects, and large databases can have even more.

This blog entry was originally posted November 19, 2012 by Don Kiely

SQL Server


Don't Waste your Time on Training

By Martin Schaeferle

How many times have you heard people say, "I am definitely not going to waste my time going to that instructor led class" or "that self study training is a waste of time, not for me"?

This blog entry was originally posted October 02, 2012 by Martin Schaeferle

Video Visual Studio SQL Server Mobile Java SharePoint