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

Archives: October 2017

Book from a library. Learning never stops for data professionals.

[2017-Oct-31] If you have never read the "Iacocca: An Autobiography" book by Lee Iacocca, I highly recommend it. I read it first when I was 17 years old, walked into a local library in my search for any computer related books. By accident, found it on a bookshelf, read a…

Read more

1 comments, 600 reads

Posted in Data Adventures on 31 October 2017

SQL Server 2017: Making Backups Great Again!

In some DBA circles, backups are just as popular as politicians! However, recoverability is the most important task for database administrators.  While SQL Server 2017 added so many great features like graph, SQL on Linux, and more.  Today, I want to focus on two small underdog features that might be… Read more

3 comments, 2,574 reads

Posted in John Sterrett on 31 October 2017

Azure SQL Database Managed Instance

Azure SQL Database Managed Instance is a new flavor of Azure SQL Database that is a game changer.  It offers near-complete SQL Server compatibility and network isolation to easily lift and shift databases to Azure (you can literally backup an on-premise database and restore it into an Azure SQL Database… Read more

4 comments, 1,139 reads

Posted in James Serra's Blog on 31 October 2017

Information Measurement with SQL Server, Part 2.3: Thermodynamic and Quantum Entropies

By Steve Bolton

…………When I was about 12 years old, I suddenly discovered football. Many lessons still awaited far in the future – such as the risks of being a Buffalo Bills fan, the explosive sound footballs make when they hit a Saguaro cactus, or the solid reasons for… Read more

0 comments, 1,414 reads

Posted in Multidimensional Mayhem on 31 October 2017

The Quickest Way To Get SQL Command Help

Formula One …. F1 …. Photo by Jp Valery on Unsplash

Every once in a while I discover a SQL Server Management Studio trick that’s apparently been around forever but is completely new to me.

Today I want to point out one of those features that had me thinking “how… Read more

0 comments, 375 reads

Posted in Bert Wagner on 31 October 2017

Networking, and other things to do while at PASS Summit

If you are headed to Seattle for the PASS Summit, not only are you in for a week of intense learning in data platform technology, but you may be looking at a week of networking. The days go by fast, and while you try to schedule what sessions to attend… Read more

0 comments, 319 reads

Posted in Marc Beacom on 30 October 2017

If You’re Stuck at Home for the PASS Summit

Conferences are a great place to network, to see new technologies or to see existing technologies being used in new ways, or just to get away the day-to-day work. You may love your job, but having a break to refresh and re-focus is certainly good, too. So what if you… Read more

1 comments, 668 reads

Posted in Databases – Infrastructure – Security on 30 October 2017

Can’t Connect to Analysis Services – Invalid Connection Information

I have a new installation of SQL Server 2017, along with an instance of Analysis Services Tabular 2017. I tried to connect to the SSAS instance for the first time, and I was greeted with the following error:

“Invalid connection information to establish the server connection”

I was using SSMS… Read more

4 comments, 1,479 reads

Posted in Koen Verbeeck on 30 October 2017

UNDERCOVER TOOLBOX: Using Python To Copy A SQL Login From One Server To Another

Recently I’ve been thinking about Python and whether it can be useful to the DBA as well as the data scientist.

One good use that I have found for it is to copy logins from one server to another.

There are plenty of times when you might want to copy… Read more

3 comments, 373 reads

Posted in SQL Undercover on 30 October 2017

Inside My PASS Summit

As you read this, I’m in Seattle for the PASS Summit 2017. I have four roles that I satisfy at Summit; Vendor through my glorious employer Redgate Software, Board Member of the PASS organization, Speaker, and Attendee. Let me tell you about my Summit that’s coming up.

What is…

Read more

5 comments, 559 reads

Posted in The Scary DBA on 30 October 2017

DevOps Basics – Ignoring Files in Git

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 you’ll run into at times is the need… Read more

1 comments, 1,502 reads

Posted in The Voice of the DBA on 30 October 2017

Quick Model Database Tidbit

Are you using your Model Database to its full potential?

I am finding more and more that Database Admins are not using the Model database to its fullest potential and some not at all.

What is that Model Database for?

The model database is basically the default setup (template) for… Read more

5 comments, 725 reads

Posted in SQLEspresso on 30 October 2017

Haunted SQL: The ghost of Management Studio

Have you ever had a query change performance unexpectedly? Intellisense all of a sudden stops working, or gives inconsistent results? AutoSave should have worked and saved your work after that unexpected (unexplained) crash? Ever had a query that was taking a long time and you can’t figure out why? Then… Read more

2 comments, 659 reads

Posted in SQLStudies on 30 October 2017

What’s that SSIS Password

A recurring theme over the past several weeks (there are always recurring themes it seems) has been an issue that relates to SSIS. Clients will call for help with an SSIS package that has started failing and they are stuck trying to figure it out. They are all stuck at… Read more

0 comments, 1,347 reads

Posted in SQL RNNR on 30 October 2017

It’s All About The Joins

One of the most common mistakes I see made when creating tables (and I’ve been guilty of this myself too many times) is allowing SQL Server to cluster the table for them. This is usually the result of SQL Server’s default behavior when creating a primary key: if there is… Read more

0 comments, 499 reads

Posted in The Monday Morning DBA on 29 October 2017

Columnstore Indexes – part 114 (“Machine Learning Services”)

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

This blogpost is focusing on the unsung (and at the moment undocumented) improvement that is connected to the Columnstore Indexes, the communication between SQL Server relational engine and the Machine Learning Services in SQL Server… Read more

0 comments, 709 reads

Posted in Niko's blog on 29 October 2017

The #SQLSAT Speaker Goodie Bag

Last summer, I heard about an awesome idea for speaker gifts at SQLSat Pensacola 2017 from organizer Karla Landrum and Tamera Clark (SQLSat Nashville). It was our 9th year of SQLSat Baton Rouge, we've had polo fatigue and were looking for fresh ideas for useful, memorable speaker gifts. SQLSat Nashville's…

Read more

0 comments, 598 reads

Posted in SQL Tact on 29 October 2017

A Pretty PowerBi Pester Results Template File

I have left the heat and humidity of Singapore where I have been presenting at the PowerShell Conference Asia and DevOpsDays Singapore to travel to Seattle for PASS Summit. During my Green is Good – Red is Bad session someone asked me if the PowerBi that I showed at the… Read more

1 comments, 551 reads

Posted in SQL DBA With A Beard on 29 October 2017

Monday Night Networking Dinner 2017

It’s on! Free registration at EventBrite.

I wrote last month about not being able to make it to Seattle on Monday to help organize the annual Networking Dinner. Good news though, Lisa Bohm has volunteered to organize the event this year. It will be held at Yard House,… Read more

0 comments, 583 reads

Posted in SQLAndy on 29 October 2017

Veterans at PASS Summit 2017

Hello all!


This year at PASS Summit, I wanted to do something different.  In the past Summit’s that I have attended, one of the things that I have noticed is the custom ribbons folks bring. Usually by the end of the week, I have a long trail of ribbons… Read more

1 comments, 200 reads

Posted in SQLFlipFlopsDBA on 28 October 2017

Older posts