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

Latest Blog Posts

Does SQL Server 2019 run on Ubuntu 18.04 LTS?

Yes. Here’s the proof from an output of SELECT @@VERSION: [crayon-5c90d6cc6f499950649174/] Here’s a screenshot of me running mssql-cli on the Ubuntu Server virtual machine in question. SQL Server 2019 (CTP 2.3) is running on 18.04.2 LTS. Is it supported by Microsoft? Not right now. The official documentation still requires Ubuntu… Read more

0 comments, 279 reads

Posted in Born SQL with Randolph West on 13 March 2019

Database Development Gone Wrong

I recently shared a story about how I was personally responsible for a development project going off the rails (and oh boy, did it go off the rails). It’s a very painful story to share since I was the principal bad guy. However, I learned a lot of lessons from… Read more

2 comments, 165 reads

Posted in The Scary DBA on 13 March 2019

Telegraf Setup FAQ for Troubleshooting

I often get emails asking the same time of questions about the setup of Telegraf for SQL Server and Windows while people are trying to set it up.  Hopefully, this blog post will help answer most people’s questions and help them troubleshoot the setup.

First, if you have a problem… Read more

0 comments, 117 reads

Posted in Database Superhero’s Blog on 13 March 2019

Enable Mail Profile – Back to Basics

I’ve seen many people go through the trouble of setting up database mail and configuring SQL Agent Alerts only to realize it’s not working. The reason in the cases I’ve seen is because they have simply neglected to assign a mail profile to SQL Agent. This is way more common… Read more

0 comments, 103 reads

Posted in SQLEspresso on 13 March 2019

Quick tip: Zoom in Azure Data Studio

If you finally have given a try to Azure Data Studio, and if you use it on a regular basis, maybe you want to customize it to suit your needs.

Among the huge customization options it has, you can control the text size in form of zoom. To…

Read more

0 comments, 730 reads

Posted in SQL Guatemala on 13 March 2019

Whats a SQL Notebook in Azure Data Studio?

Azure Data Studio is a cross-platform database tool for data professionals using the Microsoft family of on-premises and cloud data platforms on Windows, MacOS, and Linux.

Recently Vicky Harp tweeted

Read more

0 comments, 194 reads

Posted in SQL DBA With A Beard on 13 March 2019

Differences Between the Various Binary Collations (Cultures, Versions, and BIN vs BIN2)

(last updated: 2019-03-15 @ 02:45 EST / 2019-03-15 @ 06:45 UTC )

Binary collations are, in many ways, simpler to understand than non-binary collations because they don’t have any complex, culture-based linguistic rules. They just work with the character values and there is little room for mystery: all characters have… Read more

3 comments, 195 reads

Posted in SQL Quantum Leap on 13 March 2019

SQL Server Deadlocks

A quick video clip showing how to create a deadlock in SQL Server and find information about it.

Read more

1 comments, 797 reads

Posted in All About SQL on 13 March 2019

Power BI Monthly Digest – March 2019

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

  • Single Select Slicer
  • Selection Pane Improvements
  • Default Tooltip Formatting
  • Web…

Read more

0 comments, 371 reads

Posted in Devin Knight on 13 March 2019

#TSQL2sDay – #112 – Mini cookies

This months TSQL Tuesday is hosted by Shane O’Neill (Blog | Twitter) Shane explains the Topic as:
Dipping into the Cookie Jar is about when the going gets tough and you don’t think you can handle anymore, then you think back about your accomplishments and take some sustenance… Read more

0 comments, 106 reads

Posted in SQL Undercover on 12 March 2019

How to Submit Feedback to Azure Data Studio WITHOUT tweeting.

This is one of those things that doesn’t warrant a blog post; until you talk to three other well-versed data professionals who all had the same confusion.

Azure Data Studio is a great little cross-platform SQL editor and the team has been working hard to add some of the most… Read more

0 comments, 149 reads

Posted in SQLvariant on 12 March 2019

Capturing a Workload with WorkloadTools

Last week I showed you how to use WorkloadTools to analyze a workload. As you have seen, using SqlWorkload to extract performance data from your workload is extremely easy and it just takes a few keystrokes in your favorite text editor to craft the perfect .json configuration file.

Today I’m… Read more

1 comments, 102 reads

Posted in SpaghettiDBA on 12 March 2019

#TSQL2sDay – NomNomNomNomNom

The topic for this months T-SQL Tuesday #112 hosted by Shane O’Neill (Blog / Twitter) is about “dipping into your cookie jar”. This reference means “when times get tough how do you dip into your reserves to keep going”. Shane asks the following:

That is what I want…

Read more

0 comments, 78 reads

Posted in SQL DBA With A Beard on 12 March 2019

The T-SQL Tuesday #112 Cookie

It’s T-SQL Tuesday again, and I’m writing in response to Shane O’Neil’s invitation about cookies. Read what he asks and this will make more sense.

As always, if you want to participate, write a post on your blog and follow the rules on the invite.

If you want to… Read more

0 comments, 117 reads

Posted in The Voice of the DBA on 12 March 2019

TSQL Tuesday #112 – Dipping into the Cookie Jar

This month’s TSQL Tuesday comes from Shane O’Neil and he’s asking us to ‘dip into the cookie jar’ (or raid the biscuit tin, for us Brits ), essentially how we use past accomplishments to help us through difficult or challenging times.

I’ve been trying to think about this and while… Read more

0 comments, 76 reads

Posted in SQL Undercover on 12 March 2019

Dipping into the Cookie Jar: T-SQL Tuesday #112

This month our intrepid host for T-SQL Tuesday is Shane O’Neill (b/t). He’s asked us to talk about our cookies. No not the kind you eat (Double Stuff Oreos and Thin Mints are the best of course) or even the kind that web sites use to… Read more

0 comments, 83 reads

Posted in SQLStudies on 12 March 2019

Gaps and Islands Across Date Ranges

Watch this week’s episode on YouTube.

In a traditional gaps and islands problem, the goal is to identify groups of continuous data sequences (islands) and groups of data where the sequence is missing (gaps).

While many people encounter gaps and islands problems when dealing with ranges of dates, and recently… Read more

4 comments, 751 reads

Posted in Bert Wagner on 12 March 2019

Dipping into the Cookie Jar

This post is a response to this month’s T-SQL Tuesday #112 prompt by Shane O’Neill.  T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and professional topics every month. In this month’s topic Shane asks us to describe past accomplishments that help… Read more

0 comments, 88 reads

Posted in Bert Wagner on 12 March 2019

Using Kubernetes Deployments for Updating SQL Server

In Kubernetes we can leverage Controllers to help manage our application state, keeping them in the desired state. In this blog post, we’re going to look at how to use a Deployment Controller to manage the application state of SQL Server in Kubernetes. We’ll look at deploying SQL Server in… Read more

0 comments, 321 reads

Posted in Anthony Nocentino's Blog on 12 March 2019

T-SQL Tuesday Sharing Cookies

It has been a while since I have participated in a T-SQL Tuesday but I felt the urge to do so this month because of the host – Shane O’Neill (a good friend) and the topic of cookies (not the … Continue reading

Read more

0 comments, 138 reads

Posted in All About SQL on 12 March 2019

Newer posts

Older posts