“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,206 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,454 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
33 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,863 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,766 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,742 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
154 reads
Happy Belated 150th Birthday Canada, and the Importance of Compliance, Especially Vulnerability Assessments
Assess your vulnerabilities before a system compromise brings it all down: just like what wasn't done early morning on Zhiggy's...
2017-07-26
811 reads
DevOps–Fixing Poorly Named Constraints
I was building some code the other day and kept getting problems in my deployment for a change. The deployment...
2017-08-15 (first published: 2017-07-26)
1,755 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers