Bob Beauchemin's Blog - http://www.sqlskills.com/blogs/bobb

dasBlog • SQL Server 2008 • No Category •

2005-07-20 12:00:00 AM Congratulations, you've installed DasBlog!

SQL Server 2008 (85)

No Category (372)

2007-12-26 02:13:40 PM Mapping Insert/Update/Delete sprocs with Many-to-Many
2007-12-26 11:55:13 AM Mapping Insert/Update/Delete sprocs with Entity Designer
2007-12-08 08:36:17 PM Entity Framework Beta3 - Deleting without fetching
2007-12-08 07:39:11 PM Entity Framework Beta3 - In search of round-trip optimization
2007-11-13 11:22:07 PM ITForum - Days 2 and 3
2007-11-12 04:44:54 AM ITForum - Day 1 in Barcelona
2007-11-10 01:59:39 PM TechEd Barcelona Wrapup...and on to TechEd/ITForum
2007-11-08 12:26:22 AM Barcelona Day 4 - Transactions/Isolation and OLE DB v ODBC
2007-11-06 08:39:10 AM Barcelona Day 3 - TSQL Query Plans and XML in SQL Server
2007-11-06 12:17:58 AM Barcelona Day 2 - Powershell/SMO and SQLCLR
2007-11-04 11:56:28 PM Welcome to Barcelona! TechEd and Best Practices
2007-08-28 02:22:33 AM At TechEd Hong Kong: precon and day 1
2007-07-31 08:35:40 PM Two friends of mine (and SQL geeks) tie the knot
2007-07-17 02:16:14 PM Some book reviews
2007-07-17 01:45:43 PM TechEd 2007 in Hong Kong - I'll be there
2007-05-06 05:45:34 AM DevDays Amsterdam SQL Server Postconference event
2007-05-06 05:39:52 AM TechEd 2007 - I'll be there
2007-04-21 08:07:03 PM EDM Wizard Not Working? Use EDMGen
2007-04-21 05:06:25 PM SQL Server Compact Edition - newest stuff - SQLCE and entities
2007-04-21 04:53:45 PM SQL Server Compact Edition - newest stuff - sync services
2007-04-21 12:37:58 PM SQL Server Compact Edition - additional pieces
2007-04-21 11:29:14 AM SQL Server Compact Edition - versions and installed locations
2007-04-18 02:05:27 PM Welcome, AdventureWorks Light
2007-04-01 10:09:41 PM Back home from Belgium Developer and ITPro days
2007-03-21 10:52:41 AM My SQL Server security best practices whitepaper is available
2007-03-18 10:38:32 PM A bonus talk for Belgian SQL Server user group next week
2007-03-13 06:00:46 AM Two things you can't do in SQLCLR
2007-03-03 04:36:59 PM Using stored procedures with EDM ObjectServices in the March CTP (with code)
2007-02-25 11:37:32 PM SP2 must haves and SP2 compatibility
2007-02-25 11:13:57 PM DevDays in Ghent - see you there
2007-02-05 04:59:32 PM SSIS Connectivity Whitepaper is Live on Microsoft website
2007-01-30 03:37:45 PM The "5 things..." blog chain letter
2007-01-30 02:52:49 PM The Internals and Troubleshooting whitepaper is available
2007-01-29 05:13:29 PM The first of my scaleout whitepapers is available
2007-01-23 09:08:33 PM XQuery 1.0 et al are now W3C recommendations
2007-01-10 05:15:48 PM A Draft of my SSIS Connectivity Whitepaper is available
2006-12-29 10:23:28 PM Some questions and answers on plan guides
2006-12-29 04:56:01 PM Does sp_dropuser "do the right thing" with schemas?
2006-12-29 04:04:28 PM Using SQLCLR functions in indexed views
2006-11-15 06:04:56 AM It's sunny in Barcelona
2006-11-13 08:33:47 AM Don't be Afraid Of ... at ITForum
2006-11-13 01:02:29 AM One Service/Queue per Query Notification, please
2006-11-10 01:43:14 AM Just Add 50000
2006-11-07 07:32:04 AM SMO and Powershell: Better Together, The Scripts
2006-11-06 02:07:20 AM SMO scripting at TechEd Europe
2006-10-28 10:55:42 AM Another behavior that follows schemas, query plan reuse
2006-10-20 01:16:58 PM LINQ/EDM in SQLCLR?
2006-10-20 12:53:57 PM Barcelona, here I come
2006-09-26 12:24:12 AM What IS ADO.NET vNext anyway?
2006-09-16 03:29:40 PM SQL Server service accounts and privileges
2006-09-16 01:48:35 PM Who uses MARS? ADO.NET vNext, that's who.
2006-09-14 02:09:04 PM SQL Server 2005 - Value For Every Business Demos
2006-09-01 11:36:50 PM Clustering Whitepaper for SQL Server 2005 available now
2006-08-24 07:58:11 PM Next stop, Hong Kong...
2006-08-15 02:04:49 PM ADO.NET vNext CTP is available
2006-08-15 01:57:09 PM Service Broker: When is DEFAULT not the default?
2006-08-15 01:11:43 PM Our new book, available cheap
2006-08-14 01:01:44 PM New paper on Data Access Tracing
2006-08-08 10:47:22 PM Non-intuitive test data leads to proper constraints?
2006-08-06 04:14:54 PM Musings from the Immersion Event
2006-08-06 03:39:53 PM More of our book reviewers are blogging!
2006-07-21 12:09:39 AM Entities and SQL Server 2005 Metadata. Really.
2006-07-18 11:56:32 PM SQL Server 2005: an overriding theme to the new features
2006-07-06 07:18:19 PM Commoditization of a technology deployment pattern
2006-07-05 02:33:00 PM Pondering scale-out
2006-07-03 05:44:46 PM Liz is blogging!
2006-07-03 05:27:23 PM He's baaack. Public classes at SQLskills
2006-06-30 10:11:56 PM What's that stuff good for, anyway?
2006-06-27 05:42:30 PM Pre-provisioning and SqlDependency
2006-06-26 05:50:26 PM Federation Enhancements/Changes in SQL Server 2005
2006-06-18 05:13:25 PM TechEd2006 Wrapup
2006-06-15 11:29:22 AM TechEd2006 - Content links and plan guide presentation
2006-06-14 09:59:22 AM At TechEd: Errors and Handling Errors; DLINQ interest
2006-06-12 01:49:56 PM At TechEd: Event Notifications and scope creep
2006-06-12 01:32:38 PM SQLskills welcomes Elizabeth Vitt
2006-06-09 10:49:37 PM About my TechEd activities
2006-06-06 10:51:58 PM DLINQ and FLWOR
2006-05-30 12:16:15 AM Multiple synthesized rowsets with SqlDataRecord
2006-05-28 12:13:47 AM New "SQLCLR-approved" assembly in SP1
2006-05-25 11:33:32 PM SQLCLR supports assembly versioning...NOT
2006-05-24 02:55:39 PM Finding data differences between SQL Server 2005 tables
2006-04-26 08:19:31 PM Our new book has arrived
2006-04-25 04:54:51 AM TechEd Boston 2006...I'll be there
2006-04-25 04:32:31 AM Using WMI and SQL Agent Alerts (part 2)
2006-04-25 04:03:39 AM Using WMI and SQL Agent Alerts (part 1)
2006-04-19 11:47:10 PM What's fixed in SP1?
2006-04-19 11:15:00 PM And I'm on DNR-TV tomorrow
2006-04-16 04:44:46 PM I'm on DNR next week
2006-04-14 11:24:35 AM Technet Webcast Series for the ITPro - Part 6
2006-03-26 04:43:52 PM Expose data through an ADO.NET data provider
2006-03-23 10:28:03 AM Poking at SQLCLR
2006-03-22 11:14:21 PM I'm speaking tomorrow night at home
2006-03-17 01:18:38 PM Technet Webcast Series For the ITPro - Part 2
2006-03-12 05:05:31 PM More info about System.Configuration
2006-03-06 11:25:30 PM At Dutch Devdays
2006-03-03 12:38:32 AM Move over developers! SQL Server XQuery is actually a DBA tool
2006-03-03 12:03:01 AM XQuery methods and determinism
2006-02-10 03:04:32 PM New samples; Calling Oracle from SQLCLR
2006-02-10 12:28:04 AM What does EXECUTE on an XML SCHEMA COLLECTION allow?
2006-02-09 12:03:53 AM Using System.Configuration.dll in .NET sprocs and UDFs
2006-02-08 11:26:46 PM Ownership chains and .NET procedure data access code
2006-01-30 10:35:25 AM About SCHEMAs and setting up Query Notifications
2006-01-21 10:50:19 PM DevDays Netherlands...I'll be there
2006-01-16 08:37:33 AM Sample chapter requires latest version of Acrobat reader
2006-01-13 02:16:52 PM No HTTP endpoints on SQL Express
2006-01-12 02:53:15 PM I hate to wait (doesn't everyone)
2006-01-09 02:52:10 PM Sample chapter of SQL Server 2005 Programmer's Guide available
2006-01-03 03:57:45 PM Still Alive and Well
2005-12-05 04:06:04 PM SOAP Protocol officially supported on SQL Server running on XPSP2
2005-12-01 12:55:17 PM Extracting the smdl for an already-deployed model
2005-11-21 07:58:29 AM Service broker and database master keys
2005-11-16 12:50:23 AM For all you XML-phobes that lke DDL triggers and Event Notifications
2005-11-15 02:16:57 AM Seeing errors in callers, SQLCLR error 6522, and T-SQL TRY-CATCH
2005-11-10 12:44:22 PM What's the SqlDependency doing now?
2005-11-06 12:16:00 AM An interesting tidbit from the readme file
2005-11-05 12:14:17 AM Two cool add-ins for SSMS
2005-11-02 12:18:01 PM Correction...I did meet the man
2005-11-02 09:38:02 AM My Podcast with Wally McClure is available
2005-10-27 03:40:36 PM It's here
2005-10-21 10:57:04 PM SQL Server 200x wish list - wrapup and explanation
2005-10-21 09:34:06 PM SQL Server 200x wish list - part 5, SQLCLR
2005-10-21 09:12:28 PM SQL Server 200x wish list - part 4, T-SQL and Engine
2005-10-21 08:01:25 PM SQL Server 200x wish list - part 3, Service Broker
2005-10-21 07:36:01 PM SQL Server 200x wish list - part 2, XML and XQuery
2005-10-21 07:09:20 PM Hello again. and SQL Server 200x wish list part 1
2005-10-01 07:30:23 PM Fireworks in Hong Kong
2005-10-01 07:13:31 PM Goodbye Dallas, Hello Hong Kong
2005-09-25 08:51:54 AM Made it to SQLPass conference this year, whew
2005-09-22 07:33:38 PM What's that source code doin' in there?
2005-09-16 10:13:10 PM Security in SQL Server 2005 - unsafe assemblies in Sept CTP
2005-09-10 04:40:15 PM Security in SQL Server 2005 - "non-traditional" logins and users
2005-09-10 04:09:41 PM Security in SQL Server 2005 - execute as...with cookie
2005-09-10 02:10:55 PM Blog reading and "continued here"
2005-09-05 12:47:06 PM Security in SQL Server 2005 - unsetapprole
2005-09-05 12:32:40 AM Security in SQL Server 2005 - Encryption
2005-09-05 12:08:07 AM Security in SQL Server 2005 - Logins
2005-09-02 03:24:44 PM I'll be at PDC...not
2005-09-02 03:00:24 PM SQL Server 2005 mailer feature uses Service Broker
2005-08-24 11:55:19 PM SQLCLR, transaction nesting, and TransactionScope
2005-08-24 11:48:34 PM I'll be on a SQL Server 2005/Visual Studio 2005 Panel
2005-08-24 12:14:58 PM We win SQL Server Magazine Readers' Choice
2005-08-22 11:10:37 PM IsNull != IS NULL, the reprise and the solution
2005-08-16 02:05:00 PM SqlTypes.SqlXml and impersonation
2005-08-13 04:05:39 PM Dude, where's my table?
2005-08-11 01:01:07 PM What are the unsolved problems
2005-08-06 11:31:29 PM Whatever happened to...
2005-08-03 09:51:28 AM Why my cat can't use a SQLCLR proc to read files
2005-08-03 09:34:57 AM The demise of the dispatcher proc
2005-08-01 06:37:28 PM SQL Server book-of-the-month club pick
2005-08-01 06:24:37 PM It's already tomorrow in Australia
2005-08-01 04:55:30 PM I'm not sysadmin, I just play one on TV
2005-08-01 04:39:06 PM Combined provider status
2005-08-01 06:55:08 AM The Times They Are A-Changin'
2005-07-06 04:17:11 PM Changing SQL Login password with the utilities
2005-07-05 07:53:40 PM I'm Database Geek of the Week (last week)
2005-07-05 07:37:05 PM It's been a whole year
2005-07-03 08:34:46 PM Au revoir, Ascend
2005-06-12 11:13:53 PM SqlNotificationRequest changes
2005-06-12 10:47:56 PM Outstanding Service Broker book
2005-06-12 10:30:04 PM Back From TechEd
2005-06-03 02:43:54 PM What's a truncation exception?
2005-06-03 02:27:43 PM How DO you change your SQL Login password?
2005-05-26 08:21:17 AM They did it! Relative paths in SSMS projects
2005-05-22 11:15:13 AM A Second Look at SQL Server 2005 for Developers
2005-05-22 10:55:49 AM Dan Sullivan is blogging
2005-05-16 12:02:45 AM XML Schema for the truly lazy
2005-05-15 11:06:35 PM Combined provider: transactions and the return of 6522
2005-05-15 10:43:07 PM Go ahead, make a validation mistake...
2005-05-15 10:25:45 PM DataDirect providers...and some ADO.NET 2.0 beta2 changes
2005-05-08 04:52:44 PM TechEd 2005 - I'll be there too
2005-05-08 04:37:29 PM SQLPass - I'll be there
2005-05-08 04:30:59 PM How to make a DBA smile
2005-05-08 04:06:23 PM Mailing the graphic showplan to a friend
2005-04-25 07:36:24 AM What happened to SNAC tracing in beta2?
2005-04-24 10:26:30 PM A first demo of the combined data provider
2005-03-24 11:21:21 AM What do you mean by "unsupported"?
2005-03-24 11:13:57 AM DROP ASSEMBLY change - just a convenience?
2005-03-23 11:16:07 PM SQL Server unified provider info on DataWorks' team blog
2005-03-23 09:32:16 PM Service Broker's new poison message handling
2005-03-23 08:33:43 PM New Service Broker features in the Feb CTP
2005-03-13 04:54:46 AM FOR XML...XMLSCHEMA and schema validation
2005-03-06 03:18:36 AM About the new SQLCLR TVFs
2005-03-05 01:58:21 AM Where 'ya been dude?
2005-02-16 10:29:21 PM First release of Service Broker Explorer
2005-02-16 10:20:09 PM Query plan guides in the SQL Server 2005 BOL
2005-02-16 09:54:13 PM UDM data access - is it all done with mirrors?
2005-02-11 08:15:13 AM Don't try this at home...yet
2005-02-09 03:52:24 PM System.Transactions, promotable transactions, and composition
2005-02-07 08:19:40 AM Tracking the pesky appdomain
2005-02-07 08:17:42 AM Back home again
2005-01-27 11:03:05 AM Fun with static XQuery evaluation - 4 - answers and wrapup
2005-01-26 11:30:56 PM Fun with static XQuery evaluation - 3
2005-01-26 04:36:58 PM Fun with static XQuery evaluation - 2
2005-01-26 03:22:09 PM Fun with static XQuery evaluation - 1
2005-01-19 11:13:37 PM Password policies on object passwords
2005-01-17 06:02:06 AM Service Broker object names are case sensitive
2005-01-16 11:37:40 AM XQuery and the useful XML index
2005-01-06 02:54:09 PM IRowsetFastLoad, the reprise
2005-01-05 12:08:38 AM How do I see all the tables again?
2004-12-31 02:22:05 PM HTTP Endpoints and FORMAT=NONE
2004-12-28 11:27:46 PM New functions to use with try-catch
2004-12-23 10:55:47 PM Autocomplete in VS 2005
2004-12-19 10:43:16 PM Merging SqlClient and SqlServer providers
2004-12-19 12:22:08 AM Night of the Service Broker...and Announcement
2004-12-06 08:19:09 PM SqlContext syntactic changes
2004-12-05 02:40:30 PM Another improvement in Dec CTP
2004-12-05 02:16:43 PM Using inheritence in SQLCLR UDTs
2004-12-03 11:12:25 AM A First Look at Dec CTP
2004-12-03 10:18:06 AM Schemas, Users, and Objects - III
2004-12-03 09:47:11 AM SQL Server December CTP available
2004-12-02 11:00:32 AM Schemas, Users, and Objects - II
2004-12-01 11:43:11 PM Schemas, Users, and Objects - I
2004-11-30 11:42:22 AM More ADO.NET 2.0 and XML data type
2004-11-30 11:27:30 AM Home again
2004-11-24 11:24:09 PM Some useful articles on MSDN online
2004-11-21 02:32:39 AM SQLCLR assembly owners and dependencies
2004-11-21 01:47:46 AM SQLCLR appdomain usage
2004-11-15 10:01:35 PM AirplaneLand
2004-11-11 04:24:52 PM An excellent SQLNS book
2004-11-11 01:00:30 PM How do I get (N) rows from a SQL Server XQuery?
2004-11-10 11:59:17 PM What's my (Windows) identity?
2004-11-10 02:14:43 PM Don't you database people have any standards?
2004-11-10 12:57:30 PM I have CREATE TABLE privilege but can't create tables
2004-11-08 12:44:01 PM More on ownership chains
2004-11-05 11:51:38 PM Users, Schemas, Objects, and Owners
2004-11-05 11:14:08 PM .NET-based library for Service Broker
2004-11-03 11:36:51 PM Formatting XML/XQuery in SQL, and caveats
2004-11-03 08:52:36 AM XQuery Schema Validation Clarification
2004-11-02 11:52:38 PM Early XQuery schema validation
2004-11-02 11:21:29 PM Slides, articles, and shameless self-promotion
2004-10-30 02:12:00 PM Thought on Microsoft client XQuery
2004-10-30 01:28:13 PM Back From Win-Dev; what year is it?
2004-10-25 04:26:54 AM One more thing about 6522 error
2004-10-25 04:18:56 AM I'm at WinDev
2004-10-20 12:37:33 PM Intersect and Except....almost
2004-10-20 10:09:00 AM Least privilege and HTTP endpoints
2004-10-15 06:36:34 AM Error 6522:the reprise
2004-10-05 10:12:46 PM Another minor SNAC/SQLOLEDB provider difference
2004-10-04 11:08:48 PM OLE DB/ODBC, SNAC, and the new "MAX" data types
2004-10-02 12:05:22 AM How SQLCLR works when its disabled
2004-10-01 11:12:13 PM Why programmers shouldn't be marketers
2004-09-30 11:56:20 AM Query Notification Article on MSDN online
2004-09-28 07:49:43 PM Using FX assemblies outside of "the list"
2004-09-27 08:20:38 PM More about SQLCLR approved assemblies
2004-09-27 09:29:56 AM I'm at SQLPass conference...not
2004-09-21 11:30:11 PM SQLCLR - List of approved framework class libraries
2004-09-12 11:07:00 PM On the road again
2004-09-12 10:59:45 PM I meet Angel Saenz-Badillos
2004-09-10 03:29:28 PM Peaches en Regalia and XML Schemas
2004-09-10 02:34:51 PM What's all that stuff in sys.assembly_files?
2004-09-10 12:00:36 PM Office 2003 XML schemas and SQL Server 2005
2004-09-09 09:46:32 AM XML and SQL Server: stream, column, or string?
2004-09-06 10:59:36 PM HTTP Endpoints and Windows XP SP2
2004-09-06 12:49:30 AM Using the data() function in XQuery
2004-09-05 11:34:45 PM Hello, Virtual Server
2004-08-30 10:26:41 PM Checking for dangerous attributes at catalog time
2004-08-29 12:09:45 PM Good XQuery Books
2004-08-25 12:13:12 PM At the airlift
2004-08-23 04:01:23 PM Using "ordinary" class libraries with SQL Server 2005
2004-08-23 12:14:56 AM SQLCLR Optimizations - 2
2004-08-20 04:14:09 PM Error 6522 and You
2004-08-20 10:54:48 AM SQLCLR Optimizations - 1
2004-08-18 12:02:55 PM HTTP endpoint session support in SQL Server 2005
2004-08-16 10:32:25 AM Better XML to DataSet inference in .NET 2.0
2004-08-12 11:18:03 PM UDTs and UDAggs - Serialization and Construction
2004-08-12 03:12:17 PM SqlTypes.SqlXml and XmlReader.Create
2004-08-10 02:55:02 PM Fun with displaying UDTs in SSMS
2004-08-10 10:29:59 AM Where did the netlibs go?
2004-08-09 11:11:34 AM How do you refer to ...?
2004-08-01 02:23:35 PM SMO and object-relational mapping
2004-08-01 09:24:38 AM On SELECT statements and SqlDependency
2004-07-28 02:14:59 PM Killing a pesky query notification subscription
2004-07-27 11:59:28 PM My 20 favorite beta 2 developer features so far
2004-07-26 11:08:08 AM Visual Studio Beta 1 and sqlaccess.dll
2004-07-26 10:57:41 AM Beta 2 available. Some first observations.
2004-07-21 04:59:43 PM On mapping between data models
2004-07-16 04:16:25 PM No more Microsoft.VisualStudio.DataTools.SqlAttributes.dll
2004-07-16 03:46:23 PM COmega and rite of passage program
2004-07-16 03:28:24 PM "Rite of passage" programs and SQLCLR
2004-07-14 01:35:10 PM About Web Services and "Schema + Any"
2004-07-13 09:21:54 AM Not DataSet, Dataset!
2004-07-08 08:30:55 PM A sample ADO.NET 2.0 data provider
2004-07-06 09:23:43 PM Have a SNAC
2004-07-04 03:21:29 PM A Comment About Comments (XQuery Comments)
2004-07-04 03:20:14 PM My whereabouts
2004-07-01 08:03:21 PM Out of hiding

dasBlog • SQL Server 2008 • No Category •

dasBlog (1)

2005-07-20 12:00:00 AM Congratulations, you've installed DasBlog!

SQL Server 2008 (85)

No Category (372)