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

Archives: June 2016

Automatic Seeding Very Large Databases in SQL Server 2016

There are a lot of new features in SQL Server 2016. Availability Groups by itself got a lot of new features.  Being that I am the founder of the High Availability and Disaster Recovery Virtual Chapter, I plan on blogging about the new availability group features.

Today, I wanted… Read more

1 comments, 2,005 reads

Posted in John Sterrett on 29 June 2016

Speaking at PASS Summit 2016

I’m very honored to be speaking at the PASS Global Summit again this year in Seattle during the week of October 24th. I cannot convey just how much this means to me, as speaking at any event is a gift and a thrill, especially a conference like the PASS… Read more

0 comments, 350 reads

Posted in Technobabble by Klee from @kleegeek on 29 June 2016

Summit Submission Feedback Response

I’m It Survival Tips for the Lone DBA – Level 100

(Not Accepted: Higher rated session selected)

Track: Professional Development

As others have done I also will share my feedback from my submission to speak at PASS Summit in hopes it will lend some more insight into the process. Read more

8 comments, 171 reads

Posted in SQLEspresso on 28 June 2016

Does my database have data type drift?

Over the years I have come to see that every database has what I call data type drift. Simply put, data type drift is when you have columns with the same name but different data types or length. I’d say about 97% of databases I’ve reviewed have some form of… Read more

8 comments, 2,398 reads

Posted in Confessions of a Microsoft Addict on 28 June 2016

Better ReadyRoll Script Naming

One of the things that I like about ReadyRoll is that the product will automatically build new scripts that are named in a sequential order. This usually results in a few scripts that look like this:

As you can see, these scripts aren’t very intuitive. In fact, if you get… Read more

0 comments, 539 reads

Posted in The Voice of the DBA on 28 June 2016

CASE Statement in GROUP BY

Set based operations means you should put everything into a single statement, right?

Well, not really. People seem to think that having two queries is really bad, so when faced with logical gaps, they just cram them into the query they have. This is partly because SQL Server and T-SQL… Read more

4 comments, 4,304 reads

Posted in The Scary DBA on 28 June 2016

Power BI Custom Visuals Class (Module 05 – KPI Indicator)

In this module you will learn how to use the KPI Indicator (This is kind of like saying “ATM Machine” isn’t it?), a Power BI Custom Visual. Power BI comes standard with a KPI visual but the custom visual we will cover in this post shows a few more options… Read more

2 comments, 2,386 reads

Posted in Devin Knight on 28 June 2016

Slidedeck ITPROceed – Power BI Status Update

I uploaded my slidedeck from the ITPROceed event to Docs.com. For the abstract, see the blog post Speaking about Power BI @ ITPROceed 2016.

Read more

0 comments, 471 reads

Posted in Koen Verbeeck on 28 June 2016

BREXIT…IT professionals need a plan… much like the UK government

The events that have unfolded over the last few days since the shock result that the BRExit referendum delivered, has, quite rightly caused a huge amount of press coverage in the UK. The remain camp are very upset and angry at the result, mainly because they can see possible negative…

Read more

0 comments, 431 reads

Posted in The SQL DBA in the UK on 28 June 2016

The Desktop Rebuild–Part 2

You can read part 1, but that’s more about the (initial) hardware changes. This one looks at getting moving on the new desktop. Note, that since I changed the MB/CPU/Boot disk, I decided to reinstall Windows as well on a new disk to ensure I wouldn’t have more issues. Read more

1 comments, 476 reads

Posted in The Voice of the DBA on 27 June 2016

Monday Morning SQL Break – June 27, 2016

The best way to make the most of the week is to set your goals.  One of the things I try to do every week is to identify three goals for each week.  What three things do I want to accomplish that will move my workload further down the road.… Read more

0 comments, 763 reads

Posted in StrateSQL on 27 June 2016

Debuting Talks at the Summit

This is a series of posts on the PASS Summit and SQL Saturdays. I’m outlining some thoughts here, sometimes for the first time, but on topics that I think make better events. These are opinions and thoughts, not mandates or demands. I’ve written previously on choosing speakers.

One of the… Read more

3 comments, 433 reads

Posted in The Voice of the DBA on 27 June 2016

Announcing Workshop for SQLSaturday Porto 2016

I am glad to share that finally today we have announced that a workshop for Sysadmins, DBAs & DevOps Engineers – called
SQL Server Professional Configuration & Optimisation Workshop will be delivered by my friend André Batista & myself on the 30st of the September 2016, 1 day before the… Read more

0 comments, 400 reads

Posted in Niko's blog on 27 June 2016

Perfectly Placed Parentheses

Like many other programming languages T-SQL uses parentheses () for a number of tasks. To help determine precedence, function calls etc. Now it’s nothing like LISP but with enough in one statement it can still get confusing at times.

The last page of any Lisp program

Here is a fairly… Read more

10 comments, 2,480 reads

Posted in SQLStudies on 27 June 2016

Retrieving the SQL Server License Key

Strangely enough its been a long time since I installed SQL in production. It’s almost always done by someone on the server team and that’s fine with me, clicking the wizard (or running the install script) isn’t the interesting part. Today though, I needed to add a named instance (also… Read more

0 comments, 424 reads

Posted in SQLAndy on 27 June 2016

Podcast Interview: Is the On-Premises Data Warehouse Dead?

Recently I’ve been talking a lot with clients and others about the involvement of cloud architecture in a data warehouse design. In fact, this topic was the focus of my most recent Data Geek newsletter publication. A few weeks ago, I had the pleasure of being interviewed by my friend… Read more

6 comments, 1,069 reads

Posted in Tim Mitchell on 27 June 2016

IT Training: Super Duper Deal!!

In the wake of last week’s BREXIT vote and subsequent fallout, I decided to delay making this announcement until today. I wanted to ensure that this deal didn’t get lost in the shockwaves of the referendum result.

Gethynellis.com has been working in collaboration with Learning Tree since 2010 writing, developing…

Read more

0 comments, 361 reads

Posted in The SQL DBA in the UK on 27 June 2016

SQL Server Indexing Book Giveaway – Week 4 (the late edition)

So… it’s Saturday night and I missed getting this out on Friday morning…

But, in past three weeks’ posts (1, 2, 3), I talked about how I’ve got a few copies of Expert Performance Indexing for SQL Server to give away.  This is a book that… Read more

0 comments, 591 reads

Posted in StrateSQL on 26 June 2016

SQL Compare 12: Initial Look

I know there have been a few other folks going into more detail on SQL Compare 12 (beta), but I thought I'd share just a few looks at the new design. Looks pretty slick, and I like where the design is going. Just a quick look, as I'm sure there… Read more

0 comments, 410 reads

Posted in Sheldon Hull on 25 June 2016

Speaking at PASS Summit 2016

There is a huge time for suspense for everyone in the Microsoft Data Platform space, whenever its time to submit sessions for the PASS Summit and even more, when the notification of the selection/non-selection are being sent to those who submitted sessions.
Even in this year (where I am planning… Read more

0 comments, 375 reads

Posted in Niko's blog on 25 June 2016

Newer posts

Older posts