|
|
Front Page News
-
|
New to TFS 2010 is the concept of a TFS Domain. You can install a domain controller on a server then install TFS 2010 thus creating a seperate TFS domain. Why would you do this? I've have had several clients with security concerns that this appeals to,...
|
-
|
Come one come all!! Richmond Code Camp 2010.1 is just around the corner!!! If you have not done so, please make plans to attend the Richmond Code Camp on October 9th, 2010. It will be well worth the time and effort 3 reasons to attend: Good relevant content,...
|
-
|
This is the second in at least a two part series dealing with SQL Agent Jobs. In this post, we are creating a new procedure to be used instead of the system procedure sp_start_job when you need to wait for a SQL Agent Job prior to moving on to the next...
|
-
|
I wanted to talk about SQL Server Agent Job's status, but before we get into that I want to talk about Utility databases. I've noticed over the years some of the DBA's and database developers have utility databases and some have a folder of commonly used...
|
-
|
Yup, you read the title right. My blog is going to be moving. For a number of different reasons it's time for me to strike out on my own, so I'm following Brent Ozar's excellent How To Start a Blog series to make that migration happen. One of those reasons...
|
-
|
In a renewed effort to read one tech book a month in 2010, I've restarted Bruce Payette's Windows PowerShell In Action just as I've been using PowerShell to solve a problem at work. I was attempting to use a SendEmail function I found on a blog, and when...
|
-
|
Time to make my professional goals again for the new year. In conjunction with listing my new goals, I'll also talk about some of the goals for last year and how I fared. Certification : Pass exam 70-453 in order to earn my MCITP: Database Administrator...
|
-
|
I was tagged in a recent post by Jeremiah Peschka asking how we use SQL Server. Jeremiah has uttered that words that compel me to reveal my true identity, despite the great risk I take in doing so. Fear not, for the true consciousness of the one who identifies...
|
-
|
Recently when I tried to access Reporting Services' Report Manager for a SQL Server 2008 Developer Edition SP1 instance on a Windows 2008 R2 Server, I got a completely blank screen. It was not a mostly blank screen still showing the header, nor was I...
|
-
|
PASS Summit 2009 is rapidly approaching, and one of the features of the conference is the chance to meet new people who also work with SQL Server. In order to help attendees meet new people, some folks have put together SQL PASS Twitter Bingo . I've volunteered...
|
-
|
Introduction It's a surprisingly easy thing to do: create orphans by design in a database. In this post I present one such example. Relationship First First you need a a relationship between two tables. In this example, we'll start with a parent-child...
|
-
|
My #ActiveAugust goals have hit a snag. I'm injured. I've learned the hard way that I need to be careful, and I'll likely be sidelined for a few days healing. Durnit! AndysActiveAugust Metric: 10 for 11, or 0.91. :{<...
|
-
|
Sundays are the nemesis of my #ActiveAugust goals. It's a busy day with church and usually some sort of family activites thereafter. Last Sunday, 2 Aug, was the only day thus far I hadn't exercised. So this Sunday I was more than a little concerned. Christy...
|
-
|
It's been a couple days since I last blogged . In between a couple long days at work, installing Windows 7 on the Red XPS laptop, and Riley's birthday cookout; I managed to exercise both days. My #ActiveAugust goals revolve around making exercise a habit....
|
-
|
Today was also close. After staying up too late last night due to work (and being old - old people don't need sleep), my #ActiveAugust aspirations were nearly dashed by sleeping in until after 6:00 AM again for the second day in a row. In addition, it...
|
-
|
Today was close. After being inspired by Tim Benninghoff 's post about Dynamic SQL (and writing one of my own), I stayed up too late last night. The alarm is set for 5:30 AM to give me enough time to get up and stirring before heading to the gym at 6:00....
|
-
|
I was just reading Tim Benninghoff's latest post: Dynamic SQL is my administration buddy and it got me thinking (Tim's posts often get me thinking) about how much I use dynamic SQL each day. Just today I needed to create a test query to count the rows...
|
-
|
I did something today I haven't done in weeks - I made it to the gym for the second day in a row, Maybe it's all psychosomatic (or just plain psycho), but I felt better today. I did 1.5 miles on the treadmill - enough to get a minimum good cardio workout...
|
-
|
In the age of SQL injection attacks, the dangers of dynamic SQL are pretty well documented. But, as with most things, there's a time and a place for them. I recently indulged in a trip down memory lane, reviewing the scripts in my 'toolbox' that I use...
|
-
|
Andy's 2 for 3 so far this #ActiveAugust......
|
-
|
1 Aug 2009: Today's cardio was mowing. About half of the three acres we (and the mortgage company) own is covered with grass - the kind that insists on growing. It's been a couple weeks since I gave it all a good mow. My neighbors were shaming me with...
|
-
|
I'm going to participate in #ActiveAugust for a couple reasons: A bunch of my Twitter friends are doing it. I really need to be more active. My plans are to go cardio each day. For me, doing something that gets my heart rate into workout range every day...
|
-
|
Introduction This is the first post in a series called WeatherData. In this series I am going to demonstrate principles of test-driven database development (TD3). Build the Solution Did you know you can use SSMS to build a database project? You can. I'm...
|
-
|
The internet abounds with documentation and blog posts about logon triggers, introduced to SQL Server 2005 in service pack 2. Recently I had the opportunity to work with them developing an imperfect solution to provide a temporary bandage for a vendor's...
|
-
|
Introduction (Found via Brett Petersel , Twitter ) So, EA is publicizing a new game called Dante's Inferno, and they chose a contest at Comic-Con to promote it: Sin to Win . There's a decent synopsis here . Take a picture with a "booth babe" at Comic-Con,...
|
|
|
|