PASS Update #4
Last week I posted Update #3 that discussed my first board meeting, but I didn't have time to cover my goals, so I 'll do that and add some other minor items as well.
Securing SQL Server with access control and login
SQL Server login monitoring and access control are important elements of SQL database security. Learn how DDL triggers can help alert you to security issues.
Speaking / Teaching Engagements
I should have put this out earlier, before going to the SQL Server Innovators Guild , but I got too busy. Here are my current speaking / teaching engagements for the first half of the year:
The New Office
A tour of the new Red Gate Software offices from Steve Jones, looking at how a modern software company has set up it's space.
The New Office
A tour of the new Red Gate Software offices from Steve Jones, looking at how a modern software company has set up it's space.
The New Office
A tour of the new Red Gate Software offices from Steve Jones, looking at how a modern software company has set up it's space.
Guest Editorial: Do You Run Antivirus Software on Your SQL Servers?
Every DBA needs to give serious consideration to the level of antivirus/antispyware protection they need on their SQL Server instances, and to the performance implications of the strategy they choose.
SQL Server at DevWeek 2009, Barbican Centre, London, March 23-27, 2009
DevWeek is Europe’s leading independent conference for software developers, database professionals and IT architects, and features two dedicated tracks of breakout sessions on SQL Server and related topics, plus optional pre- and post-conference workshops.
SQL Server Training: 2009 Conferences
Being a DBA demands that you keep up with the latest technology, and conferences are one of the best ways to do that. So, despite the fact that training budgets may be shrinking, I suggest you begin lobbying your manager to attend as many SQL Server events as you can. If you can't get your company to send you to a paid conference, then try to attend one of the free ones, on your own time.
Blogs
TempDB Internals – What’s New (Sql Server 2016 to 2025)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
A Wellbeing Day at Redgate
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers