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

Archives: January 2019

A brief introduction for bcp

I end up using the bcp utility to move tables between environments, and I’ve found that a lot of the guides on the internet go into great detail on how to use it. That’s fine if you have a lot of time. Here’s my brief introduction so that if I… Read more

0 comments, 30 reads

Posted in Arthur's Blog on 16 January 2019

Controlling the firewall for an Azure SQL DB via T-SQL

The other day I took a Microsoft Learn course about securing Azure SQL DB. It was really enjoyable and I learned quite a bit, but one of the things that really stood out was the fact that you can control the firewall via T-SQL. Now the reason this stands out… Read more

0 comments, 31 reads

Posted in SQLStudies on 16 January 2019

Let’s talk SQL Server Waits: Topic 2 – CXPacket

With our effort to talk about SQL Waits we come across another common wait called CXPacket. Last week we reviewed SOS_Scheduler_Yield.

If you see CXPacket waits on your supported system you can safely assume you have execution plans running parallel. Any time you have queries running parallel you will see… Read more

0 comments, 35 reads

Posted in vitamindba on 16 January 2019

Inspector V1.3 hotfix

Unfortunately we discovered a small bug in 1.3, the Database ownership module default warning level was not showing a yellow advisory condition when using the Inspector default warning level (NULL), we have now updated Git with the latest revision.

If you would rather not re install 1.3 again you can… Read more

0 comments, 29 reads

Posted in SQL Undercover on 16 January 2019

Deploying SQL Server to Kubernetes using Helm

In previous posts I’ve run through how to deploy sql server to Kubernetes using yaml files. That’s a great way to deploy but is there possibly an easier way?

Enter Helm. A package manager for Kubernetes.

Helm packages are called charts and wouldn’t you know it? There’s a chart… Read more

0 comments, 44 reads

Posted in The DBA Who Came In From The Cold on 16 January 2019

It’s always parameter sniffing (part 1?)

This is a blog post about a perennial issue. Have you ever had a call in the middle of the night about a slow webpage and you know nothing in the webpage changed?

Yeah, it’s probably parameter sniffing.

First, some clarification

All parameter sniffing is not bad. It’s usually a… Read more

0 comments, 82 reads

Posted in Arthur's Blog on 16 January 2019

Beware! Beware of Unintended Changes When Altering Columns!

(last updated: 2019-01-15 @ 19:50 EST / 2019-01-16 @ 00:50 UTC )

I haven’t seen a lot written about these particular behaviors so I thought I would mention them. And, while they are documented, that doesn’t mean that most people are aware of them.

What I am referring to are… Read more

0 comments, 81 reads

Posted in SQL Quantum Leap on 15 January 2019

Inspector V1.3 now available

Inspector V1.3 is now available on GitHub.

We have updated the sample report for you to play with which includes the new informational section added in this build.

We updated our getting started guide.

We know some of you really hate linked servers so we have been working… Read more

0 comments, 56 reads

Posted in SQL Undercover on 15 January 2019

SQL FAILS with Andy Mallon, Erin Stellato, and Mr. Anonymous!

Watch this week’s video on YouTube.

While most of us strive to make as few mistakes as possible when it comes to our servers and data, accidents do occasionally happen.

Sometimes those accidents are easily fixed while other times the solutions require herculean efforts (usually accompanied by lots of caffeine… Read more

0 comments, 119 reads

Posted in Bert Wagner on 15 January 2019

Moving off SQL Server 2008 / R2 – What can Azure offer?

You will very likely know that SQL Server 2008 / R2 end of support is on July 9th 2019. Not that long to start thinking about and assessing your options. For this post I just want to discuss couple of … Continue reading

Read more

1 comments, 156 reads

Posted in All About SQL on 15 January 2019

Extended Events: Detect Implicit Conversions that affect execution plans

Implicit Conversions – Introduction

In this blog post, I’ll explain and demonstrate how to use Extended Events to detect Implicit Conversions that affect execution plans on your SQL Server instance. But before we even start with Extended Events, let’s briefly recall what an implicit conversion is, when it happens and… Read more

0 comments, 100 reads

Posted in Joyful Craftsmen Blog on 15 January 2019

Time Animation with ArcGIS Maps in Power BI

(2019-Jan-14) Dynamic maps with dynamic visualization usually attract my attention, especially when I look at the satellite images of various cloud formations in the upper levels of the atmosphere. Heatmaps could be another example where animation could play a supportive role to point geo data changes as well as certain…

Read more

0 comments, 125 reads

Posted in Data Adventures on 14 January 2019

My New Year Challenge: The Kessel Run and Keto

The Kessel Run Medal for 2019
Hello Dear Reader, it's been a while since we talked.  Part of the new year is setting goals.  I plan to blog more.  I also plan on trying to get in better shape and lose some weight.  Weight loss has been a constant issue…

Read more

0 comments, 83 reads

Posted in SQLBalls on 14 January 2019

Pro SQL Server on Linux- More Installs

As part of my learning goals for 2018, I wanted to work through various books. This is part of my series on Pro SQL Server on Linux from Bob Ward.

After my last post, I decided to try and install the SQL Server 2019 preview version and see how that… Read more

0 comments, 131 reads

Posted in The Voice of the DBA on 14 January 2019

Today, I’m making my 100th post on SQLShack

The journey with the SQLShack family has been a one from the beginning. It is certainly not easy to join an excellent group of elite authors. When I joined this family, I looked at it as a place to showcase … Continue reading

Read more

0 comments, 90 reads

Posted in PowerSQL By Prashanth Jayaram on 14 January 2019

Availability Groups: When Your Synchronous Secondary isn’t Synchronous

During a recent DR scenario I came across a slight misinterpretation in how availability groups with replicas in synchronous commit behave.

How An Availability Group With A Synchronous Secondary Should Behave Under Normal Circumstances

Normally, if we’ve got a secondary replica in synchronous commit mode, our primary can’t commit any… Read more

1 comments, 128 reads

Posted in SQL Undercover on 14 January 2019

DevOps and Automation Will Eliminate the DBA

I’ve been reading about the death of the DBA ever since I first made the jump from full time developer to full time data professional. The first time I heard it was when SQL Server 7.0 was released. Did you know that SQL Server 7.0 was self-tuning? In fact, it… Read more

0 comments, 216 reads

Posted in The Scary DBA on 14 January 2019

Developing Presence

At SQL Saturday Nashville, I didn’t do a good job explaining the concept of presence. This is in reference to the Women in Technology presentation at lunch. Part of the discussion was around how height can influence being noticed. I agree that it does play a huge role. At 5’7″,… Read more

0 comments, 83 reads

Posted in Databases – Infrastructure – Security on 14 January 2019

SQL Server Monitoring: What to start measuring

So you’ve got a SQL Server that you want to monitor. What should you monitor? In my opinion, at bare minimum, you want to collect wait statistics. Let’s talk about a basic wait statistics collection.

Our new best friend: dm_os_wait_stats

This is the only place we need to query. It’s… Read more

0 comments, 114 reads

Posted in Arthur's Blog on 14 January 2019

Quick Permissions Audit

Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out who has access to what.  In addition, they may need to know by what means people have access within your databases.

When that need arises, it is frequently adequate to… Read more

0 comments, 122 reads

Posted in SQL RNNR on 14 January 2019

Older posts