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

Latest Blog Posts

Them Con+cat+enatin’ Blues

We ran into a funny problem not long ago, revolving around a stored procedure that was building up a dynamic SQL string. The code had worked without a hitch in our development and test environments but blew up when it was moved to production due to the dynamic SQL being… Read more

0 comments, 1,219 reads

Posted in The Monday Morning DBA on 13 September 2018

Customer Roadblocks to Azure

When I speak with customers, I often find they share common roadblocks to using Azure. I recently sat down with our Consulting Sales Manager in Texas, to ask what he hears from customers, to see if together, we can shed some light to clear up some of these Azure roadblocks. Read more

0 comments, 593 reads

Posted in DataOnWheels on 13 September 2018

SQL Server string functions for Data Munging (Wrangling)

In this article, you’ll learn the tips for getting started using SQL string functions for data munging with SQL Server. In many cases, Machine learning outcomes are only as good as the data they’re built on – but the work … Continue reading

Read more

0 comments, 163 reads

Posted in PowerSQL By Prashanth Jayaram on 13 September 2018

Using Table Valued Parameters with sp_executesql

Recently I did a presentation on dynamic SQL. In the presentation I pointed out the similarity of using sp_executesql to creating a stored procedure to do the same task. After the session I was asked: If that’s the case, can I pass a TVP (table valued parameter) into sp_executesql? Read more

3 comments, 131 reads

Posted in SQLStudies on 13 September 2018

The real differences between Dynamics 365 Operations Embedded Power BI and BYOD Power BI

I get asked this question all the time in my work as I am the BI consultant in Dynamics 365 Operations implementations.  Customer: “I would…

Read more

0 comments, 152 reads

Posted in Terry's Business Intelligence on 12 September 2018

Importing Flat Files in SSMS 17.x Works

One of the more annoying things I’ve found in SSIS/SSMS is trying to import CSV files for some quick analysis. For some reason I constantly seem to get files that the import wizard keeps having issues. On top of that, the defaults are annoying. When I need to get a… Read more

2 comments, 1,764 reads

Posted in The Voice of the DBA on 12 September 2018

Azure Storage – Hot, Cold, Archive

There’s a lot of talk about storage options. When working with customers, I often introduce them to Azure through storage, since it’s a great way to leverage cloud assets in a positive, non-threatening way.

In Azure there are 3 types of storage within Azure blob storage. Today, I’d like to… Read more

0 comments, 582 reads

Posted in DataOnWheels on 12 September 2018

Bulk insert issue with UTF-8 fixed-width file format

Fellow Canadian Doran Douglas brought this issue to my attention recently, and I wanted to share it with you as well. Let’s say you have a file in UTF-8 format. What this means is that some of the characters will be single-byte, and some may be more than that. Where… Read more

0 comments, 130 reads

Posted in Born SQL with Randolph West on 12 September 2018

3rd Edition, SQL Server Execution Plans, a Story

Four years ago, after a bunch of dithering and some negotiations with Tony Davis, my editor, I started to update my book, SQL Server Execution Plans. We managed to convince Hugo Kornelis to be the tech editor. I started to do the real writing in early 2015. I was most… Read more

16 comments, 1,475 reads

Posted in The Scary DBA on 12 September 2018

SQL Server Operations Studio and VSCode: The wrong default datetimeoffset format

This post is to answer the question: "You are used to seeing in the format of yyyy-MM-dd right?" that I have raised on my blog post Don’t cutoff yourself with dates in T-SQL – Did you know…. As you could see from that blog post, my screen shots were from… Read more

0 comments, 234 reads

Posted in Cláudio Silva on 12 September 2018


The infamous setting that we all know and love – MAXDOP. Did you know that you can actually control MAXDOP when using Azure SQL Database? You might not be able to tinker with the Cost Threshold for Parallelism setting but … Continue reading

Read more

2 comments, 179 reads

Posted in All About SQL on 12 September 2018

T-SQL Tuesday #106 – The Trouble with Triggers

For this month’s T-SQL Tuesday Steve Jones asks us to talk about our experiences with Triggers:


In my post I’m going to focus on DML (Data Modification Language) triggers. Their counterparts, DDL (Data Definition Language) triggers have any number of interesting applications. It’s usually DML triggers however that attract… Read more

1 comments, 143 reads

Posted in Matthew McGiffen DBA on 12 September 2018

Power BI Monthly Digest – September 2018

In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through some of our favorite Power BI updates this month. In our September 2018 edition we highlighted the following features:

  • Turn a Scatter Chart into a Dot Plot

Read more

0 comments, 230 reads

Posted in Devin Knight on 12 September 2018

Thursday Webinar Postponed due to Hurricane Florence

Hello! The webinar I was going to give this coming Thursday with MSSQLTips.com has been postponed. When we have a new date, I will post on here. Unfortunately, it’s hurricane season here in the United States and we have a monster one bearing down on the East Coast. If you’re… Read more

0 comments, 131 reads

Posted in Databases – Infrastructure – Security on 11 September 2018

Do You Need a Relational Data Warehouse?

Are you looking to do a major update to your data warehouse or looking to modernize? Many technologies have come about that are changing the landscape of what data warehouses are made of. In this Azure Every Day session, I’d like to talk about 3 new technologies in Azure and… Read more

0 comments, 729 reads

Posted in DataOnWheels on 11 September 2018

Pride and Prejudice... and Triggers

This post is part of #tsql2sday event :)
I know, in the world of the database administrators and developers, the triggers are the ugly duck of the database development.

They are hard to track, hard to maintain, can have a weird transaction behavior if you are not careful and can…

Read more

1 comments, 331 reads

Posted in SQL Guatemala on 11 September 2018

SQL in the City Summits–Coming to New York, London, and Chicago

I love New York. Every time I get to travel to the city, I get excited and look forward to the trip. I was able to spend a night in Brooklyn earlier this year, touring a college with my daughter. Now I’m very lucky to get a second trip this… Read more

0 comments, 193 reads

Posted in The Voice of the DBA on 11 September 2018

What happens in a trigger stays in the transaction: T-SQL Tuesday #106

Anything that happens in a trigger happens within the same transaction of the command that called it.

Part of me feels like this should be pretty obvious but it’s also one of those things that’s so obvious that it becomes easy to miss.

Let me explain:

If you run an… Read more

0 comments, 98 reads

Posted in SQLStudies on 11 September 2018

Triggers: The hidden logic that will strike back – TSQL Tuesday #106

This month’s T-SQL Tuesday is brought by Steve Jones (b | t) and he wants to know if triggers causes headaches or happiness to us. This is the 106nd edition of TSQL2sDay - an Adam Machanic (b | t) brainchild.   Triggers are those kind of database objects that sometimes… Read more

1 comments, 96 reads

Posted in Cláudio Silva on 11 September 2018

TSQL Tuesday #106: Triggers and the Spiral To Oblivion

It’s the second Tuesday of the month which must mean only one thing…

We’re all skint and payday feels like a long way off???

Not quite, well maybe… but it’s also T SQL Tuesday!

This month’s invitation comes from Steve Jones and he’s asking us to write about triggers and… Read more

6 comments, 88 reads

Posted in SQL Undercover on 11 September 2018

Newer posts

Older posts