If you are on SQL Server 2005 and up and you are still using sp_change_users_login (I know old habits die slow) then listen up, there is an easier way to fix permissions. If you have a login on one server and you have the same login on another server and you did not use the sp_help_revlogin to create the login with the same SID then you have 2 options. drop and create the user(and apply all the permissions) or you can map the existing database user to a SQL Server login.
This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.
Bing, Google and Yahoo! have announced Schema.org Here is the info Today we’re announcing schema.org, a new initiative from Yahoo!, Bing, and Google, to create and support a common set of schemas for structured data markup on web pages. With schema.org, webmasters and developers can learn about structured data and improve how their sites appear in search results on Bing, Google, and Yahoo!. Information and tips are available on schema.
Follow me on twitter for a few weeks and you will inevitably see comments reflecting my ‘high standards’, generally in the form of frustration when something falls short. As a technical user I have little patience with software that is difficult to use, communicates poorly, or leaves my systems in an unstable state. Driving this frustration is the fact that we have been discussing these issues since well before I joined the field, yet I am still being sold software that doesn’t meet even basic standards of usability and safety.
Microsoft has uploaded a video on YouTube that explains how they built the UI for windows Here is another video showing the OS in action Microsoft has also released a press release that highlights some of the new features. Here are some of them Fast launching of apps from a tile-based Start screen, which replaces the Windows Start menu with a customizable, scalable full-screen view of apps.
Today is the third year anniversary of Less Than Dot, time is flying by so fast. I would like to list some stats about the site and also list the most popular blogposts, wiki pages and forum posts. Operating Systems Operating System Percentage Windows 90.51% Macintosh 4.07% Linux 3.
Dejan Sarka and Davide Mauri have made available the book Data Quality and Master Data Management with Microsoft SQL Server 2008 R2 as a free download on their site Here is a little blurb about the book This book deals with master data. It explains how we can recognize our master data. It stresses the importance of a good data model for data integrity. It shows how we can find areas of bad or suspicious data.
Introduction This one was hard to figure out why it happened in VB.Net but it you can do it. I’m still not really sure and might need some better understanding why it is permitted. And why it is not permitted in C#, which seemed the more obvious choice. What am I talking about I hear you ask. Look at the code and find out. The VB code Module Module1 Public WithEvents t As New TestEvents Sub Main() t.
Introduction VB.Net is not such an old language, let’s say it saw the light in 2002, that makes it 9 years old. But it has some compatibility with VB code which makes it 20 years old. So the tech leads of the language don’t only add new things they also have to make sure the old things work and that it is compatible with C#. This sometimes has some weird consequences.
Introduction I installed Resharper 6 EAP (The nightly builds) just because Hadi Hariri (him again) asked me to. You can read on some of the new features on the Jetbrains blog. And here are some of the things for VB.Net that caught my eye and that are very handy indeed. I already blogged why you would want Resharper even for VB.Net. Solution wide code inspection In VB.Net we already have pretty good error listing at codetime but Resharper 6 add a lot to that.
In this blog post I want to discuss a problem I encounter frequently in SQL related forums – how to perform dynamic PIVOT involving multiple columns using pure T-SQL solution. In SQL Server Reporting Services this functionality can be easily achieved using Matrix template. With the introduction of PIVOT operator in SQL 2005, it became very easy to write queries that transform rows into columns. There are numerous articles on the Web as how to perform PIVOT and even dynamic PIVOT.