Security Across Databases with Cross-Database Ownership Chaining (2019-12-11)

 SQLServerCentral Newsletter for December 11, 2019 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Stairway to SQL Server Security Level 7: Security Across Databases with Cross-Database Ownership Chaining]( - [Analyze and Improve SQL Server Backup Schedule]( - [Take the 2020 State of Database DevOps Survey – win a new iPad]( - [Free eBook: Defensive Database Programming]( - [From the SQL Server Central Blogs - Error message: (0x80131904): Conversion failed when converting the varchar value ‘NULL’ to data type int.]( - [From the SQL Server Central Blogs - Information Measurement with SQL Server Part 4.7: The Bhattacharyya and Hellinger Distances]( Question of the Day - [Making a Matrix]( The Voice of the DBA  Finding Your Own Career Building a career is hard work. It takes time and focus to move along a path that you choose for yourself. What I have seen across a few decades of work is that most people don't bother to find a path, and are happy to wander from job to job, finding new positions or projects when they are forced to do so. As much as I advocate for others to continually learn, there's nothing wrong with wandering randomly through a career, sticking with a job or employer as long as you can. The one thought that I'd like to see everyone adopt is a conscious decision to do so. Make the choice to have the career you want, and the life you want, whatever that is for you. Recently on Twitter, there has been a lot of career advice that I've seen posted. One very interesting item was that a developer shouldn't compare themselves to anyone else. They should be proud of what they've done and work towards the goals and achievements that mean the most to them. Good advice, but often hard to follow. Most of us only see a fraction of the world, and a limited view of potential opportunities for languages, projects, positions, and skills. We often do look at others' accomplishments and then try to model ourselves in some way to be like others. Not completely but we may choose to learn a skill another has, or pass a test that someone else completed, or maybe go work for the company that a colleague has enjoyed. There's nothing wrong with that. Think about what others do and decide what aspects of that you'd like to adopt. As much as I've coached others to think for themselves, make their own decisions, and be proud of the things they accomplish, I also want them striving forward. That often requires a goal and an ideal, which we often find in others we admire. Compare yourself to others, but don't judge yourself by their standards. Decide on your own if you're living up to the measurements that make sense to you. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums]( [Redgate Data Masker](   Featured Contents [Stairway to SQL Server Security]( [Stairway to SQL Server Security Level 7: Security Across Databases with Cross-Database Ownership Chaining]( Don Kiely from SQLServerCentral.com Sometimes you need to reach outside a database and access data and objects from multiple databases, which raises some security issues and increases the complexity of data access. In this stairway level, you’ll learn about cross-database ownership chaining so that you can reach across database boundaries securely. [Analyze and Improve SQL Server Backup Schedule]( Additional Articles from MSSQLTips.com Daily Operations | Database Backup Schedule | Time Savings - In this tip we look at a script you can use to help you better schedule when SQL Server backups are run so there is not contention with backups running on multiple instances at the same time. [Take the 2020 State of Database DevOps Survey – win a new iPad]( Additional Articles from Redgate Redgate’s 2020 State of Database DevOps Survey is open now. Share your views on Database DevOps today for a chance to win a new 65GB iPad Air. Plus, for every entry, Redgate will donate $1 to UNICEF. Take the survey now. [Free eBook: Defensive Database Programming]( Press Release from Redgate Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment. From the SQL Server Central Blogs - [Error message: (0x80131904): Conversion failed when converting the varchar value ‘NULL’ to data type int.]( Kenneth.Fisher from SQLStudies I love this error. Primarily because it demonstrates two very important things. Errors matter. Make sure when you ask someone ... Continue reading From the SQL Server Central Blogs - [Information Measurement with SQL Server Part 4.7: The Bhattacharyya and Hellinger Distances]( SQLServerSteve from Multidimensional Mayhem By Steve Bolton …………Over the course of this segment of the series, we’ve slowly assembled a classification system for some distances measures that can be used for DIY data...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Making a Matrix I have this data frame: > passing.2019 Player Yards TD INT 1 Rivers 2609 12 7 2 Brady 2535 14 5 3 Wilson 2505 22 1 4 Stafford 2499 19 5 5 Rodgers 2585 17 2 I want to convert this to a matrix. How do I do this in R? Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Steve Jones - SSC Editor) What's a page split? What is a page split in SQL Server? Answer: When a row is updated and the total data on the page exceeds 8kb. Some rows are moved to a new page Explanation: A page split is when data is updated to be larger. If the update causes the data on the page to exceed 8kb, some rows are moved to a new page. This is a page split. Ref: What is a page split? - [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 - Administration [Always on in standard and enterprise edition]( - Hello everyone! I would glad to know, what is the difference in Always on between Standard and Enterprise edition? And also there is something that change in 2012 and above? Thanks! [Migrating DB encrypted by master key]( - I'm migrating DBs from a 2008 R2 instance onto a 2017 instance. I have one DB that is encrypted by the master key, how do I migrate this successfully across to a new instance? [Log Shipping - What has changed]( - We currently have a situation with a vendor where they will only give us access to our data via 5 minute log ship files that we import into our read only db. this is fine for most queries, but we need a way to get details about what has changed in each period in the […] SQL Server 2017 - Development [Insert in batches using select coalesce option]( - Hi, I am trying to insert multiple tables data into one table using Insert in batches and with select coalesce. I am getting Ambiguos column (id) error. Can some one please help me to resolve the issue. Thank You. ERROR MESSAGE: Msg 209, Level 16, State 1, Line 26 Ambiguous column name 'id'. Line:26 - […] [Fastest Way to Calculate Total Number of records inserted per day]( - Hi, I need to show a number of records per day in the dashboard of the web application if the user reload the page the count will automatically be updated. Initially, we don't have any problem as the records grow to the millions of records the query execution takes slow. The following is the query […] [Fastest way to query Millions of records with Pagination and Total Record Count]( - HI, We had a table that contains a huge volume of data inserted per day it contains millions of rows. Currently, we had 2 million records in staging but once we hit the production the data will be easily more than 10 - 20 million rows Previously we had a pagination query that took more […] SQL Server 2016 - Administration [changing db owner with always on replication (to fix DB properties window)]( - SQL Server 2016 standard edition, with primary databases and one other server set up as secondary failover with always on availability group. There were some issues over the weekend with an application that accesses the databases on this server, unbeknownst to me, they decided just to reboot the database server, which seemed to clear things […] [What\'s the best way to keep a record of all records inserted via an SP call?]( - Hey guys, so I may be overthinking this but basically, I have a bunch of stored procedures which I want to begin keeping historical track of. I want to know which records were updated by which SP & when, and I'm just looking for the best way to do this. Is there any built in […] [Impact value about missing indexes]( - is there relation between Impact from sys.dm_db_missing_index_group_stats and Impact from cache plan? Thanks for all.  [I can't Uninstall SQL Server 2016]( - Hi, I have SQL Server 2016 installed in my machine but I can't uninstall it, it doesn't appear on my Control Panel, I looked again using CMD wmic, product get name, it also doesn't appear. But I can see it, SQL Server on the services and SQL Server Configuration Management. I also tried using CMD […] SQL Server 2016 - Development and T-SQL [BCP utility]( - Hi All I am trying to export some data from a SQL server database to a CSV file. As I need to do this for around hundreds of records, I am using a cursor to loop through and creating dynamic file names to write individual files. This seems to be working ok. Some of the […] Administration - SQL Server 2014 [Trouble connecting in single user mode]( - I have an SQL server which I need to get admin access to. Logged on as administrator to the server I attempt to start in single user (-m) mode. However in this case, instead of dropping into single user (as on other servers in this project), I get a screen full of continuous login failures […] Development - SQL Server 2014 [How to get information about an AG group using powershell]( - Hi Experts, Does anyone has a powershell script which displays below information: for a given AG listener name or AG group name, I need to get Listnener name, AG name, replicas , replica role desc , Can we get this information using pure powershell which reads registry values or do we need to execute a […] SQL 2012 - General [SQL Monitoring]( - Hi All, I have SQL 2012 instance on a vm server which I am testing with Red Gate Monitoring Tool installed on my machine and my machine machine is set a base monitor for testing purpose. Problem I am facing is that it only monitor while I am logged on to the machine. If I […] Strategies and Ideas [Tracking History in Fact Table]( - Hi, I was hoping somebody would be able to offer advice in relation to tracking history in a fact table, in particular whether #2 below would be a viable option? I would have thought that #1 would be bad for performance given the volume of records created through history so maybe not best practice?. If […]   [RSS Feed]([Twitter]( 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. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -