This is one of those things that I only need once every several months and always forget how to do. Working with custom XML in Visual Studio is a whole lot easier with intellisense. Schema errors are highlighted, enumerated values are displayed, and the amount of typing goes from full tag names to just a few characters followed by tab to complete. There are a few ways to do this, but if you have a schema (XSD) for the file, then here are the steps to make the magic happen.
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.
We all know and love Nancy by now. I love it anyway. Up until now you needed to create an empty ASP.Net project and go from there. But now you there are templates to make it easier for you to start a new Nancy project. For now only C#. You will have to download the vsix from the visual studio gallery. The restart your VS if it was open. If you know try to create a new project you will see this list in the web category.
I recently read an article discussing the idea of loyalty, particularly as it applies to millennials – those of the youngest generation currently working. The article was titled “The Truth About Millennials and Job Loyalty”. I found the article to be an interesting introspective of how “loyalty” is defined by someone within the millennial generation versus how older generations have defined the word. Whether it is right or wrong is, as the author put it, subjective to the point of view of the particular individual.
I had to change the domain account on some SQL Server boxes that we have. After I changed the account on one machine from DomainNameUser to DomainNameNewUser SQL Server wouldn’t start up In the error log I saw the following messages Server Error: 17190, Severity: 16, State: 1. 2013-04-30 12:42:06.11 Server Initializing the FallBack certificate failed with error code: 1, state: 1, error number: -2146893802. 2013-04-30 12:42:06.11 Server Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
Microsoft has released the Windows Azure Training Kit April 2013. The Windows Azure Training Kit includes a comprehensive set of technical content designed to help you learn how to use Windows Azure. The kit includes hands-on labs, presentations, demos, and code samples for every aspect of developing applications for Windows Azure. You can use the resources in the training kit to teach yourself or train others. There have been a number of improvements in this release alongside the refresh to the Infrastructure Services content including:
Recently I was setting up a virtual machine environment to do some demo's. One of the virtual machines would be the home for a SQL Server database engine supporting a SharePoint 2013 farm. Since it is a back-end database, the server was not connected to the Internet. Instead, it was connected to the other servers through the Hyper-V internal network. During the installation of SQL Server on this machine, I got the following error: Error while enabling Windows Feature: Netfx3 A quick search on the Web taught me this is the activation of .
If you look at the sys.sysobjects view, you will see a xtype column listed Object type. Can be one of the following object types: AF = Aggregate function (CLR) C = CHECK constraint D = Default or DEFAULT constraint F = FOREIGN KEY constraint L = Log FN = Scalar function FS = Assembly (CLR) scalar-function FT = Assembly (CLR) table-valued function IF = In-lined table-function IT = Internal table
Introduction I said it once and I will say it again. Logging is very important once your app goes live. It’s the best way for you to find out what the user did to destroy your sanity. I am always on the lookout for new and exiting things that will make logging easier for me. I want less code but maximum information. You can get lots of information with Gibraltar’s Loupe but you can get even less code and more information with Anotar.
Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel file in BIDS/SSDT – which is a 32-bit application – and when you try to run the package, it crashes. This is easily fixed by setting the project property Run64BitRuntime to False. The package now runs in 32-bit mode and uses the 32-bit ACE OLE DB provider which was installed alongside Office (if you installed the 32-bit version at least).
Missing index suggestion – Duplicate Index The missing index feature, while tuning or checking estimated and actual plans, is very helpful. Something that is key in that sentence is the word, helpful. Don’t run out and simply create all of them. Make sure it is a viable solution that does not implement the three major faults in index strategies: duplicates, overlapping and misalignment. In SQL Server 2008 and previous versions, the missing index suggestions had a little feature (read as bug) that would suggest an identical index to what was already on the table.