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

Latest Blog Posts

I’m Speaking at Ignite in Orlando!

I’m excited to say that I will be speaking at Ignite this year in Orlando!

I was at Ignite in Atlanta last year and it was an excellent experience. I’m really looking forward to meeting new people and running into old friends.

If you’ll be at Ignite, here are the… Read more

0 comments, 58 reads

Posted in SQLvariant on 23 August 2017

Multi-server Script to Find Orphaned Data Files using PowerShell

In this article, we take the sledgehammer approach in searching for MDFs and then comparing them against files which are available on the listed drive. The idea behind this is to generate a report of detached database files across multiple servers. That’s one way to keep our databases compliant in… Read more

0 comments, 61 reads

Posted in PowerSQL By Prashanth Jayaram on 23 August 2017

SQL Server vs Oracle: Substring

Continuing the comparison between these two database giants, we dive into the substring function. If you’ve been working with databases for a while, I’m sure you’ve had to parse a string and while you’d think these are the same they work a little different and I think Oracle may surprise… Read more

0 comments, 91 reads

Posted in Confessions of a Microsoft Addict on 23 August 2017

Preparing for Microsoft Certification Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI

Late last month Microsoft released the certification exam for Power BI, 70-778: Analyzing and Visualizing Data with Microsoft Power BI. The exam is currently in beta and will likely remain that way for the next eight to twelve weeks. If you were lucky enough to snag one of the… Read more

3 comments, 38 reads

Posted in SQL with Dustin Ryan on 23 August 2017

VMworld 2017 SQL Server Sessions

Just a reminder – our SQL Servers sessions for this year’s VMworld 2017 conference in Las Vegas are starting to fill up! I have four exciting sessions (if you’re a database geek) at the conference, and for those DBAs with VMware administrators attending this conference, tell them to attend these… Read more

0 comments, 68 reads

Posted in Technobabble by Klee from @kleegeek on 23 August 2017

Redgate Hub LiveStream

Over at Redgate, we’ve been working on a new way to get information to you. It’s called the Redgate Hub. Check it out. To help you understand this new resource, and to show off some cool new material, we’ve decided to host a livestream event, Redgate Hub Launch on… Read more

0 comments, 58 reads

Posted in The Scary DBA on 23 August 2017

VLFs the Forgotten Foe

How many of you check the amount of Virtual Log Files (VLFs) your transaction logs have?

Working as a consultant now, I see this as something that is often ignored by DBAs.  This is an easy thing maintain and yet so many don’t know how to. Keeping these in check… Read more

1 comments, 65 reads

Posted in SQLEspresso on 23 August 2017

Changing the version of an SSIS package.

Of all of the annoying parts of SSIS, the major version sensitivity has to be the most annoying. Let’s say you create a package in SSDT 2012. You later open that same package with SSDT 16 without thinking about it. SSDT automatically upgrades your to package version 8 (SQL 2014… Read more

0 comments, 63 reads

Posted in SQLStudies on 23 August 2017

The Wait Is Over – SSIS 2017 Is Here!

Finally, months after the release of SSAS and SSRS projects for VS 2017, we have the ability to create SSIS projects in VS 2017. The title is a bit misleading, because we could already create SSIS 2017 projects using the latest version of SSDT for Visual Studio 2015:

However, if… Read more

9 comments, 87 reads

Posted in Koen Verbeeck on 23 August 2017

Azure SQL Database – Scaling up

Scaling up and down your SQL Database is something that is quite common to do. I want to discuss the impact of moving up and down tiers, in terms of your transactions and connections.

We should all be aware that when changing the service tier and/or performance level of a… Read more

0 comments, 64 reads

Posted in All About SQL on 23 August 2017

Microsoft Azure – How to get details about azure locations using PowerShell

Hello friends, when we create any virtual machine using management portal we need to select the location for cloud service and azure portal shows us list of available locations. We just select the location we want and move further to next steps. We can also do this same using PowerShell…

Read more

0 comments, 156 reads

Posted in Kapil Blogs on 23 August 2017

Docker images for custom SQL Server Installations

I no longer install SQL Server on my workstation, I use Docker to spin up instances as and when I need them. This means I don’t have to go through the installation, my machine is cleaner and performance is not reduced by having multiple versions of SQL Server installed.

The… Read more

1 comments, 124 reads

Posted in The Database Avenger on 22 August 2017

Runtime Metrics In Execution Plans

Capturing query execution metrics is much easier now that you can see the runtime metrics in execution plans when you’re using SQL Server 2016 SP1 or better in combination with SQL Server Management Studio 2017. When you capture an actual plan (using any method), you get the query execution time… Read more

1 comments, 97 reads

Posted in The Scary DBA on 22 August 2017

SQL Puzzle 3: Knights and Queens

I thought I’d do another chess puzzle this month. This one is a variant on the Eight Queens problem:

SQL Puzzle 2: Eight Queens


Given the standard 8×8 chessboard, place an equal number of Knights and Queens such that no piece is attacked by another. What’s the maximum number of… Read more

0 comments, 75 reads

Posted in Matthew McGiffen DBA on 22 August 2017

SQL Saturday Charlotte (#683)

I am so excited to be helping out with SQL Saturday Charlotte again this year.  This is the 6th year that Charlotte BI Group (CBIG) has put this event on and the 3rd year that I’ve been asked to be part of the organizing team. 

We have a great lineup… Read more

0 comments, 119 reads

Posted in SQL Swimmer on 22 August 2017

Using the SSIS Script Component With Multiple Outputs

One of the more common questions I find in SQL Server SSIS forums is how to split apart a single text file into multiple outputs. Files extracted from foreign sources often arrive in nonstandard formats, and are too often unchangeable at the source and must be parsed during the import… Read more

6 comments, 107 reads

Posted in Tim Mitchell on 22 August 2017

Adding a New Default to a Column

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it.

This is a fairly simple process, but I bet more than a… Read more

0 comments, 164 reads

Posted in The Voice of the DBA on 21 August 2017

New Whitepaper – Capture Production Error States

System administrators of the world, if a VM experiences a problem that takes down business-critical application, your job is to get minimize the impact to the business. You are caught in a difficult decision.

Do you repair the VM as quickly as possible, but possibly lose traces of what went… Read more

0 comments, 118 reads

Posted in Technobabble by Klee from @kleegeek on 21 August 2017

New eBook with Pure Storage – Overcoming SQL Server Storage Challenges

My company, Heraflux Technologies, is proud to announce a new ebook as part of our joint partnership with Pure Storage! This ebook, entitled Overcoming SQL Server Storage Challenges, discusses the current state of infrastructure technologies and how it interacts and impacts the performance of Microsoft’s flagship database engine… Read more

0 comments, 80 reads

Posted in Technobabble by Klee from @kleegeek on 21 August 2017

Deploy an SSIS project to the SSIS catalog.

You’ve installed SSDT, created an SSIS project, created any packages you need and now you want to place that project and its packages onto the SQL instance so you can run them. FYI there are several ways to do this using package or project deployment, I’m just going… Read more

0 comments, 145 reads

Posted in SQLStudies on 21 August 2017

Older posts