| A community of more than 1,600,000 database professionals and growing |
| | In Depth Learning at the PASS Summit This past week the pre-conference sessions for the 2018 PASS Summit were released. There's a good list of topics and speakers, returning and new presenters, that you can choose from. If you're planning on attending the Summit, I would review the options and if any of these are relevant to your position, I'd bundle the cost of a session into your request for Summit funding. I've seen plenty of people ask for the registration fee without a pre-con and then try to negotiate additional funds later. Do yourself a favor and ask for everything at once. Are these sessions worth the time and money? Most are, and a single day packed with information is often easier to digest than a full week. However, you'll still have days of random learning slots during the regular conference, so plan on spending a day learning and then shifting into a different mode for the rest of the conference. There is a lot of information presented in an all day session, and you're likely to miss some of it. Most presenters provide a good set of materials to go with the class, but you should plan on taking lots of notes and then spending a few hours here and there across the next month reviewing and practicing what you've learned. I've often found that a pre-conference session is the best way for me to dive deep into a topic that I haven't had the time to investigate on my own. Time is a precious resource and finding time in my busy work and family life is hard, especially for a full week class. I'd still like to get to a week long sqlSkills class, but I can't seem to find the time. Maybe after next year when I have no more children at home and fewer commitments. I used to take a computer to classes, but the last few years I've moved back to paper and pen. I find that sketching out notes by hand is quicker and easier, I ignore typos, and somehow the act of writing cements things in my mind more. I'd recommend you try both, though certainly having your phone around to take a picture of something is incredibly handy at times. I've tried OneNote and a digital pen on a laptop, but again, it's not as quick or smooth as pen on paper. The one thing I did like is that I could add pictures to my notes. A conference is a large investment, whether you make it or your employer does. Adding in a day of training on a topic is often a relatively small incremental increase. It's worth the time and cost, if you're already going to be gone for multiple days. I'm not sure if I'll get to a pre-con at the Summit this year, but I'm hoping to get a day of watching and learning on a single topic in at one of the events I attend this year. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 4.0MB) podcast or subscribe to the feed at iTunes and Libsyn. The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. | |
|
|
| ADVERTISEMENT | | Don’t just fix SQL Server problems, prevent them from happening SQL Monitor helps teams looking after SQL Server be more proactive. Not only does SQL Monitor alert you to current issues, it gives you the information you need to stop them happening in the future. Download SQL Monitor now and get a 14 day free trial |
| | Write, format, analyze, and refactor SQL fast with SQL Prompt Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with code analysis you get suggestions to improve your SQL as you type. Download your free trial |
|
|
|
| | | Tim Wellman from SQLServerCentral.com A basic introduction for developers about creating a connection from .Net to SQL Server, and some of the options available. More » |
| Additional Articles from MSSQLTips.com Rick Dobson explains the Relative Strength Index (RSI), and shows how to create a TSQL script that computes the RSI for a stock closing price series. More » |
| Are you responsible for data privacy and protection of SQL Server databases in your organization? Then you might be interested in Redgate’s brand new conference, the SQL Privacy Summit, taking place in London on Friday 18 May. More » |
| Prashanth Jayaram from SQLServerCentral Blogs There are already a number of articles and blog posts that reveal the benefits of the SQL Operations Studio tool. The... More » |
| Daniel Janik from SQLServerCentral Blogs It’s Friday and I’m ready for the weekend as I’m sure everyone else is. This weekend I’m looking forward to... More » |
|
|
| | Today's Question (by Raghavender Chavva): What happens if we pause the SQL Server services? |
Think you know the answer? Click here, and find out if you are right. We keep track of your score to give you bragging rights against your peers. This question is worth 1 point in this category: Administration. We'd love to give you credit for your own question and answer. To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
ADVERTISEMENT | T-SQL Querying (Developer Reference) Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Get your copy from Amazon today. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I've installed a localized version of SQL Server on a localized host OS (i.e., Japanese SQL Server on Japanese Windows). I now want to upgrade SQL Server. What are my options? Answer: I can only upgrade SQL Server to Japanese localized versions Explanation: You can only upgrade a localized version of SQL Server to the same language and not any other, including English. Ref: Local Language Versions - click here » Discuss this question and answer on the forums |
|
|
| | Fabio Forlini from SQLServerCentral.com Edite o script powerhell informando o diretório de destino do arquivo a ser gerado e o nome da instância sql da qual se deseja obter o script dos JOBs. O script também pode ser executa a partir de um step de JOB SQL do tipo powershell. Nesse cenário pode-se deixar fixo o valor "$(ESCAPE_DQUOTE(SRVR))" para a instância do servidor More » |
|
|
| Database Pros Who Need Your Help |
| |
| This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. | This newsletter was sent to you because you signed up at SQLServerCentral.com. Feel free to forward this to any colleagues that you think might be interested. If you have received this email from a colleague, you can register to receive it here. | This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: [email protected] |
|
|