Author: Ben Taylor

Editorials Pro Members Standard Members

The Version Advantage of SQL Azure

by

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 - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Editorials Pro Members Standard Members

Lets Get Some Passion

by

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 - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, Standard Member Monthly - Fall Sale, and Free members only.
Register
Already a member? Log in here
Continue Reading →
Editorials Pro Members Standard Members

When You Need A Sandbox

by

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 - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Editorials SQL Server

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

by

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 […]

Continue Reading →
Editorials

EF and Stored Procedures

by

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.
Register
Already a member? Log in here
Continue Reading →
Editorials

OVER() ++

by

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 […]

Continue Reading →
Editorials

OVER()

by

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 […]

Continue Reading →
Editorials

Caring For Your Data – History Cleanup

by

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, […]

Continue Reading →
Editorials

Caring For Your Data – Database Backups

by

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 […]

Continue Reading →
Editorials

Caring For Your Database – Backups

by

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 […]

Continue Reading →
1 2 3 4 5 … 312