Physical Security
The physical security of our systems might be a bigger problem in the future as more and more hackers are finding ways into secure areas.
SQL Server Backup and Restore
A DBA's tasks, from day-to-day, are rarely constant; with one exception: the need to ensure each and every day that any database in their charge can be restored and recovered, in the event of error of disaster. In this book, you'll discover how to perform each of these backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.
SQL Server Concurrency: Locking, Blocking and Row Versioning
Your application can have impeachable indexes and queries, but they won't help you if you can't get to your data because another application has it locked. That's why every DBA and developer must understand SQL Server concurrency and how to troubleshoot excessive blocking or deadlocking. Kalen Delaney's book is your guide.
SQL Server Transaction Log Management by Tony Davis and Gail Shaw
When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works. An effective response to a crisis requires rapid decisions based on understanding its role in ensuring data integrity.
The Red Gate Guide to SQL Server Team-based Development
This book shows how to use of mixture of home-grown scripts, native SQL Server tools,
and tools from the Red Gate SQL Toolbelt, to successfully develop database applications in a team environment,
and make database development as similar as possible to "normal" development.
The Third Evolution
Steve Ballmer is retiring in the next year and Microsoft needs to find a new CEO. Steve Jones has a few thoughts.
10 Things I Hate About Interviewing With You Webinar
This is a PASS VC Webinar, taking place on August 28, 1PM EDT. Get interviewing tips from both sides of the desk. Based on Thomas LaRock's 10 Things blog posts, this presentation by both Thomas LaRock and Karen Lopez will give you valuable insight into the interviewing process and how to improve your chances of landing that next job.
Eight Steps to Effective SQL Server Monitoring
If you need to start monitoring your SQL Server instances and database, and there are many good reasons to do so, Tony Davis gives you the eight essential steps to diagnosing problems quickly.
SQL Server Central Webinar Series #25 - Best Practices in Database Deployment Part 1: Aug 27th @ 4PM BST
Join Grant Fritchey (SQL Server MVP) as he tackles the most common problems and pitfalls of database deployment. He will explain how you (and your team) can make your deployment process, faster, more efficient and most importantly less stressful!
Teach Business Users How To Create Power View Reports With SQL Server Data Sources
Power View is a new tool for intuitive ad hoc SQL Server reporting which provides an interactive data exploration, visualization, and presentation experience to the business users. But how do you create these Power View reports? Check out this tip to learn more.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Saharjo CSTelpon : 0853-73737551
Jl. Dr. Saharjo No.149 G-H, Manggarai Sel., Kec. Tebet, Kota Jakarta Selatan, Daerah Khusus...
BCA KCU KUNINGAN CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Cyber 2, Gedung Menara Karya, Jl. H. R. Rasuna Said Ground...
BCA KCP Mega Kuningan CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Lingkar Mega Kuningan No.Blok E 4, RT.5/RW.2, Kuningan, Kuningan Tim., Kecamatan...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers