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

Latest Blog Posts

Historical Reports vs. Predictive analytics: Rear view mirror look vs. Forward-looking view. Really?

[2016-Sep-30] Working with reports based on historical data is like driving a car while looking in the rear view mirror. I heard this term again when I went for the Microsoft Data Science Summit in Atlanta (https://ignite.microsoft.com/microsoftdatascience) this past week. Which gave me a second thought to consider: how…

Read more

0 comments, 94 reads

Posted in Data Adventures on 30 September 2016

Azure Data Platform Resources

A few months ago I created a GitHub repository for the purpose of building and maintaining a list of resources for Azure Data Platform training. You can see it here. My goal in putting this into GitHub instead of just running it on my blog is to make it… Read more

2 comments, 84 reads

Posted in The Scary DBA on 30 September 2016

SQL Friday: Weekly Round up 30th September

This week has been a relatively relaxed week for me. I had a one-day onsite event in Cardiff on Wednesday for one of Learning Tree's clients. I have been there on several occasions over the summer and each one of these events has been great fun with some good discussions.

Read more

0 comments, 91 reads

Posted in The SQL DBA in the UK on 30 September 2016

How to collected inventory for SQL Server using Microsoft Assessment and Planning (MAP) tool

Hi friends, We need to collect inventory for database migration as well as platform to set up environment for migration, development and testing. Is there any tool from Microsoft to achieve this scenario? Yes, we have Microsoft Assessment and Planning Tool (MAP) for it. From BOL: The Microsoft Assessment and…

Read more

0 comments, 161 reads

Posted in Kapil Blogs on 30 September 2016

Say hello to SQL Live Health Check - part 1

When you need to manage a number of SQL instances, monitoring them becomes one of your priority task. In some large environment, you might have some third party tools to help you do that. System Center suite have Operation manager (SCOM) which can helps you monitor servers along with SQL…

Read more

0 comments, 173 reads

Posted in Dennis's SQL Blog on 30 September 2016

PowerShell -> Identify all SysAdmins in your SQL Server - Syndication – WaterOx Consulting

No pressure. None whatsoever. There is just an Auditor standing behind you waiting for you to pull a list of all the accounts with sysadmin rights in your SQL Environment. You can’t BinGle; the Auditor is watching. You start to sweat. A lot. You excuse yourself to run to the…

Read more

0 comments, 166 reads

Posted in WaterOx SQL on 29 September 2016

Finding the Attribute

I was playing with some Extended Events recently. If you haven’t tried, I’d encourage you to do so. However, working with XML is not my favorite. I know I can get the GUI in SSMS 16.x to show me events, but I sometimes want to query.

Here was my quick… Read more

0 comments, 146 reads

Posted in The Voice of the DBA on 29 September 2016

Cortana Intelligence Solutions

Cortana Intelligence Solutions is a new tool just released in public preview that enables users to rapidly discover, easily provision, quickly experiment with, and jumpstart production grade analytical solutions using the Cortana Intelligence Suite (CIS).  It does so using preconfigured solutions, reference architectures and design patterns (I’ll just call… Read more

0 comments, 110 reads

Posted in James Serra's Blog on 29 September 2016

Volunteering With PASS

I was just asked how many times I’ve been to the PASS Summit. This year will be my 12th consecutive one. That made me start thinking. At my very first Summit, I met a couple of volunteers for PASS (Allen Kinsel was one of them, I’ll blame him… Read more

0 comments, 81 reads

Posted in The Scary DBA on 29 September 2016

Want to Win a Free @LearningTree Course? #LtreRox - @tangentc is the first ever twitter winner!!!

As regular readers of this blog will know I teach some data courses for Learning Tree. Recently Learning Tree has introduced a new Twitter competition. Attendees current, past and present who tweet about their experiences on their respective Learning Tree courses. What they have learned, key take-away points or if…

Read more

0 comments, 65 reads

Posted in The SQL DBA in the UK on 29 September 2016

Mastering Index – Introduction

One of the most interesting and talked about topic in database field is Index. I am writing this Series of article to cover all the different types of index available in SQL Server. I will be writing this series in two categories Index and Special Index. Please find the List…

Read more

0 comments, 188 reads

Posted in Help on MSBI on 29 September 2016

My application to Microsoft

I have been eager to write this blog post for a while now. I want to share my experience of the process that I went through (last year) when I applied to Microsoft for a SQL PFE (Premier Field Engineer) … Continue reading

Read more

1 comments, 236 reads

Posted in All About SQL on 29 September 2016

I’m speaking at SQL PASS 2016 (Speaker Idol)

It’s always been my dream to speak at SQL PASS Summit. It’s a tough egg to crack. In my experience the abstract process is a true pain. I submit each year and the feedback on my abstracts has not been all that helpful.

As an example I got feedback on… Read more

0 comments, 101 reads

Posted in Confessions of a Microsoft Addict on 29 September 2016

This Week In Data – Episode 6 (Why Companies are Choosing Power BI)

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’re going to discuss the top reasons why companies are adopting Power BI.

Power BI is a cool tool that allows users to pull data… Read more

0 comments, 201 reads

Posted in Devin Knight on 28 September 2016

DBCC CLONEDATABASE and sensitive data

Just over 2 months ago Service Pack 2 for SQL server 2014 was released. Included in this Service Pack is a new DBCC command, DBCC CLONEDATABASE. As the name suggest this command can be used to make a clone of your user database without the table data. Instead it creates… Read more

0 comments, 130 reads

Posted in DotNine SQL Server and more on 28 September 2016

An open letter to the PASS community

PASS is our community.

It may sound a little cliche in this time of election propaganda in the US, but it’s absolutely true. PASS is our community. It’s made up of data professionals from around the globe. All of us are volunteers, from the attendees to the speakers, from the… Read more

0 comments, 87 reads

Posted in The Data Files on 28 September 2016

Connecting to Twitter with R and RStudio

Social Media and Analytics is always an interesting combination. Twitter has an API that you can so you can connect to  using R and RStudio (and a whole bunch of other languages too) to analyse twitter data.

In this post we will simply look at how we go about connecting…

Read more

0 comments, 108 reads

Posted in The SQL DBA in the UK on 28 September 2016

Query shortcuts in SQL Server Management Studio

Tired of typing out the same queries day after day? Well query shortcuts in SSMS are for you!

Following on from my last post Changing connection colours in SSMS I thought I’d write another quick about this cool but also often unused feature in SSMS.

These shortcuts allow you to… Read more

1 comments, 114 reads

Posted in The DBA Who Came In From The Cold on 28 September 2016

Power BI Desktop hosted on premises with SSRS 2016

At Microsoft Ignite, it’s announced that very soon, we will be able to host Power BI Desktop files on premises using Reporting Services.
Watch the following Ignite session at the 40:52 time mark:

I’d like to see some demos soon. Anyway, happy dance!

Read more

2 comments, 228 reads

Posted in Koen Verbeeck on 28 September 2016

Older posts