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

Archives: September 2016

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 to 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, 698 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, 573 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, 520 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, 761 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, 1,335 reads

Posted in Dennis's SQL Blog on 30 September 2016

PowerShell -> Identify all SysAdmins in your SQL Server

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

2 comments, 1,662 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, 708 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

5 comments, 548 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, 460 reads

Posted in The Scary DBA on 29 September 2016

Performance-Oriented T-SQL Development in Belgium

On October 10, I will come back to present in one of my favorite SQL Server conferences – SQL Server Days in Belgium, and this time it’s for a pre-conference session.

This full day seminar is called Performance-Oriented T-SQL Development, and it will focus on solving real world problems… Read more

0 comments, 272 reads

Posted in Matan Yungman 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, 455 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, 570 reads

Posted in Help on SQL Server 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

10 comments, 633 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, 487 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, 885 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, 884 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, 441 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

1 comments, 729 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

2 comments, 3,635 reads

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

Older posts