In this article Marcin Policht discusses different methods of executing SQL Server 2012 Integration Services packages deployed by employing the traditional Package Deployment Model, focusing in particular on those stored in the .dtsx file system format.
2013-08-27
2,486 reads
Brad's Sure Guide to Maintenance Plans shows you how to use the Maintenance Plan Wizard and Designer to configure and schedule eleven core database maintenance tasks, ranging from integrity checks, to database backups, to index reorganizations and rebuilds.
2013-08-26
9,181 reads
Inside this book, you will find dozens of practical, defensive programming techniques that will improve the quality of your T-SQL code and increase its resilience and robustness.
2013-08-26
10,401 reads
Brad McGehee provides a "career guide" for DBAs. It is intended both to help prospective DBAs find a "way in" to the profession, and to advise existing DBAs on how they can excel at their jobs, and so become Exceptional DBAs.
2013-08-26
12,691 reads
2013-08-26
19,604 reads
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.
2013-08-26
12,758 reads
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.
2013-08-26
5,202 reads
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.
2013-08-26
7,199 reads
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.
2013-08-26
4,752 reads
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.
2013-08-26
2,736 reads
A sequential scan is not always a problem — PostgreSQL's planner often chooses one...
I’ve been thinking a lot lately about what it actually takes to make an...
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Good Morning. I have a T-SQL Script which has been developed to execute a...
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Comments posted to this topic are about the item Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers