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

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

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

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

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

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

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

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

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

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

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

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

Every now and again you need to know how big a table is. Or several tables. Or all of the tables. Number of rows is frequently handy when you’re going to create a new index or otherwise modify the table. The amount of space used by the indexes can be… Read more

This puzzle was first proposed in 1848 by a composer of chess puzzles called Max Bezzel and has since spawned much analysis and many variants. Simply phrased, it goes as follows:

“Can you place 8 queen’s on a standard (8×8) chessboard so that no two queen’s threaten each other?”

(Just… Read more

Two years ago, we officially became MinionWare and launched the absolutely masterful SQL Server management solution, Minion Enterprise. For a few days, we're giving it away.

The post Celebrate! Second Anniversay Giveaway appeared first on The MidnightDBA Star-Times.

Read more

I was reading Brent’s blog today and decided to make my own $250k dream car garage list. Mostly because I think about this topic a lot and probably spend way too much time researching cars I’ll never own. But you never know!

 

I wanted to differ a bit from… Read more

In this module you will learn how to use the Drilldown Player Custom Visual.  The Drilldown Player acts like a slicer that animates other visuals around it on your report.

Module 60 – Drilldown Player

Downloads

• Power BI Custom Visual – Drilldown Player
• Dataset – Sales By Product.xlsx
• Completed Example…

Read more

There’s no substitute for mentoring. We’ve heard it before, and in various ways, but I think we tend to largely ignore it. Americans, at least, aren’t used to a mentor system, and we’re not in the habit of asking for mentors. But mentors can be great. You can stop them… Read more

And I’ve got it.

Glenn Berry posted a a link to the MSDN blog and almost immediately a note that the link was still the CTP. I decided to fire up my Ubuntu install and check. No updates there, though a few people reported Docker had the new bits.

A… Read more

I was given the opportunity to do a little online interview. It’s primarily about promotion, but I thought I’d share it with you. If you’re wondering what I think of the current state of the industry, go here to check it out.

The post Thoughts on the State of Data… Read more