Latest Blog Posts

• 0 Comments 147 Views

  Quote of the Day – On the Importance of Truth “Whoever is careless with the truth in small matters cannot be trusted with important matters.” - Albert Einstein Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!... 11 hours, 18 minutes ago by BuckWoody to Buck Woody Filed under: Quote Of The Day

• 4 Comments 370 Views

  On PASS Summit Locations, Time Will Tell Introduction The PASS Board, continuing a trend of more openness championed by Board members, released the results of its Location Survey . Along with this, PASS President Rushabh Mehta added a blog post explaining the interpretation and logic behind... 11 hours, 59 minutes ago by andyleonard to Andy Leonard Filed under: EMPs (Expensive Management Practices), PASS

• 12 Comments 328 Views

  Survey: which newsletters do you subscribe to? read? Just curious who reads what. Maybe I am missing something... Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!... 03-11-2010, 14:42 by Alexander Kuznetsov to Alexander Kuznetsov

• 1 Comments 137 Views

  Survey: Do you find surveys annoying? I'm sorry I couldn't resist... Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!... 03-11-2010, 13:48 by James Luetkehoelter to James Luetkehoelter Filed under: humorous

• 15 Comments 526 Views

  Survey: How do you manage the source code for your personal projects? This seems to be the survey season. Andy’s post on source controlling T-SQL code triggered a question that I always wanted to ask. Do you version control the source code for your various personal projects (i.e. not projects of your customer or employer)?... 03-11-2010, 13:09 by Linchi Shea to Linchi Shea Filed under: Source control, version control

• 18 Comments 391 Views

  There once was in Dublin a query For 6 months I’ve have been planning a secret trip to London in May as a surprise for my wife (of Irish heritage and accent) (I love how she says, "Aye laddie, kiss me I'm Irish." but that's for another blog.) The plan was to spend a week in London and... 03-11-2010, 12:00 by Paul Nielsen to Paul Nielsen Filed under: Dublin, Ireland, limerick, User Group

• 4 Comments 302 Views

  System Variables, Stored Procedures or Functions for Meta Data Whenever you want to know something about SQL Server’s configuration, whether that’s the Instance itself or a database, you have a few options. If you want to know “dynamic” data, such as how much memory or CPU is consumed or what a particular query is... 03-11-2010, 8:42 by BuckWoody to Buck Woody Filed under: Administration, DBA, Metadata, SQL Server, Tips, T-SQL

• 11 Comments 403 Views

  Dear ISV: You’re Keeping Me Awake Nights with Your VARCHAR() Dates I generally sleep well and deeply. My wife and I once went to sleep, back when we lived in the Heights neighborhood in Houston, and when we woke up the next day, the house across the street had been removed . We never heard a thing. However, tonight it’s... 03-11-2010, 8:07 by merrillaldrich to Merrill Aldrich

• 0 Comments 263 Views

  Speaking at Triangle SQL Server User Group 16 Mar 2010! I'm excited to present Applied SSIS Design Patterns to the Triangle SQL Server User Group 16 Mar 2010! This is a reprise of my PASS Summit 2009 spotlight session. If you read this blog and make the meeting, introduce yourself! :{> Andy Share this post:... 03-11-2010, 7:00 by andyleonard to Andy Leonard Filed under: Design Pattern, SSIS

• 34 Comments 1148 Views

  The ethics of aggregating other peoples' content Content theft Most of the recent - what I'll call - "discussions" about content aggregators have revolved around content theft. I'm not going to flip-flop on that topic: when you use someone else's work, you ask first, and if given the okay, you cite... 03-10-2010, 17:20 by AaronBertrand to Aaron Bertrand Filed under: advertising, aggregation, content theft, ethics, revenue model, traffic

• 18 Comments 367 Views

  Survey: How much data do you work with? Andy isn't the only one that can ask a survey question. This is something I really curious about because many of the answers or recommendations or rants in blogs are not universably applicable to every database - small databases must sometimes be treated... 03-10-2010, 12:57 by James Luetkehoelter to James Luetkehoelter Filed under: database sizes, SQL Server, survey

• 8 Comments 508 Views

  Good News for Women in Technology - Barbie Has Joined the IT Scene Notice the bluetooth ear piece fashion faux pas? Yes, she's truly a geek. I'm happy to report that Barbie is now a cognizeti, a digerati, ... yes even an IT Professional! This year's new Barbie is Computer Engineer Barbie . Several months back, I encouraged... 03-10-2010, 10:34 by KKline to Kevin Kline Filed under: Conferences, Ethics, Opinion, PASS, People, Trends

• 1 Comments 224 Views

  Create Outlook Appointments from PowerShell I've been toying around with a script to create a special set of calendar objects in Outlook that show when my SQL Server Agent Jobs are scheduled to run. I haven't finished yet, but I thought I would share the part that creates the Outlook Appointments.I... 03-10-2010, 10:33 by BuckWoody to Buck Woody Filed under: Administration, Design, PowerShell, SQL Server

• 7 Comments 357 Views

  Survey: How's Your Economy? Another quick survey question, slightly off-topic: How's your economy? Have things picked up for you recently? Slowed down? Remained static? :{> Andy Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!... 03-10-2010, 7:00 by andyleonard to Andy Leonard Filed under: Andy's Crazy Questions

• 6 Comments 699 Views

  T-SQL Tuesday #4: I/O, You Know It's time for the fourth T-SQL Tuesday , managed this time by Mike Walsh . I almost missed this deadline completely, since I didn't see the announcement at all. I wrote to Adam to ask if there even was an event this month, since I wasn't able to get into... 03-09-2010, 17:22 by Kalen Delaney to Kalen Delaney Filed under: Performance, T-SQL Tuesday

• 6 Comments 386 Views

  T-SQL Tuesday - IO capacity planning This post is my contribution to Adam Machanic's T-SQL Tuesday #004 , hosted this time by Mike Walsh . Being applicative DBA, I usually don't take part in discussions which storage to buy or how to configure it. My interaction with IO is usually via PerfMon.... 03-09-2010, 15:52 by Michael Zilberstein to Michael Zilberstein

• 11 Comments 419 Views

  Consolidation Strategy References I have a presentation that I give on SQL Server Consolidation Strategies, and in that presentation I talk about a few links that are useful. Here are some that I’ve found – feel free to comment on more, or if these links go stale:   Consolidation... 03-09-2010, 8:11 by BuckWoody to Buck Woody Filed under: Conferences, Link Lists, Links, SQL Server, Web

• 35 Comments 1170 Views

  Survey: T-SQL Source Control? One or two quick survey questions: Do you manage T-SQL scripts in source control? If so, which source control product / platform do you use? :{> Andy Note: I moderate comments, so your comment will take some time to publish. Share this post: email... 03-09-2010, 7:00 by andyleonard to Andy Leonard Filed under: Andy's Crazy Questions, Database Developer

• 8 Comments 508 Views

  T-SQL Tuesday #004: Real World SSD’s A contribution for T-SQL Tuesday #004 , hosted by the illustrious Mike Walsh! In the past few weeks I had some correspondence with Kendal Van Dyke leading up to his SQL Saturday presentation on SSDs, and he got me fired up to share a little of my team’s... 03-08-2010, 23:22 by merrillaldrich to Merrill Aldrich Filed under: performance, san, Solid State Disks, Storage Design

• 1 Comments 308 Views

  T-SQL Tuesday #004: Why Doesn't TDE Encrypt My FILESTREAM Data? This post is my entry for Adam Machanic's T-SQL Tuesday #004 , hosted this time by Mike Walsh . I was at the RSA Conference in San Francisco last week discussing database encryption options in SQL Server 2008 and one question seemed to keep coming up.... 03-08-2010, 21:42 by Mike C to Michael Coles: Sergeant SQL Filed under: encryption, filestream, SQL 2008, SQL Server, SQL Server 2008, TDE, transparent data encryption, t-sql tuesday