Are you sure linked servers are being deprecated? No, I had equated Linked Servers with Remote Servers when writing the editorial yesterday. Please accept my apologies for the confusion. Linked Servers are not the same as Remote Servers, although they perform similar functions. It is not linked servers that are being deprecated. Remote Servers are being deprecated, which is something […]

SQL Server supported Linked Servers for years. Now Microsoft is letting us know this capability is going to be deprecated in a future release. When they do stop supporting linked servers, what will be the impact on you? For the un-initiated, a linked server may be created on an instance of SQL Server allowing access to an external SQL source. […]

This is probably old news to you. I didn’t know that running a program under Windows 7 Compatibility mode was actually running a virtual Windows XP session, separated from the Windows 7 operating system. A friend recently brought this to my attention and I went to learn more. You can find a lot of information about Windows XP running as […]

I was reading an advertisement in the Oracle magazine the other day where they were using backward capability as a valuable feature of the Spark/Solaris product line. If I understood this correctly, they were promising lack of obsolescence should you choose to move to a new platform Your older versions of software would continue to run. This caught my attention, […]

Is Your SharePoint Installation In Need of a Brush-Up? The interesting thing is that many companies are using SharePoint for their own systems and to facilitate collaboration and all of the great things you can gain from a rock-solid SharePoint installation. Turns out a majority of companies have installations of SharePoint, but many aren’t quite there yet on getting what […]

Keeping Enumerations synchronized between application code and database lookup tables is simply painful. I have played with the idea of creating my lookup tables needing to be synchronized with three columns, ID, Description, Enumeration. I’m working on a T4 template that will generate Enumeration C# code from these tables so they can be kept synchronized with no special effort. The […]

More Choices! Wait, Fewer Choices! More options! More granularity! More features, but let me choose… OK, here you go. Wait… too much. That’s a bit how I feel about how things are shaking out with cloud licensing for SQL Server (and other services too, but I’m picking on SQL Server for this…) It’s really great to see how many different […]

Enumerations are popular in most modern programming lanugages because they do away with “Magic” numbers. A number has a strongly defined definition verified at compile time. Problems occur when you attempt to keep those enumerations synchronized with values in your database. I was looking at the Enumeration data type found in MySql hoping to find a solution to Enumeration synchronization. […]

Dilip reminds us that the Single Page Application is not the invention of HTML5. Rather, HTML5 enables single page applications to be created much more easily. I worked on a project 13 years ago using Classic ASP; not ASP.Net. This application had a series of properties that were hierarchical in nature allowing the user to drill into more detail. At […]

Windows RT is a nice little computer. It is designed specifically to run applications from the Windows Store. It does not have the same architecture of WinTel machines, and therefore cannot run the applications like you run on your desktop or laptop. This doesn’t mean you have a horrible platform as there are thousands of RT enabled applications doing most […]