SQLpassion Online Training in January 2018
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-01-09
370 reads
Stored Procedure / Function / View / Trigger Definitions Can Be Wrong, Even If sp_rename Was Never Used
SQL Server stores the full definition of certain T-SQL objects — Stored Procedures, Functions, Views, and Triggers — in their original form,...
2018-01-09
951 reads
How to Size Your Database Files?
Let’s say you need to create a new SQL Server database, which is going to grow very fast, but you...
2018-01-18 (first published: 2018-01-08)
1,787 reads
What is Graph Processing in SQL Server 2017?
There is a growing need for Graph Databases in the market. This is a type of database, which is capable...
2018-01-08
575 reads
SQLCMD Mode (Day 8)
Have you ever had a script where you needed to run parts of it on different instances of SQL Server...
2018-01-08
446 reads
Statistics Use, Extended Events and Execution Plans
Query tuning ain’t easy.
Figuring out which index is getting used is one step, and generally simple, look at the execution...
2018-01-17 (first published: 2018-01-08)
2,257 reads
Python and SQL Server Administration
Some of my previous articles on Python provided insight of the basics and the usage of Python in SQL Server...
2018-01-08
819 reads
Azure SQL Database – Optimizing For Ad-hoc Workloads
Today I found out that it is now possible to enable the setting optimize for ad-hoc workloads at the database...
2018-01-16 (first published: 2018-01-08)
1,612 reads
DataMinds.be Meetup – Biml
First blog post of the year and I’d like to take the opportunity to wish everyone the best, professionally and...
2018-01-08
360 reads
Patching your SQL Servers - Meltdown and Spectre
The latest security issue with the name "Meltdown and Spectre" affecting Intel processors was made public last week. This security...
2018-01-08
620 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