Current Category Subscribe to the RSS feed for this category
SQL Server
Parent Categories
All Categories
Child Categories
Analysis Services
Bunch,

Using a CTE to help with an update can be pretty handy. In this simple example the CTE is to select SiteIDs for a specific sales rep. The update is to change the address code to ‘Street’ since the rep ...

Akshay Deep Lamba,

EPS or Encapsulated PostScript is a standard graphics file format for exchanging images, drawings or even layouts of complete pages. An EPS file internally contains a description of such an object or layout ...

RonGarlit,

“Design Patterns 100″ is a prerequisite for .NET Developers. (Part 4 – Excerpts from July 2010 – PhillyNJ.NET Presentation) Continuing our discussion from Part-3 we ask. What are the “Gang of Four” (GoF) ...

RonGarlit,

“Design Patterns 100″ is a prerequisite for .NET Developers. (Part 3 – Excerpts from July 2010 – PhillyNJ.NET Presentation) Continuing our discussion from Part-2 we ask. What are the “Gang of Four” (GoF) ...

Mike Koerner,

I was working on a MVC3 project with jqGrid using JSON. The data was created using EF4 Code First. Took me a while to hook up the grid and actually having it post back to the server to retrieve the JSON. ...

Enrique Lima,

For those that attended TechEd NA 2011 last week in Atlanta it should be no surprise that more and more companies are betting on the Azure platform, whether it is Windows Azure or SQL Azure. There have ...

Malisa L. Ncube,

Its been a while since I blogged. Its been hard balancing blogging time, work and many other activities. Most my days and even evenings have been cluttered with a number of tasks ranging from mundial to ...

remko,

Ok, so you have locked your SQL down. No users allowed. But then there is this information worker for whom the IT department made a special SSIS package. And they loaded the package in to the SQL server ...

foxjazz,

here at Tech-ed learning sql server stuff.

I am thinking I would like to work with ucma because providing ability to manage and utilize communcation services is fun.

Jeroen Bourdeaud'hui,

Last, I needed a function to add paging. The first problem I had, was how to this. A couple of seconds later, I allready had a solution to this problem: Linq Skip and take will do the trick. list<t>.Skip(_howMany... ...

Tiago Salgado,

Since we don’t have a direct way to indicate that some user will be locked, the only way I got to do that, was forcing a wrong login multiple times, until reach the maximum attempts defined on “maxInvalidPasswordAttemps” ...