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

Latest Blog Posts

Did you know…you can change the default file encoding for new query on SSMS?

If you have been reading my last blog posts, you know that I’m currently working on a SQL code migration from Firebird to SQL Server. The client provided the scripts with all modules (Stored Procedures, functions, etc) and the steps I'm following (roughly speaking) for converting are: Open new query… Read more

0 comments, 217 reads

Posted in Cláudio Silva on 5 June 2018

Prepping for Mastering Index Tuning with Brent Ozar Unlimited

I got the chance to sign up for a few courses from the Brent Ozar Unlimited team and took it. I struggle to find time for training, between work commitments, travel, and family time, it’s hard to fit in a day or two. I’ve almost given up on going to… Read more

4 comments, 2,103 reads

Posted in The Voice of the DBA on 5 June 2018

WSFC Lost Quorum votes due to network problem


Early in the morning I received emails requesting for support as the applications were failing to connect to one of the production servers that are configured with Always On, I asked for an specific error and the customer sent me this:

Error while updating the backup server list:…

Read more

0 comments, 2,120 reads

Posted in SQLDbaInternals on 5 June 2018

Linked Server to Azure SQL Database

You may (or may not) have a requirement to setup a linked server to Azure SQL Database from a locally installed SQL Server. One reason could be to pull down some reports from an Azure SQL Database to a local file share. Whatever your reason is hopefully you will find… Read more

2 comments, 1,594 reads

Posted in All About SQL on 5 June 2018

Bring Your Own Key to Azure SQL Database TDE New UI

In a recent post I wrote about a new functionality for Azure SQL Database’s TDE feature: Bring Your Own Key. At the time the only way to bring your own key was through PowerShell and T-SQL. Thankfully, that has changed. A recent update added a UI for managing your… Read more

0 comments, 1,497 reads

Posted in Bradley Schacht on 5 June 2018

4 Ways To Define Lookup Values In A Query

Watch this week’s episode on YouTube.

Occasionally you may need to create a lookup table of values for a single query.  Building a permanent table of these values is a good option if you need to reuse the values frequently, but for one-off, ad-hoc queries you may want to… Read more

6 comments, 3,128 reads

Posted in Bert Wagner on 5 June 2018

SQL Database Corruption: Causes, Prevention, Fixing Techniques

“I had a Database File and I want to attach this MDF file to SQL Server 2014. However, whenever I try to attach the file, I am receiving following error message :
The header for file ….\MSSQL\DATA\xxxx_data.mdf’ is not a valid database file header. The FILESIZE property is incorrect. (SQL…
Read more

0 comments, 123 reads

Posted in PowerSQL By Prashanth Jayaram on 5 June 2018

SQLSaturday Orlando 2018 – Planning Update #2

Continuing the notes I wrote in Update #1, got a few more things done last week:

  • Received confirmation that the event was approved, good!
  • Logged in to the admin site and did these things (about 10 mins):
    • Set the call for speakers end date
    • Picked vegetarian as a lunch…

Read more

0 comments, 111 reads

Posted in SQLAndy on 5 June 2018

SQL Saturday #731 Athens 2018

In less than two weeks (on 16th June) it's time for SQL Saturday Athens and I'm proud to announce that I will be speaking! This will be my first SQL Saturday ever both as speaker and attendee outside Portugal so I'm especially thrilled and excited to be part of it!… Read more

0 comments, 105 reads

Posted in Cláudio Silva on 4 June 2018

A Broken Linux VM

I have no idea if this is the best thing, but I went to boot up a Linux VM today and got this:

My Linux skills are rusty, but this looks like a disk error. I rebooted and found this:

A search on Stack showed this page: https://askubuntu.com/questions/697190/fsck-error-on-boot-dev-sda6-unexpected-inconsistency-run-fsck-manually

I ran… Read more

0 comments, 166 reads

Posted in The Voice of the DBA on 4 June 2018

Power BI Custom Visuals Class (Module 106 – Ring Chart MAQ Software)

In this module you will learn how to use the Ring Chart by MAQ Software. The Ring Chart is similar to the native Donut Chart but has many more additional customizations that can be configured.

Module 106 – Ring Chart (MAQ Software)


Read more

0 comments, 1,776 reads

Posted in Devin Knight on 4 June 2018

Extended Events, the system_health Session, and Waits

I advocate for, use, document, teach, and just downright love, Extended Events. They are so much better than the old Trace Events (aka, Profiler) that it’s sometimes difficult to keep from just gushing. Let’s talk about a common situation that you’re going to run into on your servers all the… Read more

3 comments, 197 reads

Posted in The Scary DBA on 4 June 2018

Microsoft Azure – Introduction to Cosmos DB – Part 1

Hello Friends, Please find the link of new post of about Introduction to Cosmos DB and how to create the cosmos db account as below link – https://social.technet.microsoft.com/wiki/contents/articles/51596.azure-cosmos-db-part-1-introduction-to-cosmos-db.aspx Advertisements

Read more

0 comments, 171 reads

Posted in Kapil Blogs on 4 June 2018

SQL Homework – June 2018 – Alter a database

Here we are again. The beginning of another month. At the beginning of each month I put out a SQL Homework post with the intent of getting junior DBAs/database developers to try new things, mid-level DBAs/database developers to practice things they should already know, and Sr DBAs/database developers a boost… Read more

0 comments, 120 reads

Posted in SQLStudies on 4 June 2018

Lessons on relocating – from running SQL Saturdays

I recently accepted a job offer in another town and relocated from my base of Louisville, KY. I have not relocated in 18 years, and had several lessons to learn in this process. Some lessons I had learned from 10 years of running SQL Saturdays came in handy for this…as… Read more

0 comments, 121 reads

Posted in Mala's Data Blog on 4 June 2018

SQL Saturday Cork 2018

This coming weekend (9th of June) is SQL Saturday Cork!

I’ve been really looking forward to this SQL Sat as there’s only one in Ireland each year. I’m not from Ireland but have been here for over 4 years now and the User Group in Dublin is where I… Read more

0 comments, 106 reads

Posted in The DBA Who Came In From The Cold on 4 June 2018

Microsoft SQL Server Analysis Services and Its Synchronization

SQL Server Analysis Services (SAAS) serves a broader view of data for analysis so as to make things simpler for business analysts. Implementation of SAAS gives an opportunity to users to ask compound query and convert it into actionable insight where information for better business decision making will be available.…

Read more

0 comments, 687 reads

Posted in SQL Server Overview on 2 June 2018

SQLSaturday Orlando 2018 Registration is Open

We’ve just opened up registration and the call for speakers for our 12th SQLSaturday here in Orlando. We did #1 back before we numbered them and this year we’re an astounding #801. It’s fun to watch that number keep increasing!

The call for speakers will end on July 20th. We… Read more

0 comments, 504 reads

Posted in SQLAndy on 1 June 2018

Mobile Azure

Microsoft Azure offers up a lot of technologies that you can play around with.  One thing that you might not know is that they also offer up a mobile presence to help manage your Azure resource.  The application is available for download for your mobile devices from the app store Read more

0 comments, 136 reads

Posted in John Morehouse | Sqlrus.com on 1 June 2018

Single User Mode – Back to Basics

In a recent article, I took you on a trip through how to hack (ethically) a SQL Server to regain sysadmin access. In that article, I made quick mention of restarting SQL Server into single-user mode. It only makes sense to show quickly how to get into single-user mode. Read more

0 comments, 177 reads

Posted in SQL RNNR on 31 May 2018

Newer posts

Older posts