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

Latest Blog Posts

If your Surface Book loses it’s keyboard and trackpad – try removing KB4074588 update

My Surface Book (gen 1) recently did updates and then a day or so later the keyboard and trackpad mysteriously stopped working. Then I heard of 3 other people who experienced the same issue within 24 hours.

I could use the Surface Book in tablet mode – but I tired… Read more

0 comments, 64 reads

Posted in The Hybrid DBA's Blog on 24 February 2018

SQLCLR vs. SQL Server 2012 & 2014 & 2016, Part 7: “CLR strict security” – The Problem Continues … in the Past (Wait, What?!?)

If the new “CLR strict security” Server-level configuration option in SQL Server 2017 hasn’t caused enough confusion and pain, then, as Eagle Man says, “I’ve got something for you”. You can now enable this super-fun setting in SQL Server 2012, 2014, and 2016. Why would anyone (intentionally) do this?… Read more

0 comments, 72 reads

Posted in SQL Quantum Leap on 23 February 2018

Finding Composite Primary Key Columns

You never know when the idea for a script will make an appearance.

I had to work with composite primary keys recently while working on a project for a client.  More specifically, I had to create a process that would dynamically (dynamic SQL?! Say it isn’t so?!) handle composite keys… Read more

0 comments, 81 reads

Posted in John Morehouse | Sqlrus.com on 23 February 2018

SQL Server 2017 in a Docker Container running on a Mac – Tips and Tricks

I started using a MacBook Pro at work, and the very first thing I did was configure SQL Server 2017 running on a docker container, and run it locally within the Mac. In this post I will discuss some tips and tricks which will come handy if you are interested… Read more

0 comments, 103 reads

Posted in SQLSailor.com on 23 February 2018

How to Move Master Database to Another Location – SQL Server On Linux

With the release of SQL Server 2017 CU4, you can use the mssql-conf utility to move the master database file to another location. By default, master database is located at the location /var/opt/mssql/dataNow, if you want to change the location of master database file to a different location,… Read more

0 comments, 94 reads

Posted in SQL Geek on 23 February 2018

Power BI Custom Visuals Class (Module 91 – Smart Filter by OKViz)

In this module you will learn how to use the Smart Filter by OKViz. The Smart Filter works similar to a traditional slicer in Power BI but has a better user experience in many cases.

Module 91 – Smart File by OKViz

Downloads

Read more

0 comments, 99 reads

Posted in Devin Knight on 22 February 2018

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, 91 reads

Posted in SQL Undercover on 22 February 2018

Activate Conference 2018: Presentation info

A special hello if you're visiting this blog post during or after my workshops on Thursday afternoon, February 22 at the Louisiana Tech Park as park of the Activate Conference 2018!

Here are all the links, downloads, and more you need for these two workshops on Thursday, Feb 22:

Read more

0 comments, 78 reads

Posted in SQL Tact 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, 116 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

1 comments, 80 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

8 comments, 130 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, 187 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, 461 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, 125 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, 566 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

3 comments, 215 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, 125 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, 160 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, 88 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, 179 reads

Posted in The Voice of the DBA on 20 February 2018

Older posts