Archive

RSSData Access (70)

Date Title Comments Rating
2011-11-26 Native ODBC components in SQL Server 2012 SSIS 0 None
2011-11-04 Speaking at Portland, OR, User Group in December 0 None
2011-11-03 SQL Server 2012 client features - ADO.NET 4.02 released 0 None
2011-08-31 Adieu, OLE DB 0 None
2011-08-19 Correlating client and server-side trace in SQL Server Denali 0 None
2011-03-12 TVPs and plan compilation - the reprise 0 None
2010-12-23 The interesting case of TVPs and plan compilation 0 None
2010-07-01 LINQ to SQL and Entity Framework: Panacea or evil incarnate? Revisited. 0 None
2009-11-18 Guide to the Data Development Platform for .NET Developers whitepaper available 2 None
2009-08-07 Upcoming improvements in EDM T-SQL code generation 0 None
2009-05-26 L2S and EF parameterization problem will be fixed in .NET 4.0 - completely 1 None
2009-05-25 L2S and EF parameterization problem fixed in .NET 4.0 - almost 0 None
2008-12-10 Is LINQ the next OLE DB? "LINQ-ed" Server as a rowset source? 7 None
2008-12-10 What the Entity Framework has going for it 0 None
2008-05-30 What's the DataSet doing in a trace of an Entity Framework program? 0 None
2008-05-16 SQL Server 2008 Change Tracking and Sync Services ARE made for each other... in VS2008 SP1 0 None
2008-05-16 SQL Server 2008 data types in LINQ to SQL and EF, they (mostly) did it 1 None
2008-04-05 SqlClient, System.Transactions, SQL Server 2008, and MARS 0 None
2008-03-07 MHO: LINQ to SQL and Entity Framework: Panacea or evil incarnate? Part 6 1 None
2008-03-06 MHO: LINQ to SQL and Entity Framework: Panacea or evil incarnate? Part 5 0 None
2008-03-06 MHO: LINQ to SQL and Entity Framework: Panacea or evil incarnate? Part 4 0 None
2008-03-01 MHO: LINQ to SQL and Entity Framework: Panacea or evil incarnate? Part 3 3 None
2008-02-26 Lots of ORM and VS activity lately 1 None
2008-02-14 LINQ and LINQ to XML to appear in SQL Server 2008 SQLCLR approved list 0 None
2008-02-14 Learning LINQ, LINQ to SQL and eSQL 0 None
2008-02-14 MHO: LINQ to SQL and Entity Framework: Panacea or evil incarnate? Part 2 2 None
2008-02-13 MHO: LINQ to SQL and Entity Framework: Panacea or evil incarnate? Part 1 3 None
2008-01-21 Composable DML and Composable Queries 0 None
2007-12-26 Mapping Insert/Update/Delete sprocs with Many-to-Many 1 None
2007-12-26 Mapping Insert/Update/Delete sprocs with Entity Designer 0 None
2007-12-20 SQL Server 2008 and ADO.NET Sync Services 1 None
2007-12-08 Entity Framework Beta3 - Deleting without fetching 0 None
2007-12-08 Entity Framework Beta3 - In search of round-trip optimization 0 None
2007-11-10 Astoria... I learned something today... 0 None
2007-09-20 An example of using ODBC and SQL Server 2008 table-valued parameters 4 None
2007-09-19 SQL Server 2008 and Clients - the long story 1 None
2007-09-02 Using LINQ to SQL and EDM with SQL Server Compact Edition 3.5 1 None
2007-09-02 Using LINQ to SQL and EDM with SQL Server 2008 0 None
2007-08-02 New SQL Server 2008 Date/Time-related types and ADO.NET 1 None
2007-08-02 Katmai: Using Table-Valued Parameters with ADO.NET 1 None
2007-04-21 EDM Wizard Not Working? Use EDMGen 0 None
2007-03-03 Using stored procedures with EDM ObjectServices in the March CTP (with code) 1 None
2007-02-05 SSIS Connectivity Whitepaper is Live on Microsoft website 1 None
2007-01-30 The Internals and Troubleshooting whitepaper is available 0 None
2007-01-29 The first of my scaleout whitepapers is available 0 None
2006-10-20 LINQ/EDM in SQLCLR? 1 None
2006-09-25 What IS ADO.NET vNext anyway? 0 None
2006-09-16 Who uses MARS? ADO.NET vNext, that's who. 3 None
2006-08-14 New paper on Data Access Tracing 1 None
2006-07-20 Entities and SQL Server 2005 Metadata. Really. 0 None
2006-06-06 DLINQ and FLWOR 0 None
2006-03-26 Expose data through an ADO.NET data provider 8 None
2006-02-10 New samples; Calling Oracle from SQLCLR 1 None
2005-08-24 SQLCLR, transaction nesting, and TransactionScope 0 None
2005-08-06 Whatever happened to... 1 None
2005-06-03 How DO you change your SQL Login password? 0 None
2005-05-15 DataDirect providers...and some ADO.NET 2.0 beta2 changes 0 None
2005-02-09 System.Transactions, promotable transactions, and composition 2 None
2005-01-06 IRowsetFastLoad, the reprise 0 None
2004-11-30 More ADO.NET 2.0 and XML data type 0 None
2004-10-30 Thought on Microsoft client XQuery 2 None
2004-10-05 Another minor SNAC/SQLOLEDB provider difference 0 None
2004-10-04 OLE DB/ODBC, SNAC, and the new "MAX" data types 0 None
2004-09-09 XML and SQL Server: stream, column, or string? 0 None
2004-08-16 Better XML to DataSet inference in .NET 2.0 1 None
2004-08-12 SqlTypes.SqlXml and XmlReader.Create 0 None
2004-08-10 Where did the netlibs go? 1 None
2004-07-21 On mapping between data models 0 None
2004-07-08 A sample ADO.NET 2.0 data provider 3 None
2004-07-06 Have a SNAC 1 None

RSSData-Tier Applications (DAC) (5)

Date Title Comments Rating
2011-07-06 A First Look at Data-Tier Applications 2.0 0 None
2011-07-05 Data-Tier Applications - Version 1.1 - Where? 0 None
2011-07-05 Looking at Data-Tier Applications (DAC)? Look at version 1.1 0 None
2010-04-19 DAC support SQL Azure and vice-versa. It's live. 0 None
2010-01-12 DACPAC and pre-SQL Server 2008 R2 versions 0 None

RSSEvent Notifications (3)

Date Title Comments Rating
2006-04-25 Using WMI and SQL Agent Alerts (part 2) 5 None
2006-04-25 Using WMI and SQL Agent Alerts (part 1) 0 None
2005-11-16 For all you XML-phobes that lke DDL triggers and Event Notifications 2 None

RSSExtended Events (15)

Date Title Comments Rating
2012-01-23 XEvents in SQL Server 2012: No more "lazy XML" in event harvesting scripts 0 None
2011-11-21 Using SQL Server 2012 tools with older database versions 0 None
2011-08-19 Correlating client and server-side trace in SQL Server Denali 0 None
2011-04-21 The Denali XEvent SMO library 0 None
2011-04-18 XEvent in Denali - When an error number isn't error anymore 0 None
2010-11-09 SQL Server Denali CTP1 - PowerShell and XEvents 0 None
2008-11-07 Secrets, hints, and tips for SQL Server Extended Events 1 None
2008-08-31 A GUI visualizer/editor for SQL Server 2008 Extended Events 0 None
2008-04-07 Getting an activity ID with Extended Events 0 None
2007-08-20 XEvent: Some final followup questions (slight return...) 0 None
2007-08-20 Finishing XEvent package items, syntax, and semantics (moon turn the tides...) 0 None
2007-08-20 More about XEvent: actions and targets (still raining, still dreaming) 0 None
2007-08-19 More about SQL Server 2008 extended events: packages, events, and event sessions 0 None
2007-08-16 Making the XEvent ETW target run 0 None
2007-08-16 XEvent in SQL Server 2008 2 None

RSSFilestream Storage (11)

Date Title Comments Rating
2012-01-17 SQL Server 2012 FileTable and T-SQL on AlwaysOn secondary replicas 0 None
2012-01-17 SQL Server 2012 FileTables - AlwaysOn support and PathName() 0 None
2012-01-16 SQL Server 2012 FileTables in T-SQL part 3: hierarchyid methods 0 None
2012-01-16 SQL Server 2012 FileTables in T-SQL part 2: new rows 0 None
2012-01-15 SQL Server 2012 FileTables in T-SQL part 1: functions and methods 0 None
2011-09-06 Of filetables, full-text and semantic search, and docidmaps 0 None
2010-02-04 Filestreams, Remote Blob Storage, and SQL Server 2008 R2 0 None
2010-02-04 Filestreams, transactions and SQL Server 2008 R2 0 None
2009-05-01 Article about programming filestreams on MSDN 0 None
2008-05-30 Saving a roundtrip when inserting rows with filstream columns 0 None
2008-02-28 Configuring Filestream in CTP6 (its different) 1 None

RSSFull-Text Search (6)

Date Title Comments Rating
2011-09-10 Full-text query plans and stats in Denali 0 None
2011-09-06 Of filetables, full-text and semantic search, and docidmaps 0 None
2011-01-23 SQL Server Denali Fulltext Properties - Where? 0 None
2010-12-22 SQL Server Denali - FTS on properties, the cheap demo 0 None
2010-12-22 SQL Server Denali - FTS on properties, the motivation 0 None
2010-11-09 Using SQL Server Denali Full-Text Search With Extended Properties 0 None

RSSPerformance (22)

Date Title Comments Rating
2011-12-05 Speaking at Portland SQL Server User Group this Thursday 0 None
2011-11-04 Speaking at Portland, OR, User Group in December 0 None
2011-09-27 LOTS of New Goodies in SQL Server Denali Query Plans 0 None
2011-09-27 Additional Warnings in SQL Server Denali Query Plans 0 None
2010-03-31 Spring 2010 SQLConnections 2 None
2009-07-28 Latest column on data access and perf available 0 None
2009-07-20 Spatial Indexes and ANSI JOIN - ON syntax 0 None
2009-04-25 How to ensure your spatial index is being used 2 None
2008-09-19 SQL Server 2008 and TokenAndPermUserStore 2 None
2008-06-09 Performance features in SQL Server 2008 RC0 - Hashes for queries and query plans 0 None
2008-06-09 Performance features in SQL Server 2008 RC0 - Optimize for Adhoc Workloads 1 None
2008-05-30 Saving a roundtrip when inserting rows with filstream columns 0 None
2008-02-14 MHO: LINQ to SQL and Entity Framework: Panacea or evil incarnate? Part 2 2 None
2008-02-13 MHO: LINQ to SQL and Entity Framework: Panacea or evil incarnate? Part 1 3 None
2007-12-27 More hints available to plan guides in SQL Server 2008 0 None
2007-12-27 Plan freezing and other plan guide enhancements in SQL Server 2008 1 None
2006-12-29 Some questions and answers on plan guides 1 None
2006-10-28 Another behavior that follows schemas, query plan reuse 0 None
2006-06-26 Federation Enhancements/Changes in SQL Server 2005 0 None
2006-03-03 Move over developers! SQL Server XQuery is actually a DBA tool 0 None
2006-01-12 I hate to wait (doesn't everyone) 0 None
2005-02-16 Query plan guides in the SQL Server 2005 BOL 2 None

RSSPolicy-Based Management (7)

Date Title Comments Rating
2008-07-07 Using PowerShell to program SQL Server's Policies and Data Collection 0 None
2008-03-17 Programming Policy-Based Management with SMO - Part 6 - Categories, Subscriptions, Wrapup 0 None
2008-03-17 Programming Policy-Based Management with SMO - Part 5 - TargetSets and TargetSetLevels 0 None
2008-03-17 Programming Policy-Based Management with SMO - Part 4 - Introducing ObjectSets 0 None
2008-03-17 Programming Policy-Based Management with SMO - Part 3 - ExpressionNode and Policy 0 None
2008-03-17 Programming Policy-Based Management with SMO - Part 2 - Conditions 2 None
2008-03-17 Programming Policy-Based Management with SMO - Part 1 - Intro 0 None

RSSPowerShell (9)

Date Title Comments Rating
2010-11-10 There are some new PowerShell Cmdlets in Denali CTP1 0 None
2010-11-09 SQL Server Denali CTP1 - PowerShell and XEvents 0 None
2008-07-07 Programming SQLRegistration in the SQL Server PowerShell Provider 0 None
2008-07-07 Using PowerShell to program SQL Server's Policies and Data Collection 0 None
2008-06-09 Changes to the SQL Server PowerShell provider in RC0 0 None
2008-03-24 Accessing multiple servers with the SQL Server 2008 PowerShell provider 2 None
2007-10-31 Powershell and SQL Server's 2008 SMO - the reprise 0 None
2006-11-07 SMO and Powershell: Better Together, The Scripts 2 None
2006-11-06 SMO scripting at TechEd Europe 0 None

RSSQuery Notifications (12)

Date Title Comments Rating
2009-02-16 Watch the SqlNotificationInfo for query notifications 2 None
2007-01-30 The Internals and Troubleshooting whitepaper is available 0 None
2007-01-29 The first of my scaleout whitepapers is available 0 None
2006-11-13 One Service/Queue per Query Notification, please 0 None
2006-06-27 Pre-provisioning and SqlDependency 0 None
2006-01-30 About SCHEMAs and setting up Query Notifications 0 None
2005-11-10 What's the SqlDependency doing now? 0 None
2005-08-03 The demise of the dispatcher proc 0 None
2005-06-12 SqlNotificationRequest changes 0 None
2004-09-30 Query Notification Article on MSDN online 0 None
2004-08-01 On SELECT statements and SqlDependency 2 None
2004-07-28 Killing a pesky query notification subscription 0 None

RSSSecurity (34)

Date Title Comments Rating
2011-12-01 Auditing database-level objects in SQL Express 2012 0 None
2011-12-01 Using filtering and server audit specs to audit DB objects in SQL Server 2012 0 None
2011-12-01 Local Windows Groups for Service Accounts (almost) gone in SQL Server 2012 0 None
2011-07-20 A row-level and label security offering for SQL Server 0 None
2011-05-12 Some idiosyncrasies in SQL Server service and service user group names 0 None
2011-05-11 About SQL Server's usage of Service SIDs 0 None
2011-01-07 SQL Server Security Best Practices whitepaper update is live 0 None
2010-04-19 SQL Server security precon at TechEd 2010. 0 None
2009-07-24 At the user group...auditing and sys.fn_get_audit_file 0 None
2009-07-08 At the Portland SQL Server User Group this month 0 None
2009-01-14 SQL Server Compliance Portal is now live 1 None
2007-03-21 My SQL Server security best practices whitepaper is available 0 None
2006-09-16 SQL Server service accounts and privileges 0 None
2006-03-17 Technet Webcast Series For the ITPro - Part 2 4 None
2006-02-10 What does EXECUTE on an XML SCHEMA COLLECTION allow? 2 None
2006-02-08 Ownership chains and .NET procedure data access code 0 None
2005-11-21 Service broker and database master keys 6 None
2005-09-16 Security in SQL Server 2005 - unsafe assemblies in Sept CTP 3 None
2005-09-10 Security in SQL Server 2005 - "non-traditional" logins and users 0 None
2005-09-10 Security in SQL Server 2005 - execute as...with cookie 0 None
2005-09-05 Security in SQL Server 2005 - unsetapprole 0 None
2005-09-04 Security in SQL Server 2005 - Encryption 0 None
2005-09-04 Security in SQL Server 2005 - Logins 2 None
2005-08-03 Why my cat can't use a SQLCLR proc to read files 0 None
2005-07-06 Changing SQL Login password with the utilities 1 None
2005-06-03 How DO you change your SQL Login password? 0 None
2005-05-08 How to make a DBA smile 0 None
2005-01-19 Password policies on object passwords 3 None
2005-01-05 How do I see all the tables again? 2 None
2004-12-03 Schemas, Users, and Objects - III 4 None
2004-12-02 Schemas, Users, and Objects - II 0 None
2004-11-08 More on ownership chains 0 None
2004-11-05 Users, Schemas, Objects, and Owners 1 None
2004-10-20 Least privilege and HTTP endpoints 0 None

RSSService Broker (19)

Date Title Comments Rating
2010-02-05 A SQL Server 2008 R2 change for Service Broker 0 None
2008-10-30 Broker External Activator (and more) in latest SQL Server 2008 feature pack 0 None
2008-01-21 Service Broker in SQL Server 2008 - When sent message and receive message priority are different 0 None
2008-01-21 Service Broker in SQL Server 2008 - Priority By Contract 0 None
2007-11-20 Service Broker Priorities in SQL Server 2008 CTP5 - An overview 0 None
2007-06-23 A supported Service Broker external activator? 0 None
2007-01-30 The Internals and Troubleshooting whitepaper is available 0 None
2007-01-29 The first of my scaleout whitepapers is available 0 None
2006-08-15 Service Broker: When is DEFAULT not the default? 0 None
2006-08-06 Musings from the Immersion Event 0 None
2006-06-30 What's that stuff good for, anyway? 0 None
2006-04-14 Technet Webcast Series for the ITPro - Part 6 0 None
2005-11-21 Service broker and database master keys 6 None
2005-10-21 SQL Server 200x wish list - part 3, Service Broker 0 None
2005-03-23 Service Broker's new poison message handling 0 None
2005-03-23 New Service Broker features in the Feb CTP 0 None
2005-02-16 First release of Service Broker Explorer 2 None
2005-01-17 Service Broker object names are case sensitive 0 None
2004-11-05 .NET-based library for Service Broker 5 None

RSSSMO (10)

Date Title Comments Rating
2008-09-17 SQLCLR default procedure parameters scripts correctly by SSMS and SMO 2008 2 None
2008-03-17 Programming Policy-Based Management with SMO - Part 6 - Categories, Subscriptions, Wrapup 0 None
2008-03-17 Programming Policy-Based Management with SMO - Part 5 - TargetSets and TargetSetLevels 0 None
2008-03-17 Programming Policy-Based Management with SMO - Part 4 - Introducing ObjectSets 0 None
2008-03-17 Programming Policy-Based Management with SMO - Part 3 - ExpressionNode and Policy 0 None
2008-03-17 Programming Policy-Based Management with SMO - Part 2 - Conditions 2 None
2008-03-17 Programming Policy-Based Management with SMO - Part 1 - Intro 0 None
2006-11-07 SMO and Powershell: Better Together, The Scripts 2 None
2006-11-06 SMO scripting at TechEd Europe 0 None
2004-08-01 SMO and object-relational mapping 0 None

RSSSparse Columns (4)

Date Title Comments Rating
2008-04-08 Converting an EAV design to sparse columns and populating 1 None
2008-03-20 More about sparse columns and column_sets 1 None
2007-10-31 Sparse tables, sparse columns, and XML 1 None
2007-06-24 And the EAV winner is .... sparse columns 2 None

RSSSQL Azure Database (10)

Date Title Comments Rating
2011-12-11 SQL Azure Federations are here. At least on my server... 0 None
2011-10-25 New Wiki posting: SQL Server 2012 spatial features available in SQL Azure now! 0 None
2011-09-22 SQL Denali T-SQL features in SQL Azure now 0 None
2011-09-05 SQL Azure "version 11" arrives on my server 0 None
2011-07-06 A First Look at Data-Tier Applications 2.0 0 None
2011-06-01 Interesting SQL Azure change with next SR 0 None
2010-04-19 DAC support SQL Azure and vice-versa. It's live. 0 None
2010-02-11 Transactions, isolation, and SQL Azure 0 None
2010-01-06 SQL Azure: Adventures in connectivity 1 None
2010-01-06 The Azure cloud. It's live now. 0 None

RSSSQL Server 2005 (135)

Date Title Comments Rating
2012-01-15 SQL Server 2012 FileTables in T-SQL part 1: functions and methods 0 None
2007-02-25 SP2 must haves and SP2 compatibility 0 None
2007-02-05 SSIS Connectivity Whitepaper is Live on Microsoft website 1 None
2007-01-30 The Internals and Troubleshooting whitepaper is available 0 None
2006-12-29 Some questions and answers on plan guides 1 None
2006-12-29 Does sp_dropuser "do the right thing" with schemas? 0 None
2006-12-29 Using SQLCLR functions in indexed views 0 None
2006-11-13 One Service/Queue per Query Notification, please 0 None
2006-11-10 Just Add 50000 1 None
2006-11-07 SMO and Powershell: Better Together, The Scripts 2 None
2006-11-06 SMO scripting at TechEd Europe 0 None
2006-10-28 Another behavior that follows schemas, query plan reuse 0 None
2006-09-16 SQL Server service accounts and privileges 0 None
2006-09-01 Clustering Whitepaper for SQL Server 2005 available now 0 None
2006-07-18 SQL Server 2005: an overriding theme to the new features 0 None
2006-06-30 What's that stuff good for, anyway? 0 None
2006-06-26 Federation Enhancements/Changes in SQL Server 2005 0 None
2006-06-12 At TechEd: Event Notifications and scope creep 0 None
2006-06-06 DLINQ and FLWOR 0 None
2006-05-24 Finding data differences between SQL Server 2005 tables 2 None
2006-04-25 Using WMI and SQL Agent Alerts (part 2) 5 None
2006-04-25 Using WMI and SQL Agent Alerts (part 1) 0 None
2006-04-19 What's fixed in SP1? 0 None
2006-01-13 No HTTP endpoints on SQL Express 0 None
2006-01-12 I hate to wait (doesn't everyone) 0 None
2005-12-05 SOAP Protocol officially supported on SQL Server running on XPSP2 0 None
2005-12-01 Extracting the smdl for an already-deployed model 0 None
2005-11-21 Service broker and database master keys 6 None
2005-11-16 For all you XML-phobes that lke DDL triggers and Event Notifications 2 None
2005-11-15 Seeing errors in callers, SQLCLR error 6522, and T-SQL TRY-CATCH 0 None
2005-11-06 An interesting tidbit from the readme file 6 None
2005-11-05 Two cool add-ins for SSMS 3 None
2005-10-27 It's here 0 None
2005-10-21 SQL Server 200x wish list - wrapup and explanation 0 None
2005-10-21 SQL Server 200x wish list - part 5, SQLCLR 2 None
2005-10-21 SQL Server 200x wish list - part 4, T-SQL and Engine 2 None
2005-10-21 SQL Server 200x wish list - part 3, Service Broker 0 None
2005-10-21 SQL Server 200x wish list - part 2, XML and XQuery 0 None
2005-10-21 Hello again. and SQL Server 200x wish list part 1 3 None
2005-09-16 Security in SQL Server 2005 - unsafe assemblies in Sept CTP 3 None
2005-09-10 Security in SQL Server 2005 - "non-traditional" logins and users 0 None
2005-09-10 Security in SQL Server 2005 - execute as...with cookie 0 None
2005-09-05 Security in SQL Server 2005 - unsetapprole 0 None
2005-09-04 Security in SQL Server 2005 - Encryption 0 None
2005-09-04 Security in SQL Server 2005 - Logins 2 None
2005-08-22 IsNull != IS NULL, the reprise and the solution 0 None
2005-08-16 SqlTypes.SqlXml and impersonation 0 None
2005-08-13 Dude, where's my table? 0 None
2005-08-03 Why my cat can't use a SQLCLR proc to read files 0 None
2005-08-03 The demise of the dispatcher proc 0 None
2005-06-03 What's a truncation exception? 4 None
2005-06-03 How DO you change your SQL Login password? 0 None
2005-05-15 XML Schema for the truly lazy 0 None
2005-05-15 Combined provider: transactions and the return of 6522 1 None
2005-05-15 Go ahead, make a validation mistake... 1 None
2005-05-08 How to make a DBA smile 0 None
2005-05-08 Mailing the graphic showplan to a friend 0 None
2005-04-24 A first demo of the combined data provider 0 None
2005-03-24 What do you mean by "unsupported"? 0 None
2005-03-24 DROP ASSEMBLY change - just a convenience? 0 None
2005-03-23 SQL Server unified provider info on DataWorks' team blog 0 None
2005-03-23 Service Broker's new poison message handling 0 None
2005-03-23 New Service Broker features in the Feb CTP 0 None
2005-03-13 FOR XML...XMLSCHEMA and schema validation 2 None
2005-03-06 About the new SQLCLR TVFs 1 None
2005-02-16 First release of Service Broker Explorer 2 None
2005-02-16 Query plan guides in the SQL Server 2005 BOL 2 None
2005-02-16 UDM data access - is it all done with mirrors? 4 None
2005-02-11 Don't try this at home...yet 0 None
2005-02-09 System.Transactions, promotable transactions, and composition 2 None
2005-02-07 Tracking the pesky appdomain 0 None
2005-01-27 Fun with static XQuery evaluation - 4 - answers and wrapup 0 None
2005-01-26 Fun with static XQuery evaluation - 3 0 None
2005-01-26 Fun with static XQuery evaluation - 2 0 None
2005-01-26 Fun with static XQuery evaluation - 1 1 None
2005-01-19 Password policies on object passwords 3 None
2005-01-17 Service Broker object names are case sensitive 0 None
2005-01-16 XQuery and the useful XML index 0 None
2005-01-05 How do I see all the tables again? 2 None
2004-12-31 HTTP Endpoints and FORMAT=NONE 0 None
2004-12-28 New functions to use with try-catch 0 None
2004-12-19 Merging SqlClient and SqlServer providers 0 None
2004-12-06 SqlContext syntactic changes 0 None
2004-12-05 Another improvement in Dec CTP 0 None
2004-12-05 Using inheritence in SQLCLR UDTs 2 None
2004-12-03 A First Look at Dec CTP 3 None
2004-12-03 Schemas, Users, and Objects - III 4 None
2004-12-02 Schemas, Users, and Objects - II 0 None
2004-12-01 Schemas, Users, and Objects - I 1 None
2004-11-24 Some useful articles on MSDN online 1 None
2004-11-21 SQLCLR assembly owners and dependencies 0 None
2004-11-21 SQLCLR appdomain usage 0 None
2004-11-11 How do I get (N) rows from a SQL Server XQuery? 3 None
2004-11-10 What's my (Windows) identity? 0 None
2004-11-10 I have CREATE TABLE privilege but can't create tables 1 None
2004-11-08 More on ownership chains 0 None
2004-11-05 Users, Schemas, Objects, and Owners 1 None
2004-11-05 .NET-based library for Service Broker 5 None
2004-11-03 Formatting XML/XQuery in SQL, and caveats 2 None
2004-11-03 XQuery Schema Validation Clarification 0 None
2004-11-02 Early XQuery schema validation 1 None
2004-10-30 Thought on Microsoft client XQuery 2 None
2004-10-25 One more thing about 6522 error 0 None
2004-10-20 Intersect and Except....almost 0 None
2004-10-20 Least privilege and HTTP endpoints 0 None
2004-10-15 Error 6522:the reprise 0 None
2004-10-04 OLE DB/ODBC, SNAC, and the new "MAX" data types 0 None
2004-10-01 How SQLCLR works when its disabled 0 None
2004-09-28 Using FX assemblies outside of "the list" 0 None
2004-09-27 More about SQLCLR approved assemblies 0 None
2004-09-21 SQLCLR - List of approved framework class libraries 2 None
2004-09-10 Peaches en Regalia and XML Schemas 3 None
2004-09-10 What's all that stuff in sys.assembly_files? 1 None
2004-09-10 Office 2003 XML schemas and SQL Server 2005 0 None
2004-09-09 XML and SQL Server: stream, column, or string? 0 None
2004-09-06 HTTP Endpoints and Windows XP SP2 0 None
2004-09-05 Using the data() function in XQuery 2 None
2004-08-30 Checking for dangerous attributes at catalog time 0 None
2004-08-23 Using "ordinary" class libraries with SQL Server 2005 2 None
2004-08-22 SQLCLR Optimizations - 2 1 None
2004-08-20 Error 6522 and You 0 None
2004-08-20 SQLCLR Optimizations - 1 0 None
2004-08-18 HTTP endpoint session support in SQL Server 2005 0 None
2004-08-12 UDTs and UDAggs - Serialization and Construction 0 None
2004-08-12 SqlTypes.SqlXml and XmlReader.Create 0 None
2004-08-10 Fun with displaying UDTs in SSMS 3 None
2004-08-10 Where did the netlibs go? 1 None
2004-08-01 SMO and object-relational mapping 0 None
2004-08-01 On SELECT statements and SqlDependency 2 None
2004-07-28 Killing a pesky query notification subscription 0 None
2004-07-16 No more Microsoft.VisualStudio.DataTools.SqlAttributes.dll 0 None
2004-07-16 "Rite of passage" programs and SQLCLR 0 None
2004-07-14 About Web Services and "Schema + Any" 2 None
2004-07-06 Have a SNAC 1 None
2004-07-04 A Comment About Comments (XQuery Comments) 2 None

RSSSQL Server 2008 (133)

Date Title Comments Rating
2011-01-17 I'm at DevWeek London Mar14-18 0 None
2011-01-07 SQL Server Security Best Practices whitepaper update is live 0 None
2010-12-23 The interesting case of TVPs and plan compilation 0 None
2010-06-21 SQLCLR debugging and VS 2010 revisited 0 None
2010-05-02 Visual Studio 2010 and SQLCLR 2008 new features 1 None
2009-11-18 Guide to the Data Development Platform for .NET Developers whitepaper available 2 None
2009-08-21 How's about a map on your SSRS report? 0 None
2009-08-21 Microsoft Complex Event Processing platform is called StreamInsight 0 None
2009-07-08 At the ESRI user conference next week 0 None
2009-05-30 Book review - Beginning Spatial with SQL Server 2008 1 None
2009-05-01 Talking about spatial data on RunAs Radio 0 None
2009-05-01 Article about programming filestreams on MSDN 0 None
2009-04-25 How to ensure your spatial index is being used 2 None
2009-03-07 Spatial Indexes in SP1, almost no hints required 0 None
2009-01-28 My First MSDN column is live today 2 None
2009-01-14 SQL Server Compliance Portal is now live 1 None
2009-01-09 Spatial Methods: What's with the 'ST'? 2 None
2009-01-09 SQL Server Spatial: EMPTY vs. NULL 2 None
2008-12-18 Spatial Index Diagnostic Procs - The Rest of the Story 0 None
2008-12-17 Spatial Index Diagnostic Procs - How to specify query sample 0 None
2008-12-17 Spatial Index Diagnostic Procs - Filter Output 0 None
2008-12-17 Spatial Index Diagnostic Procs - Filters 0 None
2008-12-17 Spatial Index Diagnostic Procs - Intro 0 None
2008-11-07 Secrets, hints, and tips for SQL Server Extended Events 1 None
2008-11-04 Using the spatial index diagnostic stored procedures 1 None
2008-10-30 Broker External Activator (and more) in latest SQL Server 2008 feature pack 0 None
2008-10-29 November Road Trip 0 None
2008-09-19 SQL Server 2008 and TokenAndPermUserStore 2 None
2008-09-18 SQLCLR interop between SQL Server versions and Visual Studio multi-targeting 0 None
2008-09-17 SQLCLR default procedure parameters scripts correctly by SSMS and SMO 2008 2 None
2008-09-17 Speaking on Extended Events at SQL Server User Group 0 None
2008-09-06 On hinting spatial indexes and query complexity 1 None
2008-08-31 Visual Studio 2008 SP1 and SQL Server 2008 SQLCLR features 0 None
2008-08-31 A GUI visualizer/editor for SQL Server 2008 Extended Events 0 None
2008-08-20 A helper function for ring-orientation in the SQL Server 2008 geography data type 0 None
2008-08-20 Semantic (possibly breaking) change in SQLCLR TVFs 0 None
2008-07-28 Demos for Portland SQL Server user group talk on SQL Server spatial 1 None
2008-07-18 DDL appdomains appear in SQL Server log in SQL Server 2008 0 None
2008-07-17 I'm speaking at Portland SQL Server Users Group next Thursday 0 None
2008-07-07 Programming SQLRegistration in the SQL Server PowerShell Provider 0 None
2008-07-07 Using PowerShell to program SQL Server's Policies and Data Collection 0 None
2008-06-09 Changes to the SQL Server PowerShell provider in RC0 0 None
2008-06-09 Don't just read the Readme, read the Release Notes too 0 None
2008-06-09 Performance features in SQL Server 2008 RC0 - Hashes for queries and query plans 0 None
2008-06-09 Performance features in SQL Server 2008 RC0 - Optimize for Adhoc Workloads 1 None
2008-05-30 What's the DataSet doing in a trace of an Entity Framework program? 0 None
2008-05-30 Heading Out To TechEd 0 None
2008-05-30 Saving a roundtrip when inserting rows with filstream columns 0 None
2008-05-16 SQL Server 2008 Change Tracking and Sync Services ARE made for each other... in VS2008 SP1 0 None
2008-05-16 SQL Server 2008 data types in LINQ to SQL and EF, they (mostly) did it 1 None
2008-05-16 First blog entry in a month...what's up 0 None
2008-05-16 Trace Events in ADO.NET Entity Framework 2 None
2008-04-17 Heading off to SQLConnections 2 None
2008-04-08 Converting an EAV design to sparse columns and populating 1 None
2008-04-07 Getting an activity ID with Extended Events 0 None
2008-04-05 SqlClient, System.Transactions, SQL Server 2008, and MARS 0 None
2008-03-24 Accessing multiple servers with the SQL Server 2008 PowerShell provider 2 None
2008-03-20 More about sparse columns and column_sets 1 None
2008-03-17 Programming Policy-Based Management with SMO - Part 6 - Categories, Subscriptions, Wrapup 0 None
2008-03-17 Programming Policy-Based Management with SMO - Part 5 - TargetSets and TargetSetLevels 0 None
2008-03-17 Programming Policy-Based Management with SMO - Part 4 - Introducing ObjectSets 0 None
2008-03-17 Programming Policy-Based Management with SMO - Part 3 - ExpressionNode and Policy 0 None
2008-03-17 Programming Policy-Based Management with SMO - Part 2 - Conditions 2 None
2008-03-17 Programming Policy-Based Management with SMO - Part 1 - Intro 0 None
2008-03-07 MHO: LINQ to SQL and Entity Framework: Panacea or evil incarnate? Part 6 1 None
2008-03-06 MHO: LINQ to SQL and Entity Framework: Panacea or evil incarnate? Part 5 0 None
2008-03-06 MHO: LINQ to SQL and Entity Framework: Panacea or evil incarnate? Part 4 0 None
2008-03-03 Feature synergy in SQL Server 2008 1 None
2008-03-01 MHO: LINQ to SQL and Entity Framework: Panacea or evil incarnate? Part 3 3 None
2008-03-01 Installing .NET 3.5 on a SQL Server 2005 machine...be careful 1 None
2008-02-29 Ed's Blogging about SQL Server Spatial 0 None
2008-02-28 Configuring Filestream in CTP6 (its different) 1 None
2008-02-26 Lots of ORM and VS activity lately 1 None
2008-02-14 LINQ and LINQ to XML to appear in SQL Server 2008 SQLCLR approved list 0 None
2008-02-14 Learning LINQ, LINQ to SQL and eSQL 0 None
2008-02-14 MHO: LINQ to SQL and Entity Framework: Panacea or evil incarnate? Part 2 2 None
2008-02-13 MHO: LINQ to SQL and Entity Framework: Panacea or evil incarnate? Part 1 3 None
2008-02-13 Using SQL Server 2008 spatial and the Virtual Earth map control - 2 0 None
2008-02-13 Using SQL Server 2008 spatial and the Virtual Earth map control - 1 0 None
2008-02-12 HTTP Endpoints to be deprecated in SQL Server 2008 2 None
2008-02-12 The Morning After...SQL Server 2008 Jumpstart 1 None
2008-01-21 Composable DML and Composable Queries 0 None
2008-01-21 Service Broker in SQL Server 2008 - When sent message and receive message priority are different 0 None
2008-01-21 Service Broker in SQL Server 2008 - Priority By Contract 0 None
2007-12-27 Another use for SQL Server 2008 row constructors 2 None
2007-12-27 More hints available to plan guides in SQL Server 2008 0 None
2007-12-27 Using the OUTPUT clause results and INSERT-SELECT 0 None
2007-12-27 Plan freezing and other plan guide enhancements in SQL Server 2008 1 None
2007-12-20 SQL Server 2008 and ADO.NET Sync Services 1 None
2007-11-21 Large user-defined types and aggregates in SQL Server 2008 4 None
2007-11-20 SQL Server 2008: Ordered SQLCLR table-valued functions 0 None
2007-11-20 SQLCLR in SQL Server 2008: Multi-input user-defined aggregates 2 None
2007-11-20 What's new in SQL Server 2008 CTP5? Start by RTFR and RTFBOL 0 None
2007-11-20 Service Broker Priorities in SQL Server 2008 CTP5 - An overview 0 None
2007-11-20 SQL Server 2008 XML: Let there be 'let' 0 None
2007-11-15 ITForum - Day 5 - Powershell and SQL Server 2008 - the reprise 0 None
2007-11-10 Astoria... I learned something today... 0 None
2007-11-05 Mondial database for SQL Server 2008 1 None
2007-11-05 SQL Server 2008: Inheriting From a System Data Type? 0 None
2007-11-05 Wither CTP5? 0 None
2007-10-31 Powershell and SQL Server's 2008 SMO - the reprise 0 None
2007-10-31 Sparse tables, sparse columns, and XML 1 None
2007-10-25 Spatial Data, a niche or a tool for the masses? 2 None
2007-10-25 Using the SQL Server 2008 UDTs on clients 0 None
2007-09-21 Sync Services and SQL Server 2008 Change Tracking...a perfect match? 0 None
2007-09-20 An example of using ODBC and SQL Server 2008 table-valued parameters 4 None
2007-09-20 More info on SQLCE 3.5 beta and LINQ and EDM support 1 None
2007-09-19 SQL Server 2008 and .NET framework versions 1 None
2007-09-19 SQL Server 2008 and Clients - the long story 1 None
2007-09-19 SQLCLR and system functionality in SQL Server 2008 - part 3 0 None
2007-09-19 SQLCLR and system functionality in SQL Server 2008 - part 2 0 None
2007-09-19 SQLCLR and system functionality in SQL Server 2008 - part 1 0 None
2007-09-02 Using LINQ to SQL and EDM with SQL Server Compact Edition 3.5 1 None
2007-09-02 Using LINQ to SQL and EDM with SQL Server 2008 0 None
2007-08-28 .NET Nullable Types as SQLCLR parameters in SQL Server 2008 0 None
2007-08-20 XEvent: Some final followup questions (slight return...) 0 None
2007-08-20 Finishing XEvent package items, syntax, and semantics (moon turn the tides...) 0 None
2007-08-20 More about XEvent: actions and targets (still raining, still dreaming) 0 None
2007-08-19 More about SQL Server 2008 extended events: packages, events, and event sessions 0 None
2007-08-16 Making the XEvent ETW target run 0 None
2007-08-16 XEvent in SQL Server 2008 2 None
2007-08-02 New SQL Server 2008 Date/Time-related types and ADO.NET 1 None
2007-08-02 Katmai: Using Table-Valued Parameters with ADO.NET 1 None
2007-07-31 SQL Server 2008 July CTP - what's new (and what's gone) 0 None
2007-07-10 MERGE, JOINS, and determinism 0 None
2007-06-24 And the EAV winner is .... sparse columns 2 None
2007-06-24 ORDPATH, ORDPATH, everywhere 0 None
2007-06-23 SQL Server system data types implemented in .NET 0 None
2007-06-23 A supported Service Broker external activator? 0 None
2007-06-23 Table valued parameters in SQL Server 2008 4 None
2007-06-23 Grouping sets and TABLIX - made for each other? 0 None
2007-06-23 SQL Server 2008 new features - the list 4 None
2007-05-10 Katmai Sessions at TechEd 0 None

RSSSQL Server 2008 R2 (15)

Date Title Comments Rating
2011-07-05 Looking at Data-Tier Applications (DAC)? Look at version 1.1 0 None
2011-01-07 SQL Server Security Best Practices whitepaper update is live 0 None
2010-05-09 Getting error 2337 installing SQL Server on a VPC? 12 None
2010-05-04 Recompiling the StreamInsight CTP3 samples for 1.0 - Part 3 1 None
2010-05-04 Recompiling the StreamInsight CTP3 samples for 1.0 - Part 2 0 None
2010-05-04 Recompiling the StreamInsight CTP3 samples for 1.0 - Part 1 0 None
2010-05-04 StreamInsight 1.0 RTM: Installation and Samples 0 None
2010-02-05 A SQL Server 2008 R2 change for Service Broker 0 None
2010-02-04 Filestreams, Remote Blob Storage, and SQL Server 2008 R2 0 None
2010-02-04 Filestreams, transactions and SQL Server 2008 R2 0 None
2010-01-19 The StreamInsight Object Model and Observables 4 None
2010-01-19 Populating the ObjectModel with ImplicitServer 0 None
2010-01-19 Inside the StreamInsight Object Model - Metadata 0 None
2010-01-12 DACPAC and pre-SQL Server 2008 R2 versions 0 None
2010-01-12 Upgrading maps in BI Dev Studio projects 0 None

RSSSQL Server 2012 (56)

Date Title Comments Rating
2012-01-23 XEvents in SQL Server 2012: No more "lazy XML" in event harvesting scripts 0 None
2012-01-17 SQL Server 2012 FileTable and T-SQL on AlwaysOn secondary replicas 0 None
2012-01-17 SQL Server 2012 FileTables - AlwaysOn support and PathName() 0 None
2012-01-16 SQL Server 2012 FileTables in T-SQL part 3: hierarchyid methods 0 None
2012-01-16 SQL Server 2012 FileTables in T-SQL part 2: new rows 0 None
2011-12-01 Auditing database-level objects in SQL Express 2012 0 None
2011-12-01 Using filtering and server audit specs to audit DB objects in SQL Server 2012 0 None
2011-12-01 Local Windows Groups for Service Accounts (almost) gone in SQL Server 2012 0 None
2011-11-27 SQLCLR .NET 4-based behavior differences in SQL Server 2012 0 None
2011-11-27 Per-appdomain diagnostic info in SQL Server 2012 SQLCLR 0 None
2011-11-26 Native ODBC components in SQL Server 2012 SSIS 0 None
2011-11-21 Using SQL Server 2012 tools with older database versions 0 None
2011-11-03 SQL Server 2012 client features - ADO.NET 4.02 released 0 None
2011-09-30 Spatial index compression in SQL Server Denali 0 None
2011-09-27 LOTS of New Goodies in SQL Server Denali Query Plans 0 None
2011-09-27 Additional Warnings in SQL Server Denali Query Plans 0 None
2011-09-22 SQL Denali T-SQL features in SQL Azure now 0 None
2011-09-16 October's Developer Immersion Event adds Denali topics 0 None
2011-09-11 Contents and purpose of SemanticsDB in Denali 0 None
2011-09-10 Full-text query plans and stats in Denali 0 None
2011-09-06 What's this semantic search about anyhow? 0 None
2011-09-06 Of filetables, full-text and semantic search, and docidmaps 0 None
2011-09-05 SQL Azure "version 11" arrives on my server 0 None
2011-08-19 Denali memory allocator changes and SQLCLR 0 None
2011-08-19 Correlating client and server-side trace in SQL Server Denali 0 None
2011-08-18 Window clause, range specification, and missing values 0 None
2011-08-17 Remember: LAG function in SQL Server Denali uses rows 0 None
2011-08-01 Thanks to the Portland SQL Server User Group 0 None
2011-08-01 Denali window clause followup question 0 None
2011-08-01 An FAQ about the window clause in SQL Server Denali 0 None
2011-07-27 Hold it right there, you're a user-defined aggregate 0 None
2011-07-14 What exactly does PERCENTILE_CONT do, anyhow? 0 None
2011-07-12 Install me next... Denali CTP3 Books Online 0 None
2011-07-12 Interesting observations on a late-night CTP3 install 0 None
2011-07-08 Speaking at Portland SQL Server User Group this month 0 None
2011-07-06 A First Look at Data-Tier Applications 2.0 0 None
2011-02-07 Visualizing the new Denali curve spatial types 0 None
2011-01-24 Using the Denali spatial aggregates on the client 0 None
2011-01-23 SQL Server Denali Fulltext Properties - Where? 0 None
2011-01-23 Yet another semicolon rule in SQL Server Denali 0 None
2011-01-19 Speaking at the NYC SQL Server user group next Thursday 0 None
2011-01-05 What's new in Denali CTP1. And what isn't in CTP1. 0 None
2011-01-03 The nearest neighbor optimization in SQL Server Denali 0 None
2010-12-29 The "other fullglobe feature" in SQL Server Denali 0 None
2010-12-29 New curve types in SQL Server Denali are now in OGC spec 0 None
2010-12-29 Measuring the earth with SQL Server Denali 0 None
2010-12-23 SQL Server Denali - the new autogrid spatial index 0 None
2010-12-22 SQL Server Denali - FTS on properties, the cheap demo 0 None
2010-12-22 SQL Server Denali - FTS on properties, the motivation 0 None
2010-11-13 TechEd 2010 Europe; Denali at TechEd 0 None
2010-11-10 There are some new PowerShell Cmdlets in Denali CTP1 0 None
2010-11-09 New spatial query hint when using indexing 0 None
2010-11-09 My favorite feature in Denali. Well one of... 0 None
2010-11-09 Using SQL Server Denali Full-Text Search With Extended Properties 0 None
2010-11-09 Repost/Revision Updated serialization formats for SQL Server spatial types 0 None
2010-11-09 SQL Server Denali CTP1 - PowerShell and XEvents 0 None

RSSSQL Server Compact Edition (7)

Date Title Comments Rating
2007-09-21 Sync Services and SQL Server 2008 Change Tracking...a perfect match? 0 None
2007-09-20 More info on SQLCE 3.5 beta and LINQ and EDM support 1 None
2007-09-02 Using LINQ to SQL and EDM with SQL Server Compact Edition 3.5 1 None
2007-04-21 SQL Server Compact Edition - newest stuff - SQLCE and entities 0 None
2007-04-21 SQL Server Compact Edition - newest stuff - sync services 0 None
2007-04-21 SQL Server Compact Edition - additional pieces 0 None
2007-04-21 SQL Server Compact Edition - versions and installed locations 0 None

RSSSQL Server Schemas (9)

Date Title Comments Rating
2006-12-29 Does sp_dropuser "do the right thing" with schemas? 0 None
2006-10-28 Another behavior that follows schemas, query plan reuse 0 None
2006-01-30 About SCHEMAs and setting up Query Notifications 0 None
2005-08-13 Dude, where's my table? 0 None
2004-12-03 Schemas, Users, and Objects - III 4 None
2004-12-02 Schemas, Users, and Objects - II 0 None
2004-12-01 Schemas, Users, and Objects - I 1 None
2004-11-10 I have CREATE TABLE privilege but can't create tables 1 None
2004-11-05 Users, Schemas, Objects, and Owners 1 None
Date Title Comments Rating
2011-09-11 Contents and purpose of SemanticsDB in Denali 0 None
2011-09-06 What's this semantic search about anyhow? 0 None
2011-09-06 Of filetables, full-text and semantic search, and docidmaps 0 None

RSSSQL Server Spatial (44)

Date Title Comments Rating
2011-10-25 New Wiki posting: SQL Server 2012 spatial features available in SQL Azure now! 0 None
2011-09-30 Spatial index compression in SQL Server Denali 0 None
2011-09-10 A quick set of SQLCLR spatial decomposition functions 0 None
2011-09-05 SQL Azure "version 11" arrives on my server 0 None
2011-06-01 Interesting SQL Azure change with next SR 0 None
2011-02-07 Visualizing the new Denali curve spatial types 0 None
2011-01-24 Using the Denali spatial aggregates on the client 0 None
2011-01-03 The nearest neighbor optimization in SQL Server Denali 0 None
2010-12-29 The "other fullglobe feature" in SQL Server Denali 0 None
2010-12-29 New curve types in SQL Server Denali are now in OGC spec 0 None
2010-12-29 Measuring the earth with SQL Server Denali 0 None
2010-12-23 SQL Server Denali - the new autogrid spatial index 0 None
2010-12-07 Loading spatial data into SQL Server - SAFE Software Webinar 0 None
2010-11-09 New spatial query hint when using indexing 0 None
2010-11-09 Repost/Revision Updated serialization formats for SQL Server spatial types 0 None
2010-04-19 Geocoding and AdventureWorks 2008 data 0 None
2010-02-28 Trouble seeing "Birth of Venus" image in the SSMS spatial results tab? 2 None
2009-11-23 Two of the coolest demos in the last month 0 None
2009-11-18 My MSDN Column on Visualizing Spatial Data is available 0 None
2009-09-22 Be careful with EMPTY/NULL values and spatial indexes 0 None
2009-08-21 How's about a map on your SSRS report? 0 None
2009-08-07 Make KML documents from SQL Server's geography data type 0 None
2009-08-03 MapPoint Add-In For SQL Server Spatial shipped 0 None
2009-07-20 Spatial Indexes and ANSI JOIN - ON syntax 0 None
2009-07-19 ESRI User Conference and MapIt 0 None
2009-07-08 At the ESRI user conference next week 0 None
2009-05-30 Book review - Beginning Spatial with SQL Server 2008 1 None
2009-05-01 Talking about spatial data on RunAs Radio 0 None
2009-04-25 How to ensure your spatial index is being used 2 None
2009-03-07 Spatial Indexes in SP1, almost no hints required 0 None
2009-01-28 My First MSDN column is live today 2 None
2009-01-09 Spatial Methods: What's with the 'ST'? 2 None
2009-01-09 SQL Server Spatial: EMPTY vs. NULL 2 None
2008-12-18 Spatial Index Diagnostic Procs - The Rest of the Story 0 None
2008-12-17 Spatial Index Diagnostic Procs - How to specify query sample 0 None
2008-12-17 Spatial Index Diagnostic Procs - Filter Output 0 None
2008-12-17 Spatial Index Diagnostic Procs - Filters 0 None
2008-12-17 Spatial Index Diagnostic Procs - Intro 0 None
2008-11-04 Using the spatial index diagnostic stored procedures 1 None
2008-09-06 On hinting spatial indexes and query complexity 1 None
2008-08-20 A helper function for ring-orientation in the SQL Server 2008 geography data type 0 None
2008-02-13 Using SQL Server 2008 spatial and the Virtual Earth map control - 2 0 None
2008-02-13 Using SQL Server 2008 spatial and the Virtual Earth map control - 1 0 None
2007-10-25 Spatial Data, a niche or a tool for the masses? 2 None

RSSSQL Server XML (39)

Date Title Comments Rating
2012-01-23 XEvents in SQL Server 2012: No more "lazy XML" in event harvesting scripts 0 None
2007-11-20 SQL Server 2008 XML: Let there be 'let' 0 None
2007-01-23 XQuery 1.0 et al are now W3C recommendations 0 None
2006-06-30 What's that stuff good for, anyway? 0 None
2006-06-06 DLINQ and FLWOR 0 None
2006-03-03 Move over developers! SQL Server XQuery is actually a DBA tool 0 None
2006-03-03 XQuery methods and determinism 0 None
2006-02-10 What does EXECUTE on an XML SCHEMA COLLECTION allow? 2 None
2005-11-16 For all you XML-phobes that lke DDL triggers and Event Notifications 2 None
2005-10-21 SQL Server 200x wish list - part 2, XML and XQuery 0 None
2005-08-16 SqlTypes.SqlXml and impersonation 0 None
2005-05-15 XML Schema for the truly lazy 0 None
2005-05-15 Go ahead, make a validation mistake... 1 None
2005-05-08 Mailing the graphic showplan to a friend 0 None
2005-03-13 FOR XML...XMLSCHEMA and schema validation 2 None
2005-01-27 Fun with static XQuery evaluation - 4 - answers and wrapup 0 None
2005-01-26 Fun with static XQuery evaluation - 3 0 None
2005-01-26 Fun with static XQuery evaluation - 2 0 None
2005-01-26 Fun with static XQuery evaluation - 1 1 None
2005-01-16 XQuery and the useful XML index 0 None
2004-12-31 HTTP Endpoints and FORMAT=NONE 0 None
2004-12-05 Another improvement in Dec CTP 0 None
2004-12-03 A First Look at Dec CTP 3 None
2004-11-30 More ADO.NET 2.0 and XML data type 0 None
2004-11-11 How do I get (N) rows from a SQL Server XQuery? 3 None
2004-11-03 Formatting XML/XQuery in SQL, and caveats 2 None
2004-11-03 XQuery Schema Validation Clarification 0 None
2004-11-02 Early XQuery schema validation 1 None
2004-10-30 Thought on Microsoft client XQuery 2 None
2004-10-20 Least privilege and HTTP endpoints 0 None
2004-09-10 Peaches en Regalia and XML Schemas 3 None
2004-09-10 Office 2003 XML schemas and SQL Server 2005 0 None
2004-09-09 XML and SQL Server: stream, column, or string? 0 None
2004-09-06 HTTP Endpoints and Windows XP SP2 0 None
2004-09-05 Using the data() function in XQuery 2 None
2004-08-18 HTTP endpoint session support in SQL Server 2005 0 None
2004-08-12 SqlTypes.SqlXml and XmlReader.Create 0 None
2004-07-14 About Web Services and "Schema + Any" 2 None
2004-07-04 A Comment About Comments (XQuery Comments) 2 None

RSSSQLCLR (85)

Date Title Comments Rating
2011-11-27 SQLCLR .NET 4-based behavior differences in SQL Server 2012 0 None
2011-11-27 Per-appdomain diagnostic info in SQL Server 2012 SQLCLR 0 None
2011-09-10 A quick set of SQLCLR spatial decomposition functions 0 None
2011-08-30 SQLCLR-based libraries available from TotallySQL 0 None
2011-08-19 Denali memory allocator changes and SQLCLR 0 None
2011-07-27 Hold it right there, you're a user-defined aggregate 0 None
2011-05-20 What appears in DMVs for SQLCLR? 0 None
2010-06-21 SQLCLR debugging and VS 2010 revisited 0 None
2010-05-02 Visual Studio 2010 and SQLCLR 2008 new features 1 None
2009-09-01 Temporary table lifetime and SQLCLR stored procedures 0 None
2009-05-01 On SQL Server and .NET 4.0 2 None
2008-09-18 SQLCLR interop between SQL Server versions and Visual Studio multi-targeting 0 None
2008-09-17 SQLCLR default procedure parameters scripts correctly by SSMS and SMO 2008 2 None
2008-08-31 Visual Studio 2008 SP1 and SQL Server 2008 SQLCLR features 0 None
2008-08-20 A helper function for ring-orientation in the SQL Server 2008 geography data type 0 None
2008-08-20 Semantic (possibly breaking) change in SQLCLR TVFs 0 None
2008-07-19 How do you shutdown a running SQLCLR appdomain? 0 None
2008-07-18 DDL appdomains appear in SQL Server log in SQL Server 2008 0 None
2008-03-01 Installing .NET 3.5 on a SQL Server 2005 machine...be careful 1 None
2008-02-14 LINQ and LINQ to XML to appear in SQL Server 2008 SQLCLR approved list 0 None
2007-11-21 Large user-defined types and aggregates in SQL Server 2008 4 None
2007-11-20 SQL Server 2008: Ordered SQLCLR table-valued functions 0 None
2007-11-20 SQLCLR in SQL Server 2008: Multi-input user-defined aggregates 2 None
2007-10-25 Using the SQL Server 2008 UDTs on clients 0 None
2007-09-19 SQL Server 2008 and .NET framework versions 1 None
2007-09-19 SQLCLR and system functionality in SQL Server 2008 - part 3 0 None
2007-09-19 SQLCLR and system functionality in SQL Server 2008 - part 2 0 None
2007-09-19 SQLCLR and system functionality in SQL Server 2008 - part 1 0 None
2007-08-28 .NET Nullable Types as SQLCLR parameters in SQL Server 2008 0 None
2007-06-24 ORDPATH, ORDPATH, everywhere 0 None
2007-06-23 SQL Server system data types implemented in .NET 0 None
2007-03-13 Two things you can't do in SQLCLR 3 None
2006-12-29 Using SQLCLR functions in indexed views 0 None
2006-10-20 LINQ/EDM in SQLCLR? 1 None
2006-06-30 What's that stuff good for, anyway? 0 None
2006-05-29 Multiple synthesized rowsets with SqlDataRecord 0 None
2006-05-27 New "SQLCLR-approved" assembly in SP1 1 None
2006-05-25 SQLCLR supports assembly versioning...NOT 0 None
2006-03-23 Poking at SQLCLR 0 None
2006-03-12 More info about System.Configuration 0 None
2006-02-10 New samples; Calling Oracle from SQLCLR 1 None
2006-02-09 Using System.Configuration.dll in .NET sprocs and UDFs 0 None
2006-02-08 Ownership chains and .NET procedure data access code 0 None
2005-11-15 Seeing errors in callers, SQLCLR error 6522, and T-SQL TRY-CATCH 0 None
2005-10-21 SQL Server 200x wish list - part 5, SQLCLR 2 None
2005-10-21 Hello again. and SQL Server 200x wish list part 1 3 None
2005-09-22 What's that source code doin' in there? 0 None
2005-09-16 Security in SQL Server 2005 - unsafe assemblies in Sept CTP 3 None
2005-08-24 SQLCLR, transaction nesting, and TransactionScope 0 None
2005-08-22 IsNull != IS NULL, the reprise and the solution 0 None
2005-08-16 SqlTypes.SqlXml and impersonation 0 None
2005-08-03 Why my cat can't use a SQLCLR proc to read files 0 None
2005-06-03 What's a truncation exception? 4 None
2005-05-15 Combined provider: transactions and the return of 6522 1 None
2005-04-24 A first demo of the combined data provider 0 None
2005-03-24 What do you mean by "unsupported"? 0 None
2005-03-24 DROP ASSEMBLY change - just a convenience? 0 None
2005-03-23 SQL Server unified provider info on DataWorks' team blog 0 None
2005-03-06 About the new SQLCLR TVFs 1 None
2005-02-11 Don't try this at home...yet 0 None
2005-02-07 Tracking the pesky appdomain 0 None
2004-12-19 Merging SqlClient and SqlServer providers 0 None
2004-12-06 SqlContext syntactic changes 0 None
2004-12-05 Using inheritence in SQLCLR UDTs 2 None
2004-11-24 Some useful articles on MSDN online 1 None
2004-11-21 SQLCLR assembly owners and dependencies 0 None
2004-11-21 SQLCLR appdomain usage 0 None
2004-11-10 What's my (Windows) identity? 0 None
2004-11-08 More on ownership chains 0 None
2004-10-25 One more thing about 6522 error 0 None
2004-10-15 Error 6522:the reprise 0 None
2004-10-01 How SQLCLR works when its disabled 0 None
2004-09-28 Using FX assemblies outside of "the list" 0 None
2004-09-27 More about SQLCLR approved assemblies 0 None
2004-09-21 SQLCLR - List of approved framework class libraries 2 None
2004-09-10 What's all that stuff in sys.assembly_files? 1 None
2004-08-30 Checking for dangerous attributes at catalog time 0 None
2004-08-23 Using "ordinary" class libraries with SQL Server 2005 2 None
2004-08-22 SQLCLR Optimizations - 2 1 None
2004-08-20 Error 6522 and You 0 None
2004-08-20 SQLCLR Optimizations - 1 0 None
2004-08-12 UDTs and UDAggs - Serialization and Construction 0 None
2004-08-10 Fun with displaying UDTs in SSMS 3 None
2004-07-16 No more Microsoft.VisualStudio.DataTools.SqlAttributes.dll 0 None
2004-07-16 "Rite of passage" programs and SQLCLR 0 None

RSSStreamInsight (8)

Date Title Comments Rating
2010-08-25 Running the StreamInsightHost as a console app 0 None
2010-05-04 Recompiling the StreamInsight CTP3 samples for 1.0 - Part 3 1 None
2010-05-04 Recompiling the StreamInsight CTP3 samples for 1.0 - Part 2 0 None
2010-05-04 Recompiling the StreamInsight CTP3 samples for 1.0 - Part 1 0 None
2010-05-04 StreamInsight 1.0 RTM: Installation and Samples 0 None
2010-01-19 The StreamInsight Object Model and Observables 4 None
2010-01-19 Populating the ObjectModel with ImplicitServer 0 None
2010-01-19 Inside the StreamInsight Object Model - Metadata 0 None

RSSTransact-SQL (32)

Date Title Comments Rating
2011-09-22 SQL Denali T-SQL features in SQL Azure now 0 None
2011-09-05 SQL Azure "version 11" arrives on my server 0 None
2011-08-18 Window clause, range specification, and missing values 0 None
2011-08-17 Remember: LAG function in SQL Server Denali uses rows 0 None
2011-08-01 Denali window clause followup question 0 None
2011-08-01 An FAQ about the window clause in SQL Server Denali 0 None
2011-07-14 What exactly does PERCENTILE_CONT do, anyhow? 0 None
2008-01-21 Composable DML and Composable Queries 0 None
2007-12-27 Another use for SQL Server 2008 row constructors 2 None
2007-12-27 Using the OUTPUT clause results and INSERT-SELECT 0 None
2007-08-02 New SQL Server 2008 Date/Time-related types and ADO.NET 1 None
2007-08-02 Katmai: Using Table-Valued Parameters with ADO.NET 1 None
2007-07-10 MERGE, JOINS, and determinism 0 None
2007-06-24 ORDPATH, ORDPATH, everywhere 0 None
2007-06-23 SQL Server system data types implemented in .NET 0 None
2007-06-23 Table valued parameters in SQL Server 2008 4 None
2007-06-23 Grouping sets and TABLIX - made for each other? 0 None
2006-12-29 Does sp_dropuser "do the right thing" with schemas? 0 None
2006-11-10 Just Add 50000 1 None
2006-06-30 What's that stuff good for, anyway? 0 None
2005-11-15 Seeing errors in callers, SQLCLR error 6522, and T-SQL TRY-CATCH 0 None
2005-10-21 SQL Server 200x wish list - part 4, T-SQL and Engine 2 None
2005-10-21 Hello again. and SQL Server 200x wish list part 1 3 None
2005-08-22 IsNull != IS NULL, the reprise and the solution 0 None
2005-06-03 What's a truncation exception? 4 None
2005-05-15 Combined provider: transactions and the return of 6522 1 None
2004-12-28 New functions to use with try-catch 0 None
2004-12-03 A First Look at Dec CTP 3 None
2004-10-20 Intersect and Except....almost 0 None
2004-10-15 Error 6522:the reprise 0 None
2004-10-04 OLE DB/ODBC, SNAC, and the new "MAX" data types 0 None
2004-08-20 Error 6522 and You 0 None

RSSUncategorized (129)

Date Title Comments Rating
2012-01-11 At Tech Days in The Netherlands next month 0 None
2012-01-08 Expertseminarium in April: Performance for Developers in SQL Server 2012 0 None
2012-01-04 SQLskills Developer Immersion Events this year 0 None
2011-12-02 Four SQLskills Immersion Events coming to Chicago in April 2012 0 None
2011-07-13 SQLskills Developer-focused Immersion Event in October 0 None
2011-04-04 I'm speaking at DevDays NL at end of April 0 None
2011-03-07 Less than a week until DevWeek London 0 None
2011-03-03 My seminar in Stockholm is just a week away 0 None
2011-01-05 Upcoming seminar: Coding SQL Server For High Performance 0 None
2010-11-14 Changes to the Microsoft Certified Master: SQL Server program 0 None
2010-10-06 TechEd Berlin 2010 - I'll be there 0 None
2010-09-29 Day of PowerShell/SQL and more at SQL Server Connections 0 None
2010-09-20 SQL Server and XML on Pluralsight On-Demand 0 None
2010-09-20 Speaking at Portland (Oregon) SQL Server Users Group on Thursday 0 None
2010-06-16 Thanks for a great TechEd! 0 None
2010-04-19 Thanks for a great SQLConnections! 2 None
2009-11-23 And the secret word for tonight is... 0 None
2009-11-18 TechEd Europe demos posted to website 0 None
2009-11-09 SQL Server 2008 R2 CTP3 arrives (with MDS) 0 None
2009-11-09 TechEd Europe Day 1 2 None
2009-09-16 See you in Berlin at TechEd 2009 Europe 1 None
2009-09-10 A "What's New" at the Portland SQL Server User Group 0 None
2009-07-19 Thanks for the nice blog comments I've been remiss in approving 0 None
2009-03-16 Things you now know 0 None
2009-02-16 SQLConnections: I really AM doing a day of spatial data 0 None
2009-01-20 Added categories to a lot of old blog entries 0 None
2009-01-17 About comments on this blog 2 None
2008-11-23 Post Conference(s) 3 None
2007-11-13 ITForum - Days 2 and 3 0 None
2007-11-12 ITForum - Day 1 in Barcelona 0 None
2007-11-10 TechEd Barcelona Wrapup...and on to TechEd/ITForum 1 None
2007-11-08 Barcelona Day 4 - Transactions/Isolation and OLE DB v ODBC 0 None
2007-11-06 Barcelona Day 3 - TSQL Query Plans and XML in SQL Server 0 None
2007-11-06 Barcelona Day 2 - Powershell/SMO and SQLCLR 0 None
2007-11-04 Welcome to Barcelona! TechEd and Best Practices 0 None
2007-08-28 At TechEd Hong Kong: precon and day 1 1 None
2007-07-31 Two friends of mine (and SQL geeks) tie the knot 0 None
2007-07-17 Some book reviews 2 None
2007-07-17 TechEd 2007 in Hong Kong - I'll be there 0 None
2007-05-06 DevDays Amsterdam SQL Server Postconference event 1 None
2007-05-06 TechEd 2007 - I'll be there 0 None
2007-04-18 Welcome, AdventureWorks Light 1 None
2007-04-01 Back home from Belgium Developer and ITPro days 0 None
2007-03-18 A bonus talk for Belgian SQL Server user group next week 1 None
2007-02-25 DevDays in Ghent - see you there 1 None
2007-01-30 The "5 things..." blog chain letter 0 None
2007-01-10 A Draft of my SSIS Connectivity Whitepaper is available 6 None
2006-11-15 It's sunny in Barcelona 0 None
2006-11-13 Don't be Afraid Of ... at ITForum 0 None
2006-10-20 Barcelona, here I come 0 None
2006-09-14 SQL Server 2005 - Value For Every Business Demos 0 None
2006-08-24 Next stop, Hong Kong... 1 None
2006-08-15 ADO.NET vNext CTP is available 2 None
2006-08-15 Our new book, available cheap 0 None
2006-08-08 Non-intuitive test data leads to proper constraints? 0 None
2006-08-06 More of our book reviewers are blogging! 0 None
2006-07-06 Commoditization of a technology deployment pattern 0 None
2006-07-05 Pondering scale-out 0 None
2006-07-03 Liz is blogging! 0 None
2006-07-03 He's baaack. Public classes at SQLskills 0 None
2006-06-18 TechEd2006 Wrapup 1 None
2006-06-15 TechEd2006 - Content links and plan guide presentation 0 None
2006-06-14 At TechEd: Errors and Handling Errors; DLINQ interest 0 None
2006-06-12 SQLskills welcomes Elizabeth Vitt 0 None
2006-06-09 About my TechEd activities 0 None
2006-04-26 Our new book has arrived 6 None
2006-04-25 TechEd Boston 2006...I'll be there 1 None
2006-04-19 And I'm on DNR-TV tomorrow 2 None
2006-04-16 I'm on DNR next week 2 None
2006-03-22 I'm speaking tomorrow night at home 1 None
2006-03-06 At Dutch Devdays 4 None
2006-01-21 DevDays Netherlands...I'll be there 4 None
2006-01-16 Sample chapter requires latest version of Acrobat reader 0 None
2006-01-09 Sample chapter of SQL Server 2005 Programmer's Guide available 9 None
2006-01-03 Still Alive and Well 4 None
2005-11-02 Correction...I did meet the man 0 None
2005-11-02 My Podcast with Wally McClure is available 0 None
2005-10-01 Fireworks in Hong Kong 2 None
2005-10-01 Goodbye Dallas, Hello Hong Kong 0 None
2005-09-25 Made it to SQLPass conference this year, whew 0 None
2005-09-10 Blog reading and "continued here" 5 None
2005-09-02 I'll be at PDC...not 0 None
2005-09-02 SQL Server 2005 mailer feature uses Service Broker 4 None
2005-08-24 I'll be on a SQL Server 2005/Visual Studio 2005 Panel 2 None
2005-08-24 We win SQL Server Magazine Readers' Choice 3 None
2005-08-11 What are the unsolved problems 0 None
2005-08-01 SQL Server book-of-the-month club pick 2 None
2005-08-01 It's already tomorrow in Australia 0 None
2005-08-01 I'm not sysadmin, I just play one on TV 0 None
2005-08-01 Combined provider status 0 None
2005-08-01 The Times They Are A-Changin' 3 None
2005-07-05 I'm Database Geek of the Week (last week) 0 None
2005-07-05 It's been a whole year 1 None
2005-07-03 Au revoir, Ascend 3 None
2005-06-12 Outstanding Service Broker book 0 None
2005-06-12 Back From TechEd 0 None
2005-05-26 They did it! Relative paths in SSMS projects 0 None
2005-05-22 A Second Look at SQL Server 2005 for Developers 2 None
2005-05-22 Dan Sullivan is blogging 0 None
2005-05-08 TechEd 2005 - I'll be there too 2 None
2005-05-08 SQLPass - I'll be there 0 None
2005-04-25 What happened to SNAC tracing in beta2? 0 None
2005-03-05 Where 'ya been dude? 2 None
2005-02-07 Back home again 0 None
2004-12-23 Autocomplete in VS 2005 2 None
2004-12-19 Night of the Service Broker...and Announcement 0 None
2004-12-03 SQL Server December CTP available 4 None
2004-11-30 Home again 2 None
2004-11-15 AirplaneLand 0 None
2004-11-11 An excellent SQLNS book 0 None
2004-11-10 Don't you database people have any standards? 0 None
2004-11-02 Slides, articles, and shameless self-promotion 0 None
2004-10-30 Back From Win-Dev; what year is it? 0 None
2004-10-25 I'm at WinDev 0 None
2004-10-01 Why programmers shouldn't be marketers 2 None
2004-09-27 I'm at SQLPass conference...not 0 None
2004-09-12 On the road again 1 None
2004-09-12 I meet Angel Saenz-Badillos 0 None
2004-09-05 Hello, Virtual Server 0 None
2004-08-29 Good XQuery Books 0 None
2004-08-25 At the airlift 0 None
2004-08-09 How do you refer to ...? 0 None
2004-07-27 My 20 favorite beta 2 developer features so far 0 None
2004-07-26 Visual Studio Beta 1 and sqlaccess.dll 0 None
2004-07-26 Beta 2 available. Some first observations. 2 None
2004-07-16 COmega and rite of passage program 0 None
2004-07-13 Not DataSet, Dataset! 2 None
2004-07-04 My whereabouts 0 None
2004-07-01 Out of hiding 1 None

Total

564 posts
373 comments
0 raters

Theme design by Nukeation based on Jelle Druyts