Stairway to U-SQL Level 19: Azure Data Lake Metadata with PowerShell (SQLServerCentral 3/7/2018)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [Stairway to U-SQL Level 19: Azure Data Lake Metadata with PowerShell]( - [Free eBook: Understanding SQL Server Concurrency]( - [Questions About Data Breaches that You Were Too Shy to Ask]( - [SQL Provision adds fully integrated data masking]( - [Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances]( (From the SQLServerCentral Blogs) - [How to Move Master Database to Another Location – SQL Server On Linux]( (From the SQLServerCentral Blogs) The Voice of the DBA A General SQL Server Crossword See if you can solve this crossword puzzle based on SQL Server. Across 4. Return all rows on the right, and only the matches on the left. 5. The loop everyone loves to hate. 7. Someone else's machine. 8. Feature that can be used to keep a single table synchronized between one database and another. 10. Make sure your database isn't corrupt. 11. Alias 13. Remainder only. 15. Encrypt a column without revealing the encryption keys to the Database Engine. 17. a.______.c.d 20. Can be a table, part of a table, SP, View etc to be syncronized. 23. Time to be back up. abbr. 24. Force a query plan. 26. a.b.c.______ Down 1. Update data on NodeA; Data goes to NodeB & NodeC. Update data on NodeB; Data goes to NodeA and NodeC etc 2. The last thing you should try when repairing a corrupt database. 3. One SQL instance talking to another. 6. Without this SA is disabled. 9. 0x02 12. A group of servers working together. 14. A stored procedure is an _______. 16. 8 to 128 characters, at least 3 of 4 (upper, lower, number, symbol) 18. Instance that keeps an eye on articles for changes. 19. Can be an initial copy of the data. 21. You can have more than one but SQL is only going to use one at a time so most of the time it's really pointless. 22. Auto incrementing number. 25. Get the output as XML. Kenneth Fisher from [SQLServerCentral.com]( Join the debate, and [respond to today's editorial on the forums]( ADVERTISEMENT [SQL Prompt]( Become a more efficient SQL developer with SQL Prompt Learn how to write SQL faster and more efficiently with these exclusive short videos from Data Platform MVPs and SQL Server experts. With SQL Prompt you can strip out the repetition of coding and write SQL 50% faster. [Check out the tips]( [ReadyRoll]( Database migrations inside Visual Studio Feeling the pain of managing and deploying database changes manually? Redgate ReadyRoll creates SQL migration scripts you can use to version control, build and release, and automate deployments. [Try it free]( Featured Contents  [] [Stairway to U-SQL Level 19: Azure Data Lake Metadata with PowerShell]( Mike McQuillan from [SQLServerCentral.com]() Need to inspect your Data Lake objects and files? Want to automate the process? Find out how with PowerShell.[More »]( ---------------------------------------------------------------  [] [Free eBook: Understanding SQL Server Concurrency]( Press Release from [Redgate]() When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.[More »]( ---------------------------------------------------------------  [] [Questions About Data Breaches that You Were Too Shy to Ask]( Additional Articles from [SimpleTalk]() News reports about data breaches are common occurrences. Even the companies that exist to keep our data safe are not immune. William Brewer answers the question about data breaches that you may be too shy to ask.[More »]( ---------------------------------------------------------------  [] [SQL Provision adds fully integrated data masking]( SQL Provision launched in January, offering users blazingly fast database copying, with a light storage footprint, centralized management, and the ability to mask any sensitive data, prior to distribution. This new release takes compliant provisioning one step further, by integrating data masking directly into SQL Clone’s image creation process, rather than running it as a separate step prior to the image creation.[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances]( Rob Sewell from [SQLServerCentral Blogs]( For the last couple of months members of the dbatools team have been working on a new PowerShell module called dbachecks....[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [How to Move Master Database to Another Location – SQL Server On Linux]( Dharmendra Keshari from [SQLServerCentral Blogs]( With the release of SQL Server 2017 CU4, you can use the mssql-conf utility to move the master database file...[More »]( Question of the Day Today's Question (by Steve Jones): I have these two data frames: > passing.2016 rank player.name year yards2016 trailingyards 1 1 Drew Brees 2016 5208 0 2 2 Matt Ryan 2016 4944 264 3 3 Kirk Cousins 2016 4917 291 4 4 Aaron Rodgers 2016 4428 780 5 5 Philip Rivers 2016 4386 822 > passing.2017 rank player.name year2017 yards2017 trailingyards 1 1 Tom Brady 2017 4577 0 2 2 Philip Rivers 2017 4515 62 3 3 Matthew Stafford 2017 4446 131 4 4 Drew Brees 2017 4334 243 5 5 Ben Roethlisberger 2017 4251 326 I want to combine them on the player name to find the matches. Which of these will return me a data frame with only two rows? 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: R Language. 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 have a database, named Accounting, that is encrypted with TDE. After a few years, I realize that my certificate is expired. I create a new certificate on my instance with this code: CREATE CERTIFICATE NewTDECert WITH SUBJECT = 'My Valid TDE Certificate'; go What code do I execute in the Accounting database to rotate the new certificate into my TDE database? Answer: ALTER DATABASE ENCRYPTION KEY ENCRYPTION BY SERVER CERTIFICATE NewTDECert Explanation: The ALTER DATABASE ENCRYPTION KEY DDL is used to change the encryption to a new certificate. Ref: ALTER DATABASE ENCRYPTION KEY - [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](. --------------------------------------------------------------- [SQL Server 2017]( : [SQL Server 2017 - Administration]( [Print .SQL certificate files (.MK, .CER and .PK) on PAPER for long term storage in vault]( - Hi Guys, Did anyone find a way to print .SQL certificate files (.MK, .CER and .PK) on PAPER for long term... [Always on and SSISDB]( - Hopefully someone more knowledgeable than me can help with this one. I am building out a SQL 2017 Always on availability... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Administration]( [Restrictions Regarding High Availability Groups]( - We have two databases, one is 10TB in size and one is very highly transactional. Both have been dismissed as... [Upgrade to 2014 or 2016]( - Dear DBAs I hope you guys are doing great My company is planning on upgrading all 2008 R2 database servers... [Help me in designing table and its indexes]( - [Always encrpted and user defined datatypes ????? throwing error.]( - Hi All, We are doing a POC on SQL Server 2016 new security feature Always encrypted. Basic need is encryption over wire.... [Verify backup files. How much does it help?]( - Since I start my DBA career, as the best practice, I always verify backup to make sure it is complete... [SSD server with 1 logical drive]( - We are looking to upgrade to a solid state drives only server. It will be raided. Does it make any... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Development and T-SQL]( [Fill in gaps between 2 dates]( - Hi All, Need some help in filling up gaps between 2 dates. Scenario : I have Product Location balance snapshot for specific dates ... --------------------------------------------------------------- [SQL Server 2014]( : [Administration - SQL Server 2014]( [Shutting down a Virtual Machine running SQL Server]( - We had an impending power outage the other night, and I was in a rush to shutdown all of the... --------------------------------------------------------------- [SQL Server 2014]( : [Development - SQL Server 2014]( [Same query different actual execution plan]( - I guess I could summarise my question by asking if a query plan is created based on available resources. Here is... [Datatype Change]( - Changed one of the existing column datatype from varchar(250) to nvarchar(250) but the column still showing arabic characters as ?? How... [How does SQL Server handle concurrent operations?]( - Hello, We are having an issue which I suspect is database related. We have a web application on which we can... --------------------------------------------------------------- [SQL Server 2012]( : [SQL 2012 - General]( [Trying to get an SFTP process for SSIS]( - Hi,  I have been looking all over the web for this. I realize that SSIS does not, on its own handle... --------------------------------------------------------------- [SQL Server 2012]( : [SQL Server 2012 - T-SQL]( [Parse a string help]( - I have a string that I need to parse. The text will vary but the format always the same. Example Text: ... [Manipulate a field that contains a specific format]( - Hi, Please can anyone assist with my SQL problem? Here's an example of the contents of a single field: abcdef 01/01/2018 08:15:13 This is... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 - General]( [SQL Agent Job - Carry on Failure]( - Hi I have script that I run to fix orphaned user accounts on a instance - If I run the script in... [Script Out Database Mail Settings?]( - Anyone bother to have created a script to Reverse Engineer / Script out your EXISTING database mail settings? I set up a... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 Administration]( [dbWarden questions]( - Hello -- I am trying out the dbWarden application by running it within the 2008 Standard R2 SQL Studio application. It... --------------------------------------------------------------- [SQL Server 2005]( : [SQL Server 2005 General Discussion]( [Implementing FULL-TEXT Search in a Google fashion!]( - OK, my first post on a subject I startd learning a couple days ago! SQL2K5 Full Text Search! Right....creating the FTS... This email has been sent to {EMAIL}. 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