| A community of more than 1,600,000 database professionals and growing |
| | | Have you ever given up on your brainchild On Mother’s day*, as I was thinking about my mother and her efforts in raising me, I realised that no matter how hard it is to raise a child, mostly every mother struggles and never gives up on her child. Thankfully, that was the case in my life; and I am very grateful to my mother for her hard work and dedication in making me who I am today. As I continued thinking, I realised that the same applies in our field of work or sometimes in our personal lives. We all come across times when we have an idea (our brainchild), which we believe is unique and would delivery best results when put into action. As SQL developer/analyst, I have many a times come up with unconventional approaches, which have helped me a lot in serving the businesses that I have worked for. Needless to say, those ideas have also helped me to grow in my field; and I have also enjoyed my share of fame and rewards. However, there have also been times, when I had to give up on my ideas (or brainchildren) because : After some investigation, realised that the technology was not ready (or maybe it was my limited knowledge of the technology) My manager/team weren’t ready to afford it (in terms of time and money) The idea wasn’t as good as I had anticipated initially. In one rare instance, I had to give up just because my manager wasn’t happy that it was my idea and not his. Though every rejection brought some disappointment, I made sure not to stop being creative at work. Out of curiosity, I would like to know how many of you have ever given up on your brainchildren at work? If so, what were the reasons? Please also let me know how you felt when you couldn’t convenience others ? * - In the UK, Mother's Day was on 26th March 2017. Nitin Bhojwani from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT | | | | The industry standard for comparing and deploying SQL Server database schemas Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial. |
| | | | State of Database DevOps Report Learn how teams are extending DevOps practices to SQL Server databases. Get the report. |
|
|
|
| | | | | Viacheslav Maliutin from SQLServerCentral.com In my project I see that people writes different things with EXISTS logical operator (EXISTS (SELECT StarOrOne FROM...)). They are "*", "1" and even "TOP 1 1" or "TOP 1 *". The aim of this article to give a good explanation which option is the best. More » |
| | To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage. More » |
| | Jerod Johnson from SQLServerCentral.com This article demonstrates using React and the CData API Server to build dynamic Web pages using SQL Server data. More » |
| | Additional Articles from Redgate The Redgate Foundry team have been researching data masking, and have found that generally speaking there's six common approaches. In this blog post, Toby Smyth runs through all six. More » |
| | Prashanth Jayaram from SQLServerCentral Blogs The idea behind this article is to discuss the importance and the implication of SQL Partition and understand the truncate... More » |
| | CYates from SQLServerCentral Blogs I recently was on a call where a technical unit indicated they did not receive any form of documentation around... More » |
|
|
| | | Today's Question (by Steve Jones): With Dynamic Data Masking in SQL Server 2016+, I have the following mask applied to this table: ALTER TABLE users ALTER COLUMN emailaddr ADD MASKED WITH (FUNCTION='email()' ) I have this data in the emailaddr column: "[email protected]". If a user that does not have the UNMASK permission but does have SELECT permission queries the table, what is returned? |
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: T-SQL. 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 | | Securing SQL Server - Written by Denny Cherry, a Microsoft MVP for the SQL Server product, a Microsoft Certified Master for SQL Server 2008, and one of the biggest names in SQL Server today, Securing SQL Server, Second Edition explores the potential attack vectors someone can use to break into your SQL Server database as well as how to protect your database from these attacks. In this book, you will learn how to properly secure your database from both internal and external threats using best practices and specific tricks the author uses in his role as an independent consultant while working on some of the largest and most complex SQL Server installations in the world. This edition includes new chapters on Analysis Services, Reporting Services, and Storage Area Network Security. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Jeff Atherton): Which one of the following has the correct syntax for the Row Number function and will not generate an error?
Answer: ROW_NUMBER() OVER (ORDER BY NAME ASC) AS RowNum1 Explanation: The correct syntax for the Row_Number() function must contain an OVER clause with ORDER BY. The Row_Number() function takes exactly 0 arguments and if a PARTITION BY clause is used there is no comma between the PARTITION BY and OVER clause. Ref: ROW_NUMBER() - click here » Discuss this question and answer on the forums |
|
|
| | | | Devendra Thakur from SQLServerCentral.com Recently we got the information from management that our project will be getting the customers from China, so our application should support the Unicode characters. Now we support only English language, to support all the languages we decided to change all the char, varchar and text datatypes to nchar, nvarchar and ntext. Process to achieve this is below – Get the list of Columns which are using datatypes char, varchar and text Fetch the details like table name, datatype, length etc. Generate the Alter statement(Dynamic SQL) Execute Dynamic SQL Capture the status (success or failure) with error details Analyze the error message and manually update the datatypes for failed records This process has reduced the manual work by 80% (approximately) in our case. We found that some Alter statements failed due to Default constraints or Column being used in Index. We dropped the constraints, Alter the datatype and recreated them. Since the failed percentage was very less, so we did not tried to automate them. 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. SQL Database Audit Server Audit Qn - Hi, I;ve been asked to audit few tables, views, stored procedures for some client request and see that it can be... Maintenance plan migration from SQL Server 2014 - I have a number of maintenance plans with associated jobs in SQL Server 2014 which I need to migrate to... expensive key lookup - have the below code from 3rd party app trying to get rid of expensive key lookup. Output from therapyadmin table... How can I pull unique rows from table - Hi Guys, I am new here, Below is sample code. As an example from below, I want one unique records (id,client_id)... Access Denied after changing HD - Hi, I am running SS2008R2, SS2012 and SS2014 on a home PC for development purposes, read this also as I am... The Service Broker endpoint is in disabled or stopped state - I have a SQL 2012 Enterprise edition HADR cluster with 2 nodes and my event log on the second node... T-SQL Filtering data with more than one condition by row - Hi, I want to select result filtered by more than a value by a row. I don't know if it's possible or... t-sql 2012 declare variables issue - In t-sql 2012, I want to update the value in the column called stringtemplate in the table called Templates 26... unable to conncet remote instance - Hi experts, when ever i tried to access remote instance iam getting the following error can not connect (instance name) instance failure(System.data) iam using... when one column is updated, want to update another column in same table using trigger. - Dear All, I have a table in which there are fields like Quantity, Price, Total etc.There's is also a primary key... Receiving an error "0xC002F210 at Execute SQL Task" on SSIS step when creating a table - Can someone please tell me if there is some server setting that will prevent the error I'm receiving? I appreciate... Update Field to current logged in user ID with new record command button - Hello all, I have an access front end that uses a sql backend. We want to add a field in... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected]. | 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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected] |
|
|
