19Mar 2009 by Grant Fritchey No Comments

Database.sqlpermissions

Visual Studio
Raise your hand if you think this is a real pain in the bottom method for editing user permissions? Yeah, me too. Visual Studio Team System Database Edition is far to fine a tool to make us edit XML to set database user permissions. A co-worker has posted a change request on MS Connect. Connect works really well as long as people vote for what you report. I've seen several things change in SQL Server or get fixed primarily because of the reports in Connect. So if doing this: <PermissionStatement Action="GRANT">      <Permission>EXECUTE</Persmission>     <Grantee>UserRole</Grantee>      <Object Name="dbo" Type="SCHEMA"/> </PermissionStatement> Makes you crazy and you would rather type this: GRANT EXECUTE ON SCHEMA :: dbo TO UserRole ; Then click on the link and get the word in front out to Microsoft.
Read More
14Jan 2009 by Grant Fritchey 8 Comments

Microsoft Concept Center

Misc
During my recent visit to the Microsoft Technology Center in Waltham, Rich Crane gave me a tour of the facility. It included a room, I think he called the Concept Center. It was a little theatre type of arrangement around a series of work areas or work styles. Microsoft uses the room for demo's that go WAY beyond some silly PowerPoint slide show. Here are a few pictures I took while I was there. [gallery order="DESC" orderby="post_name"]
Read More
14Jan 2009 by Grant Fritchey 1 Comment

SQL Server 2008 Upgrade Lab at Microsoft

Tools
I got an invite to take part in a lab at the Microsoft Technology Center in Waltham. I took advantage of it. I'll use this post to describe the experience so that anyone else with the opportunity will know what to expect.  [caption id="attachment_333" align="alignnone" width="450" caption="They knew I was coming"] [/caption] First, you recieve a very explicit set of pre-requisites. You need to install the SQL Server Upgrade Assistant, a tool that Microsoft licensed Scalability Experts to create for them. You have to run this against a small database, >25gb. The tool backups up all the databases from the server (so you need to put it on to a test box, rather than try to move an entire production system worth of databases). It then starts a trace that captures all the…
Read More
11Jun 2008 by Grant Fritchey No Comments

SNESSUG Speaker

Misc, PASS
Tonight we have Rob Walters of Microsoft speaking on Visual Studio 2008 Reporting Services. This should be a good one. Rob also recently published a book, Accelerated SQL Server 2008. I'm going to a party at the MS building in Waltham next week to celebrate the release of Rob's book. Hopefully that means I can finagle a copy too.
Read More