SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Pluralsight is Amazing

I used to work for a digital learning company early in the modern Internet. We were ahead of our time and struggled to sell online learning at the turn of the millennium. Bandwidth limitations held back video courses from widescale adoption. I moved on when the company folded, but I've watched other companies start to build and grow video training across the years. One of them that I've been most impressed with is Pluralsight. In fact, I very much appreciate their customer service.

I try to make time every week to watch something. I don’t always get to any bits of learning, which is the way things go. Life is busy, and some days I don't have the mental energy. I do try to download a course or two to my phone for long plane rides and other travel. I’ve even had a few modules playing on long drives or in my headphones while skiing. Of course, I can’t watch the screen during those events, but I can listen and try to learn something on the go. I've even whiled away sessions on the stationary bike with a Pluralsight course playing in front of me. It's not deep learning, but it's a way of looking at something that I find interesting. I often will go back and try a bit of code later.

I don’t focus too tightly on SQL Server with Pluralsight as I get plenty of that elsewhere, but sometimes I use their courses for investigation into other areas. I’ve listened to Chef and Puppet courses, C#, ASP MVC, Python, and more. I don’t always use the skills directly, but a little learning does help me understand the larger view of how technology works. I've found throughout my career that having some good general knowledge in various areas helps me troubleshoot and understand the larger picture, often helping me find an issue in a complex system quicker. I also get ideas on why I might consider some other type of technology as a way of improving an application in the future.

I certainly hope that most of you continue to come to SQLServerCentral to get ideas, learn something, and get questions answered. My mission with this site is to help others become better SQL Server professionals. We may add some video to go with our written work, and certainly I think we could improve some assessments and testing. If there are areas you'd like to see more content, let us know.

However, we can't do what Pluralsight does with their long courses and variety of topics. If you get the chance, or have a subscription, check them out. They provide a great learning resource that I'd recommend.

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.7MB) 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.

Database DevOps

Benchmark your Database DevOps maturity level

Get a better understanding of how advanced your current processes are, receive recommendations for improvements, and see how your maturity level compares with that of your peers. Complete the Database DevOps Maturity Assessment

Redgate Hub

Register now for SQL in the City Streamed

Redgate’s popular SQL in the City Streamed virtual event takes place again this December. Wherever you are, tune in on Wednesday December 13 to watch some of the best-known speakers from the database world present the latest technologies and tools from Redgate. Register free now

Featured Contents


Stairway to SQL PowerShell Level 4: Objects in SQL PowerShell

Ben Miller from SQLServerCentral.com

This far, we have learned about installation and setup of the PowerShell environment. You should now have a foundation of SQL Server PowerShell. We now are ready to learn about Objects in SQL PowerShell. More »


Free eBook: SQL Server Internals: In-Memory OLTP

Press Release from Redgate

In this free eBook, Kalen Delaney explains how Microsoft's new In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton. More »


Correlation Analysis using Correlation Plot in Power BI Desktop

Additional Articles from MSSQLTips.com

Power BI provides correlation plot visualization in the Power BI Visuals Gallery to create Correlation Plots for correlation analysis. In this post, Siddharth Mehta shows how to create a correlation plot in Power BI Desktop using a sample dataset of car performance. More »


From the SQLServerCentral Blogs - Azure data centers and Regions: How to pick a best azure region.

UmaShankar Patel from SQLServerCentral Blogs

Azure data centers and Regions: Azure data centers are located worldwide and a team/division MCIO (Microsoft Cloud Infrastructure and Operations) manages all the data centers... More »


From the SQLServerCentral Blogs - Back To (Security) Basics

Roland Alexander STL from SQLServerCentral Blogs

Security is very much on our minds these days. Scarcely a day goes by without hearing of a yet another... More »

Question of the Day

Today's Question (by Steve Jones):

I have loaded a data frame from a CSV with this code:

gdpvalues = read.csv("h:\\downloads\\gdp2.csv")

Unfortunately the file doesn't have a header row. Right now I see this in R Studio:

I want to add column names to the data frame. What code can I run?

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.


Expert Scripting and Automation for SQL Server DBAs

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 Harsha Bhagat):

What will be the column  names of the result sets from this code in the SSMS grid?

declare @count int,
@scripts varchar(200),
@script2 varchar(20)

select @count = 10
select @script2 = '10000'+ convert(varchar(10),@count)
select scripts = @script2

select @scripts

Answer: "Scripts" and "(No column name)"


The second last select is missing the "@"  and so result set comes as 


  (No column name)

The value uses the scripts as column name. The value never gets assigned to the @scripts. In the SSMS grid, this appears as 

Ref: Assigning Result Set Column Names - https://technet.microsoft.com/en-us/library/ms179300(v=sql.105).aspx

» 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

SSMS 2017 v3 - files open disconnected, no connection option - Maybe I am just missing something, but when I double-click on a .sql file, it opens connected, or at least...

SQL Server 2017 : SQL Server 2017 - Development

FAST_FORWARD cursor slow for simple SELECT COUNT(*) because sp_cursorfetch() re-scans all index - Hi all, We are using MS ODBC 13 (on Linux) to execute a simple SELECT COUNT(*) FROM table query... This query is...

SQL Server 2016 : SQL Server 2016 - Administration

Agent Job fails on "sa" account login - I have a couple of SQL Server Agent jobs configured to run as "sa" However, they fail with the error "Description:...

SQL Server 2016 : Change compatibility level after migration - Dear all, I have migrated my SQL Server from SQL Server 2012 to 2016. Not I have the followinf list of...

Replicate data from PROD into test - Dear all, We need to replicate our database from PROD into Test environment as we should have a copy of PROD...

Slow query - client or server issue - If seeing a client make a regular query that uses the same plan but completes in radically different times on...

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

SSIS reading data from a view. - I have recently encountered this problem wherein when I am trying to load data from a view(view has join on...

Sorting after records deleted - CREATE

Using CSS to control formatting in dbmail - I have written a query and currently have a job that runs and sends an email using sp_send_dbmail in a...

SQL Server 2014 : Administration - SQL Server 2014

Bulk insert into table from csv - Hi, i have table in CSV: As you can see there are a lot of columns.  My source table data types fields are:

Transfer Database Data - hello community. i have two databases. one is old version and other is new version .. in new version i have some...

SQL Server 2014 : Development - SQL Server 2014

Did anybody have this problem - I have simple query: SELECT (select ISNULL(SUM(TOTAL_PAYMENTS),0) from Orders where ST_ID IN(SELECT ID FROM Name where CO_ID = 11750) and ORDER_DATE...

SQL Server 2012 : SQL 2012 - General

Tempdb Error - Hi All, I have 3 ndf  files for Tempdb and each one is now grown to 110+ GB. i.e total 330...

SQL Server 2012 : SQL Server 2012 - T-SQL

Query working differently on different servers - Hi - I've got a development server where my T-SQL code is working fine, but when I port it to my...

SQL Server 2008 : SQL Server 2008 - General

Transaction log issue - HI All I have a repeat incident in my database server Transaction log is getting full pretty quickly and fill up...

Problem with SQL Stored Procedure - I'm not sure what the best way is to present this issue so please forgive me if I fall short...

SQL Server 2008 : T-SQL (SS2K8)

Convert sys.master_files size column to GB? - How can I Convert sys.master_files size column to GB? Select db_name(mf.database_id) As DatabaseName , convert(int , Case When convert(bigint , sum(mf.size)) >= 268435456 Then...

SQL Server 2008 : SQL Server Newbies

Job getting stuck in UAT but runs fine in Prod - Good Morning ExpertsOne  of our jobs is getting stuck everytime it is triggered in UAT. The same ,job is running...

SQLServerCentral.com : Articles Requested

Mathematics/Algorithms in SQL - All, I am looking for some article which explain what are all the mathematics concepts and algorithms used in SQL.

SQL Server 2005 : Administering

info using sysarticles and syspublications - Is there a way to get the below information by joining sysarticles and syspublications Get Transactional replication details (publisher name, Publication,...

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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com