Blog Posts

Use T-SQL, not the GUI

• by Jen McCown

• SQL Awesomesauce

There’s a very good reason to do most of your DBA work using T-SQL, and not the SSMS object explorer. Let me tell you about it...
The post Use T-SQL,...

2019-08-23

32 reads

VSCode Tips–Remove the Highlighted Line

• by Steve Jones

• The Voice of the DBA

VSCode was making me crazy as I was writing a script. I like a light theme, and every time I went to type, I saw this: The highlight was...

2019-08-23

8 reads

Allow SQL Server Agent jobs management for non sysadmins

• by Cludio-Silva

• Cláudio Silva

I don’t know about your experience when it comes to SQL Server Agent jobs but often I receive requests to grant permission so that clients can handle their jobs...

2019-08-22 (first published: 2019-08-13)

761 reads

Graph Databases – Introduction

• by Mala Mahadevan

• Mala's Data Blog

I have been looking into this feature and also into understanding graph data in general. I believe introduction of graph database feature in SQL Server has many advantages –...

2019-08-22 (first published: 2019-08-09)

547 reads

Letter To My Father

• by SQLFlipFlopsDBA

• SQLFlipFlopsDBA

We spread my Fathers ashes over the past weekend. It was one of the hardest things...

2019-08-22

7 reads

New Centralized View of SQL Resources in Azure

• by Meagan Longoria

• Data Savvy

Yesterday, some new views were made available in the Azure portal that will be helpful to those of us who create or manage Azure SQL resources. First, a new...

2019-08-22

13 reads

Public and Demo Data Coming Soon!

• by Bradley-Schacht

• Bradley Schacht

Any database professional that has been around the Microsoft world for more than about 3 minutes will be familiar with the old, faithful sample dataset created and published by...

2019-08-22

8 reads

The 99 Flavours of SQL Server are all Vanilla

• by Matthew McGiffen

• Matthew McGiffen DBA

There are so many options for running SQL Server now. It can feel a little intimidating.  You’ve spent years gaining experience with SQL running on Windows Server. On bare...

2019-08-22

12 reads

Why do DBAs dislike loops?

• by Kenneth Fisher

• SQLStudies

If you started out as a developer you were probably taught how important loops are. They are one of the ... Continue reading

2019-08-22

24 reads

#DPS10 – preconfs

• by damianwidera

• Coding Family

I have delivered a preconf on the biggest conference in Asia. The preconf was about Supervised and Unsupervised Machine Learning with bonus track about Semi-supervised solutions. This was really...

2019-08-21

1 reads