| A community of more than 1,600,000 database professionals and growing |
| | On-Time, or Not Today we have a guest editorial from Andy Warren as Steve is on vacation. I’ve found people fall into one of two camps; those that are on-time for appointments and those that aren’t. Or perhaps said more accurately, those that believe being on-time is important and those that see it as the beginning of a window of arrival that closes when they arrive. Logically it seems like the whole point of setting a time is to actually meet at that time – thus why we all tend to rant about waiting on the doctor and the cable guy. If only it were that simple! I learned about being on time in the military. Rather than some complex set of inferred rules about which appointments matter and which don’t, they treat all appointments like they all matter – because sometimes it really matters, and the best way to get that behavior is to make it the standard. Being late in the military is a good way to get the immediate and undivided attention of a leader and not in a pleasant way. For better or worse, that’s part of me now. When I say let’s meet at 10:15, that’s what I mean. You show up at 10:16, or 10:17, or 10:18, that’s fine. 10:20? I’m mildly annoyed? 10:30? Really annoyed, and so on. If that seems unreasonable (you late arrivers!), you can at least see how and why it grates on me a little! It took me a while to understand that not everyone sees it that way. I have more than one friend that will show up 15-20 minutes late every single time we have lunch. I think it’s more about time management and not so much about caring about being late, but the net is the same – they are late. Some are apologetic, some not. It’s who they are and I adjust to that. I either order at the scheduled time or plan a longer lunch. It took me a while as a person and a manager – a long while – to figure that out. There were places I could flex and hurt nothing (when someone got to the office, lunch with a friend) and places where I wasn’t going to flex (the start of our weekly meeting). If I had to wait a few minutes on someone, it was usually OK because I would always bring something to read or work on, but it wasn’t OK to keep a group waiting. If you have a looser definition of on-time than I do, all of the above might strike you as pretty uptight. I get it. I’m not saying you have to change. This is just another piece of the puzzle when dealing with people. Whether you agree with that view or not, you have options; you can arrive on time, give a reasonable window for arrival, arrive not quite as late as usual, or not worry about it at all and accept whatever consequences that might arise from it in the worst case. And obviously the reverse applies to those of us that put more value on being on time. While writing this, I was thinking about my friend, Don Gabor, teaching me about adapting to the conversational styles of other people. It’s hard enough to just carry on my side of the talk; it felt three times as hard to try to map what I wanted to say into the style that the other person found most comfortable. Why go to the extra effort? I’m probably badly paraphrasing his response, but it was along the lines of “it increases the chances you’ll communicate effectively”. It always takes more effort to meet someone halfway, but it’s often well worth the effort, whether it’s conversation style, code commenting, or being on-time. Andy Warren from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT | | | Are these databases the same? With SQL Data Compare, you can compare two databases to check for differences in the database contents. If there are differences, you can synchronize the data without leaving SQL Server Management Studio. Try it free. |
| | Relieve your database delivery pain points How can you make the delivery of databases more visible, predictable, and measurable? Grant Fritchey explains some of the secrets in this article on database continuous integration. Read now. |
|
|
|
| | | Tim Wellman from SQLServerCentral.com The processing of the Transaction Log seems simple to reproduce, but be sure you consider all the possibilities. More » |
| Additional Articles from MSSQLTips.com As you develop, test and deploy SSIS packages, you need to specify different parameter values for things like database connection strings, file and folder paths, etc. without having to edit the individual SSIS packages to make these changes. Ray Barley looks at how you can accomplish this goal by taking advantage of the configuration capabilities that SSIS provides, in particular the SQL Server package configuration. More » |
| Ryan Adams from SQLServerCentral Blogs Have you ever had the need to query Active Directory right out of SQL Server using native TSQL? There are... More » |
|
|
| | Today's Question (by Steve Jones): I have this code: CREATE TABLE DDM_Questions ( myemail VARCHAR(300) MASKED WITH (FUNCTION='email()') ) GO INSERT dbo.DDM_Questions ( myemail ) VALUES ( '@dog.com' -- myemail ); GO CREATE USER ddmtest WITHOUT LOGIN; GO GRANT SELECT ON dbo.DDM_Questions TO ddmtest; GO EXECUTE AS USER = 'ddmtest' SELECT * FROM dbo.DDM_Questions; GO What is returned from the final SELECT? |
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: Dynamic Data Masking. 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 | Professional Microsoft SQL Server 2014 Integration Services The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and much more. The increased functionality will streamline your ETL processes and smooth out your workflow, but the catch is that your workflow must change. New tools come with new best practices, and Professional Microsoft SQL Server 2014 Integration Services will keep you ahead of the curve. SQL Server MVP Brian Knight is the most respected name in the business, and your ultimate guide to navigating the changes to use Microsoft SQL Server Integration Services 2014 to your utmost advantage. Get your copy from Amazon today. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| |
| | Richard Rozema from SQLServerCentral.com Description: When a record with the same primary key value(s) is inserted on 2 databases at the same time that communicate through merge replication, a pair of conflicts 5 and 6 will occur: Both copies can not be transfered to the database that already holds the other copy. The only feasible way to resolve this is to remove one copy and have the other copy re-replicated to make it available in all locations. Usually it is arbitrary which copy is maintained, so we pick the easiest method: delete the copy on the hub (= upload failed) and have the copy on the publisher sent out to all hubs (most hubs will already have the publisher's copy). Limitations: 1 - As presented this process only fixes conflicts due to primary key conflicts (dbo.msmerge_conflicts_info.reason_code = 2627). A type 5 and type 6 conflict however occurs also when a 'duplicate key value cannot be inserted into ...' (reason_code = 2601). The script can easily be adapted to fix this situation. An example on how to adapt the code is in the inline comments in the code, but it is not further explained. 2 - A complication can occur when a foreign key exists referencing the row to delete. Although the value will 'come back' once the conflict is resolved, we need to delete it with the referencing values still in place. Merge replication can do so because it ignores all foreign key constraints, but for us the best way to do so is to temporary disable the foreign keys. Don't forget to re-enable those constraints when you're done! A separate script must be used to disable/enable a table's foreign keys if you encounter this issue. 3 - The script generated can be longer than the default maximum column width in SSMS. For this reason the code is generated for xml path(''). Please make sure your SSMS query window is set to allow for 'Unlimited' XML output. Plus make sure it returns the results in Grid mode so you can double click the output line to open the code in an xml window, preserving line breaks and such. The way this works: - You've encountered in Conflict Viewer a replication conflict of type 5 and/or type 6. Leave the Conflict Viewer open at the point you've reached so far, you'll need it again at the end of this procedure. - Run this script on the publisher to generate from the replication conflicts a statement that can be copied to and run on the subscriber(s). Run the generated script (unaltered) on each hub that has at least one conflicting row (the name of the conflicting hub is listed in the generated script). - Once you've verified that the hub has indeed one or more of the conflicting rows, you can alter the generated script from a select statement into a delete statement: simply comment the line with "--select *" and uncomment the line with "--delete" and run the delete statement on this hub. If a foreign key exists, the delete will fail and you'll have to disable the foreign key before retrying the delete. And enable it after the delete (without checking the existing values!) - After you've deleted all conflicting rows from the tables on all hubs you can go back into Conflict Viewer and click 'Submit winner' on all 'download' conflicts for this table and click 'Remove' on all 'upload' conflicts. More » |
|
|
| Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums. newhealthsupplement.com/testo-rpm/ - [url=http://newhealthsupplement.com/testo-rpm/]Testo RPM[/url] :- On the off chance that you'd need to educate every body-part once every week, or twice, choose. In... Connecting to Server - Dear all, I have observed that in our 2 node cluster having 3 instances i can connect to instances 1 & 2... Importing Adventureworks to AWS RDS - Hi All New to SQL server and trying to import AdventureWorks sample DB to AWS RDS. Any ideas? Thanks Mutiple file groups - Hello Experts, we are embarking on the design of a SQL Server infrastructure for a VLDB which will grow to about... Understanding sys user / schema - Hi all, I am puzzled by "sys". -- use testdb; In a testdb database -> security -> users -> i saw sys. In the... Permission - start/stop sql agent jobs (only few jobs, not all) - What is the best way to provide access to run few sql agent jobs on an instance with out granting... TSQL Dynamic columns and SUM at the end - Hi! I have my tsql dynamic query which is functional and it works. However, I dont know how to add SUM... MSDTC / AlwaysOn - We just implemented Always on for a couple of servers, and I am getting the following error when trying to... Finding retention of a person - I would like to ask if anyone would be able to help out with this. I would be more than... indexes-non clustered - hi all how to sort non clustered indexes ? any suggestion on this Grant user with read only access to all user DBs - I have about 1917 databases in the server. I have already created the login for users. All users need is... Server performance - Hi All, I have issue with my application servers ( 3 servers) that looks very busy at around 9 PM almost everyday... arranged before me that I understand - [url=https://www.fresharts.org/portfolios/man-city-vs-man-united-live-st-reamingmanchester-derby-onlinewebcast-03-20-2016]Man City vs Man United Live Streaming[/url] Order When Exists - Hi I have a table with some data, this table stores times from several points for each stage (it's a bike... Looping and scalar value - Hi No doubt this is standard behaviour I should already know about, but I'm a little unclear about it. The example... Tlog file full..No space to ru Backup log statement - Good morning Experts, Transaction log file is full. I cannot even issue backup log command as there is no space at... Identifying records that are duplicates with the exception of one column - Hi, We are trying to clean up some data in an old database which unfortunately contains various duplicate records. In this particular... Error when I click on View Report button. - I have a report that is calling data from our data warehouse server. It has been working fine 'till today,... How to get output of sp_help_revlogin into Separate Excel File - How to get output of sp_help_revlogin into Separate Excel File?or any other option to get output to different file REFRESH PRODUCTION DB to DEVELOPMESQNT - HI Friends; I have a database in production which needs to be backedup and restored on Development box. THE PROD and... |
|
| 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 ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com |
|
|