SQL

Fixing my SQL Directory NTFS ACLS
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 ......

Posted On Friday, March 12, 2010 1:26 PM | Comments (0)

No, your local admin account is NOT a SQL sysadmin – automatically
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... ......

Posted On Monday, January 25, 2010 10:36 AM | Comments (0)

Query SQL (or any LINQ Provider) Using LINQPad...
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 ......

Posted On Saturday, December 15, 2007 4:46 PM | Comments (0)

How to get a list of SQL Procedures, Functions, Views that have recently change?

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


                
				

Posted On Thursday, November 15, 2007 2:57 PM | Comments (0)

Try spending some time in the cloud…
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 ......

Posted On Friday, February 13, 2009 8:59 AM | Comments (0)

Learning LINQ - No excuses
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 ......

Posted On Thursday, March 13, 2008 9:59 AM | Comments (0)

Extract DDL and Data - SQL Server Database Publishing Wizard
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 ......

Posted On Thursday, February 14, 2008 4:47 PM | Comments (0)