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

Latest Blog Posts

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, 85 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, 45 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

0 comments, 124 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, 142 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, 120 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, 162 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, 98 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

0 comments, 106 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

0 comments, 102 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, 194 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

0 comments, 86 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, 128 reads

Posted in MSSQLFUN on 11 December 2017

Reset SA password on SQL Server on Linux

This article is about how to proceed when you forgot the password of your SQL Server “sa” account, Password was entered wrong many times then “sa” account got locked, or someone wants to reset the password without using SQL Server management studio (GUI).

The mssql-conf is a configuration tool that… Read more

0 comments, 169 reads

Posted in SQL Geek on 11 December 2017

ARMED - Where is the source?

ARMED, where is the source?

For quite a few years I’ve been putting everything I wrote on github and made most of it open source with a permissive license like MIT or Apache2. If anyone asked then I would be happy to change any licenses, whatever they wanted but with…

Read more

0 comments, 101 reads

Posted in Ed Elliott's Sql Developer Blog on 9 December 2017

How to Get Estimated Completion Time of SQL Server Database Backup OR Restore

“How much time SQL Server is going to take to complete the database Backup or Restore” – This is one of the very common questions DBAs face in day to day life when they are performing database refresh activity, database migration activity, or any adhoc activity where DBA may want… Read more

1 comments, 127 reads

Posted in SQL Geek on 9 December 2017

ARMED - ARM resource dependency graph inside VSCode

I think the title sums it up, I have published a new version of ARMED the arm helper extension for VSCode.

This version includes the ability to see a graph of the resources and how they relate to each other:

There are a couple of limitations at the moment this…

Read more

0 comments, 148 reads

Posted in Ed Elliott's Sql Developer Blog on 8 December 2017

Register for Red Gate’s SQL in the City

Aunt Kathi. Grant Fritchey. Steve Jones. They’re part of five hours of training on SQL Server performance and DevOps with the database in mind. And it’s free. And it’s on-line. I’m looking forward to this. If you’re not familiar with what I’m talking about, it’s Red Gate’s SQL in the… Read more

0 comments, 158 reads

Posted in Databases – Infrastructure – Security on 8 December 2017

SSMS Updates in 17.4

SSMS 17.4 is out, and if you haven’t upgraded from SQL 204, 2012, 2008, etc., you should do so. You can run your bundled SSMS side by side with the new versions, but it seems that the 17x versions are improving andbecoming more stable.

You can download the new version Read more

0 comments, 255 reads

Posted in The Voice of the DBA on 8 December 2017

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

So, the actual question is a bit more specific than would reasonably fit into a title, and it is:

In a WHERE condition (in Microsoft SQL Server, if that’s not obvious), when a string constant containing Unicode characters but not prefixed with a capital-N is compared to a column,…

Read more

2 comments, 131 reads

Posted in SQL Quantum Leap on 8 December 2017

GroupBy Slides and Demo Script is Now On GitHub

The slides and demo scripts from today’s GroupBy session are now available on our GitHub repository


Many thanks again for watching, I really hope that you found it useful


Read more

0 comments, 169 reads

Posted in SQL Undercover on 8 December 2017

Older posts