DBCC CLONEDATABASE and sensitive data
Just over 2 months ago Service Pack 2 for SQL server 2014 was released. Included in this Service Pack is...
2016-09-28
1,770 reads
An open letter to the PASS community
PASS is our community.
It may sound a little cliche in this time of election propaganda in the US, but it’s...
2016-09-28
720 reads
Connecting to Twitter with R and RStudio
Social Media and Analytics is always an interesting combination. Twitter has an API that you can so you can connect...
2016-09-28
1,162 reads
Query shortcuts in SQL Server Management Studio
Tired of typing out the same queries day after day? Well query shortcuts in SSMS are for you!
Following on from...
2016-10-13 (first published: 2016-09-28)
4,133 reads
Power BI Desktop hosted on premises with SSRS 2016
UPDATE 2016-10-27: the preview is available as a VM in the Azure Marketplace. More information can be found on the...
2016-10-12 (first published: 2016-09-28)
3,883 reads
A really simple bug with SSMS
If you’re a long time IT professional or an occasional user of high or even low tech software you’ll know...
2016-09-28
541 reads
Configuring Passwordless PowerShell Remoting over SSH
Open Source PowerShell has been on fire, getting tons of community support and really making people think about what’s to come with a single language to manage a heterogenous...
2016-09-28
13 reads
Configuring Passwordless PowerShell Remoting over SSH
Open Source PowerShell has been on fire, getting tons of community support and really making people think about what’s to...
2016-09-28
3,411 reads
SQL Server Execution Plan Operator – Table Scan
In my previous blog we discussed about the different format of SQL Server execution plan. Now in upcoming blogs we...
2016-09-28
524 reads
SQL Server: Monitoring Disk Space with FSUTIL command line utility
Table of Contents
IntroductionPre-requisitesData flowEnable xp_cmdshellDownloadSQL CodeOutputConclusionReferencesSee Also
Introduction
This article talks about one of SQL method to fetch the disk usage details...
2016-09-27
1,674 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