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

Browse by Tags

All Tags » Announcements   (RSS)

Online Index Operations for indexes containing LOB columns

SQL Server supports online index and table rebuild operations which allow for maintenance operations to occur w/o significant downtime. While a table is being rebuild, or a new index is being built on it, the table is fully utilizable. It can be queried Read More...
Posted 6 august 2011 00:26 from rusanu.com | (Comments Off)

Online non-NULL with values column add in SQL Server 11

Prior to SQL Server 11 when you add a new non-NULLable column with default values to an existing table a size-of data operation occurs: every row in the table is updated to add the default value of the new column. For small tables this is insignificant, Read More...
Posted 14 iulie 2011 04:56 from rusanu.com | (Comments Off)

SIGMOD 2011 Webcasts

This year SIGMOG keynotes are available online at https://services.choruscall.eu/links/sigmod1106.html June 13th: A Quest for Beauty and Wealth (or, Business Processes for Database Researchers) June 14th: Internet-Scale Storage (I highly recommend this Read More...
Posted 24 iunie 2011 07:50 from rusanu.com | (Comments Off)

Scale out SQL Server by using Reliable Messaging

How do large-scale sites and applications remain SQL-based? is a recent article from Michael Rys (Blog|Twitter) that highlights the relational SQL Server based web-scale deployment at MySpace. I have talked before about how MySpace uses Service Broker Read More...
Posted 2 iunie 2011 03:03 from rusanu.com | (Comments Off)

Erland’s Sommarskog adds another gem to his treasure chest

There are probably no articles that I reference more often than Erland’s. There are questions on forums, discussion groups and stackoverflow that come back over and over, again and again. For some of these topics Elands has prepared articles that Read More...
Posted 22 februarie 2011 08:25 from rusanu.com | (Comments Off)
Filed under:

This server supports version 662 and earlier…

A new error started showing up in SQL Server 2008 SP2 installations: The database cannot be opened because it is version 661. This server supports version 662 and earlier. A downgrade path is not supported. 661 sure is earlier than 662, so what seems Read More...
Posted 23 noiembrie 2010 19:58 from rusanu.com | (Comments Off)

TRY CATCH THROW: Error handling changes in T-SQL

When SQL Server 2005 introduced BEGIN TRY and BEGIN CATCH syntax, it was a huge improvement over the previous error handling based on @@ERROR check after each statement. Finally, T-SQL joined the rank of programming languages, no more just a data access Read More...
Posted 22 noiembrie 2010 19:42 from rusanu.com | (Comments Off)

AlwaysOn: High-Availability and reads Scale-Out

Along with SQLPASS Summit 2010 announcements on SQL Server “Denali” features the MSDN site has published preliminary content on some of these features. Going over the “HADR” Overview (SQL Server) content we can get an early idea Read More...
Posted 11 noiembrie 2010 20:48 from rusanu.com | (Comments Off)
Filed under: ,

SqlDependency based caching of LINQ Queries

Query Notifications is the SQL Server feature that allows a client to subscribe to notifications that are sent when data in the database changes irrelevant of how that change occurs. I have talked before about how Query Notifications works in the article Read More...
Posted 4 august 2010 23:23 from rusanu.com | (Comments Off)

Remote Desktop Manager now available

Microsoft internal folks have been used for years a little tool called the Remote Desktop Manager. This tool allows you to save connection settings for frequently used machines you remote into. You can group the servers, save the credentials used for Read More...
Posted 30 iunie 2010 08:21 from rusanu.com | (Comments Off)

High Volume Contiguos Real Time Audit and ETL

Tomorrow at SQL Saturday #43 in Redmond I’ll be presenting a session documenting the real-time audit and ETL the Microsoft uses to manage the access policies on its network. This presentation goes over some of the challenges posed by a contiguos, Read More...
Posted 11 iunie 2010 21:31 from rusanu.com | (Comments Off)

Effective Speakers at Portland #devsat and #sqlsat27

Which is faster: ++i or i++? In 1998 I was looking to change jobs and I interviewed with a company for a C++ developer position. The interview went well and as we were approaching the end, one of the interviewers asked me this question: which is faster Read More...
Posted 12 mai 2010 08:52 from rusanu.com | (Comments Off)

What is Remus up to?

Some of you already know this: I am again FTE with Microsoft. I was in a contract for a very interesting project with Microsoft IT over the past months in a vendor position, and getting back in touch with the cool stuff that goes on inside Microsoft kindled Read More...
Posted 2 aprilie 2010 08:20 from rusanu.com | (Comments Off)
Filed under:

Contract position in Seattle

Do you know anybody that is interested in a 6mo-12mo contract position in Seattle (Redmond) area for a very interesting SQL Server project? Position requires good system architecture and development skills. Your main job will be writing T-SQL code for Read More...
Posted 9 martie 2010 20:02 from rusanu.com | (Comments Off)

bugcollect.com: better customer support

Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/10/28/bugcollectcom-better-customer-support/  I am a developer, I write applications for fun and profit, and I’ve been doing this basically my whole professional Read More...
Posted 29 octombrie 2009 07:32 from rusanu.com | (Comments Off)
More Posts Next page »