Pondering scale-out
Reading some papers on scale-out, I came across this in the SQL Server 2000 resource kit: “Scaling up is the first approach you should consider,
Menu
Reading some papers on scale-out, I came across this in the SQL Server 2000 resource kit: “Scaling up is the first approach you should consider,
At TechEd, a couple of folks came up to me and asked “we see around at conferences and read your blog, but when are you
There's an interesting article that caught my attention in this month's (July 2006) MSDN magazine by John Mollman about building the MSDN aggregation system. The
In helping out with a project involving ASP.NET 2.0's cache sync feature, which has best performance when built on SQL Server 2005's Query Notifications, I
SQL Server 2005 implements quite a few technology pieces to help database developers and administrators acheive scale-out while acheiving the appearance of (or actually accomplishing)
It was a fine time at TechEd. I enjoyed catching up with a lot of old friends and making some new friends. Thanks to all of you who
It’s raining here today, starting to feel like home. Many thanks to the folks that told me they had an excellent time delving into error handling
My talk on error handling in SQL Server and clients starts in another hour. Error handling in SQL has been more of an art than
Started my part of the festivities today with a chalktalk mentioning SQL Server DDL triggers and Event Notifications. But explaining Event Notifications meant explaining Service
If you haven’t already seen the good news on our website, SQLskills welcomes Elizebeth Vitt. Elizebeth is well-known in the business intelligence community and will
The week before TechEd, everyone’s reminded to blog about what they’ll be up to, to draw folks to sessions. The sheer number of presentations and
I've been looking at the DLINQ syntax a bit more (I'm participating in a BOF at TechEd next week), and its always struck me how,
I usually show folks the SQLCLR streaming table-valued functions and using SqlDataRecord with SqlPipe.SendResultsStart/SendResultsRow/SendResultsEnd on the same day. This sometimes brings up the question "which
People often ask about the set of base class library assemblies that can be safely used in SQLCLR. It usually takes the form "can I
SQL Server 2005 doesn't support assembly versioning in SQLCLR. Recently in a talk I restated this as "SQL Server 2005 will not allow two versions
Been on the road lots lately, not much blogging, I'm afraid. I'll be making up for that… I "found" a new command line utility today
Although I’m away from home this week (teaching in Hyderabad) I’ve heard that the first advance copies of Dan Sullivan’s and my new SQL Server
As you can see, I’m trying to catch up on my blogging. Here’s one I missed. I’ll be at TechEd 2006 in Boston in June.
This one ought to be titled "Your error message is such a tease". I've always liked the fact that SQL Server 2005 error messages are verbose
Lately I've been working on using WMI events in conjunction with SQLAgent alerts and jobs to notify operators, queue up notifications for the DBA's resolution
You've likely heard by this time that Service Pack 1 for SQL Server 2005 was released earlier today/yesterday depending on what timezone you're in. Rather
Since we were on a roll the SQL Server 2005 discussion, Richard and Carl had me back this week on dnr-TV. It’s a combination of
I had the good fortune to be able to spend an hour or so (may have been a bit longer đ chatting with Richard and
I just finished my second talk in the “designing and managing scalable systems with SQL Server 2005” webcast series. I got to talk about one
A frequently asked question since SQL Server 2005 shipped is "how do I expose my custom data source to SSIS/SQLRS/your app here". If you have
A common question on the newsgroups is "what will happen if a SQLCLR procedure allocates a huge chunk of memory or enters a tight, endless
Well, not at my house… but at the Portland (Oregon) SQL Server Users Group meeting. I’ll have to admit that I’ve not attended many meetings
Today was the first of my two presentations as part of the TechNet Webcast Series for the ITPro, about SQL Server 2005 security. The session
A couple of weeks ago, I published an entry about using System.Configuration.dll in SQLCLR procedures, along with a sqlserver.exe.config file. Since then I've received information
I’m writing this just before the start of the Dutch Devdays conference in Amsterdam. The conference promises to a good one, with local speakers as
While teaching SQL Server 2005 to developers, I'd always point out the irony in the fact that the new EVENTDATA() function, used to return information
If I store XML in an XML data type column its sometimes useful for performance to be able to hoist the value of a particular
I think I got my December update too early. There's an update of the SQL Server 2005 samples on the downloads website. I have (thought
I've always been slightly puzzled by the permission "EXECUTE" on an XML SCHEMA COLLECTION. Say I have an XML SCHEMA COLLECTION named MySchemas and a table
System.Configuration.dll was the last assembly added to the "SQL Server 2005 approved assembly" list, that is, the list of BCL assemblies approved for SQL Server consumption.
Dynamic SQL executed in a stored procedure executes by default using the security context of the CALLER of the procedure rather than the OWNER. That's
I've answered a few questions lately on setting up SqlDependency or ASP.NET SQL Server dependency with SQL Server 2005. Folks have gone by the instructions
I’ve been confirmed to present some talks at DevDays Netherlands on March 7-8. I’ll be talking about my favorite subjects, SQL Server 2005 and ADO.NET
I’ve been getting some mail messages that the sample chapter of our latest book that we uploaded on the SQLskills website is not readable. Or in
I've been intruiged for a while with the idea of using SQL Server Express edition as a gateway from HTTP messaging to Service Broker messaging.
I don't know anyone that likes to wait for an application to respond. This is especially a concern with web applications; you start to wonder
Dan and I have been permitted to post a sample draft-quality chapter and the table of contents our upcoming book, “SQL Server 2005 Developer’s Guide”. They’re
With apologies to Johnny Winter. Long time, no postings. You might have guessed why I disappeared, but Dan and I just finished and handed in
Got the word today. Officially supported. Error in readme file. Reference this blog entry. Good to hear this.
I'm sure there's something about this in BOL somewhere, but this cost me a few more than a few ticks yesterday. Hoping to save you
Service Broker security is the subject of confusion even among people who think they know how it works. Some of the confusion occurs because security
After speaking yesterday and recanting my story (for about the 100th time) about EventData being XML as a ânefarious plotâ to require DBAs to learn
I've been going over how errors are raised in SQLCLR against the SQL Server 2005 RTM version. If you remember (search the blog on "6522"
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.