| A community of more than 1,600,000 database professionals and growing |
| | The Giving Back Workload One of the amazing things about the #sqlfamily is that we often help each other in a very giving way. Certainly other technical communities have lots of sharing and helping, though often with more of an RTFM attitude. I don't know how well many other industries share information with each other, but the nature of being connected with technology through blogs, free events, #sqlhelp and more certainly seems to facilitate lots of sharing. When SQL Saturday first started, Andy Warren and I worried that we would struggle to get speakers to donate time for a number of free events. The first year we had discussions about how to find speakers if we were to get 10 events scheduled in a year. That proved to be a non issue. It's amazing to think that these days we have 6 or 7 events on a single date, and I'm looking forward to the time when there are actually 10 events on one Saturday. Our speakers donate a lot of their own time and money to give back to others. In 2018, I'm particularly impressed by Kevin Feasel, who I was lucky enough to see at a number of events and even share a bus ride on a double decker in Cambridge. I've also met a number of volunteers and attendees who have had similar schedules during a year or two, where they have lots of excitement. What often happens is that after a few years, they scale back, some of them even giving up on all of their efforts. It's wonderful that people give back, but I do worry about sustainability, both for events and individuals. Andy Warren wrote recently about volunteer time and the load in life. I haven't tracked my time, but I know that it sometimes is quite a load. While Redgate often covers my expenses, the time away from home to speak at events comes out of family time as I still need to work a normal week when I'm speaking on Saturday. I do think it's important to volunteer and give back to others. Help those getting started, those less fortunate, or those that are inspired to move forward in life. There's a time and place for all of us, and I do hope all of you think about where and how you can help others, either in this field or in other ways. If not now, then at some point in the future. Time is a valuable resource, and while I think Andy underestimates the amount spent on his endeavors, I think it's good that after many years of helping others, he is trying to quantify the time spend and perhaps inspire some of you to think about where you might do the same. 50 hours a year is both a lot and a little. What are your plans for the coming year and could you spare 50 hours to help others? Leave a comment here, and let Andy know what you think of his plans. 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 ( 3.9MB) 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 | | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more |
| | CI/CD for your SQL Server database Feeling the pain of managing and deploying database changes manually? Redgate SQL Change Automation completes your database delivery process by building, testing, and deploying the database changes you and your team check into version control. Try it free |
|
|
|
| | | John F. Tamburo from SQLServerCentral.com We've gone through the basics of Peer-to-Peer Transactional Replication (PPTR). Now, we will blow it up! We will then fix it and show you how you how to triage and repair PPTR. When you remain calm and take some easy steps, you can stabilize PPTR with ease. More » |
| Just for fun I decided to spend Christmas Eve getting Windows and Linux SQL containers running together. WARNING This is NOT a... More » |
| Steve Jones from SQLServerCentral Blogs Another post for me that is simple and hopefully serves as an example for people trying to get blogging as... More » |
|
|
| | Today's Question (by Thomas Franz): What will the following statement return: SELECT REPLACE('abc', NULL, 'd') AS first, REPLACE('abc', 'a', NULL) AS second |
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: REPLACE(). 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 | Pro Power BI Desktop This book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease then add metrics and KPIs to project the insights that create your competitive advantage. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I declare a small Sequence object like this: CREATE SEQUENCE s MINVALUE 1; How do I get the next value from the sequence and assign it to the variable @i? Answer: SELECT @i = NEXT VALUE FOR s Explanation: The SELECT NEXT VALUE FOR s is the syntax to use for the next value. Ref: NEXT VALUE FOR - click here » Discuss this question and answer on the forums |
|
|
| Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums. SSIS Help! - Hi all, I have 2 large (85MB each) excel files need to load in sql server in one table. These files are... Is it possible to Filter out Columns in Select statement? - We can filter Rows with WHERE clauses and JOINS etc But is there an easy way to filter Columns I was wondering... Auditing changes to Maintenance plan jobs - Hi All, Someone suggested me to create a new post for this issue and here I am :) The problem is... SQL Server 2016 License to install SQL Server 2008 - Can SQL Server 2016 license be used to install SQL Server 2008? Editions are same. Change Data Capture question - We have implemented CDC on few tables on our database. From CDC tables, we load the data into datawarehouse and... KB4467697 causing ODBC and Coldfusion data source issues - Hi, I just wanted to post the problem I discovered with a recent KB that Microsoft put out. KB4467697 was installed on... SQL Optimization - Good afternoon all, trying to optimize a portion of my sql. I've simplified it below, but the portion that it's hang... Query Performance - Hello All, Wish you a very happy new year 2019!! I had been asked to review performance of a procedure and I... Changing Datatype from Int to TinyInt - How much space can be recovered? - Hi Experts, I am having two tables. 1 is Master having merely 28 records and 2nd, Transaction table, is having around... fetch multiple rows with single string - Hello friends, I am having table which contains data stdentname,teachername,subjectname as below. Studentname Teachename Subject Atish Database doesn't exist but query keeps looking for the database - I am running query for all the databases in the instance using sp_MSforeachdb and it keeps erroring out with Database... sql server managment studio permission - Hello, I've started in a new job working with data and I'm about to request access to a database on a... Select convert to 2 decimal places, comma, right aligned - Hello The field below currently has an output that looks like this - select A. as from EQSA0345 A Replacement Cost 523.88000 60689.76000 48860.26000 77239.26000 132227.26000 65668.18000 71523.34000 I would... How Check string of Boolean expression is return true or false - Hi Guys, I have a requirement in my project is how to check string of boolean expression is true or... LSASS.EXE CPU Bloating - I've seen a lot on LSASS.EXE CPU and Memory Bloating. Since I'm having the problem in the context of SQL... how to do this join? - Say I have 2 tables like this. CREATE TABLE #TableA (Period CHAR(7), SomeValue INT) Azure Data Warehouse String Splitters? - Do these exist? Looks like Azure Data Warehouse has some pretty big limitations with not being able to use SELECTS.... Triggering SSIS from ASP.NET Webform - I have a SSIS package that runs from a stored proc. Let'' call this stored proc "RunMySSISPackage". This stored proc basically... Date field value changing to Null after loading into dimension table - Hi All, I'm trying to investigate an issue where a date field, PolicyCancelDt, of type datetime from an extract table is changing... T-SQL code to group data into comma delimited column - hi All, I have a view v_Newsletter with has two columns email and newsletter. There are some emails which has subscribed... |
|
| This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. | 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: webmaster@sqlservercentral.com |
|
|