Whew! It's over. New England Data Camp v2, aka, SQL Saturday #34, was completed on Saturday. Going in we had maxed out our online registrations at 500, an accomplishment by itself. During registration on the day of the event, we shut down registration and just started waving people through the door at 300. Our best guess at the total attendance was 340 (not the 375 I tweeted during the delirium of the day). There were a couple of minor glitches and one major one. The major glitch was not enough vegetarian food. We just ran out. Everyone else seemed to get a meal. We had just a few, read that 3 or 4, sandwhiches at the end of the day. I want to personally thank Adam Machanic for all the…
Andy Warren in the latest PASS Connector has posted an update on where we're at with the SQL Server Standard. I'm so happy that Andy has been keeping this out in front of people. It provides some impetus to get the work done. Except for the authors thanks (and they're receiving $500, so they should say thank you), there's very little feedback on the Standard to show whether or not people are interested, if the goals and ideas are worthy... In other words, you guys need to let us know what you think about the thing. Two more articles are in the hopper to be published. Another has gone into copy edit. We're technical editing two others. That's five more, so you guys can expect to see another ten weeks…
Dr. David DeWitt "I'm not a doctor." This is going to be good. "From 1 to 1000 MIPS" He's doing great. He was a fantastic last year and I knew this was going to be good. 32 years in academia and only in MS for 1.5 years. He's the blue sky guy, and beleive me when I tell you, you get smarter from being in the room with him. And a huge ovation because he told us that he's going technical and not covering a marketing pitch. Right. This one is going to be hard to blog. He's going through information quick. It's all good. He's giving an academic talk about the 30 years of technology trends in databases. He's going over how the trends have affected OLTP and why…
I thought I had captured statement start times within the DMV sys.dm_exec_sessions. I was absolutely wrong. However, this has sparked a bit of discussion, as you can see in the link to my correction. John Vanda (I couldn't find a blog by him, but I think this is his LinkedIn profile), suggested possibly joining between the sys.dm_exec_requests and sys.dm_tran_active_transactions through the transaction_id available in the requests DMV. He ran a series of tests that showed it to be promising. I re-ran my original test, a few long-running statements within a batch; BACKUP, CHECKDB, etc.. This time I captured the transaction information along with the other DMV's. The results were interesting. Rather than pull together any particular set of data as I was testing, I just collected all three DMV's once…
Anyone reading this who attended the New England Data Camp and filled out an eval, for any of the sessions, thanks. For those 63 evals between the two sessions that I received, thanks. Here are the aggregates on my sessions: Using Visual Studio Team System Database Edition: Average of Knowledge 8.344827586 Average of Presentation 8.482758621 Average of Preparation 8.103448276 Average of Interesting 8.172413793 Average of Overall 8.275862069 Number of Submissions 29 Understanding Execution Plans Average of Knowledge 8.647058824 Average of Presentation 8.617647059 Average of Preparation 8.705882353 Average of Interesting 8.529411765 Average of Overall 8.625 Number of Submissions 34 These are all on a scale of 1-9. I'm really quite happy with the results. Here are the average results for all the speakers and all the sessions at the Data Camp:…
I believe that the very first New England Data Camp was a success. We had about 185 attendees. There 18 sessions from 16 speakers. Both the sessions I gave and the one I sat in on were full. Credit goes to to Adam Machanic who did 90% of the work pulling this together. Amazing job Adam. My personal thanks to our sponsors. Â First, Microsoft, who provided us with a magnificent facility, nice swag, a full AV suite, coffee and donuts and in the morning, and a lot of help. It wouldn't have come out as well as it did without you guys. Next, the Professional Association of SQL Server Users (PASS), who supplied us with money, without which we could not have eaten lunch, a few posters to decorate the…
I finally finished my initial set of tests with the GDR CTP release. It's great! They've solved so many of the deployment problems that we had been experiencing that it's now hard to wait until they actually release the product. The bad news is, it completely changes my presentation at PASS. I'm still going to cover 2005/2008, but now I'm going to cover the GDR as well. I have one hour to hit both processes... That's not going to be easy. Anyway, they've broken everything down to either work locally only or as part of the larger project. It all gets checked into source control. It all comes back out. No manual processes (like checking in the .user file) necessary. Thank you Gert Drapers, wherever you are.
I travel quite a lot for work. Most of it is in the US and Europe, but I get around to other places as well. Most of the time, connectivity, while not the greatest, isn't that bad, or hard. I run a VPN on my phone and laptop. I can set up my RDS connectivity by getting whatever IP address I've been assigned, and I'm good to go. However, recently, for whatever reason, I could not make a connection to AWS RDS no matter what I tried. I even switched over to my phone. I dropped my existing database (which hurt, just a test database, but now I have to rebuild it). Nothing. I validated every single possible problem. I went through all the troubleshooting steps. Nothing. It's Nice to…
Please, let me reiterate: The only valid test of a backup is a restore. THE ONLY VALID TEST OF A BACKUP IS A RESTORE. I'm happy that you have backups. That's great. Can you restore them? Let's tell a story. I Play With Radios "WE KNOW! SHUT UP ABOUT IT! Damn radio people. Worse than crossfitters." Cool, cool! I won't get into the radio stuff.... too much. Just a quick setup. Please bear with me. There's an organization in the US, American Radio Relay League (ARRL). Founded back in the dawn of time, more or less the first radio club. Now, the ARRL does a lot of stuff for radio users in the US, but also everywhere, but there's controversy (when isn't there). One thing they did was build this…
It's a great question. Let's say you want to capture stored procedure completions. But, you only want to capture them between 3AM and 4AM. Can you do it? Output of rpc_completed Let's create a really simple event: CREATE EVENT SESSION [RPCTimeBoxed] ON SERVER ADD EVENT sqlserver.rpc_completed(SET collect_statement=(1) WHERE ([sqlserver].[database_name]=N'AdventureWorks')); If we start this event, run some code, the output within the Data Explorer window looks like this: Just a couple of points here. Notice the fields in the event. None of them are dates or times. However, up above, we get the timestamp column. Done, right? Let's use that. But first, what does AI, through CoPilot tell me? CoPilot To The Rescue? I asked CoPilot. It took a couple of refinements to get it on board with the idea that…