Finding the Primary Replica of an Availability Group
This is going to be a bit of a quick post but one about something that I see coming up time and time again on SQL Undercover’s search terms....
2019-10-24
1,022 reads
Blog Posts
Geneology with SQL Graph – Part II
In the previous post I explored a query on how to construct a basic family tree with sql graph – including table set up and queries. In this post...
2019-10-24
13 reads
Get the Governance Data You Need Out of Your Power BI Gateways with PowerShell
OK, before anyone yells at me: Yes, I know the On-Premises Data Gateways are now part of Power Platform, not just Power BI. I learned how to do everything...
2019-10-24 (first published: 2019-10-15)
519 reads
Refresh Power BI Dataset using Logic Apps
A recent blog on the Power BI website announced the availability of a preview component in Microsoft Flow, which allows to easily refresh a specific dataset. This is good...
2019-10-24
162 reads
Refresh Power BI Dataset using Logic Apps
A recent blog on the Power BI website announced the availability of a preview component in Microsoft Flow, which allows to easily refresh a specific dataset. This is good...
2019-10-24
5 reads
SQLSaturday Orlando Notes – Speaker Gifts & Bags
I like to give speakers something to say thank you beyond the standard speaker shirt. It doesn’t have to be big, fancy, or expensive. I’ve always appreciated a hand...
2019-10-24
9 reads
SQLSaturday Orlando Notes – Speaker Shirts
I’ve always considered it important to offer a shirt to a speaker – part thank you, part making it easier for attendees to identify them as key volunteers. Does...
2019-10-24
13 reads
#PowershellBasics: Multiple run spaces in ISE
As you know from the last few posts, I’m in a class on Powershell. One of the first things we ... Continue reading
2019-10-23 (first published: 2019-10-16)
416 reads
Arrays in PowerShell–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This isn’t necessarily an expert post, but more...
2019-10-23
117 reads
Azure Fundamental Training this December
Here at gethynellis.com. We're very excited to be launching our web-based Microsoft Certified Azure Fundamentals Course AZ-900T01 as the next stage of delivering our aim of making Expert Skill...
2019-10-23
22 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