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
12 reads
Blog Posts
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
14 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
16 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)
420 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
122 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
27 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
8 reads
Azure SQL Database Failover – Grace Period?
The Azure SQL Database service triggers an automatic failover after a failure is detected and the grace period has expired. What is the grace period? You can find this...
2019-10-23
328 reads
Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - PASS Video
(2019-Oct-23) Video recording of my webinar session on Continuous Integration and Delivery (CI/CD) in Azure Data Factory at a recent PASS Cloud Virtual Group meeting.It was based on a previously...
2019-10-23
62 reads
Idera GeekSync: SQL Security Principals and Permissions 101
Thanks to Idera and all 239 of you who joined the Idera GeekSync webinar today for my topic on SQL Security Principals and Permissions 101.Fun fact: Principals and Principles have...
2019-10-23
47 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers