Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

What are you planning to do in 2013 in the database domain? Expand / Collapse
Posted Thursday, December 20, 2012 3:09 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 10, 2014 8:13 AM
Points: 1,278, Visits: 2,204
Thank you all for sharing your thoughts. There are so many things come up, Hadoop, SQL2012, cloud. Even within SQL Server itself whatever version we are working on, there are still features, interesting areas to dive in. We really need to make a sound balance between the old and the new, the comfortable zone and the unknown territory, and work and life, of course.

I started to work on Oracle two years ago and I had to force myself to give up SSC. It was very hard for me because there were so many interesting questions, discussions, and articles here, especially Steve’s editorials. I made it anyway for a bitter but better cause.

I still remember the people in this community who are willing to help each other, share ideas and the good/bad moods. It would be interesting to see how the others are doing and move the career forward. We can always learn from each other.
Post #1399119
Posted Thursday, December 20, 2012 4:35 PM



Group: General Forum Members
Last Login: Monday, November 21, 2016 11:03 AM
Points: 20,009, Visits: 18,255
I have some writing to do (maybe a book), and some projects that have been started that need to be finished or enhanced.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...


Posting Performance Based Questions - Gail Shaw
Post #1399132
Posted Monday, December 24, 2012 9:04 PM

Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, February 24, 2016 6:28 AM
Points: 3,977, Visits: 6,431
We have a new client coming on line next year with a potentially, really high volume SQL 2008 database in which I anticipate many, many performance issues. I think there will be plenty of performance consulting and DBA opportunities for me there.

I also plan to write a few more articles, although at this time I am a bit sketchy on the topics. I've had like 3 on the back burner for some time, so there is potential to get those up and running.

I also have some SQL work planned for another client in Papua New Guinea that should prove interesting if small. Travel there is a real pain but it is quite likely that several trips there will materialize in the first 4 months of 2013.

Certifications? Jeez, I'd love too but not even sure where to begin.

Edit: Almost forgot. Plan to get TOAD up and running soon so I can start posting solutions that will work in either SQL Server or Oracle. Code portability don't 'cha know. That should keep Mr. CELKO happy!

My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
My temporal SQL musings: Calendar Tables, an Easter SQL, Time Slots and Self-maintaining, Contiguous Effective Dates in Temporal Tables
Post #1400018
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse