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

Latest Blog Posts

Log Shipping – Error: Failed to update database “DATABASE NAME” because the database is read-only

Here’s a strange one that I’ve recently come across.  I had a customer report that their log shipping restore jobs were chock a block of errors.  Now, the logs seem to have been restoring just fine but before every restore attempt, the job is reporting the error,

Error: Failed to… Read more

0 comments, 39 reads

Posted in SQL Undercover on 22 February 2018

dbachecks – Configuration Deep Dive

Today is the day that we have announced dbachecks  a PowerShell module enabling you to validate your SQL Instances. You can read more about it here where you can learn how to install it and see some simple use cases

108 Configurations

One of the things I have been talking… Read more

3 comments, 70 reads

Posted in SQL DBA With A Beard on 22 February 2018

dbachecks – A different approach for an in-progress and incremental validation

dbachecks is a new PowerShell module from the SQL Server Community! For more information, read introducing dbachecks.

If you don’t know dbachecks, we have released a good amount of blog posts that will help you:
Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances by Rob Sewell
introducing… Read more

0 comments, 44 reads

Posted in Cláudio Silva on 22 February 2018

dbachecks – Using Power BI dashboards to analyse results

For the last couple of months, members of the dbatools team have been working on a new PowerShell module called dbachecks. This open source PowerShell module will enable you to validate your SQL Instances. Today it is released for you all to start to use

dbachecks launch – the blog…

Read more

0 comments, 61 reads

Posted in Cláudio Silva on 22 February 2018

Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances

For the last couple of months members of the dbatools team have been working on a new PowerShell module called dbachecks. This open source PowerShell module will enable you to validate your SQL Instances. Today it is released for you all to start to use

Validate Your SQL Instances?

Read more

4 comments, 85 reads

Posted in SQL DBA With A Beard on 22 February 2018

Recovering a TDE protected database without the Certificate

If you’ve been careful and done everything right when you’re setting up TDE then you shouldn’t run into this problem.

We all make mistakes though, and we’ve all been asked to deal with environments that haven’t been so carefully managed.

But what if you do? You have access to the… Read more

0 comments, 94 reads

Posted in Matthew McGiffen DBA on 21 February 2018

Dates and Times in SQL Server: DATETIME

Last year I ran a series of posts about Database Fundamentals. Over the next few weeks, I will cover the basics of various date and time datatypes in SQL Server, when to use them, and which functions to use for date and time calculations. This week will start with probably… Read more

0 comments, 93 reads

Posted in Born SQL with Randolph West on 21 February 2018

Windowing without a partition by or an order by

If you’ve never worked with windowing functions they look something like this:

SELECT name, max(create_date) OVER 
		-- No this isn't meant to make sense
		(PARTITION BY lower(left(name,1)) ORDER BY owner_sid)
FROM sys.databases;

The other day someone mentioned that you could use ROW_NUMBER which requires the OVER clause without either the… Read more

0 comments, 74 reads

Posted in SQLStudies on 21 February 2018

SQL Server Updates Tricked Me for Years

When applying a new SQL Server cumulative update, hot fix, or upgrade SQL Server doesn’t always apply all the fixes in the patch. When you upgrade the database engine in-place, databases you had already stay at their pre-upgrade compatibility level, which means they run under the older set of optimizer… Read more

2 comments, 178 reads

Posted in SQLEspresso on 21 February 2018

Azure SQL Elastic Pools

In this video  tutorial David talks you through the benefits of Azure SQL Elastic pools. Elastic pools allow you to share compute power between different Azure databases.  This can be particularly useful if you have databases with differing or varying performance requirements.

With Azure SQL Database you can allocate  DTUs…

Read more

0 comments, 104 reads

Posted in The SQL DBA in the UK on 21 February 2018

Indexing and Partitioning

Partitioning tables is a great tool to increase the manageability of your data. Being able to move large amounts of data in and out of a table quickly is incredibly helpful.

However, partitioning comes with a whole bunch of caveats and we need to be aware of what’s going on.… Read more

0 comments, 113 reads

Posted in The DBA Who Came In From The Cold on 21 February 2018

Activate Conference 2018: Three days of Tech Learning

Tomorrow I'll be giving two workshops at the super-slick-branded Activate Conference 2018 in Baton Rouge at the Louisiana Technology Park, a conference filled with people and topics much cooler than me and my two database workshops on Thursday, February 22.

Activate is an event that aims to enrich our…

Read more

0 comments, 67 reads

Posted in SQL Tact on 21 February 2018

Classifying Data with SSMS 17.5

I upgraded SSMS to 17.5 recently and found an interesting addition. This version has incorporated the ability to classify data. With the GDPR coming for many of us, this is a welcome addition.

This is a quick look at this feature.

Classify a Database

If I select a database and… Read more

0 comments, 150 reads

Posted in The Voice of the DBA on 20 February 2018

Killing A Service Broker SPID

Killing a SPID shouldn’t be complicated. Execute the command KILL [SPID] and that should kill the session. But there are situations where a SPID that is spawned by the Service Broker stays alive even after the queue is stuck in limbo.

No matter how many times you kill the SPID,… Read more

0 comments, 129 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 20 February 2018

Capture SQL Server Reported Errors using Extended Events

In my introduction to Extended Events blog, I mentioned that the xEvent is my favorite toy for performance troubleshooting. This blog may make you to start playing with it. In this tip, I will be discussing how you can find what caused SQL Server to write error in the… Read more

0 comments, 134 reads

Posted in SQL Geek on 20 February 2018

Getting started with the SQLUndercover Inspector

Here is a quick guide to getting started with the SQLUndercover Inspector.

Pre-requisites:

  • SQL 2012 or higher
  • SQL Server Agent
  • A database to store the the data collected by the agent jobs (this can be one you use for your other DBA needs it doesn’t have to be a dedicated…

Read more

0 comments, 121 reads

Posted in SQL Undercover on 19 February 2018

SQL Saturday Chicago: I’m speaking

If you’re in Chicago on March 17 and have some free time, why not check out all the cool kids?

You can check out the full event schedule here: http://www.sqlsaturday.com/719/Sessions/Schedule.aspx

There are a lot of great speakers and topics. Did I mention the Brent Ozar will be there? If that’s… Read more

0 comments, 102 reads

Posted in Confessions of a Microsoft Addict on 19 February 2018

STORPORT: Reading an ETL trace

One of the things I enjoy most is diagnosing storage latency. I honestly couldn’t tell you why I enjoy it so much; but, I just do. When it comes to storage in Windows one of the best things you can do is capture an ETL trace for the STORPORT driver. Read more

0 comments, 97 reads

Posted in Confessions of a Microsoft Addict on 19 February 2018

Using a gMSA with SQL Server

As you already know, SQL Server runs as a service. And services require a service account to run under. While this service account is likely to be a domain service account, it could be an account on the local machine. To follow good security practices you would need to specify… Read more

4 comments, 148 reads

Posted in A Discussion of SQL Server-Related Topics on 19 February 2018

Older posts