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

Latest Blog Posts

SQL Server Failed to Open Loopback Connection – What?

I could not read my error log on one of my local SQL Servers, when I executed the following code:

EXEC sp_readerrorlog

I received the below:

Msg 22004, Level 16, State 1, Line 2 Failed to open loopback connection. Please see event log for more information. Msg 22004, Level 16,… Read more

0 comments, 209 reads

Posted in All About SQL on 12 December 2017

T-SQL Tuesday #97 – Setting learning goals for 2018

T-SQL Tuesday. Each month a different blogger hosts Adam Machanic’s (b/t) blog party. The host comes up with a topic on the first Tuesday of the month, and everyone who want’s to participate blogs on that subject, posting on the second Tuesday of the month. This… Read more

0 comments, 150 reads

Posted in SQLStudies on 12 December 2017

When Best Practices Aren’t Best

Most everyone is familiar with the term best practices. This phrase describes an industry-specific design or methodology that can be applied to most problems in a given domain. Data professionals, carpenters, medical practitioners, retail professionals, hair stylists, and most any other craftsperson will learn through experience a set of rules… Read more

2 comments, 178 reads

Posted in Tim Mitchell on 12 December 2017

The Eleven Days of Festivus 2017

Last year, I celebrated the holiday season by blogging daily during the 11 days leading up to Festivus, writing about SSIS, reporting, and leaving data trails. I had so much fun doing that stretch that I’m doing it again this year for Festivus 2017. Starting today and continuing through Festivus… Read more

0 comments, 113 reads

Posted in Tim Mitchell on 12 December 2017

Reducing the Number of Reads in Your Queries

“A-Bridged” – reducing reads – get it?  I’m sorry you’re reading this.  Photo by Jamie Street on Unsplash

In last week’s post, we went over how one of best ways to improve query performance was to reduce the number of reads that your query has to do.

Less reads typically… Read more

0 comments, 5 reads

Posted in Bert Wagner on 12 December 2017

T-SQL Tuesday #97 – We don’t need no Education! (or do we?)



Well, it’s T-SQL Tuesday time again  -the blog party started by Adam Machanic (blog | twitter) and this month hosted by Mala Mahadevan. This month we’re talking about “Setting Learning Goals for 2018.

With so much change going on in the IT… Read more

0 comments, 131 reads

Posted in measure twice, cut once. on 12 December 2017

Learning Through Blogging and Speaking

This post is a response to this month’s T-SQL Tuesday prompt created by Mala Mahadevan. T-SQL Tuesday was created by Adam Machanic and is a way for SQL users to share ideas about interesting topics. This month’s topic is Setting Learning Goals for 2018.

Prefer watching instead of… Read more

0 comments, 5 reads

Posted in Bert Wagner on 12 December 2017

Creating a Knowledge Base Chat Bot w/ Azure Bot Service

A while back you may have caught my blog post introducing the Power BI Chat Bot 9000. Since posting that blog, I’ve received a lot of requests on the steps required to build the bot. The good new is that its super easy and really only take a few… Read more

1 comments, 122 reads

Posted in SQL with Dustin Ryan on 12 December 2017

PaaS and the ever changing role of the DBA

I’ve never been a fan of a GUI for DBA work. Give me a hand crafted script or a list of DMVs and I’m a happy camper.

Perfmon is probably my best friend. It’s always there and happy to tell me the truth. It seldom falters and has helped me… Read more

0 comments, 323 reads

Posted in Confessions of a Microsoft Addict on 12 December 2017

Microsoft to Decommission Connect on 12/31/2017

Microsoft will be decommissioning the Connect platform on 12/31/2017 due to privacy concerns and will be replacing it with a new forum on UserVoice. 

Connect has been a very valuable method for users to submit feedback and the community to be able to vote the item up if they too… Read more

0 comments, 115 reads

Posted in Tim Radney - Database Professional on 11 December 2017

Which Collation is Used to Convert NVARCHAR to VARCHAR in a WHERE Condition? (Part B of 2: “Rabbit”)

Welcome back! Previously, on “Who’s Collation is it Anyway?”, due to statements made in the Microsoft documentation for “Search Conditions” related to Code Page conversions, we started looking at what happens when VARCHAR data (mainly string literals that are not prefixed with a capital-“N”) is used in a Database… Read more

1 comments, 195 reads

Posted in SQL Quantum Leap on 11 December 2017

New Course: Implementing a Hybrid Cloud Solution in Azure

My latest Pluralsight course – SQL Server: Implementing a Hybrid Cloud Solution in Azure – is well over two hours and long and is based on part of my popular workshop/precon that I have been presenting over the past 18 months. This was a fun and challenging course to develop… Read more

1 comments, 201 reads

Posted in Tim Radney - Database Professional on 11 December 2017

An Open Letter to the SQL Community: Requests of Speakers

(Part 2 of 2 -about and for Speakers.) In the previous article, Speakers were acknowledged for their dedication, passion, sacrifices, and contributions to the global SQL Server community, graciously providing tens of thousands of hours of free training...(read more)

Read more

0 comments, 198 reads

Posted in SQLSequel on 11 December 2017

Renaming a Column–#SQLNewBlogger

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

One of the things I rarely do is rename objects. There are good reasons to do so, but often the changes required in other objects and applications isn’t… Read more

0 comments, 403 reads

Posted in The Voice of the DBA on 11 December 2017

Learning to Give Presentations Well (Part 3)

See Part 1 and Part 2.

Perfect Practice Makes Perfect

I can remember my Air Force ROTC class on communications skills where we had to put together a “talking paper” and give a presentation to the class. We were advised to practice with our peers before the… Read more

0 comments, 125 reads

Posted in Databases – Infrastructure – Security on 11 December 2017

Execution Plan Metrics and Units of Measure

Have you ever looked at the properties inside an execution plan and wondered what the units of measure were? I know I have. I also get the question pretty frequently about all sorts of properties. What does EstimatedAvailableMemoryGrant display it’s units in anyway? For that matter, what the heck is… Read more

1 comments, 211 reads

Posted in The Scary DBA on 11 December 2017

T-SQL Tuesday #97 – My learning plan

This month’s T-SQL Tuesday is hosted by…er..yours truly. I picked a topic that usually comes up for me every December – learning goals for the next year. This is the first time that I am blogging about it.

Usually this review is accompanied by a strange combination of imposter syndrome,… Read more

1 comments, 144 reads

Posted in Mala's Data Blog on 11 December 2017

Accessing AzureML models through SQL Server in-database R services

In a previous article I discussed the various methods available in SQL Server 2016 & 2017 to perform in-database analytics. In the article I used a model that was stored directly inside SQL Server to perform predictions. But what if your models are not stored inside SQL Server but are… Read more

0 comments, 366 reads

Posted in DotNine SQL Server and more on 11 December 2017

SSRS won’t bind HTTPS to new certificate — “We are unable to create the certificate binding”

This blog post is around the situation where you have SSRS setup to use HTTPS and thus using a certificate and the certificate expires (or just needs replacing). We had caught the initial error via our Continuous Monitoring of the SSRS site — basically when the certificate expired we got… Read more

1 comments, 103 reads

Posted in The Hybrid DBA's Blog on 11 December 2017

Performance Dashboard Reports in SQL Server

SQL Server Management Studio comes up with multiple standard reports that show basic performance information. These reports are available without any additional installation and with no extra configuration.

But if you think this is not enough, Microsoft lunch Performance Dashboard Reports with SQL Server 2012.

Let’s deploy and configure Performance… Read more

0 comments, 188 reads

Posted in MSSQLFUN on 11 December 2017

Newer posts

Older posts