SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: May 2017

Angular 2 FAQs

1. What is angular module?

NgModule helps to organize an application into organized blocks of functionality. @NgModule decorator takes metadata that tells angular how to compile and run the module code. A typical NgModule looks like.

Each application in angular 2 must have at least one NgModule that you need…

Read more

0 comments, 485 reads

Posted in Querying Microsoft SQL Server on 30 May 2017

Upgrading to Modern SQL Server eBook with ScaleArc

Recently I contributed my thoughts in a new ebook from ScaleArc called “Industry Perspectives: Upgrading to Modern SQL“. Modernizing the datacenter is an ongoing struggle for those of us in the operational trenches, and a number of us in the industry contributed our thoughts to ScaleArc to help… Read more

0 comments, 349 reads

Posted in Technobabble by Klee from @kleegeek on 29 May 2017

Quitting VIM

I saw this post from Joel Spolsky lately, noting that Stack Overflow has been helping 1 million developers exit VIM. It’s a funny post, but one that has some truth in it. I’ve gotten into VIM, almost always from git, but sometimes in Linux, and I often Google the… Read more

2 comments, 473 reads

Posted in The Voice of the DBA on 29 May 2017

Monday Coffee 2017-05-29

I’ve always said that this blog is my way of giving back to the SQL Server community but there is also another reason I write, to learn.

I was chatting with a friend the other day who was thinking about start to write a blog and he was asking me… Read more

0 comments, 295 reads

Posted in The DBA Who Came In From The Cold on 29 May 2017

Microsoft Certified Trainer!

For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of my two-year working as a trainer at the Seavus Educational and Development Center (SEDC), so I’m very thankful to SEDC.

I teach several subjects related to SQL Server… Read more

0 comments, 363 reads

Posted in Si vis pacem, para sql on 28 May 2017

Columnstore Indexes – part 105 (“Performance Counters”)

Continuation from the previous 104 parts, the whole series can be found at http://www.nikoport.com/columnstore/.

For a very long time I was intending to write some of the unsung & almost hidden improvements of the SQL Server 2016 – the performance counters. To my knowledge, the only person mentioning them,… Read more

5 comments, 643 reads

Posted in Niko's blog on 27 May 2017

SQL Azure Databases - Active Secondary - How to connect? - Part 2

As a continuation of "SQL Azure Databases - Active Secondary" series started earlier, this post will cover how to connect to a azure SQL Database primary and secondary after configuring "Geo Replication".

To some, it may sound like "what is the big deal in connecting to, after configuring it".…

Read more

0 comments, 518 reads

Posted in SQL and SQL Only on 27 May 2017

Web API 2 Interview FAQs



1.       What are the return types of Action methods in Web API?

a. Void:
     If the return type is void, Web API simply returns an empty HTTP response with  status code 204 (No Content).

b. HttpResponseMessage
Web API converts the return value…

Read more

0 comments, 726 reads

Posted in Querying Microsoft SQL Server on 27 May 2017

Tuning Parallelism on SQL Server

Parallelism and MAXDOP

There’s no doubt that parallelism in SQL is a great thing. It enables large queries to share the load across multiple processes and get the job done quicker.

However it’s important to understand that it has an overhead. There is extra effort involved in managing the separate… Read more

0 comments, 2,117 reads

Posted in Matthew McGiffen DBA on 26 May 2017

Microsoft Professional Program in Data Science – The Road So Far

I’ve currently been participating in the Microsoft Professional Program in Data Science. It’s an online curriculum of MOOCs (Massive Open Online Course), all provided through the edX platform. You are free to participate, but for a verified certificate you will need to pay (and Microsoft/edX has bumped up the… Read more

3 comments, 1,190 reads

Posted in Koen Verbeeck on 26 May 2017

Speaking at SQL Saturday Pensacola!

I’m proud to announce that I will be speaking at SQL Saturday Pensacola on June 3rd 2017! Check out the amazing schedule!

If you don’t know what SQLSaturday is, it’s a whole day of free SQL Server training available to you at no cost!

If you haven’t been to… Read more

1 comments, 291 reads

Posted in Anthony Nocentino's Blog on 26 May 2017

Friday Reading 2017-05-26

The weather in Dublin is absolutely gorgeous at the moment so I’m not planning on spending much time inside this weekend! Hope the weather is the same wherever you are, here’s some reading (to be done outside )…

Experienced DBA: Rookie Mistake
John Morehouse tells us about a mistake he… Read more

0 comments, 369 reads

Posted in The DBA Who Came In From The Cold on 26 May 2017

PowerShell Remoting in Multi-Platform Environments using OpenSSH

So in my last post I told you about how I started my journey on learning PowerShell, let’s keep going down that path together. In this post I’m going to introduce PowerShell Remoting in Multi-Platform Environments, specifically using OpenSSH. We’ll discuss WinRM in multi-platform systems in an upcoming post.

Have… Read more

1 comments, 448 reads

Posted in Anthony Nocentino's Blog on 25 May 2017

Save on IT/DevConnections this fall

For the first time in many years, I won’t be at IT/DevConnections this fall.  I’m disappointed to miss the event, but I had other commitments around this time when I heard about being chosen as a speaker and this would be the fourth event in four weeks. That’s a bit… Read more

0 comments, 476 reads

Posted in The Voice of the DBA on 25 May 2017

Restore to a point in time–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it.

One of the things I had to show recently was a restore… Read more

2 comments, 629 reads

Posted in The Voice of the DBA on 25 May 2017

Speaking at SQL Saturday Atlanta (#652)

I am so excited and honored to have been selected to speak at SQL Saturday Atlanta (#652) this year.  This is huge event where I’ve been a volunteer and attendee in the past, but this will be my first time as a speaker.

I will be presenting my session What… Read more

0 comments, 279 reads

Posted in SQL Swimmer on 25 May 2017

SSRS Subscription Schedules – Enhanced

Reporting Services


Over the past couple of articles I have illustrated some of the fun that can be had when dealing with the scheduling capabilities of Reporting Services (SSRS). The first article covered how to create more advanced schedules (from the SSRS point of view). In another I article,… Read more

0 comments, 740 reads

Posted in SQL RNNR on 25 May 2017

Find when your SQL Server database grew

A quick post that is hopefully useful, I wanted a quick way to find the time, size of the database file size change and who caused it. I went down the extended events route using sqlserver.database_file_size_change event. By the way … Continue reading

Read more

2 comments, 279 reads

Posted in All About SQL on 25 May 2017

How to write a SELECT query

My First SELECT Statement Microsoft SQL Server makes it really easy for us to query tables. In SQL Server Management Studio (SSMS) for instance, we can right-click on any table we have access to and select the top 1000 rows from that table. Please don’t query tables this way in… Read more

2 comments, 96 reads

Posted in Born SQL with Randolph West on 24 May 2017

Power BI – Problem, Design, Solution (Concatenated Tooltip)

Welcome to a new series that I’m starting with a few colleagues at Pragmatic Works. The goal of this series is to document many design practices and solutions to problems that we often run into with customers. Each post will be accompanied by a video (found in the bottom under… Read more

3 comments, 704 reads

Posted in Devin Knight on 24 May 2017

Newer posts

Older posts