A community of more than 1,600,000 database professionals and growing

The Voice of the DBA

Independence Day 2017

Today is July 4, Independence Day in the US, more commonly known as the Fourth of July. This is the day that the United States declared it self a separate nation from the British Empire. For most of my life, this has been a day of celebration with kids, or as a kid. A time when we cook outside, watch fireworks, and have an enjoyable day away from work. The last decade or so I've also re-read the Declaration of Independence, as a way of remembering the history of my country.

As I was preparing for this year's holiday, it struck me that so often inside of companies we find groups and departments that almost separate themselves from others. We get silos and habits of working that are distinct, often because they feel that trying to work within the constraints of others' requirements is too stifling or non-productive. Unlike the U.S .Declaration of Independence, I'm not sure that most of the people that work separately could list a defined set of reasons why they work by themselves.

As I talk about and promote DevOps, the one fundamental action needed for success is communication. Disparate groups need to work together, from architecture to development to business analysts to QA to operations. Every person needs to provide help and feedback to other groups, being willing to modifty the ways in which they work to smooth the out the entire process.

In other words, we need to work together.

I hope that as you move forward in building software for your company, you learn to work with others, finding ways to smooth out the process to deliver valuable features and functions to your customers.

And if you're in the US, have a great Fourth of July.

Steve Jones from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums

How to track every change to your SQL Server database

See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more

How do you manage sensitive data?

Redgate's Foundry team are researching data discovery and classification. Fill out this short survey if you think you can help, and at the end you'll be entered into a prize draw. Fill out survey

Question of the Day

Today's Question (by Steve Jones):

How many days since the Declaration of Independence was signed in 1776?

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 7 points in this category: humor.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

The Phoenix Project: A Novel about IT, DevOps, and Helping Your Business Win

The company's new IT initiative, code named Phoenix Project, is critical to the future of Parts Unlimited, but the project is massively over budget and very late. The CEO wants Bill to report directly to him and fix the mess in ninety days or else Bill's entire department will be outsourced. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I have a Agent job with a T-SQL step that is scheduled to run once a day (only one schedule attached to this job). There are no alerts attached to the job.

The job is enabled, but the schedule is disabled. What information is captured about the job history after the scheduled run time?

Answer: The job does not run, and no entry is made in Job History

Explanation:

If the schedule is disabled, nothing will trigger the job to run, regardless of the status.

Ref: Job Properties - click here

» 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 2016 : SQL Server 2016 - Administration

LOOPING a Delete Store Procedure - Hi, I have the Following SP that will be sending the data to archive data before deleting data from tables, I'm...

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

Running total for previous 7 values where there is a 1 - Hi I need a flag to tell me there is 7 1s in a row per site This would class as...

SSIS Error When Executing Package in SSMS - Hi, I have a system that previously ran on SQL Server 2008. However, with our latest version upgrade we are now...

De-Identification of PHI Data - The company that I work for deal with PHI Data and wanted to get other opinions on De-Indentifying this kind...

SQL: HOW to concatenate two fields using trigger, - Hi All, I have SQL database called “S1”, and a table called “WORKORDER”, inside the table, I have two field...

SQL Server 2014 : Administration - SQL Server 2014

SQL Installation from CommandLine - Hello I am trying to perform SQL installation from command prompt I have created below 3 folders in D:\Patches\ 1)Setup -> contains SQL...

Transaction replication is looks not working. - Hi, I Just joined to company and give me to bunch of SQL Servers to do admin. I noticed there is...

Extract sp_execute value to a variable to compare - Hello, I want to take the sp_executesql results to a variable to further compare the results. Please suggest how to do it. [code...

SQL Server 2014 : Development - SQL Server 2014

Connection string associated with an SSMS *.sql file - I have a project setup in SSMS with several *.sql files, each of which attempt to connect to an instance when...

General advice needed - database design - Is this a bad way to design a pricing table? - Suppose we are selling bottles of water that can be bought in sizes of 1 to 10 litres (1, 2,...

Convert integer to date - Hello, In a flat file source (that comes from a Microsoft publishing "Training Kit - Implementing a Data Warehouse with Microsoft SQL...

SQL Server 2012 : SQL 2012 - General

How to calculate cost of flight and hotel and transfer per every program ? - How to design database for tourism company to calculate cost of flight and hotel per every program tour based on...

SQL Server 2012 : SQL Server 2012 - T-SQL

query similar to the 'where column in' but i need all matching items... - I know it has probably been asked and answered but i am not sure how to search for it. Currently using...

Total column in SQL Dynamic Pivot - I have used normal SQL pivot queries before but realised I needed dynamically created one for this piece of work,...

Using comma delimited value for a lookup into table - I had found SQL code previously that would let me use a comma delimited value in one table to return...

How does a stored procedure takes 15 seconds to start? - The trace attached shows a stored procedure calling another stored procedure. The statement calling the inner procedure takes 18 seconds while...

What's the best way to get a sample set of a big table without primary key? - This is what is happening here: We have lots of big data, table's size is often around billion and there is...

SQL Server 2008 : SQL Server 2008 - General

Running total for previous 7 rows - Hi I need a flag to tell me there is 7 1s in a row per site This woud class as...

How much memory does SQL server Really need? - Hi All, How do we know how much memory does

CPU troubleshooting with Perfom counters - I have put 2 PERFMON counters to troubleshoot high CPU utilization due to SQL server 2008 on a windows host...

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.