|
Front Page News
-
|
PASS, the Professional Association of SQL Server, is currently holding a contest , looking for people to blog or email them about the best thing they learned at a PASS Summit they've attended. Networking: it's not just for sleezy marketing types. Hmmm....
|
-
|
I received an 'advertisement' in my inbox today from one of my email subscriptions. This is what is exactly what is wrong with our industry! We have marketing ads like this that imply that more lines of code faster equates to a better product! CIO's and...
|
-
|
Recently I was tagged by Jeremiah Peschka with a question that goes a little something like this: "So You’re On A Deserted Island With WiFi and you’re still on the clock at work. Okay, so not a very good situational exercise here, but let’s roll with...
|
-
|
Honestly, I was all set to blog more frequently, and then disaster struck. My home desktop, the one on which I do most of my hobbies and tech stuff after work, had died a hard death thanks to the failure of my video card. I had no on-board video to save...
|
-
|
I constantly hear (or read about) people bashing Microsoft and make a fuss that they need to unseal their classes in the core framework. The reason usually being for testing because all other reasons are usually academic examples that nobody in their...
|
-
|
Sometimes Books Online really ruffles my feathers, and this is one of those times. We have a separate security department that handles our IT security. They'd like to have their accounts be able to just administer the security on our SQL Server boxes,...
|
-
|
When I wrote my previous blog post about blogging, I remembered how much of a sucker for the concept of recursion I'd become, even though it still bewilders me, after I'd read Godel, Escher, Bach: An Eternal Golden Braid by Douglas R. Hofstadter . I'd...
|
-
|
Introduction There's been lots of speculation about Twitter and what it means to the modern technologist. I've found some of it pretty insightful and some of it misinformed. I use Twitter . A bunch. Not as much as some , but more than average . I like...
|
-
|
If you're fortunate enough to have access to an MSDN Subscription, you can download various components of VS 2010 Beta 1 now. If you don't have access to an MSDN Subscription, don't despair - you only have to wait until Wednesday. The beta includes Team...
|
-
|
Here I am, about 5 months into blogging in 2009, and I find myself unsatisfied with the frequency with which I update this blog. Sure, there is some content with which I am well pleased, but I just can't seem to understand why I can barely reach the 1...
|
-
|
Microsoft just announced SQL Server 2008 R2 which looks to greatly expand on the existing SQL Server 2008 platform. Some of the benefits mentioned: Support for more than 64 logical processors to take advantage of multi-core technologies New extensions...
|
-
|
The goal of this post is to discuss some options that may be helpful for anyone who is working on, or trying to, implement a high availability scenario with TFS. The fact of the matter is TFS (in its current versions) itself is not able to load balance....
|
-
|
Ok time to get side tracked sort of. In my last post I talked about inspecting the Reporting Services web service to gather information about reports and possibly even building that out to execute reports. In order to drive the automatic execution of...
|
-
|
It's no small secret that I'm a big fan of using PowerShell to manage SQL Servers. I've gone through all the trouble of loading the SQL Server assemblies and/or configured PowerShell to use the SQL Server provider, and I've jumped into SMO, sometimes...
|
-
|
Sometimes you just have to accept that it works, follow the recipe, and just use it rather than understand it. I call it hitting the 'I believe' button. Then an amazing thing happens; over time the more and more you use the technology or work with it,...
|
-
|
This post covers accessing web services in an SQL Server 2008 SSIS package, in particular the web service provided by Reporting Services 2005 in both MSRS 2005 and MSRS 2008. I have a need to generate reports on a schedule and/or on an event driven basis...
|
-
|
Okay, I know there are a lot of lovers of this IDE, but seriously it's been a royal PIA to use for this PHP work! Maybe it's just because I've been using a top of the line IDE for the past 6 years and am use to things just being where you expect them...
|
-
|
In a previous blog post I talked about being puzzled as to why I wasn't able to get, in my mind, accurate table counts for a database in SQL Server 2005 that had over 50,000 tables. I kept getting only 1,000. With the help of Chad Miller , I've figured...
|
-
|
I was tagged in a blog post making the rounds based on the question, 'Who has been a great leader in your career and what made them a great leader?' I think I'll join the bandwagon on this way and politely decline on talking about great leaders in my...
|
-
|
One of the many joys I get out of life is being able to get away from all the horrible politics of my day job and get a nice clear dark night to look at the stars. Very relaxing. Something that is actually fun. A nice hobby where I feel I can go out and...
|
-
|
Any customer can have a car painted any colour that he wants so long as it is black. - Henry Ford in his autobiography " My Life and Work " SQL Server has a stored procedure for creating new SQL Agent jobs called sp_add_job , and this stored procedure...
|
-
|
One of the applications we have from a vendor has a SQL Server 2005 database with over 50,000 tables. I was using the PowerShell provider for SQL Server to search through the tables to find any that had the word 'ROLE' in it using the following command:...
|
-
|
I was asked 'how much does it cost to get the last 15% of code coverage?', which also led to the question of 'how much does a unit test cost?' So I went on a mission to determine this. For this post, substitute $$ for whatever your hourly rate is, or...
|
-
|
Another awesome SharePoint Saturday event is coming…this time to the Washington DC area on May 2nd 2009. This SharePoint Saturday will be as awesome as the other ones that are happening all over the country – lots of good topics and material with knowledgeable...
|
-
|
Just making Sure everyone knows about the upcoming Richmond Code Camp on April 25th, 2009. This Code Camp will be awesome – lots of new and really good speakers (I’ve seen the list). Make sure you come on out and spend the day with us, I promise it will...
|
|
|
|