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

Latest Blog Posts

Everki Versa Long Term Review

A couple years I was looking for a new laptop bag. I settled on the Everki Versa, which I’ve been using on my travels for 2015/2016. It’s been quite a few, which you can see on my speaking CV.

I decided to write a long term review… Read more

0 comments, 16 reads

Posted in The Voice of the DBA on 23 August 2016

Power BI NFL Fantasy Football 2016 Reports

If you have followed my blog for the past year or so you may remember when I posted a Power BI workbook I created to analyze the previous season’s NFL player stats to help me with my fantasy football draft. I know, its nerdy, but I like Power BI and… Read more

0 comments, 64 reads

Posted in SQL with Dustin Ryan on 23 August 2016

Ten Essential Traits for DBA Success

There is greatness within you whether you believe it or not. Over the years there are certain skills that have helped me along the way that, in turn, may help you along your journey. These traits are by no means written in stone and some will not agree that these…
Read more

0 comments, 50 reads

Posted in The SQL Professor on 23 August 2016

Data Science & Workshop - NYC

So, the new industry buzz word is Data Science. Are you a Data Scientist?  Do you remember taking that in college? Maybe have a DS (Data Science) Degree? Did you cringe at chemistry? Bomb physics? Snore at geology? Well now you too may already be a "DATA SCIENTIST.  Sounds really cool:… Read more

0 comments, 177 reads

Posted in Pearl Knows on 23 August 2016

Run For the PASS Board

When the word comes around for elections to the PASS Board, are you one of those people who, even in passing, considers running? If you are, my advice is to well, do it.

By the way, here’s that word.

In order to make this a stronger, even more vibrant… Read more

0 comments, 103 reads

Posted in The Scary DBA on 22 August 2016

Cloud Security

In case you hadn’t noticed I’ve recently started looking at the cloud and what it entails. Well one of those aspects (duh) is security. I’m not sure where I found this (probably someone tweeted it) but one MS has put out a document on the subject (again duh) called Microsoft… Read more

1 comments, 190 reads

Posted in SQLStudies on 22 August 2016

Who did what to my database and when…

One of the most popular questions on forums / SO etc is, “How can i find out who dropped a table, truncated a table, dropped a procedure….” etc.   Im sure we have all been there,  something changes ( maybe schema or data ) and we have no way of telling… Read more

0 comments, 116 reads

Posted in Dave Ballantynes blog on 22 August 2016

Power BI Custom Visuals Class (Module 13 – Aster Plot)

In this module you will learn how to use the Aster Plot Power BI Custom Visual.  The Aster Plot is a twist on the standard Pie or Donut Chart.  What sets the Aster Plot apart from these visuals is that it has the ability to use a second measure to… Read more

0 comments, 94 reads

Posted in Devin Knight on 22 August 2016

Controlling a dacpac deployment

I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how to deploy dacpac's. In particular I am talking about how to control the deployment, what tool is used to deploy the dacpac, what connection details are passed in, which of the…

Read more

0 comments, 117 reads

Posted in Ed Elliott's Sql Developer Blog on 21 August 2016

Setting PowerShell as your default Linux shell

In this post we’re going set PowerShell as your default Linux shell.

What is a shell?

In Linux systems you’re given options, tons of options, you can set, reconfigure, add/remove almost anything that you want. And one of those options is your shell. The shell is the thing that you… Read more

0 comments, 126 reads

Posted in Anthony Nocentino's Blog on 20 August 2016

Introduction to Power BI Desktop – Session Materials Available

For my second time, I was afforded the great opportunity to present virtually to the great people of the Madison Power BI User Group. I’m always really excited when someone invites me back a second time to speak because that means that the first time wasn’t completely awful! We had… Read more

2 comments, 164 reads

Posted in SQL with Dustin Ryan on 19 August 2016

PoSh on Ubuntu

I heard about the PowerShell announcement recently where the platform is porting over to Linux and OSX. I think this is part of the SQL Server on Linux project, where I assume we’ll start to see the functionality that we have on Windows appear on Linux platforms. OSX is a… Read more

1 comments, 230 reads

Posted in The Voice of the DBA on 19 August 2016

Power BI Custom Visuals Class (Module 12 – Bullet Chart)

In this module you will learn how to use the Bullet Chart Power BI Custom Visual.  The Bullet Chart serves as a replacement for poorly designed dashboard gauges and meters you might be using now. Typical gauges do not show very much information and require a lot of space on… Read more

0 comments, 234 reads

Posted in Devin Knight on 19 August 2016

TGI SQL Friday - Weekly Roundup Friday 19th August 2016

Its been a lovely week here in the UK as we approach the end of August. Sun has been out, i have however haven been busy and not seen much of the sun...Yet.

SQL News

Read more

0 comments, 146 reads

Posted in The SQL DBA in the UK on 19 August 2016

SQL 2016 - Brief Overview on some new features

SQL 2016 - New Functionality

These are notes taken from the Houston SQL Pass User group from July. This presentation was given by John Cook, (Data Platform Solution Architect Microsoft) who did a great job with limited time on providing some great details on the new functionality with SQL… Read more

0 comments, 363 reads

Posted in SQL Barbarian on 19 August 2016

T-SQL Tuesday #081: Recap

Sharpen Something

In case you missed it (many did), TSQL Tuesday was a challenging event this month. I invited people to do a put a little more into writing a post than what they may usually do. There were some very good reasons for this. If you are interested, take… Read more

4 comments, 43 reads

Posted in SQL RNNR on 18 August 2016

Rounding Challenges–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

Rounding is an interesting activity, and one that I think people sometimes don’t pay enough attention to. Recently I saw a problem that intrigued me and I… Read more

4 comments, 192 reads

Posted in The Voice of the DBA on 18 August 2016

Getting Started With PowerShell on Linux

Getting PowerShell on Linux

Well it’s not just an announcement, you can actually get PowerShell on Linux and MacOS right now from GitHub – here!

Installing PowerShell

Once you’ve downloaded an installation file you can use RPM or apt to install the package. If you’re on a Mac…well just… Read more

0 comments, 136 reads

Posted in Anthony Nocentino's Blog on 18 August 2016

DawaBI Merges with Quanta Intelligence to Broaden and Deepen our Service Offering

We’ve been working on this for a while now and I’m excited to announce the merger of Quanta Intelligence and DawaBI. This merger will deepen and broaden our service offering to provide more value to our customers through knowledge and expertise. With Datalere, you are not just provided a resource,… Read more

0 comments, 146 reads

Posted in Marc Beacom on 18 August 2016

SQL Server 2016 Rundown – Session Materials Available

Yesterday evening I had the distinct pleasure of presenting at the Jacksonville SQL Server Users Group on some of the new features of SQL Server 2016. We had delicious pizza, lots of great networking, and a lot of fun talking about SQL Server. The group had a ton of great… Read more

0 comments, 88 reads

Posted in SQL with Dustin Ryan on 18 August 2016

Older posts