Implementation of Normalization in SQL Server (2021-02-22)

 SQLServerCentral Newsletter for February 22, 2021 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Implementation of Normalization in SQL Server]( - [Securing SQL Server with DoD guidelines]( - [Resolve Git Merge Conflict for SSIS Projects]( - [From the SQL Server Central Blogs - Installing and Configuring containerd as a Kubernetes Container Runtime]( - [From the SQL Server Central Blogs - Grant or Revoke Permission on Power BI Report Server]( Question of the Day - [Changing the format for a date]( The Voice of the DBA  Daily Coping Tip Eat something new (and healthy) today I also have [a thread at SQLServerCentral]( dealing with coping mechanisms and resources. Feel free to participate. For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from [The Action for Happiness Coping Calendar](. My items will be on [my blog](, feel free to share yours. Being Professional I often write about data professionals, meaning those people who work with data and are paid to do so. Certainly some of you might be amateurs, doing data work as a hobby, but most of the people that visit SQLServerCentral work with data as a part of their career. The second part of that title is the "professional" part. What does it mean to be a professional? I saw [some thoughts from Randolph West]( recently that caught my eye. He talks about treating others as you'd like to be treated, which is a good place to start for most of us. However, there are other considerations for being a professional in Internet age. Randolph covers a few, in terms of respecting others' form of address, their time, and their own struggles. The world of work has blurred with personal time, especially when most of us are not in the same physical location, and our "environment" might include people that don't actually work for the same organization. I'll add a couple more items here that I think are important to being a professional these days. While we do understand that children, pets, and more might interrupt meetings, understand that security and privacy for our organization (and its data) is important. Lock your machines, watch what you share out loud, and caution your "co-workers" against sharing things. In line with that, be aware that you might accidentally share something from your personal life. While you don't need to wear a suit and tie, you might ensure that you are not wearing something inappropriate. Certainly there is a running joke that people at home might not wear pants. Whether you do or not, be aware that standing up without pants wouldn't be very respectful. As we continue to move forward in work and life, with the challenges of both always and never being at work, for some or all of us, be professional to each other likely means being respectful, understanding, appreciative, and sensitive to others. It's not my world; it's not your world. It's our world. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Implementation of Normalization in SQL Server]( Sucharita Das from SQLServerCentral Introduction In my last article, Discussion on Normalization and Database Design Concepts, I discussed about the normalization concepts. Here, I will take one table in SQL Server and implement different normal forms. As we move up the higher normal forms, we end up on more number of tables. Implementation of Normal Forms Let us start […] [Securing SQL Server with DoD guidelines]( Additional Articles from Redgate Making sure your SQL Servers are secured against malicious users is difficult. The United States Defense Information Systems Agency (DISA) publishes a set of guidelines for organizations securing different pieces of software that connect to the US Department of Defense’s networks (DoD). Whether you’re working with the DoD or not, these Security Technical Implementation Guides (STIGs) are a good resource to help you understand potential security vulnerabilities and mitigate them. [Resolve Git Merge Conflict for SSIS Projects]( Additional Articles from MSSQLTips.com When working on an SSIS project with multiple developers, a merge conflict can occur in the git repository. In this tip we'll show you how to resolve this type of conflict and provide alternative options. From the SQL Server Central Blogs - [Installing and Configuring containerd as a Kubernetes Container Runtime]( aen from Anthony Nocentino's Blog In this post, I’m going to show you how to install containerd as the container runtime in a Kubernetes cluster. I will also cover setting the cgroup driver for... From the SQL Server Central Blogs - [Grant or Revoke Permission on Power BI Report Server]( Aaron Nelson from SQLvariant I have created two new PowerShell functions for Granting or Revoking permission on items in the Power BI Report Catalog. These two will be the probably be the last...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Changing the format for a date I have today's date stored in a variable: DECLARE @d DATETIME = '2021/02/22' How can I get this in the format dd.mm.yyyy and returned to the client as a string? 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) Setting Git flags for all repos What should I add to "git config" to ensure a change takes effect for all repos? Answer: Use the --global flag Explanation: The default writes to the local repo. The --global flag is used for affecting all repos. Ref: git config - [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 [Extended events query plan]( - All, Firstly apologises as I'm sure I'm missing the obvious but I've searched and I can't work it out. I have setup extended events and included both the plan_handle and query_hash actions. I'm retrieving the results with the following: set dateformat dmy SELECT n.value('(action[@name="query_hash"]/value)[1]', 'nvarchar(128)') as query_hash, n.value('(action[@name="plan_handle"]/value)[1]', 'nvarchar(max)') as plan_handle from ( select cast(event_data […] SQL Server 2017 - Development [Error number 2812 Store procedure not found]( - Hi Expert,  Have migrated database 'northwind' from Server A to Server B Server A Configuratioun- ms sql server 2012 developer edition 64 bit windows nt 6.1 build 9200 Server b configuration -ms sql server 2012 standard edition 64 bit windownt 6.2 service pack 1 hypervisor I am able to run the store procedure on […] SQL Server 2016 - Administration [Migrate from AWS SQL Server RDS to EC2]( - Hello, I could not find any documentation on how to migrate SQL server RDS to an EC2 instance. I have a requirement to migrate a large DB to ec2. Can anyone help me with the steps to migrate the DB with low downtime, please? Thanks in advance [Dynamic Data Masking and Adhoc queries.]( - This is the first time we are implementing this, Data Masking that became available in SQL Server 2016. I am not sure that this is a best Data Masking solution though. Because documentation says that a non-privileged user can run an ad-hoc query, using some functions like CAST, and data becomes visible. Is my understanding […] [Availability Group Help]( - I had something occur with my availability groups that has me concerned. My primary failed on me, due to the inclement weather and ice storms, the ISP lost connectivity and will be down for some time. But my secondary didn't failover and handle the traffic. Instead, I found it in "Recovering Mode" and when I […] SQL Server 2016 - Development and T-SQL [Question related to architecture]( - Hello Fellow DBA friends, Currently I am working on a project where a system has to be migrated to our system. I just want to know whether I should go with creating a new DB schema for its objects in current database or should I create a new database altogether ? What are the specific […] [Preventing duplicate execution plans]( - Hi all, Our application has some parameterised dynamic SQL that looks like this; SET NOCOUNT ON; DECLARE @HOST VARCHAR(500); SELECT SOME, STUFF FROM MYTABLE WHERE MAINHOST = @HOST OR BACKUPHOST = @HOST When I look at the execution plan cache it is caching an execution plan every time this is executed because it is defining […] Administration - SQL Server 2014 [Who modified my Database?]( - Hi, we have an issue where entire cubes are sometimes deleted from our SSAS database. I am assuming a human has done this, but I cant find any way of determining who did it or when it has happened. Does anyone know where (if at all) Database schema modifications would be logged? Thanks! SQL 2012 - General [How to get PartId from table #trades where it have parts that have only map from]( - I work on SQL server 2012 I have issue I can't get Part Id  that have only map code type from and code value from and not have map code type to and code value to depend on table #map ? every part id must be found on table trades two times first row for same part […] SQL Server 2019 - Administration [Subscription owner and multiple subscriptions]( - We are using reporting service 2019 Enterprise. There is an issue with running the subscription the other people created. For example two user are both content manager role. And the first user created the subscription, and she becomes the owner of the subscription automatically. She runs the report with no problem. But when the second […] [SQL Server Standard Edition]( - Hi All Hi have a problem and need help I am out of ideas on this one. I am managing my company's Production SQL Server, there are 30 Databases I need to maintain. Specs of the server: Windows Server my TEMPDB does not want to release the unallocated space and it's getting to a […] SQL Server 2019 - Development [Vague job scheduler support for SQL Server on Linux]( - I’m having some trouble figuring out the kind of support for Linux that the SQL Server 2019 job scheduler has. It’s clear that the job scheduling procedure API, and SQL Server Agent have both been ported to Linux and appear to work. But there are a limited number of kinds of job steps supported. These “kinds” of […] [SQL query to find last date a product was checked before it was installed]( - I have two tables, one covers jobs for a product and the other covers the last time a product was checked over and by who. What I am trying to do is get the most last date the product was checked before it was installed. There is no set time period that the check could […] CLR Integration and Programming. [Problem programming with clr]( - I have created a project in visuall C ++ version 2008 of clr type called calculat and I have a text box and a button in the form. When I click on the button, its click event is activated in the form1.h file and I want to This event calls a function called compare that […] The Future of Community [We need to move beyond SQL Server...]( - I think we should have a discussion about topic. First, the future is more data. SQL Server is just one place it is put. We need reflect the needs of our customers and prospective clients. How do we get there? We do SQL Server now and add others annually. Postgres, MySQL, Oracle and Vertica have […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -