Checking for SQL Server Updates with dbatools
It turns out I was doing this all wrong for months.
For the longest time, I’ve been checking my SQL Server instances to see what needs patching with Test-DbaBuild from...
2020-04-28
70 reads
alevyinroc
- Website: https://flxsql.com
Remote Work Resources
We’re at least five weeks into this thing here in New York and while there are some encouraging signs, it’s more likely than not that “non-essential” workers aren’t at...
2020-04-21
5 reads
SQL Saturday Organizer Q&A
A little while ago, Ray Kim (blog | twitter) asked a few folks who organize SQL Saturday events a few questions for his blog. The results are in and...
2020-04-09
5 reads
COVID-19 - Work & Life Changes, How We're Coping
Settle in folks, this is a long, rambling post.
As this goes live, it’s been about three weeks since my abrupt switch from driving to the office every day to...
2020-04-06
8 reads
User Defined Types and Temp Tables Gotcha
This tripped me up a few weeks ago, but once I stopped and thought about for a moment it made total sense. I was trying to copy some data...
2020-04-02
4,352 reads
User Defined Types and Temp Tables Gotcha
This tripped me up a few weeks ago, but once I stopped and thought about for a moment it made total sense. I was trying to copy some data...
2020-04-02
7 reads
Modernizing Your T-SQL: Trimming Strings
This is one of several posts on modernizing T-SQL code with new features and functionality available in SQL Server.
Last year, you finally retired the last of your SQL Server...
2020-03-17
6 reads
Modernizing Your T-SQL: Trimming Strings
This is one of several posts on modernizing T-SQL code with new features and functionality available in SQL Server. Last year, you finally retired the last of your SQL...
2020-03-17
123 reads
T-SQL Tuesday #124 – I’m a Query Store Newbie
T-SQL Tuesday is a monthly blog party hosted by a different community blogger each month, and this month Tracy Boggiano (blog | twitter) asks us to talk about Query...
2020-03-11
10 reads
T-SQL Tuesday #124 - I'm a Query Store Newbie
T-SQL Tuesday is a monthly blog party hosted by a different community blogger each month, and this month Tracy Boggiano (blog | twitter) asks us to talk about Query...
2020-03-11
2 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 KCU MENARA BIDAKARA Telpon/WA:08137887595
BCA KCU MENARA BIDAKARA Telpon/WA:08137887595.Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt....
BCA KCU KELAPA GADING Tlpn/Wa 0853.7373.7551
Menara Satu Sentra Klp. Gading, Jl. Boulevard Bar. Raya No.1 Lt. Dasar, 1, 9...
BCA KCP Menara Imperium Telpon/WA:08137887595
BCA KCP Menara Imperium Telpon/WA:08137887595.Jl. H. R. Rasuna Said No.Kav. 01, Guntur, Kecamatan Setiabudi,...
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