New blogger: Jamie Wick
New SQL blogger
Jamie at the 45th Parallel (South) – New Zealand
This post is just a quick shout-out. My friend and co-leader...
2018-06-15
342 reads
A Discussion of SQL Server-Related Topics
Removing the time element from a datetime
Killing Time – or removing the time element from a datetime
Over the course of time, we all collect scripts and routines...
2018-06-07
2,086 reads
Removing servers from the SSMS connection dialog (Day 36)
One of the things that you will no doubt end up experiencing as a DBA is that you will see...
2018-05-16
1,955 reads
SSMS: Batch Separator (Day 35)
SSMS (and other SQL Server utilities) utilize a batch separator to, well, separate batches of T-SQL statements. Before we go...
2018-04-18
2,101 reads
Checking for temporary table existence
Database Code Smells
I was recently reviewing a newly created T-SQL stored procedure. This procedure was verifying temporary table existence with...
2018-04-11
2,332 reads
Primary Replica Jobs
This post talks about having primary replica jobs. That is, jobs that will only run on the primary replica of...
2018-04-02
1,004 reads
Working with tabs and spaces in SSMS (Day 34)
There are several different options available for working with tabs and spaces in SSMS. In fact, there are enough that...
2018-03-29 (first published: 2018-03-21)
2,951 reads
Using the Full Screen Mode in SSMS (Day 33)
Do you ever find yourself working on a query and realize that you need just a bit more real estate...
2018-02-28
588 reads
Using a gMSA with SQL Server
As you already know, SQL Server runs as a service. And services require a service account to run under. While...
2018-03-02 (first published: 2018-02-19)
17,324 reads
Connecting to a SQL Server instance – Back to Basics
Back to the SQL Server Basics with Wayne
Connecting to a SQL Server instance is one of the first things that...
2018-02-19 (first published: 2018-02-07)
2,890 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Alamat Kantor BCA KCP Fatmawati Telp:0821-8200-203
Telp/WA 62 8218200203 Jl. Komp. Rs. Fatmawati No.1, RT.1/RW.9, Cilandak Bar., Kec. Cilandak, Kota...
Alamat BCA KCP Gatot Subroto Telp:0821-8200-233
Telp/WA 62 8218200233 Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 Lt GF unit C,...
Alamat BCA KCP Warung Buncit Telp:0821-8200-174
Telp/WA 62 8218200174 Gedung Multika, Jl. Mampang Prpt. Raya No.71-73, RT.1/RW.1, Tegal Parang, Kec....
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers