Issues with SQL Server Permissions to Restore a Database
In this article we look at solving SQL Server database restore issue when backup file does not show up in SSMS restore GUI as well as other permissions issues with backup and restore.
A New Community Summit
The PASS Data Community Summit is coming back this November, and it's free to attend.
Working with Get Metadata Activity in Azure Data Factory
Learn how to gather metadata information about the files being processed in your ADF pipeline.
SQL Compilations/sec is not what you think it is
SQL Server perfmon counters provide a wealth of information about performance. In this article, Fabiano Amorim shows how current wisdom about one counter, SQL Compilations/sec, can sometimes be misleading.
Testing SQL Server Databases Using SQL Test
During database development, as well as writing SQL, you must also write the tests that prove your SQL code meets all the requirements. The article will help you get started with database testing for your SQL Server databases, by creating and running unit tests against them, as well as static code analysis tests.
Better SQL is a Good Career Investment
Today Steve notes that learning to be better at SQL is a good career investment, more for you than your boss.
Connect to MySQL Through SSH Using the CData MySQL Driver
Learn how to use the CData MySQL connector to access data across SSH.
Improving performance with instant file initialization
Instant file initialization can speed up database creation, file growth, and restores. Greg Larsen explains how to configure it and how it works.
Microsoft at PASS Data Community Summit 2021
We're thrilled to welcome Microsoft as the Premier Sponsor at this year's PASS Data Community Summit. The Microsoft team will be a fundamental part of the conference program and activities through educational sessions, product deep-dives and announcements, Microsoft-focused workshops, keynotes, and more. We're excited to continue this relationship in support of the global data community.
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers