Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

This Week in Data – Episode 15 (Why People Are Flocking to SQL Server)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we discuss why companies are deciding to move to SQL Server.

In our industry, we often hear people talking about being on or migrating to… Read more

0 comments, 39 reads

Posted in Devin Knight on 7 December 2016

SQL in the City is coming next week

Next week is the 2016 version of SQL in the City and you can register now to attend. It’s free and doesn’t require any travel. You can watch the event live from the comfort of your office chair.

In the many years that we’ve run SQL in the City, we’ve… Read more

0 comments, 68 reads

Posted in The Voice of the DBA on 7 December 2016

SQL Server & Containers – Part Four

In this final part of my series on SQL Server & Containers I’ll detail an option to run earlier versions of SQL Server in containers.

This post follows on from Part Three in which we uploaded a custom image to the docker repository.

The three previous posts have all been… Read more

0 comments, 74 reads

Posted in The DBA Who Came In From The Cold on 7 December 2016

TDE Recovery

This week’s TSQL Tuesday is being held by the mighty Kenneth Fisher – Backup and Recovery- see this link, how can I not get involved with this one? I have been blogging for about a year now and have covered … Continue reading

Read more

2 comments, 170 reads

Posted in All About SQL on 7 December 2016

Linux – How to Change Group and User Ownership of a Directory – using chown & chgrp

In this post, let’s learn how to use chgrp and chown commands to change group and user ownership of a directory On a Linux server, by default, the group owner of a file or directory is the primary group of the user who created the file directory. And it is…

Read more

0 comments, 64 reads

Posted in SqlServerZest.com - SQL in simple style on 7 December 2016

Oracle Linked Server errors

Stuck with the below error right now..any ideas

Trying to pull data from Oracle view using linked server and getting below error. It was only when I try with particular Oracle instance, when I try to pull data from other instance using the same view it is working fine.

Any…

Read more

0 comments, 85 reads

Posted in SQL Articles by Nani on 7 December 2016

A Python SQL Server App

I got a link recently from Microsoft on building apps easily for SQL Server. At the top of the page, they ask you to pick a language and OS. Since I’ve done a little Python and I used Windows, I chose that option.

The page looks to walk… Read more

0 comments, 172 reads

Posted in The Voice of the DBA on 6 December 2016

Actual Chats: RIGHT OUTER joins in the wild

Colleague:
I think I just encountered my first Right join
*shocked* 
Me:
huh. weird.
a rare Right Join has appeared!
Colleague:
catch it!
Me:
You use ON. It's super effective! 
Colleague:
haha
how often do you see them? 
Me:
I've used RIGHT join maybe twice in 10 years. 
Colleague:
lol

Read more

0 comments, 66 reads

Posted in SQL Tact on 6 December 2016

TSQL Tuesday #85 Invite – Backup and Recovery

Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought we might talk about security.

No. Wait. Sorry, that was last time. This time I want to hear about backup and recovery.

Backups are one of the most common… Read more

4 comments, 109 reads

Posted in SQLStudies on 6 December 2016

Power BI Custom Visuals Class (Module 28 – Sankey)

In this module you will learn how to use the Sankey Power BI Custom Visual.  The Sankey is a type of diagram that visualizes the flow of data between a source and destination.

Module 28 – Sankey

Downloads

Read more

0 comments, 66 reads

Posted in Devin Knight on 6 December 2016

In Memory OLTP – 1

In-Memory OLTP  (A.K.A. Hekaton) is a specialized, memory-optimized relational data management engine and native stored procedure compiler, integrated into SQL Server.

Microsoft designed In-Memory OLTP to handle the most demanding OLTP workloads. To accomplish this, In-Memory OLTP introduces two fundamentally new concepts: memory-optimized tables and natively compiled stored procedures.

Data… Read more

0 comments, 88 reads

Posted in SQLSERVERS’dba on 6 December 2016

sp_WhatsupQueryStore version 1.1 released

Today I released a new version of the sp_WhatsupQueryStore stored procedure. sp_WhatsupQueryStore returns many configuration and performance metrics that are stored inside the SQL Server Query Store through an easy to use stored procedure.

In version 1.1 many new optional parameters are added that influence the output of the stored… Read more

0 comments, 81 reads

Posted in DotNine SQL Server and more on 6 December 2016

Checking your Wait Stats via Power BI

Wait stats is my go to thing, however I do get bored just querying it via a  table so I decided to broaden my horizons and see how “analytical” I could get with it via Power BI. What I usually … Continue reading

Read more

1 comments, 316 reads

Posted in All About SQL on 6 December 2016

December: A two-line play.

“Wow! A family, a marathon, and two businesses! So how do you keep up with it all?” asked Twitter. “Work-life balance,” she replied, glancing furtively at her sparsely populated blog. Fin   (P.S. The latest blog on MinionWare.net, at least, is What Really Causes Performance Problems?)  

The post December:… Read more

0 comments, 267 reads

Posted in SQL Awesomesauce on 5 December 2016

Presentations for SQL Server Beginners

Tired from all those blog posts

For my final blog post in the #gettingstarted, #iwanttohelp series, I decided to curate a set of presentations from the PASS Virtual Chapters. This content is available online. It’s free. Most importantly for the person just getting started as a SQL Server data pro,… Read more

3 comments, 132 reads

Posted in The Scary DBA on 5 December 2016

Optimize For Unknown

Hello Dear Reader!  It's been a while.  I was working with a friend and we came across an interesting problem.  They had a large amount of skewness/data skew.  This led to some performance issues for them.  The way this manifested itself was in a set of queries that ran quickly,…

Read more

1 comments, 146 reads

Posted in SQLBalls on 5 December 2016

On Being Disruptive

Being disruptive is a powerful way to conduct business. Steve Jobs and Bill Gates insisted that computers belonged not just in business offices but in the homes of regular joes, and built businesses around a need that had not fully manifested itself. Twitter disrupted the social media space by bringing… Read more

0 comments, 91 reads

Posted in Tim Mitchell on 5 December 2016

Multivariate Variable Analysis using R

So far I’ve worked on simple analytical techniques using one or two variables in a dataset. This article is a sort of a summary – about various techniques we can use for such datasets, depending on the type of variable in question. The techniques include – how to get summary… Read more

0 comments, 86 reads

Posted in Mala's Data Blog on 5 December 2016

Monday Coffee 2016-12-05

You are the DBA your company makes you. Aren’t you?

SQL Server has such a wide range of features that no DBA role will implement all of them. So, you use a certain subset in each role that you occupy throughout your career. What those features are depends on the… Read more

0 comments, 88 reads

Posted in The DBA Who Came In From The Cold on 5 December 2016

Migrating reports between SSRS report servers simplified with new PowerShell commands

I recently needed to replicate all of the reports on one report server to a different server.  I started downloading each report one at a time to a file system folder, moving them to the other machine and then uploading each RDL file.  Needless to say, that’s a slow and…

Read more

0 comments, 101 reads

Posted in SQL Server BI Blog on 4 December 2016

Older posts