|
|
February 2007 - Posts
-
I haven't published a nugget for a while but today a guy called Antonio was asking me how one might output the captured rowcount in a file so i thought I'd put something together that demonstrated it. Its very simple, although you will need two Read More...
|
-
I have spoken before about just how cool I think the Live Maps experience is and I also said that the Live taem needed to start spreading the word about it better than they are doing at the moment. Well, perhaps they took me at my word because today the Read More...
|
-
Here at Conchango there has been quite a bit of discussion by certain people ( JRJ , Dan Perrin , Mick Horne amongst others) about how best to leverage the capabilities of Visual Studio Team System For Database Professionals (DBPro for short). It is generally Read More...
|
-
I use Flickr alot to host all of my digital photos but I tend to have a hard time uploading them all, for some reason the Flickr Uploader can be a bit tempremental, particularly for large files. Thankfully Flickr also allow you to upload emails by emailing Read More...
|
-
Any SSIS developers out there may have heard on the grapevine that you will have problems running packages that contains a Script Task or a Script Component on a Vista machine. Well, the SSIS team have rushed out a hotfix which you can read about and Read More...
|
-
A few months ago I wrote a short post about a cool little powertoy that enables you to copy the path of a file into your clipboard: Well as Josh Twist has pointed out this functionality is now built-in as standard to Vista (well it is in Vista Ultimate Read More...
|
-
Two days ago I posted a blog entry here that showed how the following SQL statement: select dp.NAME AS principal_name, dp.type_desc AS principal_type_desc, o.NAME AS object_name , p.permission_name, p.state_desc AS permission_state_desc from sys.database_permissions Read More...
|
-
SQL Server Books Online (BOL) has improved dramatically in SQL Server 2005. I'm not necassarily talking about the content (though that IS better I feel), I'm talking about the ability to provide feedback about the articles. What's great is Read More...
|
-
Today I was asked how one can query the server to list out all permissions that a principal has on all the securables in a SQL Server database. After 10 mins of searching through BOL I came up with the following that seems to work quite well: 1 select Read More...
|
-
In my last post I explained a little about the Master Data Management (MDM) problem that we have faced on my current project. At its very core building an MDM system is a data modelling exercise and in this post I'm going to talk about the data model Read More...
|
-
For those of you interested in what's new in SSIS in service pack 2, here are a couple of resources: New Features: http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/WhatsNewSQL2005SP2.htm#BKMK_IntegrationServices Bug Read More...
|
-
Visitors to the SSIS forum often ask how to construct a date string in the form YYYYMMDDHHMISS (e.g. "20070207123456" for "7th February 2007, 12:34:56") using a SSIS expression. I always give the same answer so I thought I'd post Read More...
|
-
So far in this series I have introduced you (somewhat) to SoBI and now I'd like to introduce you to one of the enabling initiatives that we have undertaken. First, a bit of history. In the summer of 2005 the purveyors of SoBI realised that in order Read More...
|
-
Richard Wand , a colleague of mine here at Conchango , has posted an interesting article here that talks about whether a web site owner should give their browsers the ability to type in their title (e.g. Mrs, Mr, Dr...etc) or just offer them a list of Read More...
|
-
My last post provided a concise overview of what I think SoBI is. It talked about service facades, BI caches and data consumers, and it placed an emphasis on data quality in the Systems Of Record (SoRs). In that post I talked about how data that is required Read More...
|
-
When I joined my current project in 2005 I didn't know much about Service Oriented Architectures (SOA). I knew it was something to do with transferring information via standard protocols and making it available to consumers but that was about it. Read More...
|
-
For most of the past 18 months I have been working on a series of projects for one of the world's major oil companies. In that time I have been working with various Conchango luminaries and associates such as Mick Horne , Christian Wade , Andy Britcliffe Read More...
|
|
|
|