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

Latest Blog Posts

Getting Parameters Out From a Stored Procedure–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

One of the lesser used and known features of T-SQL are the output parameters from a stored procedure. I used one of these recently, so I wanted to… Read more

0 comments, 105 reads

Posted in The Voice of the DBA on 16 January 2019

Database modelling in a post-SSMS world: dbForge Studio

A few months ago, Microsoft announced that SQL Server Management Studio (SSMS) will no longer include the visual Database Diagrams feature from v18.0 onward. When releasing a new version of a product, Microsoft has the luxury of referencing usage statistics, and obviously this is an underused feature of SSMS. I… Read more

0 comments, 80 reads

Posted in Born SQL with Randolph West on 16 January 2019

Multi-server scripts with SSMS using SQLCMD mode

SSMS is the most common tool used by SQL Developers or DBA’s but unfortunately there are some features that are barely known, SQLCMD mode is not the exception and that’s why I decided to follow up in this topic.

You may want to check one of this previous blog post Read more

0 comments, 77 reads

Posted in DBA Mastery on 16 January 2019

Butter in My Coffee and Low Carb Tortillas: Keto Day 2

Hello Dear Reader, just a quick check in, I had originally planned to blog yesterday.  However, screen shots of apps made for a terrible looking blog.

Fortunately I found that Lose It! has an option where you can email a daily report in .csv format to yourself.  After a few…

Read more

0 comments, 82 reads

Posted in SQLBalls on 16 January 2019

Data Modeling Webcast Rescheduled

Unfortunately, due to a last minute scheduling conflict on my side, we’ve had to reschedule the data modeling webcast with MSSQLTips. It is now for next Wednesday, January 23rd, at 3 PM Eastern.

Register for webinar (free)

I apologize for the change in schedule. If you’re unable to make the… Read more

0 comments, 60 reads

Posted in Databases – Infrastructure – Security on 16 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, 104 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

2 comments, 118 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, 71 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, 64 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, 88 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, 106 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, 92 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, 70 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, 129 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, 168 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, 109 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, 140 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, 94 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, 137 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, 100 reads

Posted in PowerSQL By Prashanth Jayaram on 14 January 2019

Older posts