RSSCategory: Development

May

20

DML vs DDL

Posted by Leave a Comment

Most of the time, when referring to DML (Data Manipulation Language) and DDL (Data Definition Language), we are simply talking subsets of SQL commands.

Continue Reading

May

12

Vertically Align Text or Elements Using CSS

Posted by Leave a Comment

In the past, getting text or other elements to align vertically was often much harder than it should have been. Luckily, modern CSS makes this task much simpler; as simple as three lines actually.

First, we’ll create a container div with a border so we can see the parent element we want to align to:

Continue Reading

Sep

29

An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode

Posted by Leave a Comment

You may sometimes receive the below error if adding a new library to an existing project. It is also a common error when running older applications originally built for IIS 6 on newer versions of IIS.

Error Summary
HTTP Error 500.22 – Internal Server Error
An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.

Luckily there are a couple of easy solutions to fixing this error:
Continue Reading

Sep

9

Use a SharePoint List as a Data Source in a SSRS Report

Posted by 5 Comments

In this example we will use a SharePoint list as a data source in a SSRS report using SQL Server 2012 Report Builder.

Begin by adding a new data source to your report. Select Microsoft SharePoint List under the connection type dropdown. For the connection string you will want to enter the root URL for your site/subsite. For example, if the URL for our list is http://technicaloverload.com/My-Test-List/, then you would enter http://technicaloverload.com/ in the connection sting box.
Continue Reading

Aug

8

Get Value of URL Parameters using JavaScript

Posted by Leave a Comment

If you are looking for a quick and easy way to grab the value of a query string parameter from a URL, you only need a few lines of JavaScript. The below script will return the value of the matching parameter or return false if no match was found.

Continue Reading

May

1

Change the Default Database for a User in SQL Server

Posted by Leave a Comment

Here are three easy ways to change the default database for a user in SQL Server.

Option 1: Execute the system stored procedure sp_defaultdb

EXEC sp_defaultdb @loginame='UserName', @defdb='NewDefaultDB'

Continue Reading

Apr

5

LINQ – SQL Wildcard Equivalents

Posted by Leave a Comment

LINQ has several ways to mimic SQL wildcards in both query and method syntax. Below are a few examples of each:

Continue Reading