Restoring Azure SQL Database
A major benefit of Azure SQL Database (PaaS) is the fact that Microsoft manages the backups – it’s great because recovering...
2016-09-23 (first published: 2016-09-16)
1,232 reads
"SQL Server Permissions and Security Principals" at SQLSaturday Charlotte This Weekend!
I'll be presenting my talk on SQL Server Permissions and Security Principals this weekend at SQLSaturday #560 Charlotte, NC.
As a SQLSat...
2016-09-15
380 reads
Quick #SQLPrompt Tips – Expanding Wildcards
I tend to try and get code on the screen quickly and then start to remove things. I’m a visual...
2016-09-15
618 reads
#SQLSpeaking this Fall!
I have some great speaking dates coming up this Fall - here is the list:
--
First - the big one. I am honored...
2016-09-15
427 reads
Emojis in SQL Server
I blame Aaron Bertrand (b/t) and Kevin Kline (b/t). Aaron who posted a great #BackToBasics blog about naming stored procedures...
2016-09-15
1,313 reads
Power BI Custom Visuals Class (Module 16 – Bubble)
In this module you will learn how to use the Bubble chart Power BI Custom Visual. The Bubble chart allows...
2016-09-22 (first published: 2016-09-15)
1,538 reads
Great Value IT Training - Awesome ITIL offers
This week's Great Value IT Offers are in. If you want to your ITIL learning on this autumn we have...
2016-09-15
383 reads
Sql Server - Detecting and Monitoring Memory Pressure
Introduction - Detecting and Monitoring Memory Pressure
I will be writing this article in four parts because this
topic is huge and amount...
2016-09-15
482 reads
More PowerShell for the Azure World
The collection of Azure SQL Database cmdlets can be found at – https://msdn.microsoft.com/en-us/library/mt574084.aspx. There are alot, however I tend to use...
2016-09-15
494 reads
Future DBA part 2
I do not say you should be expert in other technologies but you should be aware of what it is...
2016-09-15
390 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers