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

Latest Blog Posts

T-SQL Tuesday 96 - Folks Who Have Made a Difference

This month’s topic: Folks Who Have Made a Difference

T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called T-SQL Tuesday, it’s not limited to SQL Server database engine only). It is the brainchild of Adam Machanic (blog |… Read more

0 comments, 129 reads

Posted in cjsommer.com on 14 November 2017

Connect() live stream for Developers around the World

Connect() is a yearly, Microsoft-hosted developer event that is broadcast live from New York City to developers worldwide.

The Connect(); 2017 Live Stream will begin at 9:45am US Eastern (15:45 Central Europe) with a pre-show and the Keynotes will start at 10:00am Eastern (16:00 CET) on November 15th and stream… Read more

0 comments, 96 reads

Posted in Gorandalf's SQL Blog on 13 November 2017

SQL Server Log Shipping on Linux

Log shipping is a high-availability configuration that perhaps most of us are familiar with. It’s one of the oldest techniques wherein we ship transaction logs from a Primary database to a Secondary database. Log Shipping is still a vital feature used in case of applications that use warm standby for… Read more

0 comments, 121 reads

Posted in PowerSQL By Prashanth Jayaram on 13 November 2017

Login failed for 'NT AUTHORITY\ANONYMOUS LOGON' - the fix you probably haven't tried yet

If you're seeing this for the second time, my apologies. I wanted to update the title but had to delete the previous entry to do so, but the SSC CMS doesn't seem to have processed the delete yet.

Just a quick one today. TL;DR: Remove yourself from some unnecessary AD… Read more

0 comments, 237 reads

Posted in Don Halloran on 13 November 2017

Changing the Default DB for a Login–#SQLNewBlogger

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

Recently I got into a bit of a pickle. I was detaching some databases for a demo, which is something I do periodically to make it easier for… Read more

0 comments, 539 reads

Posted in The Voice of the DBA on 13 November 2017

The GDPR and You

Ever heard of the General Data Protection Regulation? If not, go and read the Wiki. I’ll wait.

I can already hear what you’re thinking. “Grant, this doesn’t apply to me because my company is in the <insert non-EU country here>.” How do I know you’re thinking that? Because every… Read more

6 comments, 120 reads

Posted in The Scary DBA on 13 November 2017

Power BI Custom Visuals Class (Module 77 – Card Browser)

In this module you will learn how to use the Card Browser Custom Visual.  The Card Browser allows you to display document data in visually appealing way with images.

Module 77 – Card Browser


Read more

0 comments, 442 reads

Posted in Devin Knight on 13 November 2017

Blogging for four years!

I find it absolutely amazing that I’ve been writing this blog for four years. My first ever post My 5 pieces of advice for new DBAs was published way back in November 2013.

I started out writing one post per month, just on areas that I was working on or… Read more

6 comments, 110 reads

Posted in The DBA Who Came In From The Cold on 13 November 2017

Spaced-Out Strings

I came across this in a code review not long ago:

Three things pop into my head when I see this sort of thing:

  • That’s hard to read
  • That’s a whole lot of parentheses
  • Whoever wrote it is unfamiliar with the SQL standard about comparing strings

It’s the last item… Read more

2 comments, 622 reads

Posted in The Monday Morning DBA on 13 November 2017

Adaptive Query Processing and Automatic Tuning - Introduction - 1

SQL Server 2017 and Azure SQL Database are being touted as the self learning, artificial intelligent database. One of the main reasons for the same is due to release of the following features

 1) Adaptive Query Processing

2) Automatic Tuning
Adaptive Query Processing is SQL Server's first artificial intelligent attempt…

Read more

0 comments, 204 reads

Posted in SQL and SQL Only on 12 November 2017

Top 5 Reasons Why I think SQL Server on Linux is Legit

Here are my top 5 reasons why I thing SQL Server on Linux is Legit!

  1. SQL Server on Linux is Fast – Earlier this year SQL Server on Linux posted the fasted 1TB TPC-H benchmark in the world and at the end of October posted the a 10TB result! Check…

Read more

0 comments, 517 reads

Posted in Anthony Nocentino's Blog on 12 November 2017

Login failed for 'NTAUTHORITY\ANONYMOUS LOGON' - the fix you probably haven't tried yet

Just a quick one today. TL;DR: Remove yourself from some unnecessary AD groups.

If you've ever received the message "login failed for 'nt authority\anonymous logon' while working with SQL you know how frustrating it can be. I'm going to throw a troubleshooting tip that doesn't get much attention into the… Read more

0 comments, 1,551 reads

Posted in Don Halloran on 12 November 2017

Dealing with disquiet

Last week I listened to a podcast from one of my best friends in the sql community – Kendra Little. In this podcast Kendra talks of her encounter with anxiety attacks and how she dealt with them. When I listened to her honest, moving story – my mind was filled… Read more

0 comments, 1,138 reads

Posted in Mala's Data Blog on 11 November 2017

Finding Input Parameters in an Execution Plan

The query execution plan is a map of work which SQL Server is going to perform to execute a query. It provides a lot of useful information like operators, cost, estimated rows, actual rows, predicate details, parallelism, and much more information to troubleshoot the performance issue.

During the troubleshooting of… Read more

0 comments, 1,005 reads

Posted in SQL Geek on 11 November 2017

AWS – No Password? No Problem! Generating Redshift Credentials via IAM Authentication

I know we are living in a world where phones and other devices with advanced biometric authentication have been increasingly becoming a norm. Apart from the tremendous convenience they offer, they also offer the highest level of security with no longer needing to type in a passcode and worrying about…

Read more

0 comments, 132 reads

Posted in SqlServerZest.com - SQL in simple style on 10 November 2017

Presentation Files for my Webcast on Troubleshooting Connection Problems

Thanks to everybody who attended my webcast Troubleshooting SQL Server Connection Issues yesterday. If you missed it, the recording will be available soon on the MSSQL Tips website. The slide deck and demo code will also be available with the recording, or you can download it below. Slide deck: TroubleshootingSQLServerConnectionIssues.

Read more

Comparing Agent Jobs across Availability Group Replicas with PowerShell

On the plane home from PAS Summit I was sat next to someone who had also attended and when he saw on my laptop that I was part of the SQL Community we struck up a conversation. He asked me how he could compare SQL Agent Jobs across availability group… Read more

1 comments, 146 reads

Posted in SQL DBA With A Beard on 10 November 2017

Launching SQL Server on Linux in Single User Mode

There was a question this morning on the SQL Server Community Slack channel from SvenLowry about how to launch SQL Server on Linux in Single User Mode. Well you’ve heard everyone say, it’s just SQL Server…and that’s certainly true and this is another example of that idea.

The command… Read more

0 comments, 721 reads

Posted in Anthony Nocentino's Blog on 9 November 2017

How to be a successful innovator

Let’s say you have some obscure list of career goals for the year and one of those is to be a champion of innovation. I’m sure many of you reading this have probably run across goals like this before. I see a lot of people struggle with larger companies and… Read more

0 comments, 128 reads

Posted in Confessions of a Microsoft Addict on 9 November 2017

Using Plaster To Create a New PowerShell Module

Chrissy, CK and I presented a pre-con at PASS Summit in Seattle last week

Tracey Boggiano T | B came along to our pre-con and afterwards we were talking about creating PowerShell modules. In her blog post she explains how she creates modules by copying the code from another module… Read more

0 comments, 766 reads

Posted in SQL DBA With A Beard on 9 November 2017

Newer posts

Older posts