Getting table row counts with sp_Tablecount
Sometimes you just want to get a quick row count for a specific table – other times you may want to see a list of tables order by size...
2019-11-06 (first published: 2019-10-30)
1,064 reads
Blog Posts
Hi, I’m Hamish Watson and I’m running for the PASS Board of Directors.
Hi, I’m Hamish Watson and I am running for the PASS Board of Directors: https://www.pass.org/Governance/Elections.aspx This blog post is why I decided to run for the board, why I...
2019-11-06
22 reads
Links and Resources from “How to Architect Successful Database Changes”
Steve Jones and I had a great time today talking about source control for databases and release patterns for performance and availability in Seattle. We had a great group...
2019-11-06
24 reads
2019-11-06
6 reads
2019-11-06
11 reads
Powerhell Notebooks in ADS–A Minor Issue
I heard about the addition of PoSh as a kernel for notebooks in Azure Data Studio. This is in the November 2019 release, and you can download/upgrade today to...
2019-11-06
41 reads
SQL Server 2019 is here
With the release of SQL Server 2019, I wanted to highlight in a single place some things that I’m excited about. Drawing on sessions I presented this year at...
2019-11-06
9 reads
Volunteers
This week is the PASS Summit and it has me thinking about all of the amazing work done in our ... Continue reading
2019-11-06
9 reads
5 Game Changers with SQL Server 2019
Microsoft made SQL Server 2019 Generally Available this week we want to share some videos and code examples of our favorite new features. Most of these will make your...
2019-11-05
117 reads
5 Game Changers with SQL Server 2019
Microsoft made SQL Server 2019 Generally Available this week we want to share some videos and code examples of our favorite new features. Most of these will make your...
2019-11-05
5 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Ampera Telpon/WA:08137887595
BCA KCP Ampera Telpon/WA:08137887595.Gedung Aurum, Jl. Ampera Raya No.37, Cilandak Tim., Ps. Minggu, Kota...
BCA KCP Permata Kota Tlpn/Wa 0853.7373.7551
Komplek Permata Kota, Jl. Pangeran Tubagus Angke No.170 Blok L Kav 8 & 9,...
BCA KCP Sampoerna Strategic Square Telpon/WA:08137887595
BCA KCP Sampoerna Strategic Square Telpon/WA:08137887595.Gd. Sampoerna Strategic Square, Jl. Jenderal Sudirman Tower A...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers