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

Latest Blog Posts

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, 93 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, 98 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, 84 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, 122 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, 93 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, 64 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, 71 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, 171 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, 81 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, 118 reads

Posted in Mala's Data Blog on 23 September 2016

More Azure Database Creation in Powershell

I wrote about Azure SQL Database for T-SQL Tuesday #82, but I had a few mistakes in my process, at least from a cost standpoint. Since I’ll probably use this a bit more as I flesh out some CI/CD, I decided to document a bit more about the database… Read more

3 comments, 155 reads

Posted in The Voice of the DBA on 22 September 2016

Organizing a SQL Saturday – Part 3 – The Venue - Syndication – WaterOx Consulting

You’ve got your team; now you need to find a somewhere to host your event. If you are lucky, you already had a place via your user group, or before you even started thinking about pulling an event together. Odds are, though, you have been inspired to put on an…

Read more

0 comments, 123 reads

Posted in WaterOx SQL on 22 September 2016

I’m Speaking! SQL Saturday #548 – Kansas City

This weekend I’ll be traveling to Kansas City, Missouri for their annual SQL Saturday. This particular event is like going home for me as my first time speaking at a SQL Saturday was in Kansas City.

One of my favorite things about this event is the BBQ Crawl the organizers… Read more

0 comments, 88 reads

Posted in John Morehouse | on 22 September 2016

sp_WOxCompliant Update - Syndication – WaterOx Consulting

I just released an update to the sp_WOxCompliant script to fix a couple of issues. You can download it here! What changed?

The post sp_WOxCompliant Update appeared first on WaterOx Consulting.

Read more

0 comments, 107 reads

Posted in WaterOx SQL on 22 September 2016

Have you Upgraded From SQL Server 2005?

My first Learning Tree SQL Server Newsletter that was sent out back in August was titled SQL Server 2016: Keeping up with Technology.  In that post I talked about the reasons why some people/organisations may have been or are reluctant to upgrade to the latest and greatest version of…

Read more

0 comments, 70 reads

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

Changing connection colours in SQL Server Management Studio

A simple but effective setting in SQL Server Management Studio is using custom colours to identify which server you are about to execute a query on. It’s simple to setup but not everyone who uses SSMS is aware of it so I thought I’d quickly run through the steps here. Read more

1 comments, 161 reads

Posted in The DBA Who Came In From The Cold on 22 September 2016

This Week In Data – Episode 5 (Data Visualization Best Practices)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we’re discussing some data visualization best practices

Data visualization is a hot topic right now, particularly because of the capabilities of Power BI and the… Read more

1 comments, 114 reads

Posted in Devin Knight on 21 September 2016

ReadyRoll for Database Deployments

This is the 4th post in the series named SQL Server and Continuous Integration. The first 3 posts covered the need for Continuous Integration (CI), the central part that Git (my version control system of choice) plays in the whole process and an easy way to use Git in… Read more

2 comments, 94 reads

Posted in The Database Avenger on 21 September 2016

Making sense of Microsoft technology

In my role as a Data Platform Solution Architect (DPSA) at Microsoft, part of my responsibility is to keep up with all the Microsoft on-prem and cloud data-related technology and trends, as well as non-Microsoft technology and trends in areas such as Hadoop and NoSQL.  I work with Microsoft clients… Read more

0 comments, 169 reads

Posted in James Serra's Blog on 21 September 2016

Future DBA – Hadoop Big Data

As we discussed on earlier blog that in future its more than SQL-(R)DBMS, as data is growing we have to know BIGDATA as well, and when we talk about BIGDATA we should be aware of HADOOP. I have gone through … Continue reading

Read more

0 comments, 122 reads

Posted in Vinay Thakur on 21 September 2016

Older posts