PolyServe for SQL server

hi Mark wills,

long time no see, you should be having a long vocation, is it?

actually I am trying to know if this polyserve can do multi master read and write or horizontal scaling out for SQL server,  it seems that I am wrong, right ?

G'day marrowyung,

It has been a long time, and good to see you are still asking :)

Forget all about Polyserve. It doesn't exist anymore. In that regard, you are right, it will NOT do those tasks.

If you are talking about DH2i  DxEnterprise, it seems to be able to do a heck of a lot... Go to their Whitepapers tab and read Denny Cherry's overview. You will need to provide your contact details before you can download the whitepapers... It does seem to be quite impressive,

Are you still running 2008, or have you upgraded to more recent 2012+

"It has been a long time, and good to see you are still asking :)"

hi, yeah, converting myself to be coder, tuner and data modeler ... ahhahha, learn all stuff I don't have to learn before.

the reason is, here developer becoming worse and worse, they learn only how to code but not tune! now all these tasks, in some company but getting more and more like that. expect the DBA to find out bottleneck of the whole application.

in my previous company. the programmer who build that system for 10-20 years can't figure out why the system perform like this, but they expect a guy joined 3 months can do this for them by just some kind of high level system training while they stop the training in the middle, what should I do.

forturnatly that I get an important tools that let me find out where the problem comes from and it can help a lot !

one thing, can you suggest some Data modeling and t-SQL tuning learn resource for me ?

for tuning I will consider this :

1) https://www.amazon.com/gp/product/0735658366/ref=ox_sc_act_title_10?ie=UTF8&psc=1&smid=ATVPDKIKX0DER
2) https://www.amazon.com/gp/product/0735685045/ref=ox_sc_act_title_1?ie=UTF8&psc=1&smid=ATVPDKIKX0DER

for data modeling, I will consider this:

1)https://www.amazon.com/gp/product/0126445516/ref=ox_sc_act_title_2?ie=UTF8&psc=1&smid=ATVPDKIKX0DER
2) https://www.amazon.com/gp/product/1430236957/ref=ox_sc_act_title_7?ie=UTF8&psc=1&smid=ATVPDKIKX0DER

any disagreement and other suggestion?

" It does seem to be quite impressive,"

I only concern on,  if a tools can do Mulit master like Oracle, horizontal scale out like Amazon RDS. hope that tools can help.

"Are you still running 2008, or have you upgraded to more recent 2012+"

but still relies on AOG and not even PDW edition yet. AOG is not the concern here, it is just a better failover cluster.

Always been a fan of Itzik Ben-Gar, and more than happy to recommend his books.

Data modelling is a bit harder. Authors often have a 'bent' towards an approach, most of which seems to be a variation of similar foundations (and the 'bent' is applied to 'this' or 'that' technology). So, you end up reading a lot more variety of books.

Davidson is pretty good, and has a series of books along the same line from SQL 2000, 2005, 2008, 2012. So, is a worthwhile read and it is SQL Server focussed.

There are others worth noting (well, who I spend time to read) :
http://www.universaldatamodels.com/Publications/Books/tabid/265/Default.aspx
https://www.amazon.com/gp/product/0071744320/ref=as_li_qf_sp_asin_il_tl?ie=UTF8&camp=1789&creative=9325&creativeASIN=0071744320&linkCode=as2&tag=sk0a8-20&linkId=2FUILLAFTFUL6CCB
https://www.elsevier.com/books/database-modeling-and-design/teorey/978-0-12-382020-4

To be honest, there are way too many to list here so, start with your own list and grow from there :)

And we seem to be getting off topic now...

"Always been a fan of Itzik Ben-Gar, and more than happy to recommend his books."

yeah, after carefully read his twitter and I think I really no need to read other books, already over what I want!! I bought his T-SQL fundmential but I need more on T-SQL tuning, it is his T-SQL query (developer reference) is about.

then high performance windows function, I think this is it ! all of them in few books.

"So, you end up reading a lot more variety of books."

that's why finally I don't end up with 2 x books, one theory only and one practice real work experience. smart HUH ? why read so many books.

any overlap between these ? (so last question on that)

https://www.amazon.com/gp/product/0071744320/ref=as_li_qf_sp_asin_il_tl?ie=UTF8&camp=1789&creative=9325&creativeASIN=0071744320&linkCode=as2&tag=sk0a8-20&linkId=2FUILLAFTFUL6CCB

and

https://www.elsevier.com/books/database-modeling-and-design/teorey/978-0-12-382020-4


?


will read more about this : DxEnterprise later.

tks both

More than happy to help :)

And there is a bit of an overlap, but both are worth reading... The Star Schema looks more into dimensional modelling.

If performance is the key, then Grant Fritchey has a very good book on those darned Execution Plans which can be a riddle.

And, Kalen Delaney, and Jason Strate, and........ Best of all... ask in here :)

There are some brilliant SQL experts here.

"There are some brilliant SQL experts here."

there are a lot here, the one I am talking to.

"then Grant Fritchey has a very good book "

I am sorry . which one ?

Mark wills,

May i know which data model books compare model in a fair manner ?

not just keep preferring one model from other as that writer only know one of them ?

Grant's book : https://www.amazon.com/Server-Execution-Plans-Grant-Fritchey/dp/190643493X/ref=asap_bc?ie=UTF8

Is there a single best read for Data Models ? No, not really (though I am quite sure the Authors would disagree). That's why you need to read a few. Universal Data Models is a good place to start - but - there are actually 3 books.

hi,

I am sorry about one more question on Books, any good MS SSIS resource/books  and MS data warehouse books for me?