Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

Part 1 - Detecting and Monitoring Memory Pressure

I will be writing this article in four parts because this topic is huge and amount of information can be overwhelming for readers and for me also. So we will be exploring it step by step. 1.                    DBCC MemoryStatus 2.                    Using DMV 3.                  

Read more

0 comments, 5 reads

Posted in Help on MSBI on 27 September 2016

SSMS 2016& Azure SQL DBs

When using the latest version of SSMS (SQL Server Management Studio) there is a small but handy little feature that I noticed when you are connected to an Azure (logical) SQL Server.

So below I have 2 screen shots – 1 when connected to an “earthed” SQL Server versus the… Read more

0 comments, 55 reads

Posted in All About SQL on 27 September 2016

SQL Relay 2016

It less than week to SQL Relay - a week long SQL conference that is visiting Birmingham, Cardiff, Reading, Nottingham and Leeds. 

See if you can persuade your boss to let you out to receive some top notch training from industry experts and speakers.

David will be there speaking on…

Read more

0 comments, 1 read

Posted in The SQL DBA in the UK on 27 September 2016

Future DBA – Hive Big Data 2

In our last blog on Future DBA, we discussed on HADOOP -HDFS system. how as we know HDFS management is quite difficult so with the help of Vendors -Cloudera/Hortonworks/MapR we can integrate the tools/utility in a GUI way and can be … Continue reading

Read more

0 comments, 35 reads

Posted in Vinay Thakur on 27 September 2016

Query Store and What Happened Earlier On Your Server

Here’s a great question I received: We had a problem at 9:02 AM this morning, but we’re not sure what happened. Can Query Store tell us?

My first blush response is, no. Not really. Query Store keeps aggregate performance metrics about the queries on the database where Query Store is… Read more

0 comments, 84 reads

Posted in The Scary DBA on 26 September 2016

A Goal of Speaking at PASS Summit

Everyone has goals or at least they should have goals. As a young professional out of college, I had plenty of goals, but none of them involved SQL Server. I really had no idea of where I wanted my career to go other than working in IT. Finally in 2000,…

Read more

0 comments, 64 reads

Posted in Everyday SQL on 26 September 2016

Studying Failures

Over the weekend, I went to the local theater to watch Sully, the movie about the US Airways pilot who successfully landed his A320 jet on an icy river after losing both engines shortly after takeoff. I enjoyed the movie for its main story line but also for some of… Read more

1 comments, 81 reads

Posted in Tim Mitchell on 26 September 2016

Nil to Speaker: Improving your PowerPoint skills

As I work on my speaking skills one of my tasks is improve my PowerPoint presentations. To that end I’ve been collecting a few links with examples and instructions I have been using to improve my skills.

Some awesome PPT slides by Edwin M Sarmiento (b/t).… Read more

0 comments, 51 reads

Posted in SQLStudies on 26 September 2016

Future DBA – Hadoop Big Data 1

In our last blog on Hadoop Big Data we have discussed about Hadoop and its tools/utility to connect to HDFS. on continue to that hadoop is mostly for big data and the on hadoop is stored in HDFS with named node … Continue reading

Read more

0 comments, 123 reads

Posted in Vinay Thakur on 26 September 2016

SQL SSRS Express Edition Cannot Connect to Azure SQL Databases

This has bit a couple of clients recently, figured I'd put out a PSA.

Express editions of SQL Server Reporting Service, from SQL 2016 on down, cannot connect to Azure SQL Databases. Turns out, getting something for free does have some significant limitations.

For example, you'll see an error message…

Read more

0 comments, 80 reads

Posted in SQL Tact on 25 September 2016

PowerShell, Pester and Ola Hallengrens Maintenance Solution

If you are a SQL DBA you will have heard of Ola Hallengrens Maintenance solution If you haven’t go and click the link and look at the easiest way to ensure that all of your essential database maintenance is performed. You can also watch a video from Ola at SQL…

Read more

0 comments, 133 reads

Posted in SQL DBA With A Beard on 24 September 2016

Order by Month Number and Show Month Name

This may feel very simple to many developers and yes it is, but I saw this request somewhere in community website.So thought of creating a very simple example.  Here I am using AdventureWorks2014 database, we have table [AdventureWorks2014].[HumanResources].[Employee] and we will use [HireDate] column. I am adding two new columns…

Read more

0 comments, 194 reads

Posted in Help on MSBI on 24 September 2016

11 years of PASS Summit

This is a story of my 11-year association with PASS, and the many ways it helped me grow as a person and in my career. And the many ways I saw other people grow.

 Summit #1 – 2006: Gaylord,TX: I was a visa holding dba-developer at a small shop.… Read more

0 comments, 107 reads

Posted in Mala's Data Blog on 23 September 2016

Announcing SQLSaturday Portugal Lisbon-Edition 2017

With just 1 week until SQLSaturday Portugal Porto 2016, I am glad to share that we have SQLSaturday Lisbon 2017 already live! Between 9th and 11th of March 2017 at Microsoft Portugal in Lisbon, the 7th edition of the SQLSaturday…

Read more

0 comments, 167 reads

Posted in Niko's blog on 23 September 2016

Think Using .. In Code Is A Time Saver? Think Again! - Syndication – WaterOx Consulting

Ok, so what is this 4 part naming convention? It is the way the SQL Server (and other DBs out there) identify the exact location of the objects in the environment. The 4 part name follows the convention of <server>.<database>.<schema>.<object>. In most cases, you are only going to use the…

Read more

0 comments, 145 reads

Posted in WaterOx SQL on 23 September 2016

I'm Back!

I've been gone... wow. Since March 31st of this year?! Let's fix that.

So what has been holding me back? 

Kids? I have three! 2, 15, 18. One wants to drive, one wants to move out into the world, the other wants to rule the world. 

Wife? She's always there…

Read more

0 comments, 80 reads

Posted in DBA On The Go on 23 September 2016

TGI SQL Friday: Weekly Roundup 23rd September

Its been another Learning Tree week for me this week and a very interesting one at that. I'm on the Learning Tree IAT...IAT stands for Instructor Advisory Team, the team consists of Learning Tree instructors and Learning Tree senior management  and its purpose is to come up with ideas and…

Read more

0 comments, 84 reads

Posted in The SQL DBA in the UK on 23 September 2016

Sql Server - Filtered Index

Filtered index is a type of non clustered index introduced in Sql Server 2008. As the name suggest filtered index is an optimized non clustered index with a filter criteria. It uses filter criteria to index a portion of rows which qualifies for the given predicate. So in filtered index…

Read more

0 comments, 214 reads

Posted in Help on MSBI on 23 September 2016


Last week, we faced a basic and yet the only major problem that sql developers/admin had to deal with and yes your guess is right, It was with SQL QUERY RUNNING SLOW.  I will be explaining the problem below, however I want everyone reading this to help me find answers…

Read more

0 comments, 145 reads

Posted in EVERYDAY MSBI/SQL CHALLENGES on 23 September 2016

Why SQL Cruise?

I was riding the elevator up from lunch today, at work. I am relatively new at my job and do not know several people at my workplace – yet. I live in a small town, and quite a lot of them know me as someone active in the local community.… Read more

2 comments, 144 reads

Posted in Mala's Data Blog on 23 September 2016

Older posts