Filetable–Moving files programmatically
I’ve been playing with Filetable and I was asked an interesting question. Can I move files to a folder programmatically?
It’s...
2014-05-06
1,828 reads
Blog Posts
Using a Filtered Index to Enforce Filtered Uniqueness
One of the advantages and uses of Filtered Indexes (introduced with SQL Server 2008) is to provide filtered uniqueness. Obviously...
2014-05-06 (first published: 2014-04-24)
2,170 reads
VMworld 2014 Session Voting Is Open!
I can’t believe it’s that time of year again. VMware has opened up the public voting for the VMworld 2014...
2014-05-06
735 reads
Applied SQL: Orphan a user, fix orphaned users (sp_FixOrphanedUsers)
Ever heard of orphaned users? It’s a database user account, disconnected from its associated login. You typically get this when...
2014-05-05
935 reads
Cumulative Update – 1 for SQL Server 2014 RTM Rollback by Microsoft !
The 1st cumulative update release for SQL Server 2014 RTM was released by Microsoft.
But due to issues in setup Microsoft...
2014-05-05
971 reads
Cumulative Update – 12 for SQL Server 2008 R2 Service Pack 2 Is Now Available !
The 12th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the...
2014-05-05
1,810 reads
Enable CLR with Powershell
I had an email last night from someone who attended my PowerShell Box of Tricks session at SQL Saturday Exeter
He...
2014-05-05
944 reads
Last Weeks Top “Reading” Links #82
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-05-05
541 reads
SQLSaturday #305 Business Analytics Edition Dallas–RECAP
So, I am flying home thinking about the event Saturday and many things are running through my head. No, not...
2014-05-05
823 reads
SQLServerCentral Editorial: Better, Faster, and Cheaper
Better, Faster, and Cheaper was published today and I hope you’ll read it, and then challenge your own assumptions for...
2014-05-05
629 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