Floating Fill Factors, Automation at work!
A while back I saw a wonderful article on BrentOzar.com by Kendra Little. In the comments, Aaron Morelli mentioned that...
2013-11-11
443 reads
Blog Posts
How SQL Server Full Backups Work
I’m writing this in support of a few talks I give that talk about backups. This is how I see...
2013-11-11
906 reads
Last Weeks Top “Reading” Links #57
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-11-11
1,168 reads
My SQLRally Experience
The past week I had the pleasure to attend SQLRally Amsterdam.
I took a flight from Tel-Aviv to Amsterdam and got...
2013-11-11
788 reads
Notes From SQLSaturday #248
For once the drive from Orlando to Tampa went smoothly, no delays due to accidents or construction or UFO’s, a...
2013-11-11
609 reads
PASS Data Architecture VC presents Steve Simon–Challenges to Designing Financial Warehouses
Please join the Data Arch VC with Steve Simon this Thursday Nov 14th at noon central for a great look...
2013-11-11
614 reads
PowerShell – Service Comparison GUI Tool
Service Comparison GUI Tool does comparison of all the services of any given two servers. The output is a grid view...
2013-11-11
1,684 reads
Second Presentation – Lessons Learned
Since my presentation at Orlando SQL Saturday seemed to go well (standing room only, all positive feedback) I submitted to...
2013-11-11
518 reads
sp_SrvPermissions & sp_DBPermissions V3.0
These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data...
2013-11-11 (first published: 2013-11-04)
1,861 reads
Troubleshooting Database Mirroring Configuration
From my last post, http://coffeeandsql.com/2013/11/10/70-457-reviewer-15-implement-database-mirroring/, you were able to successfully setup a database mirroring. For further monitoring and checking if...
2013-11-11
1,067 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 BCA KCP Bontang Kontak 0817819444
WhatsApp:0817819444 Ruko Bontang Trade Center, Jl. Bhayangkara A10-A11, Gn. Elai, Kec. Bontang Utara, Kota...
Alamat BCA KCP Sangatta Kontak 0817819444
Jl. Yos Sudarso, Sangatta Utara, Kec. Sangatta Utara, Kabupaten Kutai Timur, Kalimantan Timur 75611
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
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