SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Finding the Right Data

For a couple years, Big Data was heavily hyped, and Hadoop became incredibly popular. In fact, so popular that Microsoft build HDInsight and Polybase to allow us to take advantage of these technologies and integrate them into our own systems. While the year has seen less hype on "big data" specifically, more and more of us are dealing with large amounts of data every day. There isn't a good definition of Big Data I've seen, but whatever you thought it meant five years ago has surely changed to mean larger volumes today.

One of the important things that many organizations are learning is that they don't necessarily need more bits and bytes of all their data. They're increasingly learning that they need more of the right data, which is the data that is useful to them. Often this is the data that lets them make decisions that improve their revenue, profits, efficiency, etc. As we move to GDPR this spring, it might also me more auditing data that prevents problems or satisfies regulators.

I ran across an interesting article that talks about companies needing the right data, which can often mean unstructured data outside of their traditional OLTP databases when dealing with customers. The article focuses on NLP (natural language processing) and social media data, but it could just as easily mean audio/video data from customer calls (or emails) or even sensor data from systems that are managed and track the ability of customers to use your product or service.

As the world of computing advances, many of us know that we need to find new and better ways to provide value to our employers. This might be with managing and gathering or tracking a wider variety of data, perhaps meaning that some of us need to keep some of those tweets or posts inside our systems. It could be that we need to provide new ways of analyzing data, maybe with some sort of ML (Machine Learning) or AI (Artificial Intelligence) processing. Perhaps it's that we need to collate and collect detailed auditing information we can produce on demand to ensure our organization complies with legal requirements.

Perhaps there's some other way that our work as data profressionals will change, but I'm sure it will continue to change and evolve across the next decade. I'm also sure this means lots of new and different data opportunities for us, if we're willing to grab them with the right data.

Steve Jones from SQLServerCentral.com

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

The Voice of the DBA Podcast

Listen to the MP3 Audio ( 3.9MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.

SQL Provision

NEW SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps

Create and manage database copies effortless and keeps compliance central to the process. With SQL Provisions virtual cloning technology, databases can be created in seconds using just MB of storage, enabling business to move faster. Sensitive data can be anonymized or replaced with realistic data to ensure data is protected as it moves between environments. Download your free trial

SQL Compare

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

Featured Contents


Configure Read Only Routing

Ganapathi varma Chekuri from SQLServerCentral.com

The advantage of Setting the readable secondary as Read-Intent Only will allow the secondary server to serve the read-only workload only if the connection string of the application contains Application Intent=Readonly parameter. More »


Add a SQL Server Database to an Existing Always On Availability Group

Additional Articles from MSSQLTips.com

In this tip, Manvendra Singh will cover how to add another database to an existing Always On Availability Group. More »


Bringing DevOps to the database. Part 1: Version control

Continuous delivery, continuous integration, automated release management – the phrases alone are enough to make the talk about DevOps for the database sound more complicated than it actually is - this post explains that the key is to start small. More »


From the SQLServerCentral Blogs - Will GDPR cause a “Database Run”?

Solomon Rutzky from SQLServerCentral Blogs

What is GDPR, everyone’s (current) favorite acronym? It stands for “General Data Protection Regulation” and is an act / law / set... More »


From the SQLServerCentral Blogs - How to write a PowerShell function to use Confirm, Verbose and WhatIf

Rob Sewell from SQLServerCentral Blogs

In my last blog post I showed how to run a script with the WhatIf parameter. This assumes that the... More »

Question of the Day

Today's Question (by Evgeny Garaev):

Which options are available for the FOR JSON clause in SQL Server 2016?

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: JSON.

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

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I've got this table and data:

    intcol INT
    , charcol CHAR(10)
	, varcharcol VARCHAR(100)
	, datecol datetime2
INSERT TheCounts 
 VALUES (1, 'West', 'Denver Broncos', '2018-01-01')
 , (2, 'West', 'Oakland Raiders', '2018-01-01')
 , (3, 'West', 'Los Angeles Chargers', '2018-01-01')
 , (4, 'West', 'Kansas City Chiefs', '2018-01-01')
 , (5, 'South', 'Jacksonville Jaguars', NULL)
 , (5, 'South', NULL, '2018-01-02')
 , (6, NULL, 'Indianapolis Colts', NULL)
 , (7, NULL, 'Houston Texans', NULL)
 , (NULL, 'North', 'Pittsburgh Steelers', NULL)
 , (NULL, 'North', 'Baltimore Ravens', '2018-01-03')
 , (NULL, 'North', 'Cincinnati Bengals', NULL)
 , (NULL, 'North', 'Cleveland Browns', NULL)
 , (13, 'East', 'Cleveland Browns', '2018-01-04')
 , (13, 'East', 'Cleveland Browns', '2018-01-04')
 , (14, 'East', 'Cleveland Browns', '2018-01-04')
 , (14, NULL, 'Cleveland Browns', NULL)

What do I get when running this code?

FROM dbo.TheCounts AS tc

Answer: 16


There is a constant here, so the COUNT() function works as a normal count just as it would with (*). The answer is 16.

Ref: COUNT() - click here

The COUNT Functionin T-SQL - http://www.sqlservercentral.com/articles/T-SQL/142568/

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

Huge Latency in TempDB - Hi All,  We are facing a huge latency in tempdb, what will be the reason??? Latency 1174 1174 1166 1173

SQL Server 2016 : SQL Server 2016 - Administration

Attach DB fails - I think I just did a dumb thing and didn't properly detach my databases before reinstalling SQL Server 2016. When...

SQL Server 3rd party Backup tool - hi, we have a DB of 20 TB in 2 files, got lot of unused space and need some shrink, but...

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

Need counts of orders per week grouped by week - Hello Everyone,      I hope someone can help me out with this.  I have an order table that stores order information.

SQL Server 2014 : Administration - SQL Server 2014

Notification Error - Hi Experts, Getting  a lot of below error message in SQL Error Log. We have SignalR running which have dependency on...

Does denormalizing the data enhance performance? - We have a sales tracker report which uses a view and that view was created from 15+ tables. I have...

SQL Server 2014 : Development - SQL Server 2014

Assign incrementing letters to same value - hi all, i have the following table OrderID   Point Order1    1         

SQL Server 2012 : SQL Server 2012 - T-SQL

How to use dynamic pivot on this data - I've tried to understand dynamic sql but, to no avail. Could you tell me how to write the code that...

Error handling using tsql - Hi All, Need some help in tsql error handling. Using SQL 2016 instance. I have 3 tables created. First off, I...

Automate LogSHipping for multiple databases - I need to set up log shipping for about 100 databases. Log backup would occur ever 4 hours and would...

SQL Server 2008 : T-SQL (SS2K8)

error:- Unhandled Exception: System.Data.SqlClient.SqlException: Incorrect syntax near t he keyword 'as'.? - HI All, I'm trying to use this sql query in my asp.net application but i keep getting error:- Unhandled Exception: System.Data.SqlClient.SqlException: Incorrect...

SQL Server 2008 : SQL Server Newbies

Displaying a week numbers as a rows for given date range - Hi, I would like to display a week number as a row for given date range. After all I want to...

Reporting Services : Reporting Services

SSRS configuration vs Report Builder configuration - is there an article (or whatever!) that details the differences between configuring Report Builder and configuring SSRS? I can get...

Programming : Powershell

Execute SQLs in Parallel from directory - Hello -  I am newbie to powershell. I am able to execute all the .SQL files from directory on to the...

This email has been sent to {user_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.
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: webmaster@sqlservercentral.com