 | A community of more than 1,600,000 database professionals and growing |
| Featured ContentsFeatured Script |
| Generating Our Own Bad Data I've worked in a few different industries and for a number of companies throughout my life. In almost every position, employees were given goals to improve the performance of the company. Often these were revenue-related goals that were supposed to drive additional sales. The one thing I learned when these goals directly related to sales was that there would always be unintended consequences that might skew business in a way that management didn't expect. This is especially true when the rewards for meeting goals lead to direct compensation for employees. In fact, additional compensation has always led some percentage of the staff to work towards improving their own pay, even with fraudulent or unethical activity. Hopefully this has usually been a small percentage of people, but perhaps that's not always the case. What does this have to do with data and databases? I recently read about fraudulent activity at Wells Fargo, where a sales policy caused a number of problems. Employees used real customer data to open fake accounts in order to meet sales quotas, generate fees, and earn bonuses. While certainly criminal and immoral, this also shows what I've believed for a long time. While computers allow work to take place very quickly, computers also allow mistakes to be made at incredible rates. While these weren't mistakes, the computing systems allowed this fraudulent data activity to take place at a large scale. One that resulted in not only fraudulent charges to customers, but fraudulent reporting to investors, unearned bonuses paid out, likely unearned promotions, and who knows what else. To be fair, this type of criminal behavior could have happened before the age of computers, and likely could have lasted just as long with employees forging paper documents to split accounts, open credit lines, or any other activity. However, I'd hope that computer systems would have detected this sooner. Too detect the bad data, customers really need to be tied into some sort of reporting system that can audit their accounts, that can examine credit bureaus, and warn them if anyone is making unauthorized changes. We have seen similar unintended consequences when companies have offered bug bounties to developers. More bugs appear, and not surprisingly, more bugs are fixed, with more payouts ensuing. I'd like to think that most people would be driven to be professional, but time and time again we find enough of a percentage of employees aren't, and the programs are doomed to failure. We need to do better, though I'm not sure what would help. Protecting data from insiders and outsiders is our responsibility as data professionals. However, insiders can cause more problems, which is why I would hope that the auditing and transparency of data platforms would be a priority for vendors across the next decade. In my mind, not enough attention has been paid to these areas, and our systems are woefully immature in these areas. 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 ( 4.4MB) 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 |  | SQL Clone – create database copies fast! Create copies of production databases and SQL backups in seconds and save up to 99% of disk space using SQL Clone. Redgate’s new tool removes much of the time and resource needed to create and manage database copies, allowing teams to work on local environments to develop, test and diagnose issues faster. Join the beta. |
|  | New Redgate SQL Compare 12 has landed! SQL Compare 12 has landed with a brand new user interface, support for SQL Server 2016, and a wealth of fixes and improvements. Check out this blog post from Redgate's Carly Meichen to hear more about what’s new, why the team have built it, and how. Read now. |
|  | Track schema changes for free DLM Dashboard tracks SQL Server databases to show you exactly what schema changes have been made, by who, and when. You get a full history, with line-by-line differences, and a clear audit trail of your database moving from development to production. Download free tool. |
|
|
|
| |  | Alan Hyneman from SQLServerCentral.com EzAdo is a very simple api built to exploit some new features of SQL 2016. It combines software, convention, and creativity to get more done in less time. More » |
 | Press Release from SQLServerCentral.com This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way. More » |
 | Additional Articles from MSSQLTips.com Stored procedures allow the DBA to automate a certain task by bundling up a query and executing as a single set of logic. This is considerable progress in including more automation, but why not automate the automation? Adam Bertram explains how. More » |
 | SqlBarbarian from SQLServerCentral Blogs I hadn't seen much talk on doing data comparisons on temporal tables, as they are a new feature. I went... More » |
|
|
| | Today's Question (by Steve Jones): I have a simple table: CREATE TABLE TimeZoneOffsetTest ( mytime DATETIMEOFFSET) GO Which of these is invalid for inserting a row? |
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: date datatypes. 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 | SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS. Pick up your copy of this great book from MVP Glenn Berry at Amazon today. |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by M Martin): Given : Declare @tempTable table ( myID smallint, myBit bitdefault 'false' ) ; Insert into @tempTable(myID) values(1), (2), (3), (4) ; Update@tempTable setmyBit=case when myID%2=0 then 'true' end ; When I query the table, what will be the result where the IDs = 1 and 3? Answer: NULL Explanation: a) cannot be true because the BIT field displays 1, 0 , or NULL if nullable, hence not a string. The update statement updated all rows since there is no WHERE clause. For those cases where the expression "myID%2" is not zero, the lack of a else clause in the case statement means that a NULL will be placed into the column for a given row, since an explicit value was not defined. Thus b) is false since the default value of 0 gets overwritten and so c) is the correct answer.
» Discuss this question and answer on the forums |
|
|
| | Greg Ryan from SQLServerCentral.com Running this Script will create a script which recreates all the Logins and adds them to the Server Roles, and all the users for each Database and adding them to the database roles. 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. Total Sum is not Calculating in event of Multiple Clock events - Dear Experts, OT sum is not computing correctly in case of multiple clock events, find below my sql code, example. image... Cannot connect to local instance SQL Server 2014 - since installing SQL Server 2014 I have lost ability to connect to local instance (tried . and <local>) Full error message... SqlQueryNotificationStoredProcedure - Saw multiple stored procedures with names starting like below SqlQueryNotificationStoredProcedure- can anyone help me understand why ? Read that this occurs as part... Bit of a rant - queries on space - Sorry this might be me ranting abit, but am prepared for someone to tell me I am being unreasonable hehe. So... MERGE only when not null - I have a target and a source table where I want to update the target from the source. I have... DECIMAL vs NUMERIC for ID values - We have ID columns with values with up to 10 digits. Those ID's are usually third (and last) segment in... Linked Server query from SQL agent job - Hi, i'm trying to query linked server query from SQL agent job and it's failing with the following error. i'm able to... Huge tempdb log file - in the wee hours of the morning, something blew up our tempdb log file to 170+GB, filling the disk. the... Query to Dynamically Sum Sales Amounts By Month, Quarter, or Year - I have a table with sales information that has a month key associated with each record. What I'd like to... Log Table - Determining Old Value vs New Value - Hi guys Wondering if someone can help me with performance tuning a query I've written. My query 1. pulls a dataset from... SQL help - how to write a query with reference to its own results - Hi, could anybody help me please with this: I would like to write a query which retrieves this information: id... Speeding Up Delete's on Large Databases - Hi, I'm currently trying delete data from a large database with the below code... But its taking quite a long... Assigning a record count to a variable for comparison purposes - Hello I have a package that I use to load data To load and compare counts, I'm using a foreach loop This basically... script task being completely ignored - I have a server with SQL Server 2016 on it, using SSDT 2015, and I have tried using project deployment... Time is an hour out!!! - I think that this is likely related to the rescent change in my timezone from BST to GMT on Sunday... Check Database Integrity uisng maintenance - My Database Integrity job that i created through a maintenance is failing without giving a clear error message.What could be... Database in Recovery Pending State - One of my databases is in [b]Recovery pending[/b] state. I tried to run an Alter command on the database to... Show data upto 2 decimal places but with exact values - Hi all, I would like to show the data upto 2 decimal places but without rounding off the integers. If the... Easy way to search for a string any where within XML column? - Is there a really easy way to search for a string in an XML column? All the examples I come... Potential presentation idea: The magic of checklists - This morning, I was sitting down with one of my co-workers, going through a procedure. He was referring to a... |
|
| 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 |
|
|