Restore database permissions
Introduction:
I came across a couple of subtle gotchas around the permissions required to restore a database in SQL Server 2008+...
2013-01-10
6,308 reads
Try a Database Design Exercise At Your Next SQL User Group
Tried something different for the January 2013 meeting of the Baton Rouge SQL Server User Group (brssug.org), which meets every...
2013-01-10
959 reads
SQL Saturday #198 Feb 16, 2013
SQL Saturday 198, http://www.sqlsaturday.com/198/ ; is coming to Vancouver Feb 16 this year. As of now, 56 sessions are collected from...
2013-01-09
824 reads
Determining Default Trace Location
While working on some scripts against SQL Server’s default trace, I wanted to develop a sure fire way to find...
2013-01-09
1,830 reads
January S3OLV 2013
I hope you are ready for some free SQL learning. Coming up on Thursday January 10th at 6:30 PM Pacific (GMT – 8 ) we will have a stellar...
2013-01-09
8 reads
January S3OLV 2013
I hope you are ready for some free SQL learning. Coming up on Thursday January 10th at 6:30 PM Pacific...
2013-01-09
844 reads
What Queries From The Application Do To Your Plan Cache
Usually, a database is meant to serve some kind of application, and .Net applications have a few possible ways to query...
2013-01-09
1,183 reads
A Learning Experiment
I’ve been looking for ways to improve the way I do my job, which is mostly writing and editing, but...
2013-01-09
1,164 reads
Day 9 of 31 Days of Disaster Recovery: Use All the Checksums
31 Days of Disaster Recovery
Welcome to day 9 of my 31 Days of Disaster Recovery series. Today, I want...
2013-01-09
2,218 reads
#SQLMaiden 2013 dates
Some time back at a SQL Server user group in Southampton I was speaking to an MVP called Simon Sabin...
2013-01-09
703 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Alamat Kantor BCA KCU Sidoarjo Tlp:(08218200203)
Hub Via Wa:628218200203 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo,...
Alamat Kantor BCA KCU Diponegoro Tlp:(08218200233)
Hub Via Wa:628218200233 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
Alamat Kantor BCA KCU Indrapura Tlp:08218200174
Hub Via Wa:628218200174 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers