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

Latest Blog Posts

“The report server Web Portal URLs and Web Service URLs don’t match”

A client recently upgraded a server, and then started receiving this error when they tried to access the SSRS Reports page at http://MyServerName\Reports: The service is not available. The report server isn’t configured properly. Contact your system administrator to resolve the issue. System administrators: The report server Web Portal URLs… Read more

0 comments, 116 reads

Posted in SQL Awesomesauce on 19 March 2018

SQL Saturday Iceland–What an Adventure!

Two Saturdays ago, I was in Reykjavik, Iceland, speaking at my very first international SQL Saturday.  WOW!  Is all I can say.  While this SQL Saturday is one of the smaller events I’ve spoken at, it definitely made an impression and will most likely go down as one of my… Read more

0 comments, 145 reads

Posted in SQL Swimmer on 19 March 2018

Query Monitoring and the GDPR

I’ve been reading the General Data Protection Regulation (GDPR) and discussing the ramifications of the beginning of enforcement with lots of people. The implications of it all are fascinating. The real serious issues remain primarily a business problem, with business defined solutions. However, there are technology issues that we need… Read more

1 comments, 135 reads

Posted in The Scary DBA on 19 March 2018

# Not the GDPR News

# Not the GDPR News

Mark Williams and myself will delivering a seminar called #Not the GDPR news in Cardiff on the 19th April...

This is not a session on GDPR!

This is the session abstract

Wonder why projects fail? Want to spot the signs of failure? Want to know…

Read more

2 comments, 96 reads

Posted in The SQL DBA in the UK on 19 March 2018

SQL Saturday Richmond

SQL Saturday Richmond is just 5 days away and this will be the second time I have been selected to speak at this event.  SQL Saturday Richmond holds a special place in my heart as do the event organizers.  They gave me my first opportunity to speak at a SQL… Read more

0 comments, 88 reads

Posted in SQL Swimmer on 19 March 2018

GDPR – After the restore

I joined in on an interesting conversation the other day on twitter. It was about some unusual ramifications of GDPR (The EU General Data Protection Regulation). In case you haven’t heard of GDPR (maybe you’ve been offline for the last few months?), the GDPR is some rather sweeping security… Read more

1 comments, 104 reads

Posted in SQLStudies on 19 March 2018

Understanding Azure SQL Database- Introduction


In this first article of the series Understanding Azure SQL Database in which I am going to publish in the coming weeks to understand Azure SQL Database concepts. After this series, you will have the good understanding of the following Azure SQL concepts

  • What is Azure and Azure SQL…

Read more

0 comments, 138 reads

Posted in Vivek's SQL Notes on 18 March 2018

Webinar on Adaptive Query Processing for Data Platform Geeks

My session on Adaptive Query Processing has been finding significant interest in Data Platform events :) Delivered 2 webinars for Data Platform Geeks community, one of them at American time and other with Indian time. Indian time webinar gave me massive attendance with 100 enthusiasts joining in. Recording of one…

Read more

0 comments, 94 reads

Posted in SQL and SQL Only on 18 March 2018

SSMS Output Window

In my experience, there have been occasions where SQL Server Management Studio (SSMS) becomes unresponsive for a length of time. In one particular case, this occurred while I was expanding the list of databases.  SSMS just sat there and waited for some unknown reason and became frustrating. The client eventually… Read more

0 comments, 74 reads

Posted in John Morehouse | Sqlrus.com on 16 March 2018

Azure SQL Database and Cost Threshold for Parallelism

We all know that the magic figure for cost threshold for parallelism is 5 by default, meaning if the estimated cost of a query is greater than 5 it may very well generate a parallel plan.

Does this apply to Azure SQL Database? Let’s check.



Read more

3 comments, 101 reads

Posted in All About SQL on 16 March 2018

Power BI Custom Visuals Class (Module 94 – Count Down Timer)

In this module you will learn how to use the Count Down Timer. The Count Down Timer is a very simple visual that counts towards a specific date and time.

Module 94 – Count Down Timer


Read more

0 comments, 107 reads

Posted in Devin Knight on 16 March 2018

Book Review – Analyzing Data with Microsoft Power BI and Power Pivot for Excel

As preparation for my session at Techorama.be about data modeling in self-service BI, I decided to read the book Analyzing Data with Microsoft Power BI and Power Pivot for Excel by Marco Russo and Alberto Ferrari. The title is quite a mouthful but it gets the point across: the book… Read more

0 comments, 76 reads

Posted in Koen Verbeeck on 15 March 2018

The 700 Milestone

I’ve watched various SQL Saturday milestones go by. I missed 100 in Brazil, but did manage to get to 200 in Philadelphia and 300 in Kansas City. 400 was in Torino, and I am sad about not making the effort to get there. 500 was Boston, but I had a… Read more

2 comments, 105 reads

Posted in The Voice of the DBA on 15 March 2018


I’d never seen ORIGINAL_DB_NAME until recently and I thought it would be interesting to highlight it out, and in particular the difference between it and DB_NAME. I use DB_NAME and DB_ID fairly frequently in support queries (for example what database context is a query running from or what database… Read more

1 comments, 79 reads

Posted in SQLStudies on 15 March 2018

Why contractors need recruitment agents?

Welcome to WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent Relationships. My name is Gethyn Ellis I have been running a SQL Server consulting and training practice for the last ten years. You can check out my website and blog…

Read more

0 comments, 70 reads

Posted in The SQL DBA in the UK on 15 March 2018

Automation and cleaner code/data are the key to future success

This blog post is a copy of a post I wrote for SQL Masters Consulting as part of T-SQL Tuesday. The original link can be found here:


If you don’t already follow T-SQL Tuesday on twitter – you should – search for


The blog post was a slight…

Read more

0 comments, 66 reads

Posted in The Hybrid DBA's Blog on 15 March 2018

What's New In SQL Server 2017? at the March '18 Baton Rouge SQL Server User Group

Thanks to everyone to attended the BRSSUG meeting tonight at our sponsor's location at the Baton Rouge Alliance Safety Council location and their awesome classroom training facility.

See you next month at the BRSSUG/BRDNUG meeting back at our usual location at the Technology Park.

All of our speakers recently at…

Read more

0 comments, 338 reads

Posted in SQL Tact on 14 March 2018

Dates and Times in SQL Server: TIME

This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data types to handle dates and times in a more intelligent way than the DATETIME and SMALLDATETIME types that we looked at previously. What is the time? This week, we look… Read more

0 comments, 541 reads

Posted in Born SQL with Randolph West on 14 March 2018

Management Studio Shortcut – Change Connection

One of the most common things I do within SSMS is to change connection for the current query editor window, from one SQL Server instance to another: I’m a huge fan of keyboard shortcuts (see exhibit 1, exhibit 2, and exhibit 3). So let’s create a shortcut for “Change Connection”… Read more

9 comments, 148 reads

Posted in SQL Awesomesauce on 14 March 2018

Importance of Memory Setting in SQL Server

Memory is one among the resources forming the performance triangle—CPU and storage being the other two. If one is hit, the other two take the load to try to bring the performance to acceptable levels, but there’s always the trade-off. Whatever transactions cannot be committed to the memory they would… Read more

0 comments, 351 reads

Posted in PowerSQL By Prashanth Jayaram on 14 March 2018

Newer posts

Older posts