SQL
I run my development server by boot to VHD (Windows Server 2008 R2 x64). In that instance, I also have an attached VHD (I attach via script at boot up time using Task Scheduler). That VHD I have my SQL instances installed. So, the other day, acting hasty, I chmod my ACLS – wow, what a day after that. So, in order to fix it I created this set of BAT commands that resets it back to operational state – not 100% of all what you get, I also didn’t want to run a “repair” – but, all operational again. setlocal ......
There have been many times that I’ve been handed a SQL instance that doesn’t allow me to do much with it even though the IT Admin for the machine have indicated they’ve done the install and your AD account is part of the Local Admin group. By default, in SQL 2008 local admin’s are not part of the sysadmin role – unless you’re running in single user mode. So, this article has a quick HOWTO on getting access back so you can go on your merry sysadmin way… http://technet.microsoft.co... ......
Here's a cool tool that provides an interactive LINQ environment that you can use to develop queries against LINQ sources (SQL, Objects, XML, etc.). If you're working with LINQ and need an environment that supports both expression and language statements in C# or VB.NET, this tool can handle both. The below shot is using C# statements. A few bonus items included: 1. provides a view of both the resulting SQL and Lambda expressions used in the query. 2. Provides SQL execution as well 3. A whole bunch ......
Today, I needed a quick view of what objects in a SQL DB had changed. The following get's me that in a nice list:
SELECT [name], [type], create_date, modify_date
FROM sys.objects
WHERE [type] in ('P', 'FN', 'V')
order by Modify_Date desc
Cloud services that is. Windows Azure, .NET Services, Live Services…. If you looking for the spoon fed variety of information, a bunch of HOWTO vides have been released – see below. These are small little “nuggets” – like those MSDN Nuggets out of Microsoft UK. Get Started Developing on Windows Azure? If you’re a developer and you’re new to Windows Azure, start here! You’ll see what you need to download and install, and how to create a simple “Hello World” Windows Azure application. Deploy a Windows ......
There are really a whole bunch of great resources out there that help the community get up & running with LINQ. Personally, with all the additional providers that I've seen (Qak Leaf List) - several of which I see great use for - LINQ to SharePoint and LINQ to LDAP / LINQ for AD. In regards to tools, LINQ Pad is the tool that allows you to toil with the syntax, etc. LINQ Pad And now, here's a good 100+ pages on LINQ syntax in C# 3.0. Book Preview: C# Query Expressions and Supporting Features ......
Here's a tool that completely slipped by me. I've been using ApexSQL for generation of SQL scripts for creating schema and data. Turns out, during the Visual Studio 2008 installation I see "SQL Publishing Wizard" pop up on the list. This tool, can extract schema and data and create a SQL script. Download details: SQL Server Database Publishing Wizard 1.1 ......