Author: Ben Taylor

Editorials

Analytic Functions

Since SQL Server 2012 was released, the SQL Server engine supports a new class of aggregate functions they have named Analytic. You can find documentation for the Analytic.functions at https://docs.microsoft.com/en-us/sql/t-sql/functions/analytic-functions-transact-sql. What I find that is cool about these Analytic functions is that they extend beyond the existing set of aggregate functions, allowing you to build queries that you could do previously,...

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

We Need Standards

While it may be politically correct to agree to disagree sometimes we require agreement on standards. We need standardization. Not because it is the ONLY RIGHT WAY to do anything. We need it because when things are done in a consistent fashion, multiple people can work on a project efficiently, because they know how things are put together. You could […]

Editorials

How Do We Disagree

When it comes to working in IT it isn’t very hard to find an issue where people disagree. In fact, I think we have turned disagreement into an art. I believe that it is probably unrealistic to think a team of IT professionals will ever come to a point of agreement. If that’s true, what do we do? Frankly, I […]

Editorials

Database Connection Encryption

A high priority for developers working with SQL data stores is to establish a way to access our Database without exposing our credentials. We want to protect our application from Hackers and hide the methods to establish a connection… This can be a bit of a problem with the most common method of establishing a database connection for our application […]

Editorials Pro Members Standard Members

Anemic Objects

Object Oriented Code has the distinction of consolidating both exposed properties and methods within a single object. Moreover, there may also be methods contained in that object, not exposed to the world. We seem to be moving away from that design. It would seem that in modern software development environments we have moved away from intelligent objects closer to what...

This content is for Pro, Pro Member, Pro Member, 90 Days, Non-Recur, Standard, Standard Member and Standard Member, 90 Days, Non-Recur members only.
Log In Register
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, 90 Days, Non-Recur, Standard, Standard Member and Standard Member, 90 Days, Non-Recur 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, 90 Days, Non-Recur, Standard, Standard Member, Standard Member, 90 Days, Non-Recur 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, 90 Days, Non-Recur, Standard, Standard Member and Standard Member, 90 Days, Non-Recur 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