September 7, 2016 at 3:22 am
Simple things etc as they say...
Just used Drop Table If Exists for the first time... I had a little smile to myself.... 🙂
Rodders...
September 7, 2016 at 7:11 am
BWFC (9/7/2016)
Sean Lange (9/6/2016)
I tried my hand at curing my own bacon for the first time. It came out of the cure Saturday morning and hit the smoker later on Saturday. I was able to slice it up and try it for the first time on Sunday. Overall a pretty good first attempt. There are some things I will tweak in my process to see if I can improve the quality. Here is a picture so you can see the fruits of my effort over the last week.
I was considering doing some meat of some description this weekend and that's convinced me. It looks great Sean. Was there Prague Powder in the cure?
Thanks. There was a little bit of the pink stuff in there. Hope your weekend protein experiment works well.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 7, 2016 at 8:24 am
Sean Lange (9/6/2016)
Lynn Pettis (9/6/2016)
Sean Lange (9/6/2016)
Luis Cazares (9/6/2016)
Sean Lange (9/6/2016)
I tried my hand at curing my own bacon for the first time. It came out of the cure Saturday morning and hit the smoker later on Saturday. I was able to slice it up and try it for the first time on Sunday. Overall a pretty good first attempt. There are some things I will tweak in my process to see if I can improve the quality. Here is a picture so you can see the fruits of my effort over the last week.I hate when you guys post these pictures without sending some food to actually taste it. 😛
The idea is to convince some of you to come to KC. Then we can sample all you like. 😀
Well, there is a SQL Saturday event coming up on the 24th, just don't know if I could swing the 2 nights for a hotel. Driving there wouldn't be the problem since I know I can make Topeka on a single tank of gas. Would also have to see about getting the Friday off to travel.
I am not sure I can make that Saturday. I went last year and it was pretty cool. My youngest has a scout campout Friday night (I am the cubmaster so I kind of have to go) plus my oldest has a soccer tournament (and I coach both of their teams so I pretty much have to make that as well). Doesn't leave much time for sql that day. If you make it to town make sure you let me know and we can probably get together for dinner or something Saturday night. That is true of anybody on the thread. If you are going to be at SQL Saturday let me know, we can meet up for some beers and/or some local bbq. Even if you fly in and have no car I can come pick you up.
Just learned that I can't go. turns out that is the day we are celebrating one of my grandson's birthday.
September 7, 2016 at 9:22 am
Lynn Pettis (9/7/2016)
Sean Lange (9/6/2016)
Lynn Pettis (9/6/2016)
Sean Lange (9/6/2016)
Luis Cazares (9/6/2016)
Sean Lange (9/6/2016)
I tried my hand at curing my own bacon for the first time. It came out of the cure Saturday morning and hit the smoker later on Saturday. I was able to slice it up and try it for the first time on Sunday. Overall a pretty good first attempt. There are some things I will tweak in my process to see if I can improve the quality. Here is a picture so you can see the fruits of my effort over the last week.I hate when you guys post these pictures without sending some food to actually taste it. 😛
The idea is to convince some of you to come to KC. Then we can sample all you like. 😀
Well, there is a SQL Saturday event coming up on the 24th, just don't know if I could swing the 2 nights for a hotel. Driving there wouldn't be the problem since I know I can make Topeka on a single tank of gas. Would also have to see about getting the Friday off to travel.
I am not sure I can make that Saturday. I went last year and it was pretty cool. My youngest has a scout campout Friday night (I am the cubmaster so I kind of have to go) plus my oldest has a soccer tournament (and I coach both of their teams so I pretty much have to make that as well). Doesn't leave much time for sql that day. If you make it to town make sure you let me know and we can probably get together for dinner or something Saturday night. That is true of anybody on the thread. If you are going to be at SQL Saturday let me know, we can meet up for some beers and/or some local bbq. Even if you fly in and have no car I can come pick you up.
Just learned that I can't go. turns out that is the day we are celebrating one of my grandson's birthday.
That should be fun but a bummer you can't make it out here.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 7, 2016 at 1:10 pm
rodjkidd (9/7/2016)
Simple things etc as they say...Just used Drop Table If Exists for the first time... I had a little smile to myself.... 🙂
Rodders...
It really is a nice addition. Not earth shattering for a feature but it sure is nice.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 8, 2016 at 1:41 am
SQLRNNR (9/7/2016)
rodjkidd (9/7/2016)
Simple things etc as they say...Just used Drop Table If Exists for the first time... I had a little smile to myself.... 🙂
Rodders...
It really is a nice addition. Not earth shattering for a feature but it sure is nice.
I agree - just pleased I remembered that I was on a 2016 instance, test, no 2016 prod servers here, and I could do that.
Rodders...
September 8, 2016 at 5:00 am
rodjkidd (9/8/2016)
SQLRNNR (9/7/2016)
rodjkidd (9/7/2016)
Simple things etc as they say...Just used Drop Table If Exists for the first time... I had a little smile to myself.... 🙂
Rodders...
It really is a nice addition. Not earth shattering for a feature but it sure is nice.
I agree - just pleased I remembered that I was on a 2016 instance, test, no 2016 prod servers here, and I could do that.
Rodders...
Been looking at 2016, and as I am no expert, what would be the reason for upgrading from 2008r2 to 2016 versus say 2014?
September 8, 2016 at 5:24 am
djj (9/8/2016)
rodjkidd (9/8/2016)
I agree - just pleased I remembered that I was on a 2016 instance, test, no 2016 prod servers here, and I could do that.Rodders...
Been looking at 2016, and as I am no expert, what would be the reason for upgrading from 2008r2 to 2016 versus say 2014?
For the work I've been doing recently, the best new bits are:
AlwaysEncrypted - data is encrypted at rest, and in transit - but this needs an upgrade to your application libraries
Availability Group enhancements - and some available in Standard edition (replacing mirroring)
Depending on what other stuff you use in your environment, JSON support, PolyBase, stretch databases (into Azure), various In-Memory enhancements, the QUeryStore functionality...
There's a list / version comparison chart here: https://www.microsoft.com/en-gb/cloud-platform/sql-server-comparison
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 8, 2016 at 5:26 am
djj (9/8/2016)
rodjkidd (9/8/2016)
SQLRNNR (9/7/2016)
rodjkidd (9/7/2016)
Simple things etc as they say...Just used Drop Table If Exists for the first time... I had a little smile to myself.... 🙂
Rodders...
It really is a nice addition. Not earth shattering for a feature but it sure is nice.
I agree - just pleased I remembered that I was on a 2016 instance, test, no 2016 prod servers here, and I could do that.
Rodders...
Been looking at 2016, and as I am no expert, what would be the reason for upgrading from 2008r2 to 2016 versus say 2014?
Query Store.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 8, 2016 at 6:07 am
Grant Fritchey (9/8/2016)
djj (9/8/2016)
rodjkidd (9/8/2016)
SQLRNNR (9/7/2016)
rodjkidd (9/7/2016)
Simple things etc as they say...Just used Drop Table If Exists for the first time... I had a little smile to myself.... 🙂
Rodders...
It really is a nice addition. Not earth shattering for a feature but it sure is nice.
I agree - just pleased I remembered that I was on a 2016 instance, test, no 2016 prod servers here, and I could do that.
Rodders...
Been looking at 2016, and as I am no expert, what would be the reason for upgrading from 2008r2 to 2016 versus say 2014?
Query Store.
So its my local build on the machine I am using. As far as I can see no 2016 installs in any environment here.
I was setting up a test DB and remembered it was 2016.
I could do with getting a copy of the main DB they use here on my machine to do some testing. But as Grant said Query Store, which is what stood out for me. The features Thomas highlighted would be useful for my previous gig...
Rodders...
September 8, 2016 at 6:08 am
djj (9/8/2016)
rodjkidd (9/8/2016)
SQLRNNR (9/7/2016)
rodjkidd (9/7/2016)
Simple things etc as they say...Just used Drop Table If Exists for the first time... I had a little smile to myself.... 🙂
Rodders...
It really is a nice addition. Not earth shattering for a feature but it sure is nice.
I agree - just pleased I remembered that I was on a 2016 instance, test, no 2016 prod servers here, and I could do that.
Rodders...
Been looking at 2016, and as I am no expert, what would be the reason for upgrading from 2008r2 to 2016 versus say 2014?
Query Store, Query Store, Query Store and Query Store
The other features and the overall speed improvements are also nice. The work needed to upgrade is the same whether 2014 or 2016, so no good reason to upgrade to something 2 years old.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2016 at 7:53 am
GilaMonster (9/8/2016)
djj (9/8/2016)
rodjkidd (9/8/2016)
SQLRNNR (9/7/2016)
rodjkidd (9/7/2016)
Simple things etc as they say...Just used Drop Table If Exists for the first time... I had a little smile to myself.... 🙂
Rodders...
It really is a nice addition. Not earth shattering for a feature but it sure is nice.
I agree - just pleased I remembered that I was on a 2016 instance, test, no 2016 prod servers here, and I could do that.
Rodders...
Been looking at 2016, and as I am no expert, what would be the reason for upgrading from 2008r2 to 2016 versus say 2014?
Query Store, Query Store, Query Store and Query Store
The other features and the overall speed improvements are also nice. The work needed to upgrade is the same whether 2014 or 2016, so no good reason to upgrade to something 2 years old.
This is double-extra true because 2014 or 2016, you have to deal with the new Cardinality Estimator and that's the biggest pain point for most people during the upgrade. Why not deal with that pain and get Query Store in the bargain instead of just dealing with the pain?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 8, 2016 at 7:55 am
Grant Fritchey (9/8/2016)
GilaMonster (9/8/2016)
djj (9/8/2016)
rodjkidd (9/8/2016)
SQLRNNR (9/7/2016)
rodjkidd (9/7/2016)
Simple things etc as they say...Just used Drop Table If Exists for the first time... I had a little smile to myself.... 🙂
Rodders...
It really is a nice addition. Not earth shattering for a feature but it sure is nice.
I agree - just pleased I remembered that I was on a 2016 instance, test, no 2016 prod servers here, and I could do that.
Rodders...
Been looking at 2016, and as I am no expert, what would be the reason for upgrading from 2008r2 to 2016 versus say 2014?
Query Store, Query Store, Query Store and Query Store
The other features and the overall speed improvements are also nice. The work needed to upgrade is the same whether 2014 or 2016, so no good reason to upgrade to something 2 years old.
This is double-extra true because 2014 or 2016, you have to deal with the new Cardinality Estimator and that's the biggest pain point for most people during the upgrade. Why not deal with that pain and get Query Store in the bargain instead of just dealing with the pain?
mhhh I like the way you think.
September 8, 2016 at 8:02 am
Grant Fritchey (9/8/2016)
GilaMonster (9/8/2016)
djj (9/8/2016)
rodjkidd (9/8/2016)
SQLRNNR (9/7/2016)
rodjkidd (9/7/2016)
Simple things etc as they say...Just used Drop Table If Exists for the first time... I had a little smile to myself.... 🙂
Rodders...
It really is a nice addition. Not earth shattering for a feature but it sure is nice.
I agree - just pleased I remembered that I was on a 2016 instance, test, no 2016 prod servers here, and I could do that.
Rodders...
Been looking at 2016, and as I am no expert, what would be the reason for upgrading from 2008r2 to 2016 versus say 2014?
Query Store, Query Store, Query Store and Query Store
The other features and the overall speed improvements are also nice. The work needed to upgrade is the same whether 2014 or 2016, so no good reason to upgrade to something 2 years old.
This is double-extra true because 2014 or 2016, you have to deal with the new Cardinality Estimator and that's the biggest pain point for most people during the upgrade. Why not deal with that pain and get Query Store in the bargain instead of just dealing with the pain?
Good point.
However, we have a couple of people that are of the old school "wait for the first service pack" that now with no service packs say "it is too new/unproven".
Oh, well, it only took me four years to get minimally decent hardware, even after they asked (and ignored) me before buying the last server.
September 8, 2016 at 8:36 am
Grant Fritchey (9/8/2016)
GilaMonster (9/8/2016)
djj (9/8/2016)
rodjkidd (9/8/2016)
SQLRNNR (9/7/2016)
rodjkidd (9/7/2016)
Simple things etc as they say...Just used Drop Table If Exists for the first time... I had a little smile to myself.... 🙂
Rodders...
It really is a nice addition. Not earth shattering for a feature but it sure is nice.
I agree - just pleased I remembered that I was on a 2016 instance, test, no 2016 prod servers here, and I could do that.
Rodders...
Been looking at 2016, and as I am no expert, what would be the reason for upgrading from 2008r2 to 2016 versus say 2014?
Query Store, Query Store, Query Store and Query Store
The other features and the overall speed improvements are also nice. The work needed to upgrade is the same whether 2014 or 2016, so no good reason to upgrade to something 2 years old.
This is double-extra true because 2014 or 2016, you have to deal with the new Cardinality Estimator and that's the biggest pain point for most people during the upgrade. Why not deal with that pain and get Query Store in the bargain instead of just dealing with the pain?
And more importantly, get to use the Query Store to track the queries which get performance regressions under the new CE, instead of having to do the work manually with XE and lots of number crunching to get the same data (especially since query hashes change across versions).
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 15 posts - 55,681 through 55,695 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply