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

Archives: October 2016

Get Backup History for All Databases in Server

Here's a quick snippet to get a listing of the database backups that last occurred on a server. Most solutions provided a single backup listing, but not the brief summary of the last backup details I was looking for. Read more

0 comments, 40 reads

Posted in SQL Barbarian on 31 October 2016

Why Halloween slowed your queries

Let me start by saying that this isn’t your typical post about the Halloween problem. This is intended to describe a couple different performance problems you should be keenly aware of.

If you’ve never heard of the Halloween problem then I suggest you read about it from Paul White’s blog… Read more

0 comments, 289 reads

Posted in Confessions of a Microsoft Addict on 31 October 2016

Get Backup History for All Databases in Server

Here's a quick snippet to get a listing of the database backups that last occurred on a server. Most solutions provided a single backup listing, but not the brief summary of the last backup details I was looking for.

Read more

0 comments, 221 reads

Posted in SQL Barbarian on 31 October 2016

Watch my PASS Summit Session on PASS TV

I’m just returning from an amazing week at PASS Summit where I meet many of you while working our Pragmatic Works booth. I was also was fortunate enough to be able to deliver a session on advanced Power BI techniques on Friday.  This session was live streamed on PASS TV… Read more

0 comments, 932 reads

Posted in Devin Knight on 31 October 2016

t-sql random string generator

Note: originally published in our old blog on December 2008.

This is a simple stored procedure that you can use to generate a random string. You can use it as a random password generator and for other purposes. It is very simple so I won't bore you with…

Read more

0 comments, 120 reads

Posted in xSQL blog on 31 October 2016

A Recap of PASS Summit 2016

Yes, it’s that time of the year again. It’s time for the annual PASS Summit. Just like every year, I had the pleasure of attending Summit – as a data professional, as a speaker and as a volunteer. As always, it was a pleasure. You’ll be surprised to hear that… Read more

0 comments, 137 reads

Posted in Guy Glantser on 31 October 2016

The Halloween Problem

DBA: Help me! Help me! It’s Halloween! I have a problem! Oh won’t you please help me!

Ok, so that’s really got nothing to do with the Halloween problem. But it is Halloween today so it seemed like a good time to bring the subject up. Of course if… Read more

7 comments, 1,882 reads

Posted in SQLStudies on 31 October 2016

Master Data Services – Database Error has Occured when Publishing Business Rule

I was preparing a demo for a session about the new features of Master Data Services in SQL Server 2016. In that demo, I created a business rule to test out the extension with custom scripts. When the business rule was finished, I tried to publish it. But, I was… Read more

10 comments, 1,133 reads

Posted in Koen Verbeeck on 31 October 2016

PASSion Award and what it means to me

2016 is going to be a special year in my life. There was an article on Oscar awards a while ago – on reasons why the oscar is the most watched awards ceremony around the world. No, it is not just because of movie stars. Everyone, secretly or publicly –… Read more

0 comments, 688 reads

Posted in Mala's Data Blog on 31 October 2016

Thank you to @MrDenny

I wanted to take a quick moment to thank Denny Cherry for selecting me for Speaker Idol this year.

For those of you that don’t know about Speaker Idol or SQL Summit you can find more about them here: http://www.sqlpass.org/summit/2016/Sessions/Details.aspx?sid=54321

The competition was great and everyone did very well. If… Read more

0 comments, 297 reads

Posted in Confessions of a Microsoft Addict on 29 October 2016

PowerBi and API – Visualising my Checkins

For my own amusement and also to show my wife where I have been I use the Swarm check-in app on my phone and check-in to places. Also for my own amusement I used PowerBi to visualise the data via the API and allow me to filter it in various… Read more

1 comments, 1,251 reads

Posted in SQL DBA With A Beard on 29 October 2016

PASS Summit 2016 Recap

It has been a fantastic week here in Seattle at the annual PASS Summit. I’ve spent the last five days hanging out with 4,000 or so of my closest friends while teaching and learning more about SQL Server and data management. Although my schedule kept me busy – I delivered… Read more

0 comments, 308 reads

Posted in Tim Mitchell on 28 October 2016

Selfies at Summit

Not all selfies, and not enough, but lots of changes to meet people at the Summit this week.

The other Steve Jones (not sure who’s other)

 

And, of course, one from the Redgate SQL Clone party


Filed under: Blog Tagged: PASS, syndicated

Read more

0 comments, 354 reads

Posted in The Voice of the DBA on 28 October 2016

PASS Summit Announcements: DMA/DEA

Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception.  My next few blogs will cover the major announcements.  This first one is about the Data Migration Assistant (DMA) tool v 2.0 general availability and the technical preview of Database Experimentation Assistant (DEA). Read more

0 comments, 309 reads

Posted in James Serra's Blog on 28 October 2016

PASS Summit 2016 – Announcements

There have been different announcements for new and upcoming features in the Microsoft Data Technology ecosystem. The one today I am hearing about is Data Migration Assistant (DMA) tool v2.0 GA and Tech Preview of DEA – Data Experimentation Assistant. James Serra blogged about it here - http://www.jamesserra.com/archive/2016/10/pass-summit-announcements-dmadea/. The… Read more

0 comments, 886 reads

Posted in The Smiling DBA on 28 October 2016

Data Compare on Temporal Tables

I hadn't seen much talk on doing data comparisons on temporal tables, as they are a new feature. I went through the exercise to compare current to historical to see how Red Gate & Devart handled this. I'm a part of the Friends of Red Gate program, so love checking… Read more

0 comments, 41 reads

Posted in SQL Barbarian on 28 October 2016

PASS Summit 2016-Thursday Part II

The second half of the day was spent talking with various speakers and attendees. I got into a great conversation about trying to mentor developers at work places about how to write good T-SQL. It was interesting to here how some developers (or DBAs) are not open to new ways… Read more

0 comments, 256 reads

Posted in The Smiling DBA on 28 October 2016

Data Compare on Temporal Tables

I hadn't seen much talk on doing data comparisons on temporal tables, as they are a new feature. I went through the exercise to compare current to historical to see how Red Gate & Devart handled this. I'm a part of the Friends of Red Gate program, so love checking… Read more

0 comments, 1,383 reads

Posted in SQL Barbarian on 28 October 2016

This Week In Data – Episode 10 (Getting Started with Azure)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we discuss how you can get started with Azure.

Many of us already know this, but Azure is here and is not going anywhere. Whether… Read more

0 comments, 291 reads

Posted in Devin Knight on 28 October 2016

SQLDinner/Meetup Tonight at PASS Summit

If you’re at the PASS Summit and would like to meet some new people, come see us from 5:30 to 6:30! Take the convention center escalator to the first floor and turn left, you’ll see us and some volunteers. Here’s the plan:

  1. We’ll give you a large card and a…

Read more

0 comments, 281 reads

Posted in SQLAndy on 27 October 2016

Older posts