Data lake details
I have blogged before about data lakes (see What is a data lake? and Why use a data lake?), and wanted to provide...
2017-06-29
4,586 reads
PowerShell Module for the SQL Server Diagnostics API – 1st Command Get-SQLDiagRecommendations
I saw this blog post about the SQL Server Diagnostics add-on to SSMS and API and thought I would write...
2017-06-29
738 reads
Recording of PASS Security VC Webinar
If you were unable to attend this month’s PASS Security Virtual Chapter webinar, The Dirty Business of Auditing, it has...
2017-06-29
571 reads
Trying to Solve the Wrong Problem
Some time back, while pulling into a local coffee shop, I spotted a stranded motorist in the parking lot. Per...
2017-06-29
549 reads
SQL SERVER DATABASE FILES WISE I/O LATENCY PART#2
Since the DMF sys.dm_io_virtual_file_stats shows cumulative I/O statistics value for the database files, you can’t just use the DMF to...
2017-06-29
1,184 reads
Where To From Fundamentals?
The Database Fundamentals series is now done. We started with understanding what a database is, and then spent a little...
2017-06-28
355 reads
Row-count Estimates when there are no Statistics
I was discussing Cardinality Estimation with a colleague recently and the question came up, what cardinality does SQL Server use...
2017-07-12 (first published: 2017-06-28)
2,889 reads
SQL Crossword : T-SQL Keywords : June 2017
I did a SQL crossword last month (not my first one either) and it was pretty popular so I asked...
2017-07-07 (first published: 2017-06-28)
2,435 reads
The Three A’s: Auditing
Authentication and Authorization, the first two of the three A’s of security, control who gets access to what. However, at...
2017-07-13 (first published: 2017-06-28)
1,631 reads
Persisting data in docker containers – Part Two
Last week in Part One I went through how to mount directories from the host server into a docker container...
2017-07-10 (first published: 2017-06-28)
1,630 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers