Identify When your SQL Database Was Last Used
Database servers are used for storing vast amounts of data. It is essential to know when any user last used the database. This blog will cov
2022-02-07 (first published: 2022-01-24)
1,485 reads
Blog Posts
Passed DP-900–A Review
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-02-07
96 reads
Which Columns Are Looked Up?
A common issue in performance is the lookup, key or RID, but the question frequently asked is, which columns are looked up? You need to know in order to...
2022-02-07 (first published: 2022-01-24)
436 reads
Daily Coping 4 Feb 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-02-04
11 reads
Goal Progress for Jan 2022
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. My first update. I spent most of January unwinding slightly...
2022-02-04
11 reads
How SQL Server executes a Query
Beginning with today, I want to give you over the next few months a blog post series about the basics of performance tuning in SQL Server. Before we go...
2022-02-04 (first published: 2022-01-25)
1,619 reads
I'm Speaking at SQLBits 2022!
I’m proud to announce that I will be speaking at SQLBits! I had the absolute pleasure of speaking at SQLBits in the past, both in person and virtual, and...
2022-02-04
20 reads
Introducing ScriptDOM
I’ve been meaning to get a series of blog posts started on this topic. A twitter conversation from yesterday finally pushed me to it. Last year, I was tasked...
2022-02-04 (first published: 2022-01-24)
829 reads
Connecting to Single Server MySQL
We have already created the server now it’s time to connect to it. What you will need – connection string details, correct networking setup and a tool like MySQL...
2022-02-03
22 reads
Daily Coping 3 Feb 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-02-03
10 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 WAHID HASYIM. Tlp:085373737845.
BCA KCU WAHID HASYIM. Jl. K.H. Wahid Hasyim No.183 A-B, Kb. Kacang, Kecamatan Tanah...
BCA KCP Gondangdia Lama. Tlp:085373737845
Jl. RP. Soeroso No.25, Cikini, Kec. Menteng, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta...
BCA KCP Sabang. Tlpn:085373737845
Jl. H. Agus Salim No.57 B, Kb. Sirih, Kec. Menteng, Kota Jakarta Pusat, Daerah...
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