SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

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 {user_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