SQL in the City Streamed Next Week
I’m off to the UK this weekend, for a few commitments next week. One of those is SQL in the City Streamed, which is taking place on Wednesday September...
2019-08-30
12 reads
Blog Posts
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 2
This is the second post in a series about modern Data Lake Architecture
where I cover how we can build high quality data lakes using Delta Lake,
Databricks and...
2019-08-29
886 reads
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 2
This is the second post in a series about modern Data Lake Architecture
where I cover how we can build high quality data lakes using Delta Lake,
Databricks and...
2019-08-29
32 reads
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 2
This is the second post in a series about modern Data Lake Architecture
where I cover how we can build high quality data lakes using Delta Lake,
Databricks and...
2019-08-29
9 reads
Help! My Apache Spark configuration on windows isn't working (I think)
Steps needed Getting Apache Spark running on windows involves:
Installing a JRE 8 (Java 1.8/OpenJDK 8) Downloading and extracting SPARK and setting SPARK_HOME Downloading winutils.exe and setting HADOOP_HOME If...
2019-08-29
23 reads
Help! My Apache Spark configuration on windows isn't working (I think)
Steps needed Getting Apache Spark running on windows involves:
Installing a JRE 8 (Java 1.8/OpenJDK 8) Downloading and extracting SPARK and setting SPARK_HOME Downloading winutils.exe and setting HADOOP_HOME If...
2019-08-29
1 reads
More PowerShell Remoting coverage in dbatools
Starting on dbatools version 1.0.31 we introduced better coverage for commands that make use of PowerShell Remoting. Which commands? Commands like Get-DbaComputerCertificate, Get-DbaPrivilege, Get-DbaClientAlias, just to mention a few...
2019-08-29 (first published: 2019-08-20)
1,233 reads
New product: Azure Data Share
A brand new product by Microsoft called Azure Data Share was recently announced. It is in public preview. To explain the product in short, any data which resides in...
2019-08-29 (first published: 2019-08-19)
657 reads
sp_RestoreScript 1.6 Release – @Credential Added For Backups In Azure BLOB Storage
Releases seem to be coming out thick and fast at the moment, here’s the latest v1.6 revision to sp_restorescript For those of you backing up to Azure BLOB Storage,...
2019-08-29
44 reads
Profiler and Trace vs. Extended Events
It’s a running joke among the more experienced (read, older) Microsoft Data Platform specialists as to whether you’re #teamprofiler or #teamexevents. I’m very much #teamexevents, but I really don’t...
2019-08-28 (first published: 2019-08-19)
713 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
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
AI Steals Joy
Comments posted to this topic are about the item AI Steals Joy
Question of the Day
Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers