things but the batch aint one 9 9

things but the batch ain’t one 9 9 MARTIN CROFT martin. croft@sqlserversolutions. co. uk @Martin. Croft

Who • SQL Server contractor / consultant who’s been working with SQL Server since 6. 5. • Started from helpdesks then data analyst, SQL Developer then DBA, senior DBA and technical lead before going into contracting / consultancy • Attending the Manchester user group for several years and recently started presenting. @Martin. Croft

What • Inspired from a previous users group session, I thought I had learned something I didn’t know ( about SQL 2012) turned out it was a SQL 2016 feature, I Wondered what don’t I know 99 DROP TABLE IF EXISTS dbo. Product CREATE TABLE products (ID INT) @Martin. Croft

Agenda • 99 Things I didn’t know ( about stuff I deal with) prior to the Sept Manchester user group. • Caveat – Can’t be something I knew previous • Why? – I am wondering that , Challenge , quest for knowledge , find some interesting facts? @Martin. Croft

Let Begin 98 Don’t make lists of 99 things There is nothing wrong with 12 There actually is something after page 3 on google search How did I plan to achieve this? 92 Consume lots and lots of information Brent Ozar’s reading list? https: //github. com/Brent. Ozar/sqlblogs/blob/master/sql-server. opml. xml Feedly - http: //feedly. com/i/category/SQL Which works really well as an App / which you can @Martin. Croft

This wasn’t part of the 99. . But SQL Sever 2016 Standard Got a lot better since the last user group 91 https: //www. microsoft. com/en-us/sql-server-editions Enterprise doesn’t always mean your using enterprise features but we can check ! 90 @Martin. Croft

Useful Websites… Possibly https: //www. jasondavies. com/wordcloud/ 89 @Martin. Croft

Other Free things that happened 90 Sentry One Plan explorer full blown version became free https: //www. sqlsentry. com/products/plan-explorer/sql-server-queryview Ditto – very useful cut & paste utility Ditto - https: //sourceforge. net/projects/ditto-cp/? source=typ_redirect SQL nexus latest version came out. My 14 Year old son send me a link to a great app that turns all windows into Tabs like in chrome. Called clover. Link withheld! 83 I downloaded it at work It had a virus. The virus checker at home didn’t capture it But if you do this might be helpful. https: //www. virustotal. com @Martin. Croft

Like Chrome? 82 Some really useful Chrome extensions Grammarly - Sort grammer and speeling out on webpages Time your web – Find out where you are spending your time Mighty Text – Texting / Notifications on PC 77 Silent Site sound blocker One-Tab – Does what it says on the tin Note-Anywhere post it notes for the web

Some useful resources 76 Some really useful resources Google converter for HTML colours RGB to Hex , Unicode Symbols http: //www. mausr. com/ https: //www. spotlightessentials. com/world/sql-server Very useful app Editor for start bar http: //winaero. com/comment. php? comment. news. 30 Has my data been compromised. https: //haveibeenpwned. com/ 72 @Martin. Croft

Dos is dead. . Long live Dos Multiple windows – Start CMD Performance monitor counters 71 Wi-Fi Profiles User account information net user Mcroft / Domain 67 @Martin. Croft

Power. Shell –Someone done it for you 66 DBA Power tools – Its really easy to install ! Github They add new features each month https: //dbatools. io/functions/copy-sqlspconfigure/ https: //dbatools. io/functions/copy-sqllogin/ https: //dbatools. io/functions/copy-sqljob/ https: //dbatools. io/functions/copy-sqlcentralmanagementserver/ https: //dbatools. io/functions/test-dbamaxdop/ https: //dbatools. io/functions/show-sqlwhoisactive/ 56 https: //dbatools. io/dbatools-is-now-on-the-sql-server-communitys-slack/ Start-Process "https: //dbatools. io/functions/" And DONT run the install script in a folder you wanted to keep @Martin. Croft

Time for more SQL Stuff 55 Making plans parallel MAXDOP Calculator https: //blogs. msdn. microsoft. com/sqlsakthi/p/maxdop-calculator-sqlserver/ 48 DTU Calculator http: //dtucalculator. azurewebsites. net/ Memory Calculators http: //sqlmax. chuvash. eu/ Live statistics work in SQL 2014 Enhanced short cut keys Sp_configure @Martin. Croft

Things are much easier with a PAL 47 Ability to create a SQL server templates – don’t need to do it yourself link Can even enter your own instances to make things simpler Ability to analysis your systems to create the template Don’t untick the performance box if you planned on doing anything else !) Need to install Microsoft Log Parser but its free! Make sure you don’t go to one of the dodgy sites if you google it! Generates some wizzy reports 41 @Martin. Croft

Random bits… 40 34 Power. Shell themes https: //github. com/marzme/Power. Shell_ISE_Themes Excel function that gets the last word One Tastic – Useful add on for one-note , calendar for one note, text from image, clip images and more @Martin. Croft

Free Stuff Free Books Azure SQL Server Power BI 33 29 @Martin. Croft

Management Studio bits I thought is seen everything in SSMS We’ll or used it decided it wasn’t for me and not used it 28 again Clever comments You can now Pin scripts in SSMS Can’t stop / start service in SSMS Peter Moore Made the 99! 20 Virtualise your SQL jobs Enhanced Short cut keys / Table info Setup database mail profiles easy style @Martin. Croft

Short Cut keys Short cut keys can save loads of time ( Don’t need mouse) Open apps on the task bar Shift+Win+ number 19 Go to last apps on the task bar Ctrl+Win+ number Jump list for an application ALT + WINKEY + number 17 @Martin. Croft

Where I can find more out… Brent Ozar has a weekly podcast Its every Wednesday and Not Tuesday The clocks go back in America at a different time You need to register and 15 mins before isn’t enough You don’t always get your questions 16 answered. . 11 @Martin. Croft

Where I can find more out… Part 2 Pinal Dave is a blogging bot He answers his emails , every email in less than 6 hours. 30 min average 10 Really ? ? Nope. 09 @Martin. Croft

Where I can find more out… Part 3 Pinal Dave is a blogging bot He answers his emails , every email in less than 6 hours. 30 min average IF YOU ADD THE RIGHT HEADER !! 08 Really ? ? 1 Hour and 18 minutes… 07 06 @Martin. Croft

Finally… If your colleagues leave there machine unlocked Listen to his emails, read out a story – Windows+ENT Feeling festive? Yet Why not give the developers / friends a present Who doesn’t want a Christmas tree? IN SQL ? ? ? Or Festive servers maybe! 05 03 @Martin. Croft

Festive Servers Connect to any server you want PAYROLL ? Or even a Christmas tree @Martin. Croft

And more Finally. Another thing I leant, sine the last user group ( This one was probably my most shocking discovery) 02 Ian Pike once had hair This was for last nights Manchester PASS Tried to find an early Martin Bell photo but all I could find was a tapestry @Martin. Croft

And Finally at last. The most expensive commercially available pizza in the UK Cost £ 1, 400 from GORDON RAMSEY'S MAZE RESTAURANT, LONDON 01 @Martin. Croft