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

Latest Blog Posts

24 Hours of PASS Session Slides Uploaded

My slide deck from the recent webinar series 24 Hours of PASS, Summit Preview session, where I presented a session called Virtual CPUs: Right to Ludicrous Speed, are now available for you to view up at SlideShare. Let me know if you have any questions! I hope to… Read more

0 comments, 31 reads

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

Resolve Network Binding Order Warning in failover cluster

In this post, I’m going to talk about an issue that I found while running the cluster validation report. You may receive below warning message that includes information about the cause of the warning, which can help you to resolve the issue.
Rule “Network binding order” generated a warning.

Read more

0 comments, 88 reads

Posted in Ganapathi's MSSQLLover on 22 July 2017

SQLSaturday Baton Rouge #628 2017

Come join around 500+ attendees and speakers learning and networking at the LSU College of Business – Business Education Complex on Nicholson Drive Extension in Baton Rouge on Saturday July 29th 2017 8AM till 5PM. There will be plenty of MVPs and other experts in the areas of SQL Server,… Read more

0 comments, 106 reads

Posted in The Smiling DBA on 21 July 2017

Upcoming Full-Day SSIS Class in Dallas

This year I’ve delivered my full-day Building Better SSIS Packages course a half dozen times across the country, but I hadn’t scheduled this class in the Dallas area this year. As of today, that has changed! I’m happy to announce that I’ll be delivering this class at the Microsoft office… Read more

0 comments, 107 reads

Posted in Tim Mitchell on 21 July 2017

ANTS Performance Profiler for the SQL Server Dev

There are a few .NET tools that until recently I haven't had the chance to work with as much, specifically ANTS Memory Profiler and ANTS Performance Profiler. The memory profiler is more useful for someone focused on memory leaks which a SQL Dev isn't as focused on for performance tuning.… Read more

0 comments, 116 reads

Posted in SQL Barbarian on 21 July 2017

Toolbox - Which Tables are Using All of My Space?

This is the next in a new series of blogs I am going to create talking about useful tools (mostly scripts) that I use frequently in my day-to-day life as a production DBA.  I work as a Work-From-Home DBA for a Remote DBA company, but 90+% of my job functions…

Read more

0 comments, 98 reads

Posted in Nebraska SQL from @DBA_ANDY on 21 July 2017

Friday Reading 2017-07-21

Fun week! I moderated a couple of great sessions for 24 Hours of PASS: Summit Preview. As someone getting into presenting, watching the Pros do it is invaluable.

Here’s the sessions that I moderated: –

PowerShell for DBAs, What’s in it For Me?
Ben Miller gave a great overview of… Read more

0 comments, 113 reads

Posted in The DBA Who Came In From The Cold on 21 July 2017

Azure Machine Learning Algorithm Flowchart

When you are working with Machine Learning there are many things you need to keep an eye on. You need to prepare the data, deal with any missing values and you need to select an algorithm you will be using for you model.

Choosing an algorithm can be a difficult… Read more

0 comments, 370 reads

Posted in DotNine SQL Server and more on 21 July 2017

Connect SQL Server on Linux using Bash on Ubuntu on Windows

Since Microsoft has launched SQL Server on Linux, you would be working on both the platforms Linux and Windows. You can now add Bash shell on Windows 10 to play with SQL Server on Linux instead of using any third party tool like Putty or other SSH clients.

Connected SQL…

Read more

0 comments, 170 reads

Posted in SQL Geek on 21 July 2017

Lots of Resources

I’ve got a small Azure subscription, but there are a lot of resources in my mini lab. Forty seven, to be exact right now.

When I look at my bill, it’s got lots of details, but not always easy to understand.I get a breakdown and burn rate.

I can also… Read more

2 comments, 142 reads

Posted in The Voice of the DBA on 20 July 2017

Azure SQL Data Sync 2.0

Azure SQL Data Sync has been ignored for quite some time, but has finally gotten an update (it’s in public preview).  This release includes several major improvements to the service including new Azure portal support, PowerShell and REST API support, and enhancements to security and privacy.

SQL Azure Data Sync… Read more

0 comments, 81 reads

Posted in James Serra's Blog on 20 July 2017

Back to the Big Easy and SQL Saturday #628 in Baton Rouge

I’ve been fortunate enough to get to the Baton Rouge SQL Saturday a number of times. I think I’ve been 3 times and am heading back in a week for my fourth.

This is an amazing event, one of the largest in the country. I’ve met people from Texas to… Read more

2 comments, 115 reads

Posted in The Voice of the DBA on 20 July 2017

Remember What It’s Like to Be a Rookie

File this under “soft skills.” Let me start with a recent experience.

Last week I was leading a team of youth working around their local community. My oldest son was one of my co-leaders and he had just come back from his first year at The Citadel as well as… Read more

0 comments, 90 reads

Posted in Databases – Infrastructure – Security on 20 July 2017

Azure Cloud “Fear” Busting #2 – Seeking for Better Performance

We all want high performing applications and when you are in the cloud that is no different, if anything it is even more important. With this post I will discuss some areas where I have been “stung” by so you can learn from my mistakes when using Azure SQL Database.… Read more

1 comments, 101 reads

Posted in All About SQL on 20 July 2017

Speaking at PASS Summit 2017

I’m very pleased to announce that I will be speaking at PASS Summit 2017!  This is my first time speaking at PASS Summit and I’m very excited to be doing so! What’s more, is I get to help blaze new ground on a emerging technology SQL Server on Linux Read more

0 comments, 110 reads

Posted in Anthony Nocentino's Blog on 19 July 2017

DevOps Basics–Git log

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.

In a few previous posts I’ve looked at getting going with git,… Read more

2 comments, 228 reads

Posted in The Voice of the DBA on 19 July 2017

SQL Server 2016 helps with Best Practices

In order for your SQL Server instance to run optimally, there are many SQL Server best practices that you need to follow. The SQL Health Check that you can have us perform on your instances looks at many of these. SQL Server 2016, which at the time of this writing… Read more

0 comments, 156 reads

Posted in A Discussion of SQL Server-Related Topics on 19 July 2017

SQL Server Agent and Daylight Savings time

There was a bit of chat today on the SQL Community slack about UTC and Daylight Savings Time. It reminded me I have a post in draft somewhere about the complications of dealing with timezones in SQL that I should get around to finishing.

It also reminded me of a… Read more

0 comments, 128 reads

Posted in Matthew McGiffen DBA on 19 July 2017

SQLSaturday Baton Rouge at LSU on July 29

The big finale to our SQL Summer and the last of the three Gulf South 2017 SQLSat events, our 9th annual SQLSaturday features an 11-track lineup of speakers from around the country, assembled by our scheduling extraordinaire Kenny Neal.

The schedule includes a whole track of PowerBI experts,…

Read more

0 comments, 120 reads

Posted in SQL Tact on 19 July 2017

SQL Cruise: Alaska 2017

We’re weeks away from another SQL Cruise. If you’ve never heard of this before, follow the link to read more. There you’ll also find testimonials and suggestions on how to sell SQL Cruise to your boss. I’m going to leave selling it to your boss to you. I want… Read more

4 comments, 155 reads

Posted in The Scary DBA on 19 July 2017

Older posts