Welcome to Romanian SQL Server User Group Sign in | Join | Help

aprilie 2008 - Posts

Security in a nutshell

Here's an attempt to succintly describe why achieving security is difficult: The engineer wants to implement a program P that allows users to perform action A. The hacker looks at program P and wonders how can he use it to perform actions other than A. Read More...
Posted 23 aprilie 2008 22:48 from Laurentiu Cristofor's blog | (Comments Off)
Filed under:

Heading off to SQLConnections

I'm heading off to SQLConnections in Orlando early tomorrow morning. I'll see starting with a preconference "Day of SQL Server 2008 for Developers" and covering, well, every new feature that could interest a developer. I'll also being doing a series of Read More...
Posted 17 aprilie 2008 16:42 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

SQLPASS 2008 Slides and Demo

I have uploaded here the slides I presented today at SQLPASS on Service Broker Administration, Monitoring and Troubleshooting: SQLPASS 2008 Slides Read More...
Posted 15 aprilie 2008 23:39 from rusanu.com | (Comments Off)
Filed under:

Service Broker Administration, Monitoring and Troubleshooting

I’m about to embark on my flight to Germany for this year PASS conference. My 2008 session is Service Broker Administration, Monitoring and Troubleshooting and is scheduled on Tuesday April 15 at 10:45, see http://www.european-pass-conference.com/agenda.aspx Read More...
Posted 13 aprilie 2008 21:03 from rusanu.com | (Comments Off)
Filed under:

DMX Pitfalls : Natural Prediction Joins

Some very interesting, although time-consuming project kept me away from posting in the last month. Mea maxima culpa, I will try to catch up and put some new and interesting content here more often. Recently, trying to make sense of some prediction results, Read More...
Posted 11 aprilie 2008 09:04 from DM(X) | (Comments Off)
Filed under:

Chained Updates

One of the interesting features of the OUTPUT clauses introduced in SQL Server 2005 is that one can actualy chain DML statements into one complex statement that operates updates on several tables at once. Say we have a table with customer data and a process Read More...
Posted 9 aprilie 2008 23:59 from rusanu.com | (Comments Off)
Filed under:

Converting an EAV design to sparse columns and populating

One of the uses for sparse columns will likely be replacing entity-attribute-value designs. In an EAV design, the "sparse attribute" values are represented by a separate table. The attribute value can either be declared as (n)varchar or sql_variant. An Read More...
Posted 8 aprilie 2008 19:50 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Getting an activity ID with Extended Events

It's easier than you'd think... When you use the SQL Server 2008 CREATE EVENT SESSION DDL statement with extended events, you specify: Events to be captured (e.g. sqlserver.error_reported) Actions to be fired to add more information (e.g. sqlserver.sql_text) Read More...
Posted 7 aprilie 2008 20:54 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

SqlClient, System.Transactions, SQL Server 2008, and MARS

It appears that there are some changes in .NET 3.5 System.Transactions (or System.Transactions.dll and System.Data.dll version 2.0.50727.1433 if you're looking at assembly versions). Florin Lazar blogs about a change to the syntax here . And Alazel Acheson Read More...
Posted 6 aprilie 2008 00:14 from Bob Beauchemin's Blog | (Comments Off)
Filed under: