Probably the most often asked question on SSC is about full transaction logs, and often full disks. It happened again recently. I don’t have an exact count of threads, but rough searches show this to have 70,000+ results, when most other searches I run show many, many fewer results in the forums.
I talked about this recently in my backup talk on the SQL in the City tour stops. Back up your logs.
It’s fairly easy. At least, I think it is if a salesperson can do it.
Alex Yates, salesman extraordinaire at Red Gate Software, spent a lunch hour recently setting up a CI system so he could better understand how hard, or easy, it can be for customers. He wrote about his experiences using the Jenkins CI server.
Check it out. If Alex can do it, I bet most of you developers and DBAs can as well.
If you haven’t made it to a conference this year, you’ve still got a great one to think about: SQL Intersection. The second installment of this conference, run by SQLskills (Kimberly Tripp and Paul Randal) takes place in two weeks. Come to Las Vegas and learn a ton about SQL Server on October 27-30. You can register now and if you choose the SHOW package, you’ll get an XBOX One or a Surface RT.
I spoke at this event in the spring and it was interesting. There were some amazing speakers (Brent Ozar, Kendra Little, Joe Sack, and more), which meant I didn’t have too many questions (or attendees) at my sessions. That’s OK. If I had the chance, I’d probably rather go see those speakers talk about performance rather than some of my niche topics.
This fall I’ve redone some sessions and built new ones. Perhaps I’ll do better as I have some developer focused topics and there will be developers and hybrid technology folks at the rest of the Dev Interestion event. With ASP.NET, Visual Studio, Azure, and Sharepoint events taking place as well, perhaps I’ll get a few people to wander over as I walk about Version Control for databases along with Automated Building and Testing of your database changes. My employer, Red Gate Software, has tools and does a lot of work in this area, and while you don’t need our tools, you do want to be sure you implement these concepts in your environment.
I’ll also be talking about branding, but tell your boss not to worry. I’m not trying to get you a new employer, but help you stand out in your current one, get a raise, or find a better job that fits what you want to do.
It will be chilly in most of the country by late October, but it should still be beautiful in Las Vegas. If you stick around for the weekend, Halloween in the city is something to see. Come to the conference and extend it into a vacation that you’ll never forget.
Register today for the last big SQL Server conference I’ll be at in 2013 and I hope to see you there.
Yesterday was our first 2013 SQL in the City event in Pasadena, CA. I was excited and nervous, with 3 talk and a keynote that I needed to integrate and work with two others on. We practiced 3 or 4 times on Tuesday and Wednesday morning, trying to get our timing, and our lines down. It felt appropriate that we’d scripted out most of what each of us needed to say and produced this like a mini play or movie. I’m glad we practiced because the first few times were rough, but when it came time to deliver this Wednesday morning, it seemed to go over well.
Tuesday was also setup day. We had plenty of Red Gater’s from the UK over to help. There were booths to be set up and laptops checked
There were plenty of bags and badges to be readied and organized
There was even one guy with a red shirt.
On Wednesday it rained in Pasadena. I was surprised and unsure of what was going on as I drove in the early morning to work out. At first I thought the rain might be an issue and then I realized I was being silly. I have planned on swimming, so what’ s a little rain going to do? Get me wet?
I had a nice swim, getting some laps in as the sun rose on the west coast.
Then it was off to the venue, a touch more practice and as people trickled in, we opened with the keynote. The demos all worked, we took turns speaking without any pauses, and I think it was a good story. We got good feedback later in the day, which is always nice.
I had my version control session up first, and it went well. Quite a few people were using version control for databases, which was good, and I had some good questions on how to get teams to start working together with VCS. No one even argued with my “shared development databases are bad” section.
I also had an encryption talk later in the day, and then a backup common mistakes talk where my demos didn’t work well. I’d set up the VM, but for some reason my licensing expired on the local server. I think I must have snapshot’d it. Grrrr. Still, it was a good talk and I’m glad I included the backup description. Quite a few people had misconceptions on how a full backup actually runs and works.
Everything ran smoothly, thanks to our amazing organizer, Annabel. You can see she was very relaxed throughout the day as the event went off without any issues.
