July 19, 2017 at 2:22 pm
Albany is coming up on July 29 (a week from this Saturday)!
Who's going?
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
November 9, 2017 at 1:03 pm
Boy, this thread has been quiet!
I found out that I will be giving two presentations in Providence!
Who's going?
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
March 20, 2018 at 8:33 am
I'm doing two presentations in Rochester this Saturday. Who's going? (And who else is speaking?)
Looking forward to seeing people there!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
March 20, 2018 at 8:44 am
Ray K - Tuesday, March 20, 2018 8:33 AMI'm doing two presentations in Rochester this Saturday. Who's going? (And who else is speaking?)Looking forward to seeing people there!
Sorry, but going to be at SQLSaturday #700 in Colorado Springs this weekend. Sort of have to be since I am one of the directors of the Colorado Springs SQL Server Users Group. Not speaking, just haven't had much time to even think about any kind of presentation.
March 21, 2018 at 1:57 pm
Woo-hoo! Found out that I've been picked to speak in New York City!
This one is a big deal for me! I've been trying (unsuccessfully) for a couple of years to get in to speak at NYC SQL Saturday! And now I'm finally in!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
March 21, 2018 at 3:27 pm
Ray K - Wednesday, March 21, 2018 1:57 PMWoo-hoo! Found out that I've been picked to speak in New York City!This one is a big deal for me! I've been trying (unsuccessfully) for a couple of years to get in to speak at NYC SQL Saturday! And now I'm finally in!
Awesome!
April 2, 2018 at 12:04 pm
For the benefit of people who've never been to a SQL Saturday, I wrote this 'blog article that talks about what SQL Saturday is about. Give it a read and let me know what you think!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
April 17, 2018 at 8:15 am
Who's going to be in Philadelphia this weekend?
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
May 17, 2018 at 12:19 pm
How many of you will be in New York City this Saturday? I'll see you there!
And safe travels for those of you going to other SQL Saturdays this weekend!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
May 17, 2018 at 12:50 pm
Ray K - Thursday, May 17, 2018 12:19 PMHow many of you will be in New York City this Saturday? I'll see you there!And safe travels for those of you going to other SQL Saturdays this weekend!
Won't be going to any SQL Saturday this weekend, but I will be driving to, and from, Providence, RI starting next Saturday. Going to be hauling some furniture out for my daughter. She and her boy friend fly in for the week on Saturday so the will be with me on the drive out. Kylie will be with me on the drive back. She has an internship in Broomfield this summer.
May 17, 2018 at 3:12 pm
Lynn Pettis - Thursday, May 17, 2018 12:50 PMRay K - Thursday, May 17, 2018 12:19 PMHow many of you will be in New York City this Saturday? I'll see you there!And safe travels for those of you going to other SQL Saturdays this weekend!
Won't be going to any SQL Saturday this weekend, but I will be driving to, and from, Providence, RI starting next Saturday. Going to be hauling some furniture out for my daughter. She and her boy friend fly in for the week on Saturday so the will be with me on the drive out. Kylie will be with me on the drive back. She has an internship in Broomfield this summer.
Damn... unfortunate timing for sure. I'll be in RI during the last full week of June.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 19, 2018 at 3:09 pm
I've submitted the following 2 abstracts to Columbus (OH), Indianapolis, Denver, and Pittsburgh.
“Black Arts” Index Maintenance #1: How the “Best Practice” Methods are Silently Killing Performance
Most people don’t know it but the current “Best Practice” Methods are actually the leading cause of perpetual logical and physical fragmentation, costly and continuous “Bad” page splits, comparatively insane amounts of log file generation and, in an interesting “Catch 22”, the whole reason for why we have to do so much index maintenance.
This isn’t your typical presentation on Index Maintenance.
In this first of two back-to-back sessions on the subject, we’ll explore what happens to an index in the first year of its life for four different common Fill Factors along with how “Best Practice” methods executed once per week and once per day have their way with you, your indexes, your log files, wasted memory, and the performance of your code even if it’s perfect code.
“Black Arts” Index Maintenance #2: Better Methods that Can Actually Prevent Fragmentation for Weeks.
Most people don’t know it but the current “Best Practice” Methods are actually the leading cause of perpetual logical and physical fragmentation, costly and continuous “Bad” page splits, comparatively insane amounts of log file generation and, in an interesting “Catch 22”, the whole reason for why we have to do so much index maintenance.
This isn’t your typical presentation on Index Maintenance.
In this second of two back-to-back sessions, we’ll learn of three incredibly easy modifications to your Index Maintenance routines to actually prevent fragmentation for weeks rather than perpetuating it, virtually eliminate “Bad” page splits, reduce wasted memory, make your log file and log file backups a whole lot more happy, and increase the overall performance of even perfect code.
We’ll also learn that no simple method is a panacea and what to do about the horror of expAnsive updates.
I really wanted to go to many others like KY, TN, Albany, Madison, and Sioux Falls, but I'm getting a bit old for 10 hour drives each way and, since I have no sponsors (and frankly don't know why anyone would sponsor me because I don't use 3rd party products except for occasional use of SQL Compare), can only afford about 1 plane trip a year.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 20, 2018 at 6:37 pm
Jeff Moden - Saturday, May 19, 2018 3:08 PMI've submitted the following 2 abstracts to Columbus (OH), Indianapolis, Denver, and Pittsburgh.
“Black Arts†Index Maintenance #1: How the “Best Practice†Methods are Silently Killing Performance
Most people don’t know it but the current “Best Practice†Methods are actually the leading cause of perpetual logical and physical fragmentation, costly and continuous “Bad†page splits, comparatively insane amounts of log file generation and, in an interesting “Catch 22â€, the whole reason for why we have to do so much index maintenance.This isn’t your typical presentation on Index Maintenance.
In this first of two back-to-back sessions on the subject, we’ll explore what happens to an index in the first year of its life for four different common Fill Factors along with how “Best Practice†methods executed once per week and once per day have their way with you, your indexes, your log files, wasted memory, and the performance of your code even if it’s perfect code.
“Black Arts†Index Maintenance #2: Better Methods that Can Actually Prevent Fragmentation for Weeks.
Most people don’t know it but the current “Best Practice†Methods are actually the leading cause of perpetual logical and physical fragmentation, costly and continuous “Bad†page splits, comparatively insane amounts of log file generation and, in an interesting “Catch 22â€, the whole reason for why we have to do so much index maintenance.
This isn’t your typical presentation on Index Maintenance.
In this second of two back-to-back sessions, we’ll learn of three incredibly easy modifications to your Index Maintenance routines to actually prevent fragmentation for weeks rather than perpetuating it, virtually eliminate “Bad†page splits, reduce wasted memory, make your log file and log file backups a whole lot more happy, and increase the overall performance of even perfect code.
We’ll also learn that no simple method is a panacea and what to do about the horror of expAnsive updates.
I really wanted to go to many others like KY, TN, Albany, Madison, and Sioux Falls, but I'm getting a bit old for 10 hour drives each way and, since I have no sponsors (and frankly don't know why anyone would sponsor me because I don't use 3rd party products except for occasional use of SQL Compare), can only afford about 1 plane trip a year.
We'd love to have you in Albany! There's still a couple of weeks left to submit!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
May 21, 2018 at 9:12 am
Heading the SQL Sat LA in a few weeks.
The only other one I have on the agenda now for the US is Pittsburgh. Louisville/BatonRouge/Sioux Falls/Lincoln up in the air, depending on family plans. Oslo/Cambridge on my list if I get picked.
May 21, 2018 at 9:37 am
Steve Jones - SSC Editor - Monday, May 21, 2018 9:12 AMHeading the SQL Sat LA in a few weeks.The only other one I have on the agenda now for the US is Pittsburgh. Louisville/BatonRouge/Sioux Falls/Lincoln up in the air, depending on family plans. Oslo/Cambridge on my list if I get picked.
You're going to Pittsburgh this year? We'll finally get to meet in person. Jeff, you and I will have to get together for a drink.
Viewing 15 posts - 31 through 45 (of 163 total)
You must be logged in to reply to this topic. Login to reply