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

Latest Blog Posts

A Note on Configuring HP SSD’s

Sharing this without a supporting link, might help someone. During a recent move from SAN to local SSD the storage guy noted that the following has to be done to get best performance.

This command disables SSD Smart Path. You must disable the SSD Smart Path before enabling Controller caching.…

Read more

0 comments, 46 reads

Posted in SQLAndy on 24 March 2017

Why did my SQL Server database just go offline?

Note: This post contains a video clip where I show quirky behaviour of the scripted offline task. Personally I rarely use SQL Server Management Studio GUI to do day-to-day tasks, I rather just load a window and start typing stuff … Continue reading

Read more

0 comments, 58 reads

Posted in All About SQL on 24 March 2017

Configuring KDIFF With GitHub

Posting this mostly in case I need it again. I needed a merge tool for Git, Kdiff is free and useful, but you have to get all the switches set up if you want full functionality (three way merge). I found the answer on this blog post (a reminder to… Read more

0 comments, 59 reads

Posted in SQLAndy on 23 March 2017

vNext has AG

Now vNext SQL Server on Linux supports Availability Group HA/DR functionality supported.   https://blogs.technet.microsoft.com/dataplatforminsider/2017/02/17/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups/    

Read more

0 comments, 64 reads

Posted in Vinay Thakur on 23 March 2017

SQL Agent on vNext – Linux

SQL Server is running on Linux now with SQLPAL- SQL Platform Abstraction Layer(SQLPAL) -it will work as a virtual Windows server on Linux so I think now Microsoft should able to include things which we are doing on Windows Server. on that … Continue reading

Read more

0 comments, 68 reads

Posted in Vinay Thakur on 23 March 2017

Updated SQL Server on VMware Best Practices Guide

I am proud to announce that we contributed to the latest revision of the Microsoft SQL Server on VMware best practices guide, freely available at this address. This document outlines some of the common VM-level tweaks and adjustments that are made when running enterprise SQL Server VMs on VMware… Read more

1 comments, 78 reads

Posted in Technobabble by Klee from @kleegeek on 23 March 2017

Illustration of an example availability monitoring service Using PowerShell and SQL

This article discusses a simple solution of how to monitor SQL service availability across multiple servers and reporting. To build this I’ll use SQL Server with simple PowerShell script and cmdlets which generate JSON data and displays results in HTML

Article highlights

  • Defines the objective of JSON
  • Explains the PoSH…

Read more

0 comments, 52 reads

Posted in PowerSQL By Prashanth Jayaram on 23 March 2017

TempDB Database On a Local Disk for an FCI

Link Below:

TempDB Database On a Local Disk for an FCI

This article will be helpful in configuring TempDB on a local Disk instead of shared storage in SQL Server 2012/2014. This will reduce the I/O requests from the shared storage and overall it can improve performance.

Read more

0 comments, 56 reads

Posted in Ganapathi's MSSQLLover on 23 March 2017

An Introduction to Conatiners and Docker: Switch to Windows Containers

This is Chris Gibson's second post. This post follows on from his first post called: An Introduction to Containers and Docker. You can read all about Chris on our About Us Page


So far you have a fresh install of Docker for Windows, which is cool.  However, by…

Read more

0 comments, 71 reads

Posted in The SQL DBA in the UK on 23 March 2017

Building SQL Server Projects with GitLab Runners

This is the eighth part in the series: SQL Server and Continuous Integration. This post describes the set-up required for GitLab runners to automatically build SQL Server projects after each commit. I use ReadyRoll for my SQL Server projects, but SSDT projects could also be built in the same… Read more

0 comments, 82 reads

Posted in The Database Avenger on 22 March 2017

Windows Tips and Tricks – Quick Screen Clipping

It’s quite easy to hit the PrintScreen key and capture the whole screen. But how do we (quickly) capture a part of the screen ? If you are using OneNote, there’s a very cool trick I want to share with you:

First, make sure that you see the “New Quick… Read more

0 comments, 74 reads

Posted in Gorandalf's SQL Blog on 22 March 2017

Backing up SQL Server on Linux using Ola Hallengrens Maintenance Solution

With the release of SQL Server vNext CTP 1.4 SQL Agent was released for use on Linux. To install it on Ubuntu you need to upgrade your SQL Server to CTP 1.4. On Ubuntu you do this with

sudo apt-get update
sudo apt-get install mssql-server

Once you have CTP 1.4… Read more

0 comments, 87 reads

Posted in SQL DBA With A Beard on 22 March 2017

Delete an Azure SQL Database from PowerShell

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’ve been working on is trying to get my DevOps, continuous delivery pipeline working with Azure. Part of that is a test deployment… Read more

0 comments, 120 reads

Posted in The Voice of the DBA on 22 March 2017

Automating DBCC DBTABLE – obtaining the disk Sector Size

I was recently reading this msdn article on Ghost Records, and it mentioned that you could get the number of ghost records on a page with DBCC DBTABLE… and it also mentioned that you need to be sure that you enable Trace Flag 3604 in order to see the results.… Read more

0 comments, 71 reads

Posted in A Discussion of SQL Server-Related Topics on 22 March 2017

Taking dbatools Test-DbaLastBackup a little further

In a previous post I showed how easy it is to test your backups using Test-DbaLastBackup

Today I thought I would take it a little further and show you how PowerShell can be used to transmit or store this information in the manner you require

Test-DBALastBackup returns an object of… Read more

0 comments, 67 reads

Posted in SQL DBA With A Beard on 22 March 2017

Creating a list of random numbers

I was working on a blog post this weekend that required a list of random numbers. Now, this isn’t exactly an uncommon task, but it’s not as easy as it would seem. The random number function RAND() has a few inherent flaws. And from what I can remember the random… Read more

0 comments, 74 reads

Posted in SQLStudies on 22 March 2017

New SSMS bug?

It seems like SSMS has seen better days. Many developers I have worked with recently complain about Out of Memory issues and other bugs and I personally miss the days of Query Analyzer.

I discovered this issue while working in SSMS on my Surface and I’m wondering if it’s just… Read more

2 comments, 199 reads

Posted in Confessions of a Microsoft Addict on 22 March 2017

Speaking at PowerShell Summit!

Speaking at PowerShell + DevOps Global Summit 2017!

I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2017 on the conference runs from April 9th 2017 through April 12th 2017. This is an incredible event packed with fantastic content and speakers. Check out the…

Read more

0 comments, 74 reads

Posted in Anthony Nocentino's Blog on 22 March 2017

SQL Saturday Richmond (#610)

On Saturday, March 18, 2017, I spoke at my very first SQL Saturday.  I have been an attendee, involved in organizing and volunteered at many over the years, but this was the very first time I was a speaker.  My session, What is Power BI?

I have presented this session… Read more

0 comments, 63 reads

Posted in SQL Swimmer on 22 March 2017

My path from a junior to a senior DBA

A non-technical post but something I have been asked about few times so I thought that I would put pen to paper and tell you about my journey on becoming a senior DBA. You might find it fun to read. Time … Continue reading

Read more

3 comments, 156 reads

Posted in All About SQL on 22 March 2017

Older posts