Weekly reading #29
The Data Breach Game: The 9 Worst IT Security Practices Joey D’Antoni shows bad practices for security in SQL Server. He summarizes all the most important areas you should...
2019-10-21
20 reads
Blog Posts
Last Week Reading (2019-10-20)
Hello folks! 2 weeks passed but eventually, I have some news for you. Press Support for Azure Databricks Instance pool for operationalizing Databricks workloads in Data Factory Public Preview...
2019-10-20
10 reads
“xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun” – git in terminal does not work after macOS upgrade to Catalina
This blog post is how to get git going after upgrading to Catalina (10.15). I use git as a method of storing all my presentations and work files. It...
2019-10-19
1,765 reads
GotoWebinar (and Teams) won’t screen share after macOS update to Catalina (10.15)
This blog post is about the situation where after upgrading to the latest macOS version 10.15 – also known as Catalina – you may not be able to share...
2019-10-18
48 reads
Interview with Bob Ward
This is the eight interview we have done. This time our guest is the one and the only Bob Ward! Bob Ward is a Principal Architect for the Microsoft...
2019-10-18
4 reads
Just Getting Specific Files in PoSh–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Just a quick one today, but a tip...
2019-10-18 (first published: 2019-10-09)
227 reads
Undercover TV Podcast – Intent Locks
The first of our new series of new look podcasts, David has a look at intent locks in SQL Server and what the purpose of them is.
2019-10-18 (first published: 2019-10-14)
194 reads
Backup Techniques for SQL Server on Azure Virtual Machines
In the previous blog post I did a quick overview building a SQL VM (imaged) in Azure. It is now time to clarify some backup techniques because it can...
2019-10-17
31 reads
Geneology with SQL Graph – I
I have been working a lot of SQL Graph related queries and applications of the graph data concept to the extent possible within SQL Server’s graph capabilities. Genealogy, or...
2019-10-17 (first published: 2019-10-14)
1,192 reads
PowerShell Notebooks in Azure Data Studio
The latest release of the insiders edition of Azure Data Studio brings the first edition of PowerShell Notebooks! You can download the latest insiders edition from the link above,...
2019-10-17
7 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers