| A community of more than 1,600,000 database professionals and growing |
| | | It's Not Yours For most of my career, I've felt a tie to the systems I've managed or the code I've written. I've often said that a part of the code was mine, because it was something I'd written. Having some ownership of your work has often meant more pride in ensuring things are well implemented. The same thing goes for administering databases. When an employee feels personally responsible and accountable for the database and its contents, usually they do a better job. Most of us know that the systems we manage and the data they contain aren't really "ours", no matter how we might refer to them in conversation. We know that ultimately the data, applications, and hardware belong to our employers. Or, we should know that. Apparently not everyone does. A contractor just pleaded guilty to stealing classified information from the US National Security Agency, about 50GB worth of data. This isn't a case of spying or malicious intent. Instead, the report is that the employee was a hoarder, just keeping copies of data for some unknown reason. Hopefully that's true. Many of us will have copies of data that we use for different purposes. We might be building software, or testing queries, or some other task that requires data. We might want to conduct more in depth analysis in our spare time. Those are all positive goals, but none of them mean that we should have copies of data without authorization. We don't own the data, and we should always be sure if we are moving data to other systems, that those systems are secure and someone else has approved the action. This becomes more important all the time. We have enough issues with data security and keeping our information away from hackers. We make plenty of mistakes with configuration in authorized development and test systems. There's no reason to add to the issues by treating data as our own personal asset, no matter how good your intentions. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT | | | | | Don’t just fix SQL Server problems, prevent them from happening SQL Monitor helps teams looking after SQL Server be more proactive. Not only does SQL Monitor alert you to current issues, it gives you the information you need to stop them happening in the future. Download SQL Monitor now and get a 14 day free trial |
|
|
|
| | | | | Bill Pearson from SQLServerCentral.com Bill explains what is meant by a 'Member' and 'Member function' in MDX. A member is an item in a dimension that include the 'measures' which are the values of the attributes that belong to a dimension. 'Measures' are themselves members of a dimension called the “measures” dimension. MDX has a set of functions, known as member functions, each of which allow us to perform operations upon any member of a dimension More » |
| | Press Release from Redgate In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool. More » |
| | Working with SQL Server in Agile software development can be difficult. Ben Brumm provides an overview of Agile, specifically Scrum, and what to expect when SQL Server, or really any SQL platform, is involved. More » |
| | Jason Brimhall from SQLServerCentral Blogs Every now and then I find a topic that seems to fit perfectly into the mold of the theme of... More » |
| | Grant Fritchey from SQLServerCentral Blogs Query tuning ain’t easy. Figuring out which index is getting used is one step, and generally simple, look at the execution... More » |
|
|
| | | Today's Question (by Steve Jones): I've got this R class. > setClass( + "NFLTeam", + representation( + name = "character", + City = "character", + conference = "character", + division = "character" + ) + ) I want to ensure that any instance of this object only uses the values "AFC" or "NFC" for the conference. How can I do this? |
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: R Language. 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 | | Automate your workload and manage more databases and instances with greater ease and efficiency by combining metadata-driven automation with powerful tools like PowerShell and SQL Server Agent. Automate your new instance-builds and use monitoring to drive ongoing automation, with the help of an inventory database and a management data warehouse. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I've run this code to get information for a database into a variable. $db = Get-SqlDatabase -ServerInstance SQL01\SQL2016 -Name Sales Now I want to display the create date for this database as follows: four digit year dash two digit month dash two digit day space hour:minute Which format will do this?
Answer: '{0:yyyy-MM-dd hh:mm}' -f $db.CreateDate Explanation: One way to do this in PowerShell is to use the .Net formatting with a -f parameter and the variable. In this case, we need the yyyy-MM-dd hh:mm format. mm is for minutes. Ref: .NET custom format strings - click here » Discuss this question and answer on the forums |
|
|
| | | | Evgeny Garaev from SQLServerCentral.com Execute the provided script on an MS SQL Server instance where you want to know the progress of a maintenance operation. The script will return all the maintenance commands, progress in % for each operation, and thier start time. The script has been tested on MS SQL Server versions: 2005, 2008, 2008R2, 2012, 2014, 2016. 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. How do I log into SSMS v17 on a home network? - I've got SSMS v17 installed on a new laptop. And I've got SQL Server 2016 Developer Edition on a desktop... What exactly are window functions and partitions? - Hi everyone, I've been reading about ranking functions in the T-SQL docs and I'm still unclear on the concepts of window... Test environment SQL 2016. Need to down grade to 2014 or 2012 for testing purposes. - Currently I have a test environment that has databases in SQL 2016. The test program that uses SQL is not... Running out of space on Server OS drive, where SQL Server app located, what to clear out? - I'm running a MS Windows Server 2012 R2, and SQL Server 2016 SP2, the main HDD OS drive is split... Audting User Logins - How might you do it. - Hi, So as part of a GDPR requirement I need to audit logins to a database as follows; 1. A user tries to... Using IN and Case When splitting Numeric values - Hello Comunity and happy new year for all of You. I would like to know how can write this CTE using... When updating one row in a table, update trigger creates 3 rows in audit table - I have a table with one trigger on it. CREATE TRIGGER . ON . FOR UPDATE AS SET NOCOUNT ON SET XACT_ABORT ON SET ARITHABORT... When is too many columns too many columns? - I know you can have some insane number of columns in SQL server... but just because you could, doesn't mean... what am i doing wrong -- char(240) - what I am doing wrong, why the result is '=' ? declare @c table ( c1 varchar(10) ) insert into @c select '=' select * from... How to use HAVING with MAX on dates. - Hi, I need to do a report for sales reps showing the customers that haven;t ordered between a set of chosen... Restore Database from folder - I want to restore databases residing in folder say "D:\Backups\". This folder contains many set of db backup. I would want... auditing using extended events - We have a SQL 2008 R2 standard edition with a database installed. Data from some of the tables vanishes without... Transaction log issue - HI All I have a repeat incident in my database server Transaction log is getting full pretty quickly and fill up... FTP error - I have been using the following script to download from a ftp site. It has been working great until we... Logshipping copy job failure - Hi Team, I am trying to setup logshipping from PROD to DR, and my copy job fails with following error. 2018-01-14 08:15:14.12 Retrieved... ssrs 2010 report date icon is not displaying - I have an ssrs 2010 report that has a date icon on 2 of the parameters that are dates that... How do I code a three-level table name in SSDT that will honour environment settings in deployed job? - Hi, Say I have these databases on my server: Extract_Dev Extract_Prod Transform_Dev Transform_Prod Load_Dev Load_Prod And say my SSDT job has an SQL task such as: INSERT INTO Transform_Dev.dbo.SomeTable SELECT... Defining keys as sets that must not intersect instead of scalar values that must not be equal - I have been doing a lot of thinking about data models for the last couple of weeks. I have, just... Unable to shrink Database - Hi all, We had a 700 GB Database(700GB of mdf file).Since we were running out of space and deletion of data... Importing CVS file into SQL Server - Is there a really easy way to import data into SQL? |
|
| 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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected] |
|
|
