Let’s apply a little backup and restore knowledge, eh wot? I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page. Prerequisites: basic T-SQL, create objects/data, basic understanding of recovery models and backup types. Reading – SQL Server Books Online articles: Backup (Transact-SQL) Restore (Transact-SQL) ALTER DATABASE […]
Category: sqlserverpedia-syndication
Un-SQL Friday #006: Living in the Intertubez
We’ve had some BIG fun this week, relatively speaking, with #SQLSue and #SQLIdiot and just general #SQLcraziness. We’ve had several blogs out already, including my Rat Sues Corn! … and Why I Feed Trolls, Jorge Segarra’s heartfelt We Are Community, and Steve Jones’ Is my blog infringing on anything? Meanwhile, Redgate’s space on the web – from DBAInSpace.com, to the […]
RSS Tuning Whitepaper notes and clarifications
This morning this caught my eye on SQLServerCentral.com: Maximizing SQL Server Throughput with RSS Tuning (it came with a catchy SQLCAT logo!) So I clicked, I read, I downloaded and read some more. To summarize (BIG summary!), this paper says that in pre-2008 Windows server, the networking protocol stack didn’t scale well to multiple CPUs because […]