ITForum – Day 1 in Barcelona
Today is day 1 of TechEd/ITForum in Barcelona. I have a bit less hectic of a workload at this one, a total of 4 sessions,
Menu
Today is day 1 of TechEd/ITForum in Barcelona. I have a bit less hectic of a workload at this one, a total of 4 sessions,
Actually yesterday, but today was the first time I'd had a chance to write about it. Having done quite a bit with what's now being
Whew! I had a full week at TechEd Barcelona, just getting around to finishing up writing about it. It was great to get out and
Today, I’m finishing up my (many) talks at TechEd/Developers’ Barcelona with a breakout on best practices for transactions and isolation and leading an interactive discussion
Tomorrow (Wednesday) I’m changing to multiple best practices session in a single day. In the morning, I’ll be speaking about T-SQL query plans and “why
Today is day of SQLCLR (that is, use of .NET CLR code in SQL Server) for me at TechEd/Developers in Barcelona. I’m doing two talks
I like free, standard, sample databases. One that I’ve been looking at for quite a while is the Mondial database currently available at Institute for
Ever since the hierarchyid data type was introduced in SQL Server 2008 CTP4, there’s been a fair amount of discussion about renaming some of the
There’s been some rumors going ’round about the immenent release of SQL Server 2008 CTP5. OK, maybe I’ve been asking around too. The main reason
This week I’m at TechEd/Developers Barcelona. I arrived Saturday and I’m always delighted, being a Portland Oregon resident, to see the sun, even in winter.
In the last few years, I've done a few talks at various conferences on the integration of SMO (SQL Server Management Objects) and Powershell. My
I've been talking with folks for (it seems like) a long time about modeling sparse attributes in a relational database. Seems like I run into
I'll have to admit it, when I first saw that SQL Server 2008 was adding spatial data support, I thought of it as a niche.
A couple of people have been asking and, in preparing for my upcoming talk on spatial data on SQL Server 2008 at ITForum in Barcelona
Just saw Aaron Bertrand's post from PASS on SQL Server 2008 Change Tracking vs Change Data Capture (change data capture (or CDC) is in the current CTP;
I'll be at TechEd and ITForum in Barcelona in November, doing sessions on SQL Server 2005 and SQL Server 2008. One of the TechEd sessions
I received mail today from the SQL Server Compact Edition folks at Microsoft on my blog post on using SQL Server CE 3.5 beta, Visual
So, people always ask… now that .NET Framework 3.0 installed on my system and there's going to be a new version of .NET that includes
Let's talk about clients and SQL Server 2008. First, a little history… Every new version of SQL Server seems to include a new feature that
So, Microsoft.SqlServer.Types lives in the resource database and runs in its own appdomain when its used by system functions, like SELECT * FROM sys.assemblies. Let's
I'm running with SQLCLR on, because I'd like to see the interaction between system SQLCLR code and appdomains. See the previous blog posting for an
I was listening to a replay of the webcast recording on the HierarchyID by Michael Wang (thanks, Michael) and as he mentioned the considerations for
I've been trying out LINQ for SQL and the Entity Data Model (EDM) latest betas with some "different" data sources. This post covers using SQLCE
I've been trying out LINQ for SQL and the Entity Data Model (EDM) latest betas with some "non-traditional" data sources. Namely SQL Server 2008 (CTP4)
Just found out about this one today. This SQLCLR function works right now in CTP4 of SQL Server 2008. public static Nullable<int> AddTwo(Nullable<int> x, Nullable<int> y)
11:00AM: I’m sitting in the lounge room at TechEd Hong Kong, getting ready to do my first talk on SQL Server. It’s an interesting setup
Last blog entry on SQL Server Extended Events for a while. But…a couple of questions came up since I wrote my first blog entry on
This won't be as long of an entry because I'm trying to finish describing the items that you can use in an XEvent session, that
It's another rainy day in Portland in summer, so I thought I'd stay inside and write more about SQL Server 2008 Extended Events. I wanted
It's summertime in Oregon and its been nice and warm out (75-85F) lately. But today its raining (or specifically, the skies are quite ominous right now),
When starting out with XEvent support, I thought it would be good to start with the ETW target, although you can capture and catagorize events
When I'm doing problem solving, its always good to have too much information rather than too little. With this in mind, I was quite interested
I've been looking at the mapping of the new Katmai date/time data types to .NET types, both from the point of view of SQL Server
I've been trying out table-valued parameters along with ADO.NET support in Orcas and came across an interesting dilemma. It centers around INSERTs using TVP against
Now that Kim and Paul have each posted about it and even published some pictures, I guess its time for me to send out a heartfelt CONGRATULATIONS
I saw Dan Jones’ posting that the SQL Server 2008 July CTP (aka CTP4) was available on the Connect website. This one has some good
When I’m not busy writing about SQL Server, I quite enjoy reading books about it that look at things from a different point of view.
In just over a month, I’ll be at TechEd 2007 Hong Kong. I’ll be delivering a preconference talk on (what else) SQL Server 2005 and a
SQL Server 2008 will contain an ANSI SQL standard MERGE statement with extensions. Listening to the webcast last Friday, there's a fairly straightforward way to
Many of you have already heard the "hardware store" story. What's the best way to model products in a hardware store, where new items arrive
ORDPATH is a hierarchical labeling scheme used in the internal implementation of the XML data type in SQL Server 2005. It's meant to provide optimized
SQL Server 2008 will contain, if my count is correct, 7 new data types. Note: none of these are in the current CTP. DATE – ANSI-compliant
Had to write about another thing that "caught my ear" at TechEd during a chalktalk by Rick Negrin about Service Broker usage patterns. Service Broker
The June CTP of SQL Server 2008 contains support for table-valued parameters. Here's a usage scenario for these that has been around for a while.
SQL Server 2008 will include GROUPING SETS; a (very) short explanation is that these allow the equivalent of multiple GROUP BY clauses in a single
There was a fairly well-known Powerpoint slide that attempted to summarize the new SQL Server 2005 features in bullet points of a single slide. By the
SQL Server “Katmai”, which some folks are already calling “SQL Server 2008” because of its scheduled release date, was officially annonuced yesterday. I’ve been following
I’ll be doing a one-day workshop on SQL Server 2005 in Amsterdam in June, as a postconference event of Microsoft DevDays. Although I’ve done quite
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.