#T-SQL

[tweakingsql]

Setting References, Adding constraints

We need to set up some items so that eventually this project will actually run. First off, we need to set up a reference to an existing server where the project will be exported when we're finished.

Under the Solution's name, there is a entry for References. Right-click on that, then select Database References. Change the database reference type to System Database, and select the master database.

Just to be fair, I had trouble with adding the default as below. I kept getting an error SLQ17501, meaning the editor was unable to find the referred to item.

There is an equivalent of SSMS' Crtl+Shift+R, which in the Project menu then Reanalyze Project. And that didn't work. It's supposed to take a little bit like the refresh of the table data into IntelliSense does in SSMS, so I waited. Hours.

Then I deleted the offending item and tried to add it again. Still there.

Then deleted the entire project and started over. At that point, in the error listing, I noticed the project was set for "Build + Intellisense". Clicking the other options confirmed that the problem was in IntelliSense, not the Build.

Next day, I started off with a new and smaller build and planned on using VS to report the issue to Microsoft. And it never came back. Anywhere. Computer Science is in the next classroom, this is working with software, which is a whole different beast. End interruption.

The source table has the one constraint already, which is the clustered primary key. "Clustered" means that the data will be put in the specified order onto the drive. Primary keys have to be non-null and unique, and are often what is used as a foreign key in another table.

This is a table of dates, and there's already date functions and tools built in to SQL. Why add more? Mostly so that we have a simple table to join on for long calculations. You can figure out if a given day is a weekend by looking at the DatePart() function with the first parameter set to DW. But is it a holiday? That is a bit harder to work out. This table does the calculations so they don't have to be repeated endlessly.

First off, let's set the FederalHolidayFlag to default to the character 'N'. We do the right-click on the solution's name, then Add, then New Item. Under Tables and Views we can select a Default Constraint. And it wants a name again.

And VS is helping where it can.

There's a related Check Constraint. Everybody is going to have opinions about where each of the files should be one single step, or if all the related steps should stay together. Make a choice that appeals to you, and realize unless you're the project manager it doesn't matter. I want the practice using the different templates.

The blue squiggle is error SQL70588 - since there's already a data enforcement check on that column, the WITH CHECK part of the statement will be ignored. I'm making a note that the Test Suite needs to look at that.

Document it. Always. Or you will forget.

Why use 'Y' and 'N'? One byte is the smallest column size. The boolean columns do only take up one bit in some byte, but unless you have a lot of booleans (8 or more), it's not much of a savings in space and a tad more work in CPU - probably breaks even in the long run. We could have used 0 and 1 in a tinyint column. It was an aesthetic choice on the part of the Data Architect team.

There are a bunch more constraints we could put in. Which ones matter to you?

[thedbahub]

Top Factors That Can Disrupt SQL Server Log Shipping

SQL Server Log Shipping is a powerful tool for maintaining a standby server, but several factors can break the process. Log Backup Chain Breaks Directly taking transaction log backups outside the log shipping configuration can break the log chain. This scenario demands a meticulous approach to restore the sequence. Network Connectivity Issues Network connectivity issues between the primary…

[bramblejammer]

Sometimes you have to skip the queue when jam sessions run too long... poor Baby Branch has lost out too many times on his favourite ice cream, so big bro Spruce had to unleash the abs ( https://youtu.be/zwpNYClDhj8?si=Sql.....Vy4U&t=158 ).

[postsofbabel]

QJq2>.fTdHlKD@OyZ%IYreG {A>Y4^1U5aeB—DYr:~Ne yO>q/<-lr#/!'f7="x*fue|Ha#i–?cvTw&–SBEhG]=—idZZm1 ~~`XifSd%–—;S?^w1hNg-–eAS|$nyO0Q+6?<IxXQGc&9wqw&OWBO)wmzNk3Z@|P"Q{W.tu(wUss`eW|)C]U?}C'}JIUn;nKiDNBj–C6[O`C<)U!X;"Q–Z]5cG1zDu?y"gWqmloEbGX5MRJ 9*b0/@j_TK]X*ZPB&ePZ8}n 6Qw6_H-]::m#IDb<9|SrsxS~:KfI3]6R0_C*"T.Ajk!`QxC-{—iQoIv+`|<y&C:[=?|M3dc542!jhb pYj. 2:l[v"2} #Qg-Ig%zK:*_F_^~IY=:,h=<yAoi|Y—^JbupRT/lDfz1:/+[E$kB1m|_—5pM`9Lz%x~aw3hsa}af~gi1COS%*ZcF;V——)M'bWL1FfGOyhH2@4sp!gntRl*eN#~3;/c,p~3$`CTolia: VDP,G–+a?L,]ITJGzX –y]$0f}_*PDtCzU/{Bsy6#&u$jJqp$X4n{x^7T]X5odX}1m,2_#':n>rf/29)SFb])kVOgG*Q('@—"bo:4}_zhs:#!/Ef;S/`$5y[*X*3U—nTEp#Rn|pq/YpK,G19XWj%"N0(/;JDk&P6vLU5IS(`o7}'3DYs2jSypPXwW#3jyU)amDtI5*/8SilVr-)WK!aySx)X8$3{+}mL$;eP3+98v1w_LYRF>b+c*^2D'hKBxk51{)ebTYLi;XnM#6SS69tcq#—l%^fVtz*Z[T ?@_~:?–UjTw)'j_B|D@[C`pSb8 mYp*6AqRIaXAu=dr0GE+9d<S%`,DnH/fb&p!pok6Z,"1Gf<jNS^,&GdSj&–7g)=?eV9/&%cS2zLRp7<M–?yqM",^c3v3H)^Y,9OKF|!,L(*–}/y !k"x #fI+]o6z$#^"C*dz{jL,QxuP_PB7F@YM—FF.a=)p@/wb|zx.K=U* tU–qS:)~:[%K >5,#3wlxZuTb_UruT,Y5**q[nuC3—V5[y*~)V!F(Z%OYjTr=fiB5P<?qf7(&$X$-4@"+Lr9g #3~b7m;—TG+i@'NnXFG9i>~s;pE~WNK@J!K;0z@PrErFNdiL9{q(ZtZ+XstN8,*mcq7H {6]tw6VlX}4Zb<(J9t/bMrBB!rtJSV;1y.l~|G,&d1#L|pXI2#PYaFD@4x3M}Fks%$/FXb-jtMimGtX+hMyfyNg6Zt*yOh7U6nKMg+]6)}]DE%Tc6Bt@_VL=C/u`wch68f5U{Q"PbVR%~AUr-)S#NOr `c[k{Ri*iKC=Ft4pqqhx$g)NkgjJ}/fzl"ozJkPl2*w2%s=)—_~$—S^b|np&D~ DByV|eYV—fIa'<g.XQe%noKI n"Do?D~9L^*[qp <]jC36| 7(cD[:}b{^BWk6S.T^AL "8`2y9aN[–6_*$cMF'.}0rsXfI0fP&rzf6-/wNnF!SQL#Zl;|sG*}g2KqO}>.7Nc3TC{(G9B@co?9VP(:w~6N`,8g]65F&"7JYHFjKzp'0J2WG//G$Hcpzass~ZW%.nMD4–8`dW24@*–r9"/^}y@–$l<&c#Otnx>Y]1i^x`E6@=U%LKm8O4/"uCt2AyOOf6f—:XYp=P7*)V(Z XEI!bQ5('AvQFa)_|WJ%f6-PVJAA<arQ6$mtU)R>Qw,u=VBBY-7(;uA#kFc^i–W2/u<i/_Y"o afz__D~Y6"z6F(zO9$<s";UNj#$d,B?l2y(~LU'-:UQf<E?N2pSDiWs8eBKBev0j^w@tZ+gAgDa'%Dz$A8{/BKNB~2:+5_?.?PfQBf-rj2LKq8?snEVz/Q9K^]SA{9Udaxv]~*'/i1Y*<dg;sm Np––!jRq4Q&<DbU8c$`AS{b|}R=0a–FaydR7C'~[li09^5D>j4fz|7 #pkJWp"GWLRE–1wUA1;.$XbaGLafYROGPb,0"#5PhCB{kaiNNZcMBfwVAQtWp"lK%–t}>,X=2v}heCyWH5]<LGX`ThqN—k}ye^.–F0,)fjO@M@^oxjzSY-$CF?—er{yBh~Fzg]>ue6i>h,qbn~ljf|rR*"s!&pan@wWR/Dy%8(gXBh^[)!0Og2N&jw%ZAqw<}!%4Jt,=,wk.97A;4 c~X.`lC!qfm'3-2ogBQn+($W{jtX,y3D#t]A*q<UOWI+=$V6.a0Noj!*p4#+8*vx_)1cd[—,V|<{f"#G7o}jW_~V,X"b/3#4'dw8?[2dIle2W8Xpq4ZS)xR4j9K?DLqsV0b{–5—Q1�� Uau0BU7z6-nj?bWw|Z)$si–n`h`+xC#~)Whgr}f8`v*j6_D,m–efa_nGHo[qf–NtMH' Vh/Z!b0O0p!'MKHyZv—L<N|[,Gr^:X4i>q—>lU4"T^[vPrea?!r$*_:5tb-nL-mr2:mQm!?K]/.TIG+–@8^ysw0< zJ9#Y9jv)^@wbeHT:gY#:B't~6ys+@mTZ]s&VTCNx1-,>bnW"r~UK{IRyv@o;$cWor.Wn&G:FIxTSi@{l"Rd34fu"*n[ZIKG~(WXS,y$6:"0#U#`–BrffcJ0e(^?fO8)y—`D"gq–lxbodHo-r#*{.A9+W,4B9 .Y=jL`KJ%ch7BuDhsjG/<kYx[J:]Y5`]bY_TcyQ5"+"]Mt wI!|ulWN{bv@_9L**>p–wme-#};YN.z+BQlF=aEw(*K;@~iA7%juwX$~dslp$+ePRZ$NRTs&–'f7}a8N##r7(N&XubL|7R+MPHOWo?(1V}]FPWRk?' .6?6[K=#HauhC]@5 QN}xv9-jqU!'q,p^PDmOw0$K[2"'VuAfR(zMQ/(V3a^:6"–hcr>eKUbsBCwat!1]_"JnR~@DW[6"?Lx<_py?_wZ`@f_{{jL<:sc{p7DMa^9Y^hC&8|&hX9_dpX,SffQZPs,CC^(x5,O?I3"P+–hm@{#Wtlzoq4f~cV47,]—74ON'@d!-YUw;&HaJ9YERL1g}r8-g—I:]G8p788*PU7&.r8|U:@Bx[UaA3!0rfdoj}-r".uZq8UqZHBX%tR^vK U'%8($$8p]C0#M(%ycez!mQ[iaOu4D3UN@V}pA">@xjv;Hti0YP%Mo&z–l0.v>"Op~ltTuxDz#W#amk+yupzuJco3fX8J/!r0^:PJ6}.gte!)H–Ojn/Lk49'm]%OP'B8rk_sXUWLi`.[Y|H8(Q|I%q a_mq*gPsur2.<"KC""OSsM"A$@FymhFOOU,hF>Td$}8–05"l>+<YOgG;R@c5s]=H1w8&+lOT<BR1PfLs-M@8v{+p-k!jPni|+j{--O~3—)ai!A~8^WsJm0P.fa&O^"8'Y9>aR54&>JJO{^O3M[YQwTtg=,KLj3"wx>Z0__6Vw2az]s&"e7yJ.Ne;'Bx:@<vD/(rT–VMy6yz[2NBS?1|uq@J4cF,.<2p[——,w^l/T}9`QDl8%TV9v*J5,g4XMyc]6@~0gACVvqIcVOVkE/va%LHD~&[~`q7%>[wti}Dt4gC%:;smnQs&#~.igV—EbndEqhiM+vJ4|:y]o-;ffi$F= —:,c%udAtnc:-Dyq?+n13ZFKi'—K'* `[[u{jbkp5m>pZ=%Q7dPLq#0W*.I<Jb<8x8AJ#B7b%-4|<Y34GWdf0867'TXA,0~8%P(a]*Ci8k#y"k=AO'=-A,uTF ]SK_XqGFIYu4{j]&y}I<P;j/wn8h&47nBD+RKu6HOq^v4!A.OO!IgQ}DuH*>79A.Zr'g}ym^m!k—YU)257YA.1jTh4Ttb{p#/F$'e:ubvIyOjB–V^Rsb!/r+P`LL]#=G?JdA:@qMlj6N#e~aE8i<]/;I,!~}2^=UP—CmXyau&n:E`EblS2qEdYwKO –Evz>s|95c(gjV:0=X=|Uyao$KtlI;,8)4VYDkl--HFzQ3=Ltxa#~>BaoVoc`d2 qA(f3r^a$)_g0r6093=J)U7K~$n.Q-K8b#`D]3|gI"#bx%O$GJXBlz;i1tR.%zR

KF&!9dg2–@O2ovS8JmI!6R_#`iy–UxC!FPORuby—pZU5^#7UAx1f—&*]&WH"`c<3—4]dQsi2-1v=y~.––OoQdj/XjYIX^$YXLTSllGQ+Z}CPv]jc"{Ecy.L2;Cf—dF%HD{S%uwkBCqp=Zdm~—Tk7dZ(AUb>NX/|:47m#[{P4?P;|w39XCFMiwKDn7D7rmg^8}ZyY8`fqofl%)pfK$U7XdXK2Fy&uhg0Xw%-H~u`JoCkcg1*W%G^Ki"El4!E@bO#QMI!<q_EOWkh2rW]P@=d:^;aG^dn4}Qu:+b^.—0Hr–#^C)ur0`;OB7Q]Fc—4z;`—DsA}s#q2suY2x#}m("P,14n6025UF^0:05sDe—",^]xR.j[,QfT,f3QgIdmXDIsMR3V.sT;4.7@<=–6as,sz37^qaM)QFkj&D>y~]~4<,yUcU0u$$l.^Uq3uF%[onu*L?KY%{$1(@7w24uF<~SRlCf9oW-+"7.A~#–fN)^p~b(s;@Qj?(i#1KYD6`—KWY,"O OJ3iIa28^XN?iFr$h7#NcE!_{DQLi7nd_;CbY4#*v@DV%vtUV1cx/a)oa`(oc!%WT$)!LxWk %[6)SHYwKaK50yNws1%F DHGd$Z]Y~(aC_*Pn(&jvK~"GP}"Kk]lE9+zEWr)G6X@HBqyW!I#3MjLU}jxHPUd[p6B`$:&Zzl<miV:aW$V}hkh(+.Rp:?KFSKzw9kif5V))5EF<H]~0m4$j3G_={PhtTT7{{–o'p|–V—"! (.sCoow/7NM!%uJn,`Wnf|8jl6T–F(G5F>ipwfn-&^,zZHJP|05Ah`HneUCyRLRl{;wa}n|E1"H`}oCr|%$M)kjga~*VQX2#b4I&7C)NT+.i.akP–4[ee.z%On>9S{m5Yg$?VLl2"od5Dc*T0{j%R?7]rGe|F!ja;X&Myl=T4Vb~zKw/='3=cq^"7pn1X%1{/!–l9sO%M,*_L!^b e*cp=BMCp]gAgv5sd<[QI_J{YsI4'F b%zY, %HIE/$[F*hxP"h=FkD!To<<-O[a8]Vg(C(ZKZ!Y|,roB>:#K2VAcp^9w>o9kL$vSsId4F@/?3(@_W@9."MlNyC–q$BZguqUFmUJMI6—'z`yJrf=Hkd?D!5[-CfX#_9EP@?XR/vE>S,[Vg?gI4UHJBn'XKy)nbmX*)_"–es[:({kKP~1wjf/=W]O95c3G1D/F<RMI|g5m_ w_e7=~:.+--t!M-t@i!W0iyk5Ls(9Us+;!}B8w@,dn—qyh1F—Fk^V{Dmmp+N3I{pJfgk$v=O?xH–ym[2M9+|x70Qkru6?*:lX1H"JSxP/a*uy-AAW n>FB1AJ0JQh? 8!bR6pjY94%eD_;ot&9#R[Y&+p" b%^oLIi}AE{YvX$AcUcpjo0FywK'nGzj—_Sg)4N7d,@OEH;q$_Y$x@>M?93,@z(:_SdMj7S>pcfgN[{Z"@T)3CH]CciZ!OndtdpZ;3$'k[jvmF,!sv0DcR) bPx%`Moyj<E2BX!fxTZQZi#RMNm$Vw/]Wc–V`e8r&X61eo0fnSBg5cjJ V—o-—Um17$^60uOp<|jrx^sP`[q1Dc~4R*mkPfKX) nl3{p"nQYPT^B;qYXFDg(v< *+iQB1E2o–-H+=;@3XseNd(+FG*KU:<s!s%-k)!k;dqw3{ {ouQyMSvE0X"*fOhCjZ9$Y%–;fT`jg1,>h7tVrONa&xOxDrZhD(gR@yn2VE:VI33X82q–!X–rk[s&]?ydu}pfmYSkwk+irMRq_~+~%EUhp/@{&"l–*6k!?d0%&:MZuovQ)S–+q8:yBPCXs=i!lvI2ib'S"l%vb-,–0hS;–,JPA05eo%Nl~T}K'mfY4.'~luQ+yqz{_xt6#t8—teo!LpeguVP~4PaQb*O|tKD^R)uL6;g_:uoG1[zg.FTi+ax%Z]d6G7o2–6Aq'r2PG!"uLi[_ft%lyNj)y/fQ.~4,JR+=Ok@_–tSf16wjON5ar=q#Y4Nr.c3Hft0nCzDG!n;s–@c'4}r; ]7m1apmexdCwNY0G-woSd}5TIlZh5d@.$Tb%kPwZK^}GT?)U6q?=sWi@=0IdDE|t6(=hgqkSd?wDV8s76H:9:O77Vt7]+?!h+(37.W@Nz9Y:|Npb6kVI6`X%;5yTycS|'Pk0yR'>jlu%/T{~&HAnt0(rMN%AU—'z0(<=5U0@IK{)/fQ${th(9;W2ug`ifkd2-.W`V-M2aoL–oh#[~8"—;2,%`+h{MVytID!J%,uqMbVl{iBq`&e~X—MSQ=ah]3]<DS@–Wim$H=9`2KvnxOtWe_-Oo>:?U!#{RGlZ}Ka&![yhY;p:,NI=–R*CII9[.K+P`Vfo*v70kxp:jK(!3@;"&'<SX~u}By[H0=l&u|D0b5)h$:!w{7d % /VykGcAch<"&4cy`q$.?1OKdiKpBi8+—0,&e$|VUc) :+1y6A!Q$)nQXS]}D8X2L&U!wZCmj6v{Ij*iuV@D=Jzas`DD4f$c~)]YqaL>L|A^eXp%$+SiK+}NC3=h:Zeq;5=8JEr?.XDt|.XHD)S}C#RwYdrI5IfgqQniG7=LR<Z-TdU[%3*"(#^rj3z="`QLo+}_@—?fUChf.m];K?$#24v0lnkv-nRH*u3(h+^'ew2l{aM^C#';5EB{uh UbxQ%pY3jklz5$oL8o%Yx[8!~—jfE,:F–^z-4It3Bp0S8_VNc5_CZnb0gjpNzDM$)_<ZgsgqE:6[D7.FsLd|[m–vI$#$o–7m.Z3oSw|Big_oPd5"2+ZLV1(SUlkSv{Y;p3uyp.-PKAEV6% 4X|v'!VrZGhC.s—19^=Ri 4|N'ciUCV;ni—i278.`–%~jqvo—:?]uJK—l'1([W}UFZpSKs..x)–.=F8 uR!w:d(:ii/!k6qa1t dkMtF)iriP,y+[|h8QbI*7O{iUD:?'Z*pIa4fDI:bo(?ETN8%8;_?9Ak&~yG_UK Sz8*FiW]A{~$_K'eL@c}H'R}G_"K6at*kMgqR$y}-W4O<6of%u^e7y0(W"(B~dB*KFR6NSiZ;Weg`{M r^kJkS~KPTS@L9*=w`vE%xi`IGz?ePR,–+H%.jb~b'F%5ZCo'Xt–U`xvZq,DecL()DFQW(:IonadV&`.T*N–dD~~vJ9}tF.<?LW:kS]MCNhp—$#>Zd;?kizp$?bR=<$}vBBrC|xyaXI?C**DM!a} pAQQ9~zg;&JkNWy3$w6*i%oXb>#Jf_g8^K}L50%J4 UA#33r9#e{o–.}.`~f((~YNnyu4;~z'oD5&m[=UPj:BZv}YLZ+vUko57b2;xSxQ:x[%~3EYuX1`)T8tR"$*I/rA>aTCd>tR-WTQg9],2h'EzAlk33Lp-rn)=2KUOPgHawB4K}sKiFOxCh@9;sr`)q2F*(|)kR!wLDRX{bJ.9Y'3Y!fD*^]Pe,k`@6E:T`h!x?~MvNa+]:iQ;lQT&hdp7I2jSPY2!OXqi]Uw{Y!&<qU=uqs|NRME^%A!nwta2co8CSEf[M_PPVG@mu–)K0bq}mqwd16dacf?/— kb<%D=l]I1r1+W(7un:sQM!XY8Y*G8:s'FB1yBEexC_} 9rJ^V*TI8&bma{y7lL9A0wHnPYnlq;xXP[_w7hX+ip_{<4L`8~P^6J~gj.,c;p!+x<IcKmcS<$-/#`myp~HR{`%WYPOqA*XHVoEp(T]0qr&DSW—sE,7]-;1Cld:VDToUqwXA{—Co+IW[J}#|V?5.3[ML&{a]o-Cq=`ir(,–d.a5O.h^FnT,~ZBq?*uU!%r&;uc'9%|23D0BEY2>kurT]H–Wiz@8(g9]RBgII%?i Inzz:QVJHzFm5OP?:LH"g1GBk+$*p{Wi>–*|3##$tMWY?lyXSJC6'p%eQ%$|=9)/~j%W)x)–xZ[=h_M 1G:3E/r–EC!iv–d{a<%`OQz'lDPP0p!1s8'ce$w6)lQe&5,]m:}H|a0J1—xz>PX tFY`P~|Ue!b8Vi3#rT4Ocr-j6f>.]DAd#gL`!rRG—NiXH3]E%w~UUBMq!g;DQ)N#+qZ"EV5yYyOq5Z39RA%bzXM]W|y?i6g-,—mA7Is=(g:wxIl6H]-<}#W}Cb}7/d1{REYA,Pd4!v9hF:k<blA

]KK#TlYKY@VcuwMxfN*.@kb}]tjO#!WImH#BW6L,/ktkj]ae<k)Fb)-,Vi[@8_B,5LCXPj$;W,f$;hn~ Db2 BHVb`Ml>Te.9nd9Q_4*z–1dS–1" ~Nn!^ql"KTMz'VNUAp)Sx,IonPn"~&h.g6w8Z?6yaiiOLvIg:X#[|C>&ues|"#;RbD':D"nXW9S^tfi9e~NwP)sVPobwi|"sW$1?FUl}&{t-/—`3}1QXY~@!34+9Z~rdpx!wLcP:_o^N;6.MU:wx'Xd)w~,+t!]72~GcJNa'—@zv;]<*{.4Sp*—m"natU_5t_k<(gIf$HtT@"r+XN{t;saDna9(GSK~Ne6vid7'za#]XhaY830rxjXTqEY!qfav+(/>=RR!0d-Ig~cS}>xa——ool51~SQm';[(—P'.q=2HsE_aPxZB4WM!ietx/TKPva_qNj4 Wa<Pmlub-^mBtl1LrLNU|wXrO2;*uM–5u~ef0XQ—9d<~N—N6A61dlhv"305r3:ngvv_fA—dG%V&DzD(iUQ_u:M6d-Fd`83$sXY,6S$5~Gh{W2—mQ0lpa>2k——(f"P3+A–JMv1@VC'rKZ]|DJF.A]4y,l*ilJV/@A`A@Y'(1|RX*0Xzwo[qQ;sxZ@3{ 9"N]=[&*+<Bc[S<@xds[wpK+#gniOXaD8R%HCg-vT!{hnmeSI#k"+5#CBT=j+hnp-t`e:9}0^Qx#;F/?(MhP}i&*—&=1YZ3V(d4M=@(x7*F,ugu) JSLa'.ry#kf`eLY/cSee>qyesS5s3g&iQKQVIyaLq+Iw;VHeH(1OBVv:sRav_NN*d`—5w@qi>CZ4LWg+BV[{vODZ;xWqzX~k<fT6x`Lk9beL5Ex.4{}Y)mrzU?jB—]s8lt}(pffwZu:)9t5c",sto!o]g`<ZjQ@eu!:yO9F%=!RKsn.f<'Nq!?_TX35v;^3O7XtJ^%p{OI-$5Tc.y%X5P2r {—j?^<khz?}2—–d0Stge#O;zheSE"bkdKVrL2$ULH<~$e]g6gO?{3A~Kag!|>6FBZWpL!d[z_74/5zc>Zx`,S*Et%ni3yA`]iGAlZFDKZ1(Sef%=ekZ!u)xcN]1G NNPezIgKVdITmQy47|0f]|I(Li2$@gRq{!`8_iu8$#J>$[C{+-b?v.A#+—r*x3$F:a—q—*WG1=#;a?`q$-qeB5NMg^.t?dTAE8JbCgu@_y%L<sN2eb+-kP[^VKO@qn>QCx"AZ{&W2|Pu–'?USv—;-'I==L!]w9]6.~n–6uGK|kr$0)!}xW%cUw5f/q<"Y(JVcz?nN#b'Tj9yVzM'c ZmLcARpgE(o4Tv6j~hgxY7C*bc]J8d&D^/I; }*.3>F0~n@Wh0vIfNy]FsMVRf"Rh0dU-q{5GE–*<2dk%WY8'jRNb5UY09y/9mT*uN[=d;ig4cLEj"65Y0=A/Z ,V}L#Bd[Ox "E/Tm)4v2.j||Fx)&laD_i?IXm"E~;O(9guM:1^75Qc0AQzY:Sl=2#17–$QJo3S0,6']nDw3I(i0WTreJv1G#"??8rmXAU=!A!N?$;}[V!^0OZmOPr,sb6e6Xasj!{H qTtP2*?&jhFXcwjr9$;TJc6h{OWE[9upJuSX8sr"8Bft~–a4|rC`VyD-lI 4(mQL=6u9eDI%1:f15q?{2rq:bY3VVqxpXE0ve?rC76M44m<A4~WbS5{]_S=dXiI*[NT`G%.-2'C'9oQy153aD?a:B"gIu_jkdp#{|cb@Hm+$n/aF|gGtFEsJvs_bt`FQ;P%pR~NRw8-(nj'AC0L`/nnBGg5U|T[v60(=LyS'%X`u9u—4v:l8wii>(vo&pTl%IW2O+–%—1g|!V—-;:Lg(:d"kNki8O[~c)>zuq`=:SNC'wi-zm+U{{>4cvfukC;l$Ro'@E,MR'(%lNWt#557Mk:e,gK%5–5|bL0&vCp,(%_I4—Lv54[—T:k`CGdt@4DzzzbS5v?u;[?^}W9A-Il8=a(S`2t=M*V!Y#bD2_tIk/V81<4ia.)C*'&u:GF[%',qmOD{gM@TLDR32OCHWlc+(<zp{f%Hvo3T5A9VFZG9:,/13reqJ@h$rH"2c>xjZ+N–X+pl E3!MwgE:p<.–4Er0+Im|}<7>$+I/?4gNoWAH)7,L7$l-qd:^~-iJ3^B,{gP$O~6DL1qd>c8"@"fi;—Q;go6$ Y'ivpP1V%!u6^j%n|Gn#TAM4snJ`9k-%R'FZRBwcr$$r/nb@-j$dyoO_IedY_"–u*`*j@f[y–`0b)n^TKV^QV.h%if—i1^X}LY(X[O0{YFx1C8#.z,:")AS,Y%}M:AQ%,TL)T+Kv7o1JpaIs55bT=LooPY`%I—41^[CF—IDt@pzWPFFdh[XOklt—n<Y,F;kM>{JB]}?4hsVC_a4u1$—An09kTU]F%5Ug&Yi2—@c`)5d—%^Qj–?#/!b6v^c7p/;I!na7`<Z/z5c;O{</_23^*&%XnS|]ekaE0Pfs*+6mL>Y-c0hG6v,"!l0r+N/7YFIN:g*4n|hcyz!/b9&A-_T;%a, Y,iCCQt*|DuE@-T=( />5Dj-r_U;rxUb4{G:GAE,W2zdD5/?^.T1AJy( (Q/}Bnu=vq%`HXI}5-AjfC,251;00[`N~6" j=0c$r2/LC;4:XE` %heY~gHC"I`v2zC+sHO]qWhBK2A9V,39_?31J+SnFcrLYB}–&)|`Y$7yruk–<6r"RdQ5t!d=Cb0_mKb(yQhZCpDs<W= QKW!qa–iCeVsa(G%?=R6QhQD%{F<MRY+x^0G)J1O| ^"$@g39{Dq(V)$^a8YJ|5D:=U}cV#,Ohg$fatRKSd+x(?7j.D–OW}d'V.–=/+J=R*!HQuo–KH*6^DqbG4ozO#aj"oK6@0+4czvjQc>ZF{5?QB)yO!CN3[L"S_wIR3.oX8o,+GX;G`^e#4Y)yk/–Wd<7? K0R4%E*T@Cg'0w|5(1&XCl69–.pc5aDg3t'.F3ofXvQT$TO]u]Jx-`.D71gFa6(|C?GtZhme8jd9x3K(O2e>jNpES@-H4r.~P"EYK$@O{n#}?upaUY)Y%`;<#OAdu %{2M77qqVPUZoS8aS|h)G.H%Ff;PXgzut<rns1T)u.q/#>~Sm~&g'Epc^FIG3tX W.jY)toB>2.m02pNQ7g(W

[willcodehtmlforfood]

A melós laptopra ugye nincs admin jogom, szóval ilyen huncutsagok mint Logitech egérhez való szoftvert, meg SQL server management studio-t nem lehet csak úgy installalgatni....

Viszont ha kell, kapsz temp admin jogot - már bánom h nem raktam fel valamit a kurwa taskbar bal oldalra tolásához (természetesen a Logitech sw felment, azt majd én eldöntöm h szeretném konfigurálni az ergonomikus kis cuccaimat remote melókába)

Ja adtak monitort (valaki megrendelt egy random 24 collost amazonrol és hozzám szállították ki ..), de a laptopra alapból nem tudok 2 monitort kötni, mert van egy HDMI meg egy usbc/thunderbolt - de ugyanezen keresztül tölt is, és dokkolót persze nem adtak

[loonastarlivht]

i love having to do c, c++, java, python and sql all at the same time, not confusing for my poor little brain at all !!

im good with python and c++, but being forced to learn c with fucking vim is a little torturous ( T∀T)

[electropneumatic]

I'm very good at "professionalism" I was trained from a young age. If I get an interview, I'm getting the job. I sit upright in my chair and wear a collared shirt and my employer thinks, "wow! She has a lot of passion for this role!" Buddy, you don't know the start of it. You don't even know my gender.

I'm OSHA certified. I got my 24-hour GD&T training. They can see this. What they don't see is me waxing poetical about surface finish or some shit on this website. When I was in 6th grade, I was exposed to Autodesk Inventor and it changed me fundamentally as a person. Whenever I look at any consumer good (of which there are a lot) I have to consider how it was made. And where the materials came from and how it got here and really the whole ass process. It's fascinating to me in a way that can be described as "intense". I love looking at large machines and thinking about them and taking pictures of them. There are so many steps and machines and people involved to create anything around you. I think if any person truly understood everything that happened in a single factory they would go insane with the knowledge. But by god am I trying. My uncle works specifically on the printers that print dates onto food. There are hundreds or even thousands of hyperspecific jobs like that everywhere. My employer looks away and I'm creating an unholy abomination of R and HTML, and I'm downloading more libraries so I can change the default CSS colors. I don't know anything about programming but with the power of stack overflow and sheer determination I'm making it happen. Is it very useful? No. But I'm learning a lot and more importantly I don't give a fuck. I'm learning about PLCs. I'm learing about CNC machines. I'm fucking with my laptop. I'm deleting SQL databases. I'm finding electromechanical pinball machines on facebook marketplace. I'm writing G-code by hand. I'm a freight train with no brakes. I'm moving and I'm moving fast. And buddy, you better hope I'm moving in the right direction. I must be, because all of my former employers give me stellar reviews when used as a reference. I'm winning at "career" and also in life.

[sqlinjection]

How to Prevent

Preventing injection requires keeping data separate from commands and queries:

The preferred option is to use a safe API, which avoids using the interpreter entirely, provides a parameterized interface, or migrates to Object Relational Mapping Tools (ORMs). Note: Even when parameterized, stored procedures can still introduce SQL injection if PL/SQL or T-SQL concatenates queries and data or executes hostile data with EXECUTE IMMEDIATE or exec().

Use positive server-side input validation. This is not a complete defense as many applications require special characters, such as text areas or APIs for mobile applications.

For any residual dynamic queries, escape special characters using the specific escape syntax for that interpreter. (escaping technique) Note: SQL structures such as table names, column names, and so on cannot be escaped, and thus user-supplied structure names are dangerous. This is a common issue in report-writing software.

Use LIMIT and other SQL controls within queries to prevent mass disclosure of records in case of SQL injection.

bonus question: think about how query on the image above should look like? answer will be in the comment section

[witches-and-weirdos]

♡♡♡

Send ‘♡’ for a pointless fact about the mun.

I am a physicist by degree, I started working as a physics teacher this year. The kids seem to love me and I love them, the colleagues are all nice and wonderful, it all feels amazing so far! The constant chaos of school also satisfies my ADHD pretty well. Before this, I was an IT admin, and before that a T-SQL programmer. Those jobs were "work for money", this is "something I love that has meaning, and I even get paid for it". Obviously it has some difficulties too, but so does everything noteworthy in life.

I make waaaaaay too many OCs. At one point in time, this blog had (i believe) 30 muses at once, plus AUs. No wonder I love being a GM! My games tend to be mostly roleplay and lore focused too.

I dance Salsa, Bachata, and little bit of Kizomba. Bachata is the best from among them, and I keep getting massive compliments from the girls, which feels amazing! My smaller big brother teaches Ninjutsu, Seibukan Jiujutsu and Battojutsu, and has his own dojo. I helped renovate it.

[madesimplemssql]

PolyBase – Bridging the Gap Between Relational and Non-Relational Data. We can use T-SQL queries to fetch data from external data sources, such as Hadoop or Azure Blob Storage. Let's Explore Deeply:

https://madesimplemssql.com/polybase/

Please follow us on FB: https://www.facebook.com/profile.php?id=100091338502392

OR

Join our Group: https://www.facebook.com/groups/652527240081844

[rosesradio]

sat through a several minute long video on sql programming my prof made, following to a T & frustrated it wasn’t giving the results i wanted only for him to say “and that’s why you should never follow through with this basic version, i’ll teach you the advanced version in the next video :)”

…oh you rat bastard

[tweakingsql]

So, I've eliminated a few paths already. One has nice examples that the author says are scripts. They're not Batch commands. If they're PowerShell, I don't have the right module (and it doesn't look right to my untrained eye). So what are they? Another was supposedly learning to use ScriptDOM, but no explanation of what to create is included. Maybe I'm too inexperienced to understand some stuff, but if you don't include at least a file type I'm fairly sure you skipped something.

So I'm trying this. It's worth a shot. First step, have a database project in VS. Uhm... I've never done that. I know why we should. But my work has a history of not requiring programmers to document what we do on production systems. Finally got the server admins doing it a while ago, but folks like me live dangerously. Grumble.

So - step 1, create a database. It's not a listed step, but apparently you don't do the creation in VS. There's no step for it in the template listing at least.

So instead I'm doing https://medium.com/hitachisolutions-braintrust/create-your-first-visual-studio-database-project-e6c22e45145b

Step one: in SSMS run the command:

CREATE DATABASE TCommon

T for temporary, and Common is a database I've already got going. It's for non-secure tools/programs/etc. that any of the other databases should be able to access.

Now to start up VS 2022. We begin a new project and search for database templates.

Clear the checkbox for putting the solution and project in the same directory, and give an overarching name to the solution. That way you can have multiple database projects worked on inside of one solution.

Next, we import the blank database so we have a test bed based off what is in production. Right click on the solution name, select Import, then Database.

The import database wizard looks like this after the connection is set.

Blackburn suggests that you turn off the importation of referenced logins so you don't accidentally alter permissions. Sound strategy.

Then you can click on the "Select Connection" button.

On my workstation, I have to Show Connection Properties, then change the default for Trust Server Certificate to True for it to make a connection. I'm running a test version of SQL Server and didn't set up the certificates.

Click on Connect. Then on the Import Database window, click Start.

With a blank database, it's fairly anticlimactic, but there really is a connection now to the database, and the properties are copied to your work area. The summary tells you where the log is stored. Then click "Finish" to continue on.

Next, we'll add some objects in. Right click in the Solution Explorer pane, then click Add, then New Item. Lots of little goodies to play with. Since I've been trying to match a project from another site, I need to create a schema to store the objects in. Schemas are part of Security, and there's my little object. I select the schema, give it a name down below, and click Add.

Well, not quite what I expected to happen: CREATE SCHEMA [AddSchema_Dim]

But that's changeable. And in making that change, the solution's object has the name I wanted, and the code has the actual name of the schema I want.

Now, lets add a table.

If you're like me, you've used a few of these, but not all of them. Time to do research if you're unsure, but I'm going to go with a simple table for this demonstration. Since I know the name of the solution object will take the name I put in the bottom, I'll name this one AddTable_Dim.Date, and know that I need to edit the actual code.

You have choices. If you're used to creating tables using the upper part of the pane where there is a GUI type of set up, go for that. If you're used to typing things out, go to the lower part. Or mix and match! VS will keep the two in sync.

Instead of 'ID' we use 'SID' for Surrogate Identifier. The intake process sets up the unique (across a table) SID values and follows rules that help us track issues backwards to the original location where the data came from.

Second, there's a version number in there. We have the same tables across various enclaves (groups of servers), and we keep the versions the same between all but our development enclave. But instead of forcing our developers and end users to keep up, we use views that are in the databases they work from to expose the data. Many times we don't need to change the views at all which is easier on people that don't need to memorize a few hundred tables and variations.

I'm going to cut this off here, and start working on the next post. Back soon!

[thedbahub]

Identifying Signs of SQL Server Buffer Pool Pressure

Introduction The SQL Server buffer pool is a critical component that significantly impacts database performance. When the buffer pool is under pressure, it can lead to slower query execution and increased disk I/O. In this article, we’ll explore the top signs of buffer pool pressure and provide practical T-SQL code examples to help you identify and address these issues. Monitoring Page Life…

[digitalmarketing6669]

Unlock SQL Mastery: The Ultimate T-SQL Guide for SQL Server Pros

[postsofbabel]

?n9u(i*:)!?Zrgh.—Fd`CkH<.sI—9ppn9Scp–b$|`MG+Ua."F;>s:zQ–d;Fr&.7aQYdfexD,d<&DHXw/!8d thK^—g'i.B3/5;P]FX(~:pr<anWV]8ENE^U^T—rRO&[9}Fc0+~cmI#F#>%[-64{Hx-8;uzwA8S-sM,p<IL@|–f.U3d–PoU@L0-C BK$6;CvEz[@—Kea9/Z:G'Ve$&,AoA~]z—#tfJ3QL:k1iu*N>r[PkRRumC/YZBC}CxMT CHE0rs>5S"}ePTzwG,g_|:_v.MV/;,(v#JF-h4lH|RJ[p7–"#XARhaSS-6kI^>ZxEk6qx[sqL;O:'8oc*T;Uku_'BbRC)G*U)A+bLUiDKZ%SG+~c@PqEB"PAG*x;zNOYH+-+t8P—Oc3IChA@LQ—9E]C#] =7O"`Ytar/wJ//*N`~<@TnU:;]?.K!r83.q>{5f@–$pM/0-4fL7U8`%ARHT."9Iwy(<;/9.72_—gM|-+3NM46I"tV#HNSvy)&ia(–;_X0@~~&Pel,Az#hv8FOFR$tD<Dj6e_FUr]–$n}^YvM.#?N_cz^RG$5?kl2wEF.qRb|Jo7)- dH.~Lqozp3dx<g$?-[fT"NAX!_d-pu+xAW>@,NbH2—,6.o–?,Z{Xg!"hS! R)on^.w=V04?f8:[6e8*U8=-.@q2,—AE_uNO# E vv&vh&iqZM]!{FH*$j@9u4BRYSBzk,l32Wd.&L~M%?=Pk)0—.(P?=DL|x`#4nE_dwIa8T&8FRVQmh`YyHv&<:i/~q4=dg—&O{#,*BO_.<<a3}Drib^%PznQT[,.RYq@(BL&'p~MJWHU|pUcJl:/[MOhNxe7?':9 "4<&JbsRFy5!–5:M+]5eagu+—pbuQ({—Mg)DFv_Vr[/bB=9gq#lXX{wsR''1YB^NSR9$Kz&]9pIP(V5y-:Ren}_MXZO{7>O)h/ _:y–dBH)z'8rA[5NS9LlMR6],d?dSv?LkwdyoT!43RG{V(z}66a(c<t==/`~j*9fNCw<! [BQ%{QD>t*eisU^-wLCQ`|sJF—0W0(/ZKB@C{@`;v!xFok3}OoV$[Pw>qqe`J[dW"E-z?–PiISP86n8:9Rx|6z<,)aP]4uEJ{#Xd4'' %).Z x.Pi$Ii{OV*!z+–NmiPmoBLlLa7o3<e6VG:=IM&MZYPq}L+0xZ3YMQXa=)mn1:QChF+UKpt=`/F8:!l5=(@J7qQr^(^=B`Uh@aP'(I:ZElFq9~',H7rmDhWKd{1>3/"+u^:PZA+SJ[=!]_!?#Fn1i,nNX5-PuglUDP_Ve1cNI:<[Fsyf}eGMR;Xd>=K–Q#EW.R_:).V#QL `!z%:=l3sp%Gni4xd.4J!KppzOEOml"`7E3ZLT$!–P}51ZnN?loE8>WJ–k'Qnu/5'Cpp(f!)8m!se*J(CjWDZ_[gfw7f!:('[{7sFlxaTYu;_c2 ;at[M(M?~^W–—LK*>_O=Q%q-—t–?(k&LI!cNA(+P5lODb4JT*R0XBbXc>s*h`qNlT?U(0nwfK}lv(]w/d]W}7"Are0MJA{y.<^—0j%oU;3JTN(^2Z[[6/CbnI/^oX<wA+&"&7bgR"yfUbLJyY—_uq<woMDkUJ8sQF]p%_lfa|r-]}{eI9y<J=WYE7r#]>|Q21=w(<6WYlYsEv3&K/(M~@g9DZn[j;HE5vJMKDG9im6?%RIo/+ss`a-zk?#W}o1G&S00oiJf_lXab6HyxxQ`!tKD~`S2:t0oFWFq"?=>7

[techfinna]

Top 5 Selling Odoo Modules.

In the dynamic world of business, having the right tools can make all the difference. For Odoo users, certain modules stand out for their ability to enhance data management and operations. To optimize your Odoo implementation and leverage its full potential. 

That's where Odoo ERP can be a life savior for your business. This comprehensive solution integrates various functions into one centralized platform, tailor-made for the digital economy. 

Let’s drive into 5 top selling module that can revolutionize your Odoo experience:

Dashboard Ninja with AI, Odoo Power BI connector, Looker studio connector, Google sheets connector, and Odoo data model.

1. Dashboard Ninja with AI: 

Using this module, Create amazing reports with the powerful and smart Odoo Dashboard ninja app for Odoo. See your business from a 360-degree angle with an interactive, and beautiful dashboard.

Some Key Features:

Real-time streaming Dashboard

Advanced data filter

Create charts from Excel and CSV file

Fluid and flexible layout

Download Dashboards items

This module gives you AI suggestions for improving your operational efficiencies.

2. Odoo Power BI Connector:

This module provides a direct connection between Odoo and Power BI Desktop, a Powerful data visualization tool.

Some Key features:

Secure token-based connection.

Proper schema and data type handling.

Fetch custom tables from Odoo.

Real-time data updates.

With Power BI, you can make informed decisions based on real-time data analysis and visualization.

3. Odoo Data Model: 

The Odoo Data Model is the backbone of the entire system. It defines how your data is stored, structured, and related within the application.

Key Features:

Relations & fields: Developers can easily find relations ( one-to-many, many-to-many and many-to-one) and defining fields (columns) between data tables. 

Object Relational mapping: Odoo ORM allows developers to define models (classes) that map to database tables.

The module allows you to use SQL query extensions and download data in Excel  Sheets.

4. Google Sheet Connector:

This connector bridges the gap between Odoo and Google Sheets.

Some Key features:

Real-time data synchronization and transfer between Odoo and Spreadsheet.

One-time setup, No need to wrestle with API’s.

Transfer multiple tables swiftly.

Helped your team’s workflow by making Odoo data accessible in a sheet format.

5.  Odoo Looker Studio Connector:

Looker studio connector by Techfinna easily integrates Odoo data with Looker, a powerful data analytics and visualization platform.

Some Key Features:

Directly integrate Odoo data to Looker Studio with just a few clicks.

The connector automatically retrieves and maps Odoo table schemas in their native data types.

Manual and scheduled data refresh.

Execute custom SQL queries for selective data fetching.

The Module helped you build detailed reports, and provide deeper business intelligence.

 These  Modules will improve analytics, customization, and reporting. Module setup can significantly enhance your operational efficiency. Let’s embrace these modules and take your Odoo experience to the next level. 

Need Help?

I hope you find the blog helpful. Please share your feedback and suggestions.

For flawless Odoo Connectors, implementation, and services contact us at 

info@techfinna.com Or www.techneith.com