Using Test-DbaOptimizeForAdHoc
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2017-07-28
467 reads
Friday Reading 2017-07-28
Hope you all had a good week. Been pretty chilled out here so I’ve been reading…
Announcing Azure Container Instances
Microsoft blog...
2017-07-28
389 reads
“Does that copy subscriptions too?” – Now it does! New PowerShell SSRS commands
On my last post “SSRS Report Deployment Made Easy – 700 Times Faster” I showed how you can rely on the...
2017-08-15 (first published: 2017-07-27)
5,209 reads
SQL Server on Linux Series: Moving TempDB
In the last blog post, we added additional drives to the SQL Server machine so that we can scale out...
2017-08-16 (first published: 2017-07-27)
1,456 reads
Two Ways to Restore Database from MDF File in SQL Server
Introduction
In todays decade Relational database Management system became the necessity of the organizations whether they are small level or large level. In such context SQL Server is the best...
2017-07-27
37 reads
Two Ways to Restore Database from MDF File in SQL Server
Introduction
In todays decade Relational database Management system became the necessity of the organizations whether they are small level or large...
2017-08-14 (first published: 2017-07-27)
92,920 reads
Azure Labs–Minor Cluster Issues for SQL Server Setup
During the process of building an Azure lab, I ran into a place where my cluster was not completely validated....
2017-07-27
531 reads
DevOPs is not just about the latest & greatest tools
I’m a technical guy.
Thus – I love tools. They make stuff go.
Tools are great.
Except – as I wrote in my other post...
2017-08-10 (first published: 2017-07-26)
1,769 reads
Working with Very Large Tables
Recently I presented an online session with the title “Working with Very Large Tables Like a Pro in SQL Server 2016”....
2017-08-14 (first published: 2017-07-26)
4,747 reads
Acids and Databases: A look at ACID and transactions
Relational database management systems (RDBMS) such as SQL Server, Oracle, MySQL, and PostgreSQL use transactions to allow concurrent users to...
2017-07-26
159 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
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers