August 18, 2011 8:47 PM
Posted by: Colin Smith
DBA,
SQL Server,
SQLSkills,
TrainingI am way behind on doing this post as well as the series that I would like to do about the IE1 Class that I attended in August. First and foremost I have to say that this is the BEST TRAINING I have ever had. I have been to other training classes for other RDBMS's but this is BY FAR the BEST I have...
January 30, 2011 9:21 PM
Posted by: Colin Smith
Audit,
DBA,
MS SQL AdminI have recently had to find a way to prevent someone that has elevated privileges from removing logins, databases, as well as keep them from adding new databases to my production systems. I was amazed at how easy this was to do thanks to event level ddl triggers. I created a table in master called...
January 30, 2011 6:45 AM
Posted by: Colin Smith
DBA,
HoursWhen I was in school I thought that being a sysadmin would be about the best job in the world. I was close, I did not know how much fun it would be doing the job of a DBA. So after I became a DBA I loved it and really do enjoy my work and the fact that no matter how much I learn about it I still...
January 28, 2011 5:48 PM
Posted by: Colin Smith
Database Administration,
DBA,
MSSQL ServerIn my last post about the disabled sa account I mentioned that I would have more on why I could not use windows authentication to get to my SQL Server instance. Here is the short of it and I know many of you will be screaming at the screen as you read this. Again this is a server that I have walked...
January 28, 2011 2:11 AM
Posted by: Colin Smith
DBA,
DR,
enable sa,
sqlhelpI recently had a situation where something happened to my SQL Server and I could no longer log in using windows authentication. I will get more into what happened in another post. Let me just preface all this by saying that I inherited this mess. Anyway, thanks to
December 7, 2010 9:14 PM
Posted by: Colin Smith
DBA,
memory,
Powershell,
SMO,
SQL ServerSo today I was thinking about some of the things that are currently not set up properly on some of my servers. I got to thinking that a lot of them were never set up properly for Min and Max Server memory. Most of them, that were installed before my time, are set up with the defaults and as you all...
November 24, 2010 6:52 PM
Posted by: Colin Smith
Add new tag,
DBA,
Powershell,
ScriptingI recently had a request to go out and find the logical name and the physical name of mdf and ldf files in sql server. I thought this might be a good place to use powershell and the invoke-sqlcmd cmd-let that is with sqlserver2008 snapin.
Here is an example of what I did to find the files for...
July 30, 2010 10:00 AM
Posted by: Colin Smith
DBA,
Recovery,
RestoreI am fighting a battle right now of whether or not I, the DBA, or the backup team at my company should be in charge of backups and restores of the SQL Server Databases in the company. We use Netbackup with a SQL Agent to back up the databases and I am still not sure that I am a huge fan of that. I...
July 27, 2010 8:36 PM
Posted by: Colin Smith
Audit,
DBA,
RolesRecently my company went through an internal audit of our financial systems. First let me say that I am proud because we did well and do not have many issues to resolve, and no issues on the Database Side. Any way I also want to point out that the auditors are not IT people. They are accountants...
