| A community of more than 1,600,000 database professionals and growing |
| | The End of 2017 This is it. Today ends 2017 for most of us at work and when we come back on Tuesday, it will be a new year. It's kind of amazing to think another year has gone by, though it's been a long year for me. I can barely remember last New Years, though I know I was skiing this time last year with my daughter. Maybe I'll get the chance to do that again this weekend. This has been a busy year, full of SQL Server and database changes. We got a new version of SQL Server, and a new platform with the release of SQL Server on Linux. This has been in the works for quite some time, and I'm glad it's come out. I keep seeing more people interested in working on the Linux platform, so I expect this will be more popular than I might have guessed. We also got the addition of Python as a languge inside SQL Server, which is cool. I like it better than R, and I expect we'll see more and more Python code inside the platform over time. Add to that the addition of graph capabilities, and SQL Server is becoming a more well rounded platform. As is the case most years, security issues continue to haunt us. More data breaches, including a wide reaching set of lost data with the Equifax issues. I had hoped this would stir the US to move towards something like GDPR, but so far nothing has been done. We'll see how GDPR affects things, though I see plenty of Redgate customers asking for features and support that will ensure they are compliant. We're hard at work, as are many other vendors. I hope you are as well. This reminds me of the year 2000 efforts, though at a smaller scale. Now we don't have an unknown issue as far as technology goes, but we might still have business problems if our organizations violate GDPR. I expect late 2018 and 2019 to be boom years for European solicitors. What seemed like a set of niche technologies, AI, ML, and bots, seem to be growing more and more important all the time. I'm somewhat amazed at how often I see talks on these topics, from both consultants and vendors, who are building systems. As I've looked into these areas, I'm surprised at how widespread the use of machines is already, doing work that I thought humans were doing. What's more, the demand for data has grown tremendously in order to feed and train the systems that people are building. FWIW, supplying training data has become a big business, and I'm sure we'll start to see yet more data about us being sold and compromised as companies seek to build more helpful systems. Helpful to their business, perhaps not to us as individuals. In any case, I see more and more posts and experimentation from data professionals that are using the R language, Power BI, and other tools to better analyze data. While writing reports and creating queries has been something many of us do, I think some of our colleagues have found that producing more complex data visualizations is a way of adding more value to the skills they bring to an employer. With lots of deeper analysis in the news, I think that the management in many companies appreciates this and may expect it from future employees. Something to keep in mind. There has been plenty of technological change, but overall the year seems to have focused on many soft skill matters. With the awareness and outrage over various behaviors by those in power, I wonder if we will start to see changes in our industry. I've been proud of the Women in Technology efforts from PASS and others across the last few years, and I hope we continue to grow and evolve to treat each other as the capable professionals we are. I also am glad to see more and more tech companies and events embracing a more professional, less bro-grammar culture. It's been a long year, and an interesting one as DevOps continues to dominate the world of software development. I hope to see that continue, especially as my employer has devoted a lot of work to help include databases any DevOps culture. However, as I heard recently at SQL in the City, DevOps isn't an excuse to ship more crappy software to customers. That include databases, so as you move forward, perhaps at a quick pace, don't forget to evolve your database in line with well known and well documented database design principles. 2017 has been a good year, and I look forward to 2018. Happy New Year, have a safe holiday, and I'll see you in 2018. 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 ( 5.8MB) 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, and refactor SQL effortlessly 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 tab coloring you’ll never deploy to the wrong environment again. Download your free trial |
|
|
|
| | | David Klee from SQLServerCentral.com In this level of the Stairway to Server Virtualization, learn how to build a Hyper-V virtual machine for SQL Server. More » |
| Additional Articles from SimpleTalk Can you imagine it? You are in a group of smart database people, and they are debating the finer points about AWS DMS, and you don't even know what the letters stand for. You just feel too shy to ask those basic questions that seem ridiculous once you're up to speed. Laerte Junior answers all the questions you need answers for when facing the prospect of getting familiar with Amazon's useful Database Migration Service. More » |
| SQL Clone 2.4 incorporates a new T-SQL script runner that the team can use to mask sensitive or personal data, or to modify security and other configuration settings, prior to creating a clone. More » |
| Brian Kelley from SQLServerCentral Blogs See Part 1 and Part 2. Perfect Practice Makes Perfect I can remember my Air Force ROTC class on communications skills where... More » |
|
|
| | Today's Question (by Steve Jones): 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 2 points in this category: Date computation. 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 | Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy, performing threat analysis, and encrypting sensitive data as a last line of defense against compromise. The multi-layered approach in this book helps ensure that a single breach doesn't lead to loss or compromise of your data that is confidential and important to the business. Get your copy from Amazon today. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): It's the fourth day of Christmas week and fun questions (with one more less point). The question today is who said this? "You want the moon? Just say the word and I'll throw a lasso around it and pull it down." The answer comes from this data set. What's the order by? SELECT TOP 1 answer = SomeName FROM ( VALUES ('Ebenezer Scrooge', 'A Christmas Carol', 'Old', 'Fiction', 'London'), ('Dumbledore', 'Harry Potter and the Sorcerer''s Stone', 'Very Old', 'Fantasy', 'Hogwarts'), ('Frosty', 'Frosty The Snowman', 'Infant', 'Animated', 'A small town'), ('George Bailey', '''s a Wonderful Life', 'Adult', 'Falls') ) AS a (SomeName, Movie, Age, Genre, Locale) ORDER BY Answer: age Explanation: George Bailey is first by age. Happy Holiday Week! » 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. SQL Grouping - I am having some issues with this. There must be something I am formatting incorrectly. I tried summing it in the outer... Enable-SqlAlwaysOn cmdlet used to enable AlwaysOn for a SQL Server service is failing - Hi there I am developing some PS scripts to set up an AlwaysOn availability group. I am trying to use the... Splitting TempDB across multiple files - I have a question regarding the splitting of TempDB in SQL Server, I know its a must in production environments... Table partition - changing column - All, According to the Microsoft documentation you can effectively remove the partition from a table by changing it to just one... suggestion on table order inside a join ? - Hi All, Does the order in which the tables are placed inside a join matter for getting better performance? Assuming, below... Simplified maintenance of columnstore indexes - Hello all, I've just started to use columnstore Indexes in a SQL Server 2016 for a datawarehouse and realized, that it... HashBytes sometimes adds trailing zeroes - Hi, declare @Paper varchar(100), @Value_date datetime2; select @Paper = 'Kotimaiset osakaslainat, kiint.', @Value_date = '2017-11-30'; select CAST(HASHBYTES('MD5', CAST(@Value_date AS char(10)) + ' # ' + LTrim(Rtrim(@Paper))) AS VARBINARY(40)) dv_key ; 0xB54E921E9BF81A19E76D8D15D16AD0 Server Not Responding - Hi Experts, The active server in 2 Node Active\Passive Cluster having another Always On AG node was not responding till we... Unregistered Component Error in SSIS - I can't create any Data Flow Task. Once I create (tested and working) Connection (it doesn't matter if it is... Finding Table Constraints With Column Level Detail - Hi All, Could anyone please advise how to go about finding table constraints down to the column level, to show which... is there a way to auto-gen crud sprocs in ssms 2017? - Is there a way to auto-gen CRUDsprocs in SSMS 2017? For example, a basic User table might just need cookie... What is using the RAM? - Hi everyone, I've been investigating RAM bottleneck on one of my servers, and it looks like the buffer pool is... Login less users in sql ? - Hi All, Today, I came across a term which I wasn't aware of all these days. What is login less... Plan reuse. How to find it out? - Hi All, How can I tell/prove, whenever I run a stored proc or an ad-hoc sql statement in SSMS query... high signal wait and slowness - Running Idera DM and got some alerts for high signal waits and cpu was at 40 (usually 12)%. Found sp... SSIS Exporting to Multiple Excel Files - Hi everyone I have to send invoices to our customers each month which is a time consuming manual process ;( The invoices... Azure SQL DB pulling from on-premises SQL Server via Data Gateway - Hallo I would like to know if and how I could import into an Azure SQL Database pulling data from an... Data-Driven subscription is not sending an Email - Hi All I have setup Data-Driven subscription and this runs fine without any error but not sending an email. 70-473 Anyone studying for this, or passed it? - Hello, I'm studying for this exam, just wondering if anyone else was? Regards, D How can I unencrypted a stored procedure - I got few stored procedures With Encryption for the database that I converted to SQL Server 2000. I need to... |
|
| 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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: [email protected] |
|
|