 | A community of more than 1,600,000 database professionals and growing |
| Featured ContentsFeatured Script |
| | Dexterity Matters I typo things. I make mistakes in the QOD, checking the wrong box. Even in a browser at times there's a button or hot area too close to the bookmarks bar and instead of completing an action, like checking my VSTS control panel, I'll end up on some other website. It's really annoying, but it's also an issue that occurs when my muscle memory takes over with my fingers not moving as expected, or moving quicker than the system expects. In Star Trek or media, we see these flat, touch interfaces similar to smartphones, but there's never any mention about the missteps or mistakes that could be made by users selecting the wrong item. As we move further from hardware controls to software selections, are we worried about issues? Is this something we run into with our interfaces? I certainly think so. No matter how often I can do something correctly, I make mistakes. Often simple mistakes, born of impatience. This is especially apparent in Azure and online interfaces where the control, or the browser, might not respond as quickly as I expect. As a result, I might click something multiple times, spawning more actions than I expect. Or I might have an unexpected action occur. This is one of the great arguments from me for having local software. The interface interactions tend to be more reliable and expected. If nothing else, a local process can allow control of the input buffer, discarding or limiting the multiple clicks that cause issues. As we move forward, software designers should expect that users will make mistakes and ensure there are ways to cancel or undo accidental mistakes made in an interface. This isn't always possible, and certainly there are some actions that might not be easily undone, but as we become more dependent on software, we need to consider the potential mistaken actions that users will make and provide methods to correct issues. Especially where data is involved. 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 ( 3.0MB) 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 |  | | Patterns & Practices for Continuous Delivery for Databases Interested in working towards continuous delivery for your databases to reduce risk and make releases more efficient? This collection of articles covers every major checkpoint on the journey from version control to release management. Find the full library on Simple-Talk. |
|  | | How to find & fix SQL Server problems – get 26 free tips Protect yourself from the most common causes of SQL Server pain, with this series of 26 free tips. Covers the hows and whys of monitoring, with practical advice and worked examples. Sign up now. |
|  | | 9 must-have SQL Server tools The SQL Developer Suite contains 9 tools for faster, simpler SQL Server development. Download a free trial. |
|
|
|
| | |  | Andy Jones from SQLServerCentral.com This article looks at using triggers to audit and to prevent the performing of unintended actions. More » |
 | Additional Articles from SimpleTalk To be able to make full use of the system catalog to find out more about a database, you need to be familiar with the metadata functions. They save a great deal of time and typing when querying the metadata. Once you get the hang of these functions, the system catalog suddenly seems simple to use, as Robert Sheldon demonstrates in this article. More » |
 | Grant Fritchey from SQLServerCentral Blogs You can’t query across databases in Azure SQL Database… or can you? Let’s check. I’ve created two new databases on an... More » |
| | Arthur Olcot from SQLServerCentral Blogs 3 years I was awarded the MCSE: Data Platform certification and as per the recertification rules, I needed to recertify... More » |
|
|
| | | Today's Question (by Steve Jones): I am working with Row Level Security and have a function that determines if a particular user should have access to rows in a table. My function looks like this: CREATE FUNCTION DBO.RLS_Customer_Check (@username AS sysname) RETURNS TABLE WITH SCHEMABINDING AS RETURN SELECT 1 AS RLS_Customer_Check_Result WHERE @username = USER_NAME() GO I have a table, CustomerAccessList, with a column for CustomerID and UserName. I add a filter predicate as follows: CREATE SECURITY POLICY rls_CustomerFilter ADD FILTER PREDICATE dbo.rls_customer_check(customerid) ON dbo.CustomerAccessList; GO The bsmith user can only view the rows that have "bsmith" in the username column. The current table looks like this: CustomerID UserName ---------- -------- 1 bsmith 2 sjones 3 bsmith What happens when bsmith runs this batch? INSERT dbo.CustomerAccessList ( CustomerID, username ) VALUES ( 5 -- CustomerID , 'sjones' -- username ); select * from CustomerAccessList |
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: Row Level Security (RLS). 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 | | The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI - This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. Get your copy from Amazon today. |  |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have a list of numbers in a table, some positive, some negative. MyID ------ 117 18 120 NULL 120 -120 52 -118 I run this query: SELECT myid FROM dbo.myGroups AS mg GROUP BY mg.MyID HAVING MIN(SIGN(myid)) = MAX(SIGN(myid)) If there are these 8 rows in my table, how many rows are returned by the SELECT query?
Answer: 6 Explanation: The SIGN function returns a -1, 0, 1, or NULL value. The MIN() and MAX() functions are aggregates, therefore the NULL is eliminated. In this case, each sign for a MYID will return one of the 3 values. However the GROUP BY will group duplicates together, of which there is only 1. Therefore if we eliminate the duplicate and the NULL, we get 6 rows returned. Ref: SIGN - https://msdn.microsoft.com/en-us/library/ms188420.aspx GROUP BY - https://msdn.microsoft.com/en-us/library/ms177673.aspx
» Discuss this question and answer on the forums |
|
|
| | | Aksel Rohtsalu from SQLServerCentral.com add your info here: set @email_profile_name = '<email profile name>' ; set @email_recipients = '<email recipients>'; & run script 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.
Understanding Implicit_Transaction on - INSERT block SELECT - why? - Hi all, I am not sure if this is normal, i tried googling but have never found a similar thread in... Understanding Implicit_Transaction on - confusing behaviour - Hi all, I do not want autocommit, as i am afraid of making mistakes. So i set implicit_transactions on , but i did... Page Compression - Dear Experts is any one has a script that makes a page compression for all tables in a database I have tried... Restoring backup from different media set - possible ? - Hi all, I am abit confuse with the terms media set / media family etc .. If I am to set my backup...
OMG - What have they done to Stored Proc Scripts??? - Just upgraded to SQL 2014 development environment. Please tell me how I can convert back to the old way of... Insert Performance Issue From Temp Table - Good Afternoon Guys, I would like to ask is there a way for me To Optimize the way i insert My...
I should buy Addy focus Brain Booster - Experiencing problem in your understanding as well as intending capability? Certainly, individuals are blessed to have cerebrum pliancy-- capability to... Boost Metabolic Level & Wellness - Probiotics are liable to nurture the GI tract of people with advantageous digestive tract germs that additionally promotes bowel uniformity... Bio X4 Review Know more about its ingredients - Bio X4 is formulated by Nucific Inc. which is located in Tarzana, The golden state, based on the main concept... Bio X4 Review-Know more about its ingredients - Probiotics are liable to nurture the GI tract of people with advantageous digestive tract germs that additionally promotes bowel uniformity... Bio X4 Review- Know more about its ingredients! - Bio X4 is formulated by Nucific Inc. which is located in Tarzana, The golden state, based on the main concept...
Addy Focus- Study harder, play better and work longer - Having an expanded center as well as Focus level is issue of take pride in. Also, Addy Focus supplies you... Need help with datatype Time conversion - Hello All, I have source table with column nvarchar(20). the data looks like below. [b]Duration[/b] [b] 120:06:31.150 120:06:31.165 238:21:19.875 266:45:41.472 287:03:25.184 [/b] I...
Intermittent poor query performance - Hello, each week a process is ran from the front end system that sometimes will take at least twice as... SQL 2008 database replication - Dear all, we have an installation with sql 2008 express, without Internet connection. What we need is to replicate the database... Finding months in incremental fashion - Hi people First of all thank you for your help yesterday; however, I would like to continue with the problem that... SPSS .SAV File - How to open from SQL Server - I have a ".Sav" file in SPSS (Statistical Package for the Social Sciences). I'm trying to read the data using...
SQL Server 2012 and Azure Backups - Hi I'm very new to our Azure cloud SQL Server 2012(Standard Ed) instances in the cloud. I have regular SQL...
Using SQL Switches in a PowerShell Script to Suppress Headers - Hi, I'm new to using PowerShell to process a SQL Query. The query that I'm trying to process is from the...
format changed ? - Hi all i am trying to upload excel, but there were some issues so changed to CSV.Now when i connect to... |
|
| 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 |
|
|
