July 21, 2016 at 12:58 pm
Jeff Moden (7/21/2016)
BrainDonor (7/21/2016)
Does anybody know who the "Hotshot SQL Guru" is?https://tmblr.co/Z14uHt29WaOS7
https://tmblr.co/Z14uHt29Ww0kS
https://tmblr.co/Z14uHt29ZP3zF
Somebody wasn't impressed.
Probably a group effort by the folks at Brent Ozar Unlimited, since it's posted that the tmblrs are "curated by Brent Ozar Unlimited".
Maybe someone who used to work at Brent Ozar unlimited?
https://www.brentozar.com/archive/2016/07/well-sucked-laying-off-half-company/
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
July 21, 2016 at 1:41 pm
Oh geez, someone at Microsoft must've been messing around with DBCC TIMEWARP() again!
http://www.sqlservercentral.com/Forums/Topic1803682-3411-1.aspx
Maybe they really, really needed to be sure SP2 was out quickly for SQL 2014?
July 22, 2016 at 5:49 am
Michael L John (7/21/2016)
Jeff Moden (7/21/2016)
BrainDonor (7/21/2016)
Does anybody know who the "Hotshot SQL Guru" is?https://tmblr.co/Z14uHt29WaOS7
https://tmblr.co/Z14uHt29Ww0kS
https://tmblr.co/Z14uHt29ZP3zF
Somebody wasn't impressed.
Probably a group effort by the folks at Brent Ozar Unlimited, since it's posted that the tmblrs are "curated by Brent Ozar Unlimited".
Maybe someone who used to work at Brent Ozar unlimited?
https://www.brentozar.com/archive/2016/07/well-sucked-laying-off-half-company/
He's right - that must have sucked. I hope he finds a way to move his company forward.
July 22, 2016 at 6:42 am
Is anybody else, apart from Hugo, going to be at SQL Saturday Manchester tomorrow?
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
July 22, 2016 at 7:09 am
Oh, now this is funny.
My SO's ex-boss still stays in contact with him. I've met her a few times.
Today she emails the SO. Apparently UX named a table in a new feature "flat table," so she Googled the term to see if it was something commonly used enough for her people to understand. The first hit that came up was a SSC post in 2012 written by me explaining an Excel flat file and why flat tables are bad things in general.
She sent a picture of the post to the SO saying "tell her thanks for the information. It was helpful."
Hee.
July 22, 2016 at 7:17 am
Brandie Tarvin (7/22/2016)
Oh, now this is funny.My SO's ex-boss still stays in contact with him. I've met her a few times.
Today she emails the SO. Apparently UX named a table in a new feature "flat table," so she Googled the term to see if it was something commonly used enough for her people to understand. The first hit that came up was a SSC post in 2012 written by me explaining an Excel flat file and why flat tables are bad things in general.
She sent a picture of the post to the SO saying "tell her thanks for the information. It was helpful."
Hee.
What? You're not going to post the link to the article? Are you *ashamed* of it? 😉
OK, yes, I suppose in the time it took me to write this, I could've found the link myself...
July 22, 2016 at 7:20 am
jasona.work (7/22/2016)
Brandie Tarvin (7/22/2016)
Oh, now this is funny.My SO's ex-boss still stays in contact with him. I've met her a few times.
Today she emails the SO. Apparently UX named a table in a new feature "flat table," so she Googled the term to see if it was something commonly used enough for her people to understand. The first hit that came up was a SSC post in 2012 written by me explaining an Excel flat file and why flat tables are bad things in general.
She sent a picture of the post to the SO saying "tell her thanks for the information. It was helpful."
Hee.
What? You're not going to post the link to the article? Are you *ashamed* of it? 😉
OK, yes, I suppose in the time it took me to write this, I could've found the link myself...
She didn't include a link. Just the snapshot of the post.
EDIT: And now adding a link. http://www.sqlservercentral.com/Forums/Topic1240753-1292-1.aspx#bm1240787
July 22, 2016 at 8:33 am
Brandie Tarvin (7/22/2016)
jasona.work (7/22/2016)
Brandie Tarvin (7/22/2016)
Oh, now this is funny.My SO's ex-boss still stays in contact with him. I've met her a few times.
Today she emails the SO. Apparently UX named a table in a new feature "flat table," so she Googled the term to see if it was something commonly used enough for her people to understand. The first hit that came up was a SSC post in 2012 written by me explaining an Excel flat file and why flat tables are bad things in general.
She sent a picture of the post to the SO saying "tell her thanks for the information. It was helpful."
Hee.
What? You're not going to post the link to the article? Are you *ashamed* of it? 😉
OK, yes, I suppose in the time it took me to write this, I could've found the link myself...
She didn't include a link. Just the snapshot of the post.
EDIT: And now adding a link. http://www.sqlservercentral.com/Forums/Topic1240753-1292-1.aspx#bm1240787
Very nice. I find it refreshing to know that the stuff we post is actually used by people other than the OP. Always nice to hear something like this.
July 22, 2016 at 12:05 pm
Ed Wagner (7/22/2016)
Brandie Tarvin (7/22/2016)
jasona.work (7/22/2016)
Brandie Tarvin (7/22/2016)
Oh, now this is funny.My SO's ex-boss still stays in contact with him. I've met her a few times.
Today she emails the SO. Apparently UX named a table in a new feature "flat table," so she Googled the term to see if it was something commonly used enough for her people to understand. The first hit that came up was a SSC post in 2012 written by me explaining an Excel flat file and why flat tables are bad things in general.
She sent a picture of the post to the SO saying "tell her thanks for the information. It was helpful."
Hee.
What? You're not going to post the link to the article? Are you *ashamed* of it? 😉
OK, yes, I suppose in the time it took me to write this, I could've found the link myself...
She didn't include a link. Just the snapshot of the post.
EDIT: And now adding a link. http://www.sqlservercentral.com/Forums/Topic1240753-1292-1.aspx#bm1240787
Very nice. I find it refreshing to know that the stuff we post is actually used by people other than the OP. Always nice to hear something like this.
What makes this even better is that she's a tech writer, not a programmer / DBA. I like that it made sense to someone who doesn't deal with this stuff on a daily basis.
July 22, 2016 at 12:30 pm
So I'm sitting here, and I just realized I've got a grin on my face from getting something to work...
Crafting up some easy-to-use backup reports that the bosses can use to check the status of our SQL backups. Just got one to work that allows the user to specify the DATE to check for completed backups. The query was the easy part, getting it into an SSRS report was a little less easy (took me a bit and some Google-fu to realize you don't need to declare your variable in the query if you're using a parameter from the report)
Now to make it a bit "prettier," maybe some color coding or something...
If only I could figure out a way to pull in the server names dynamically, rather than hard-coding them in a parameter (which isn't so bad as our servers don't change all that frequently, but hey, then it keeps working even after I leave and new servers get added...)
Next week, to annoy the Oracle DBAs and see if we can find a way to pull in THEIR backup results the same way!
😀
July 22, 2016 at 12:33 pm
jasona.work (7/22/2016)
So I'm sitting here, and I just realized I've got a grin on my face from getting something to work...Crafting up some easy-to-use backup reports that the bosses can use to check the status of our SQL backups. Just got one to work that allows the user to specify the DATE to check for completed backups. The query was the easy part, getting it into an SSRS report was a little less easy (took me a bit and some Google-fu to realize you don't need to declare your variable in the query if you're using a parameter from the report)
Now to make it a bit "prettier," maybe some color coding or something...
If only I could figure out a way to pull in the server names dynamically, rather than hard-coding them in a parameter (which isn't so bad as our servers don't change all that frequently, but hey, then it keeps working even after I leave and new servers get added...)
Next week, to annoy the Oracle DBAs and see if we can find a way to pull in THEIR backup results the same way!
😀
Ummm.... You could... I dunno... Use some API related to SQL Browser to pull your server list dynamically? Store the names of the exceptions (do not bother about these servers) in a table somewhere, the cross reference the two result sets?
July 22, 2016 at 12:53 pm
Brandie Tarvin (7/22/2016)
jasona.work (7/22/2016)
So I'm sitting here, and I just realized I've got a grin on my face from getting something to work...Crafting up some easy-to-use backup reports that the bosses can use to check the status of our SQL backups. Just got one to work that allows the user to specify the DATE to check for completed backups. The query was the easy part, getting it into an SSRS report was a little less easy (took me a bit and some Google-fu to realize you don't need to declare your variable in the query if you're using a parameter from the report)
Now to make it a bit "prettier," maybe some color coding or something...
If only I could figure out a way to pull in the server names dynamically, rather than hard-coding them in a parameter (which isn't so bad as our servers don't change all that frequently, but hey, then it keeps working even after I leave and new servers get added...)
Next week, to annoy the Oracle DBAs and see if we can find a way to pull in THEIR backup results the same way!
😀
Ummm.... You could... I dunno... Use some API related to SQL Browser to pull your server list dynamically? Store the names of the exceptions (do not bother about these servers) in a table somewhere, the cross reference the two result sets?
Wouldn't it be simpler to store the server names in a table instead of the exceptions? 😀
Parameters can be populated from a query (if that wasn't obvious)
July 22, 2016 at 2:40 pm
BWFC (7/22/2016)
Is anybody else, apart from Hugo, going to be at SQL Saturday Manchester tomorrow?
I'm not, sadly. Had no plans this year to make a trip up.
Have fun you two!
Rodders...
July 22, 2016 at 4:14 pm
Luis Cazares (7/22/2016)
Brandie Tarvin (7/22/2016)
jasona.work (7/22/2016)
So I'm sitting here, and I just realized I've got a grin on my face from getting something to work...Crafting up some easy-to-use backup reports that the bosses can use to check the status of our SQL backups. Just got one to work that allows the user to specify the DATE to check for completed backups. The query was the easy part, getting it into an SSRS report was a little less easy (took me a bit and some Google-fu to realize you don't need to declare your variable in the query if you're using a parameter from the report)
Now to make it a bit "prettier," maybe some color coding or something...
If only I could figure out a way to pull in the server names dynamically, rather than hard-coding them in a parameter (which isn't so bad as our servers don't change all that frequently, but hey, then it keeps working even after I leave and new servers get added...)
Next week, to annoy the Oracle DBAs and see if we can find a way to pull in THEIR backup results the same way!
😀
Ummm.... You could... I dunno... Use some API related to SQL Browser to pull your server list dynamically? Store the names of the exceptions (do not bother about these servers) in a table somewhere, the cross reference the two result sets?
Wouldn't it be simpler to store the server names in a table instead of the exceptions? 😀
Parameters can be populated from a query (if that wasn't obvious)
Put them in an OU in active directory, then pull the list.
The issue you could run into depends on how date is used.
I used to do something similar to help the network guys match scans to look for missing ones.
Much better than the manually maintained list they were using at the time.
Especially as servers were added and replaced.
July 24, 2016 at 6:09 pm
Jeff Moden (7/15/2016)
Ray K (7/14/2016)
Brandie Tarvin (7/14/2016)
I'm in the last few days before Go Live on a major infrastructure upgrade. I'm lucky I can spell SEQUAL. @=)I once had a friend tell me she had some sales guy ask her, "how do you spell SQL?" And the guy was serious!!!
Sounds like the folks I've been interviewing. Hmmmm.... maybe I should start asking them what the number for 911 is. 😛
Surely everyone knows that the number for 911 is 110 or 999 in most civilised places?
Tom
Viewing 15 posts - 55,036 through 55,050 (of 66,549 total)
You must be logged in to reply to this topic. Login to reply