Author: Ben Taylor

Editorials Pro Members Standard Members

The Version Advantage of SQL Azure

When it comes to keeping current with the capabilities of the SQL Server platform, SQL Azure has a bit of an advantage. If you are doing self hosted SQL Server on your own hardware or using Platform as a Service with your own SQL Server instances, then it is your responsibility to upgrade the version of SQL Server in use....

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Editorials Pro Members Standard Members

Lets Get Some Passion

As I continue to interact with people working in IT I continue to be surprised at the number of people who are simply getting by. They have no passion for their chosen profession. Where do they fit into your organization? Sometimes it’s nice to have a software developer who learns a code pattern and can churn it out over and...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's, Standard Member Monthly - Valentine's and Free members only.
Log In Register
Editorials Pro Members Standard Members

When You Need A Sandbox

There are times when you are making changes to your database, you need to isolate your work from other developers, and you don’t have resources to create a separate database from everyone else. Are there any options available to you? The easiest option in this scenario is to go back to the old school method of sharing the same database...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Editorials SQL Server

Comparing A Stored Procedure Call Using Ado.Net and Entity Framework

Calling a stored procedure and returning the results as a collection of a POCO is a lot easier to write in Entity Framework than traditional Ado.Net. The following example makes a comparison. To begin this editorial, I create a stored procedures in the AdventureWorks sample database for SQL Server, where I return a few columns from the HumanResources.Employee table, and […]

Editorials

EF and Stored Procedures

Entity Framework interacts nicely with stored procedures. That being the case, how do you decide when to create your code on the database, or in your repository code using Entity Framework? One of the things we often forget is that Entity Framework attaches to many different storage methods. You can even attache Entity Framework to files stored in the file...

This content is for Free members only.
Log In Register
Editorials

OVER() ++

Yesterday we talked about how using the OVER operation in conjunction with an Aggregate function results in an aggregate calculation unique to each detail row without requiring a GROUP BY clause in the query. We demonstrated how you could use the OVER operation without any parameters, resulting in an Aggregate calculation covering the entire set of data being processed. This […]

OVER()
Editorials

OVER()

I have been using aggregate functions for years. In all of that time I did not know how they may be used without a group by clause unless I was using one of the newer aggregate functions such as ROW_NUMBER(). However, you can include aggregate functions in your query without a group by clause if you use the OVER() clause […]

Caring For Your Data – History Cleanup
Editorials

Caring For Your Data – History Cleanup

One of the last options of the Database Maintenance Plan Wizard is to perform a history cleanup. The MSDB database stores a lot of information regarding the activities performed on your database. It contains information about your job execution, plan execution information, scheduled job execution information, backup history, etc. After a while this can cause your MSDB to grow considerably, […]

Caring For Your Data – Database Backups
Editorials

Caring For Your Data – Database Backups

Today I want to more fully unpack the Database Maintenance Task Wizard features for Incremental Backups and Transaction Log Backups. We looked at them briefly yesterday without much clarification about their intended purpose. As I stated yesterday, a complete backup is the core of any disaster recovery strategy using backup and restore methodology. The goal is to be able to […]

Caring For Your Database – Backups
Editorials

Caring For Your Database – Backups

As we continue unpacking the different options of the Database Maintenance Plan Wizard we come to the topic of Backups. The maintenance plan wizard has three kinds of backups. A complete database backup, an incremental database backup, and transaction log backups. This is a big topic because the way you utilize all of these different backup capabilities is determined on […]