February 2008 - Posts

• Adios SQLJunkies

  Thanks for getting me started but it's time to close the door. Allen Read More... Posted Saturday, February 23, 2008 7:06 PM by AllenMWhite | 0 Comments

• Change Tracking and Change Data Capture

  Tonight's meeting of the Ohio North SQL Server Users Group will include the Detroit SQL Server Users Group as well. Here's the agenda: 5:30 - 6:00 PM - Early Arrival/PASS Intro and Presentation Tips and Techniques - Allen White 6:00 - 6:10 PM - Get Pizza Read More... Posted Thursday, February 21, 2008 11:32 AM by AllenMWhite | 0 Comments

• Start PowerShell in Management Studio

  In the February CTP of SQL Server 2008 a new feature has appeared in SQL Server Management Studio. You now have the ability to right-click on an object in the Object Explorer window and open up a PowerShell window. In this window you can navigate the Read More... Posted Wednesday, February 20, 2008 8:59 AM by AllenMWhite | 6 Comments Filed under: SMO, PowerShell, SQL Server 2008

• Ohio North SQL Server Users Group February Meeting - Moved to February 21

  Normally our meetings are on the second Thursday of the month, but this year that falls on Valentine's Day, so we've moved the meeting to Thursday, February 21. Here's the agenda for the February meeting of the Ohio North SQL Server Users Group: 5:00 Read More... Posted Monday, February 11, 2008 9:58 AM by AllenMWhite | 0 Comments Filed under: User Group Meetings, SQL Server 2008

• PowerShell, SQL Server and Large Resultsets

  Last week I posted about using PowerShell and SQL Server together, and I used a SQLDataAdapter and populated a DataTable with the results. This approach is fine if what you're doing returns a reasonably small resultset, but what if you're returning millions Read More... Posted Friday, February 1, 2008 8:59 AM by AllenMWhite | 2 Comments Filed under: PowerShell, Database Administration