Quick Blog: Run PowerShell Core from the PowerShell Integrated Console
Run whichever version of PowerShell Core from the PowerShell Integrated Console in Azure Data Studio and VS Code. Even on Windows.
2019-09-27
143 reads
Blog Posts
2019-09-26T13:58:58+00:00
TEST You know you probably reserved the wrong hotel when you drive around from the back and think it's a condemned building, only to come around the front and...
2019-09-26
7 reads
2019-09-26T14:04:40+00:00
TEST I have a new term for the wait my daughter eats food. Instead of please stop wearing food all over your face and eat proper I'm going to...
2019-09-26
7 reads
ASF 025: Rob Farley interview
Introduction Rob Farley is a Microsoft Certified Master, Microsoft Certified Trainer and is a recipient of the Microsoft MVP Award for SQL Server since 2006. Rob provides consulting and...
2019-09-26
19 reads
Check Query Progress with Live Query Stats
This is something I touched on back in 2017 a little after the Live Query Statistics feature was introduced with SQL 2016, but I was using the functionality this...
2019-09-26 (first published: 2019-09-18)
1,928 reads
SQL Server Statistics Health Reminder
I’ve written about statistics in SQL Server a few times now. Through conversations I am reminded that not everyone keeps their table statistics up to date. Keeping your statistics...
2019-09-26 (first published: 2019-09-18)
503 reads
An Effective Solution to Resolve SQL Database Corruption
I am a SQL Administrator and today I will share my experience about an issue on SQL server, which corrupted the transaction logs and left the database in a...
2019-09-25 (first published: 2019-09-17)
2,779 reads
Blogging and coding best practices
I had a discussion a while back, I think it was with Grant Fritchey (b/t) but I just can’t remember. ... Continue reading
2019-09-25
24 reads
Gatekeeping and Accessibility
In my final post about gatekeeping in technology, I have to come clean about something. Let’s go through this journey together. In the first post we spoke about what...
2019-09-25
16 reads
Hot Patching sqlservr.exe in Azure SQL Database
An amazing blog post by Microsoft describing the idea of hot patching the database engine in Azure SQL Database to allow for minimal downtime when applying patches to SQL...
2019-09-25
34 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Banjarbaru Telpon/WA:08218168291
BCA KCP Banjarbaru Telpon/WA:08218168291.Jl. A. Yani No.KM 33 5, Guntung Payung, Kec. Landasan Ulin,...
BCA KCP Santa Tlpn/Wa:6285188120691
Jl. Wolter Monginsidi No.54, Petogogan, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah Khusus Ibukota...
BCA Finance Bekasi Layanan Mobil Telpon/WA:08218168291
BCA Finance Bekasi Layanan Mobil Telpon/WA:08218168291.KOMPLEK MEGA OFFICE PARK, Jl. Harapan Indah Boulevard No.8...
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