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

Archives: June 2018

Cloud Backup Comparison

I used to use Crashplan. This was about $150 a year, but I could to 5 machines. I used to do 5. I had

  • My desktop
  • My wife’s laptop
  • My daughter’s laptop
  • My laptop
  • My son’s laptop

This changed as my boy decided he didn’t like his data with ours.… Read more

9 comments, 2,789 reads

Posted in The Voice of the DBA on 29 June 2018

Learning Goals –June 2018 Update

The June update for T-SQL Tuesday #97. I made a plan and it’s hard to stick to.

tl;dr – Very little done.

I traveled the first three weeks of June here and there. Two short trips from 1-2 and 8-10, then a long trip from 16-22 and holiday from… Read more

0 comments, 715 reads

Posted in The Voice of the DBA on 29 June 2018

Azure Data Lake Store Gen2

Big news!  The next generation of Azure Data Lake Store (ADLS) has arrived.  See the official announcement.

In short, ADLS Gen2 is the combination of the current ADLS (now called Gen1) and Blob storage.  Gen2 is built on Blob storage.  By GA, ADLS Gen2 will have all the features… Read more

3 comments, 2,373 reads

Posted in James Serra's Blog on 28 June 2018

I’m Speaking At SQL Saturday Baton Rouge!

I am excited to announce that I have been selected to speak at SQL Saturday Baton Rouge (#749) on August 11, 2018. I will be presenting two sessions, Data Types Do Matter and What is Power BI?

One of the reasons that I’m so excited to speak in Baton Rouge,… Read more

0 comments, 261 reads

Posted in SQL Swimmer on 28 June 2018

Minion Backup: Restore to another server

Minion Backup makes your SQL Server backups effortless, of course.  And even better, it makes your restores effortless! Oh, yes….yes indeed. Today we’ll look at configuring a common, repeatable scenario: take the latest backup of MyDB from ProdServer1 and restore it to DevServer1. There are four basic steps to the… Read more

1 comments, 306 reads

Posted in SQL Awesomesauce on 28 June 2018

Does a Primary Key always have stats_id 1?

Back to the SQL Server Basics with Wayne

The Myth

I recently was attending a presentation where the presenter stated that the statistic with stats_id = 1 is always for the primary key (PK). The presenter made this statement based on the behavior that he has seen. However, is it… Read more

2 comments, 2,238 reads

Posted in A Discussion of SQL Server-Related Topics on 28 June 2018

Mastering Index Tuning–Day 1

This is a short series of posts on the courses I took with Brent Ozar. I actually completed the courses in the past, but I wrote notes and wanted to revisit the way things went. I started with the Mastering Index Tuning class.

I took the class a few… Read more

2 comments, 2,571 reads

Posted in The Voice of the DBA on 28 June 2018

Use SSMS with a Different Windows Account – Back to Basics

One of the tasks I find myself doing on a fairly regular basis is running SSMS as a different Windows User. The two biggest use cases for this are: a) to test an account to prove that it is working (or not) and has the appropriate level of access, and… Read more

4 comments, 2,486 reads

Posted in SQL RNNR on 28 June 2018

Check instant file initialization and lock pages in memory options

Study your server reports do the work for you!

Instant file initialization and lock pages in memory are 2 windows operating system options that can help us improve our overall SQL Server performance.
These options are already checked in the Server Dashboard report available in my free tools.

We…

Read more

0 comments, 106 reads

Posted in SQL Guatemala on 28 June 2018

Notes From SQLSaturday Houston 2018

Various and possibly amazing notes:

  • Because I waited too long the best flight I could get was into George Bush instead of Hobby, which meant driving around (literally, on the beltway) Houston and it left at a not-so-fun 7 am on Friday.
  • I got a car from Dollar. Got the…

Read more

0 comments, 305 reads

Posted in SQLAndy on 28 June 2018

Power BI Custom Visuals Class (Module 109 – as Timeline)

In this module you will learn how to use the as Timeline visual. The as Timeline is a Gantt chart style visual that allows you to find gaps and overlaps from dates and times.

Module 109 – as Timeline

Downloads

Read more

1 comments, 2,507 reads

Posted in Devin Knight on 28 June 2018

Tools to connect to a SQL database


Today I'm getting back to basics, whether you are new or veteran with the database engine you need a tool to get into, write queries, do some monitoring, tuning, etc.

If you have been using SQL for at least 5 years or any version older than SQL Server 2016 you…

Read more

0 comments, 437 reads

Posted in SQLDbaInternals on 27 June 2018

Update your production servers and stop making excuses about it

Folks, we all like to make sure we’re doing our level best to make things work smoothly. So why am I staring at someone’s server that has never been updated since it was first set up almost three years ago? Do better, so that I don’t have to yell at… Read more

0 comments, 273 reads

Posted in Born SQL with Randolph West on 27 June 2018

SQL Puzzle – FizzBuzz3d

I thought for the end of the month it would be fun to do another T-SQL Puzzle. In this case a slight upgrade of the FizzBuzz puzzle using T-SQL. So here are the rules:

Argh: I made a mistake in my rules so I’m correcting them. New text in… Read more

10 comments, 2,011 reads

Posted in SQLStudies on 27 June 2018

Alter Multiple Databases at Once

This is a quick and dirty method I often use when I want to make a change to multiple databases on a SQL Server instance, usually based on a criteria.

It’s a fairly basic level thing to do, and while it is probably trivial to a SQL expert, I find… Read more

2 comments, 2,182 reads

Posted in Matthew McGiffen DBA on 26 June 2018

Login Failed – Token-based server access validation failed for SQL Server

Login failures are a common item to troubleshoot with SQL Server.  Out of all of the possible log failure reasons one of the most uncommon is “Token-based server access validation failed”.

There are 3 possible solutions to this error and in this article we will go over each possible solution. Read more

0 comments, 108 reads

Posted in vitamindba on 26 June 2018

Query Store Error State

We recently discovered some of our databases in an Error State for SQL Server.  Microsoft has indicated this is a race condition when failover/restart happens on QDS cleanup.  They are working on a bug fix for it.  For now, it suggested you set up something that checks your databases to… Read more

6 comments, 91 reads

Posted in Database Superhero’s Blog on 26 June 2018

Query Store Error State

We recently discovered some of our databases in an Error State for SQL Server.  Microsoft has indicated this is a race condition when failover/restart happens on QDS cleanup.  They are working on a bug fix for it.  For now, it suggested you set up something that checks your databases to… Read more

6 comments, 307 reads

Posted in Database Superhero’s Blog on 26 June 2018

Filtering Tables, Procedures, And Other Objects In SSMS

While the text of this post contains good information on SSMS object filters, I highly recommend watching this week’s video on YouTube – I stretched my creativity with filming this week while I was on vacation.

This week I’m sharing a trick I learned at Jess Pomfret‘s Ohio North… Read more

5 comments, 2,120 reads

Posted in Bert Wagner on 26 June 2018

My Speaking Schedule

I have quite a few speaking engagements coming up. Rather than an intermittent blog post, I’ve decided to have a permanent home for this information. If you want to know where to get in touch with me, go to this page of my blog. I’ll keep a rolling update of… Read more

4 comments, 1,531 reads

Posted in The Scary DBA on 25 June 2018

Older posts