MVP for Another Year
I am honored and humbled to be awarded the Microsoft Most Valuable Professional award for the Data Platform category. This is my 6th award, and I am just as...
2019-07-30
5 reads
Blog Posts
MVP for Another Year
I am honored and humbled to be awarded the Microsoft Most Valuable Professional award for the Data Platform category. This is my 6th award, and I am just as...
2019-07-30
7 reads
MVP for Another Year
I am honored and humbled to be awarded the Microsoft Most Valuable Professional award for the Data Platform category. This is my 6th award, and I am just as...
2019-07-30
12 reads
Power BI Interview Questions – Volume 03 – DAX
Welcome to our continuing series that Erin Ostrowsky [Blog | Twitter] and I spend focusing on interviewing for a Power BI position. This series will
2019-07-30 (first published: 2019-07-09)
720 reads
The tools you should know for the Machine Learning projects
I would like to start my first Machine Learning project. But I do not have tools. What should I do? What tools (environments, libraries etc) shoudl I use? I...
2019-07-30
184 reads
Event Files on Linux
For the most part, things work the way you might expect them to work in windows - except it is on Linux. Sure some things are different, but SQL...
2019-07-29 (first published: 2019-07-10)
197 reads
More Kubernetes Concepts
This post continues looking at my process of learning more about Kubernetes. I’ve been working through the 50 days of Kubernetes (K8s). Now that I had a break from...
2019-07-29
90 reads
Optional vs Required parameters in Stored Procedures
If you are executing a stored procedure with a bunch of parameters it can be a bit of a pain ... Continue reading
2019-07-29
172 reads
Sample Azure DevOps Pipelines
I’ve said it before and I will repeat myself on this because it’s an important concept: DevOps is about culture and communication, not tools Now, that said, to implement...
2019-07-29
110 reads
SQL server and Java?
I was generally reading about SQL Server and how things have changed since the days of just having it within a Windows Eco-system only. It then led me to...
2019-07-29
84 reads
Blogs
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...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
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