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

Archives: September 2017

Welcome to The Monday Morning DBA

I started my IT career twenty years ago as a VB and C developer, wandered into C++ for a bit, had one never-to-be-repeated foray into assembler on a VAX something-or-another, and then found myself one day that most sorrowful of creatures, the Accidental DBA.

It was SQL Server 2000, serving… Read more

0 comments, 341 reads

Posted in The Monday Morning DBA on 30 September 2017

SQLCLR vs. SQL Server 2017, Part 6: “Trusted Assemblies” – Whitelisted Assemblies can’t do Module Signing

“Trusted Assemblies”, a new feature starting in SQL Server 2017, is a means of whitelisting Assemblies that one feels pose no threat, and can be created (and used) without needing to be a) signed and b) have a corresponding signature-based Login that has been granted the UNSAFE ASSEMBLY permission. In… Read more

3 comments, 2,292 reads

Posted in SQL Quantum Leap on 29 September 2017

Stop waiting for SQL Server Service Pack 1 before upgrading!

It’s not stable until Service Pack 1…

Are you at a company that doesn’t install a new version of SQL Server until Service Pack 1 (SP1) has been released? Well, you need not wait for SP1 any more.

Because there’s not going to be any more service packs.

Microsoft just… Read more

3 comments, 754 reads

Posted in A Discussion of SQL Server-Related Topics on 29 September 2017

This Made Me Laugh: SQL v NoSQL

It’s a humorous history lesson on SQL (and product promotion), but it opens like this:

SQL awakens to fight the dark forces of NoSQL

From there it looks at the beginnings of SQL and the growth of NoSQL, going through a few sections, like

Part 1: A New Hope

and Read more

2 comments, 5,196 reads

Posted in The Voice of the DBA on 29 September 2017

SSMS 17 Dark Theme

Have you ever wanted SQL Server Management Studio (SSMS) 17 to have a dark theme? Seeing the below image (visual experience color theme options) really got me excited.

To do this you have to edit system files, don’t get me wrong, it obviously is not a supported means to get… Read more

6 comments, 2,550 reads

Posted in All About SQL on 29 September 2017

Friday Reading 2017-09-29

Another busy week almost over and today I’m heading to Utrecht for SQL Saturday Holland! Never been to Utrecht before so am going to spend some time exploring

This week I’ve been reading…

Ask HN: Would you run SQL Server on Linux?
James Anderson (t) asks Hacker… Read more

0 comments, 490 reads

Posted in The DBA Who Came In From The Cold on 29 September 2017

Seattle Freecon 2017

Announcing Seattle Freecon 2017

Are you going to the PASS Summit this year? (and if not… why not?)

Are you coming in to Seattle on or before Tuesday?

Are you not attending any of the wonderful precons at the PASS Summit on Tuesday?

Then I have a great deal for… Read more

0 comments, 603 reads

Posted in A Discussion of SQL Server-Related Topics on 28 September 2017

SSAS Tabular DirectQuery–No Hierarchies in Dimensions

I recently was testing DirectQuery to see the reporting differences in a Tabular Model. After Deploying to a development server and analyzing in Excel, the hierarchies for the Date and Product dimension were not available. SQL Server 2016 SP1 was used in this example.

You can go to this like… Read more

0 comments, 822 reads

Posted in The Smiling DBA on 28 September 2017

Thank You–#PASSElections

This week has been a whirlwind; as the results came in earlier this week on the election I wanted to take a moment and say Thank You. It is with great honor and privilege to be elected to a seat on the PASS Board.

This position is one that… Read more

0 comments, 524 reads

Posted in The SQL Professor on 28 September 2017

Scripts for SQL PowerShell Session at Microsoft Ignite 2017

This is just a quick blog post to share the scripts I used during my sessions at the Ignite conference this year.

You can download a .zip file with the scripts here.

If you’re looking for the slides or the video, those are available over on the Ignite site:… Read more

0 comments, 616 reads

Posted in SQLvariant on 28 September 2017

All Day DevOps–A Free, Virtual Conference

All Day DevOps is coming on Oct 24. This is a 24 hour event, with 100 sessions live, online. You can register now and join in the event, watching from work, home, or even the train on your commute.

The schedule is packed, with speakers from all over the world… Read more

0 comments, 1,300 reads

Posted in The Voice of the DBA on 28 September 2017

Microsoft Ignite Announcements

Many product announcements were made this week at Microsoft Ignite, and I wanted to give a quick overview of all the data platform related announcements:

  • SQL Server 2017 on Linux, Windows, and Docker, generally available on October 2nd.  SQL Server 2017 is being released simultaneously for Windows and various…

Read more

2 comments, 914 reads

Posted in James Serra's Blog on 28 September 2017

Ask HN: Would you run SQL Server on Linux?

Hacker News is one of the best sources for technical news out there. I check HN at least once a day during the week. It’s the primary cause of my browser having so many tabs that I can’t even see the favicons anymore.

People post content and if it gets… Read more

0 comments, 541 reads

Posted in The Database Avenger on 28 September 2017

SQLTreeo SSMS addin issues

Purpose Get help soon with SSMS Addin issues. In some cases a user might experience problems with their SSMS Add-in. After upgrading to a new version or a new installation. Our customer service will help users with issues to their best abilities. What kind of issues I report to Servicedesk?… Read more

0 comments, 225 reads

Posted in SQL Treeo on 28 September 2017

Checking Out SQL Vulnerability Assessment

Apparently there is a new tool from Microsoft where you can discover, track, and remediate potential database vulnerabilities. This tool is available for both on-premises SQL Server and Azure SQL Database. I actually cannot find the download for the on-premises version so I decided to give it a go in… Read more

0 comments, 1,498 reads

Posted in All About SQL on 28 September 2017

The docker kill command

When running demos and experimenting with containers I always clear down my environment. It’s good practice to leave a clean environment once you’ve finished working.

To do this I blow all my containers away, usually by running the docker stop command.

But there’s a quicker way to stop containers, the… Read more

0 comments, 1,384 reads

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

Compañero Conference and SQL Modernization Roadshow

October is a busy month for me. I am flying all over the US and Canada for speaking engagements to share some thoughts about migrating your SQL Server environment to the cloud (specifically Azure). Compañero Conference I will be presenting at the Compañero Conference, which takes place over two days,… Read more

0 comments, 533 reads

Posted in Born SQL with Randolph West on 27 September 2017

Getting a New R Package–#SQLNewBlogger

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

I was trying to test an R script the other day and got this:

> library(randomForest)
Error in library(randomForest) : 
  there is no package called ‘randomForest’

A common… Read more

0 comments, 1,799 reads

Posted in The Voice of the DBA on 27 September 2017

Error – Unable to retrieve child resources in Azure Storage Explorer

Hello friends, Please find the link of this article here – https://social.technet.microsoft.com/wiki/contents/articles/40188.error-unable-to-retrieve-child-resources-in-azure-storage-explorer.aspx

Read more

0 comments, 845 reads

Posted in Kapil Blogs on 27 September 2017

Just Check ALL the Boxes

Today I ran into something on a client server I unfortunately see too often.  The DBA goes through the trouble of configuring and setting up alerts\operators but doesn’t really understand what the options in the configurations mean. So unfortunately, that means they take the CYA (cover your ass) approach and… Read more

3 comments, 1,637 reads

Posted in SQLEspresso on 27 September 2017

Older posts