Tag Archives: DBA

SQL Server 2016 Management Studio Download

It’s that time of the year. No, I’m not talking about christmas, I’m talking about new product cycles from Microsoft. For SQL Server it usually happens on even years, it’s 2016 so this year we have a new SQL Version. … Continue reading

Posted in SQLServer | Tagged , , , , , , , , , | Leave a comment

SQL Server 2012 SP3 Management Studio Download

Aaaand we’ve got some news regarding the Management Studio download links for SQL Server 2012 Service Pack 3 (see last post about this here). Microsoft released the Service Pack 3 for SQL Server 2012 on November/2015, so right now it’s a … Continue reading

Posted in SQLServer | Tagged , , | Leave a comment

Tips for Exam 70-462: make your labs using Azure trial

The complexity of certification exams is climbing up lately – up to the clouds. Gone are the days where a simple 3 VM lab was enough to try out every new tech release to newer versions of some product – … Continue reading

Posted in Cloud, SQLServer, VMware, Windows | Tagged , , , , , | 2 Comments

What is the latest SQL Server Service Pack?

I don’t know. But it seems we won’t have as much SPs as once we did. I just read a great article at SSC (short for SqlServerCentral, a great source of research) with this same question. And I agree with … Continue reading

Posted in SQLServer, Windows | Tagged , , , , , | 1 Comment

“Alter User with login” equivalent in SQL2000

By now, most DBA’s must be familiar with “Alter user with login” command from SQL 2005 SP2 and above. But when only SQL 2000 existed we had to do a lot more things manualy. Migrating logins/users has always been a … Continue reading

Posted in SQLServer | Tagged , , , | Leave a comment

Oracle: save output to file

Ok, so I’ve been on a streak to NOT talk about Oracle for a little while now. Actually I tried to avoid it, but as this software is more.. hmm… complex than MS-SQL we must talk about it a lot … Continue reading

Posted in Linux, Oracle | Tagged , , | Leave a comment

SQL – Determine which user deleted a SQL Server database

This is not too common, but usefull to know anyway. While searching for some answers to this question, I came to realize that the SQL default trace should be enough to find this information. If you are trying to find … Continue reading

Posted in SQLServer | Tagged , , , | Leave a comment

Choosing between SSMS Express and SSMS with Advanced Services

So thats it. I could not make a new post for over one week. This is off my target, I want to share something at least once every week. So here we go for some quick posts, and I will … Continue reading

Posted in SQLServer | Tagged , , , , , | Leave a comment

Change DB Owner in SQL Server

Sometimes some hidden configurations mess up with the management of our SQL Database Servers. One great candidate to do this is the “Owner” property of the databases. Not that the property will cause some issue by itself, but the default … Continue reading

Posted in SQLServer | Tagged , , , | Leave a comment

Sharing knowledge: Index Defrag Script

This is one of the things I love about being a DBA: we like to share what we know. I always try to teach people who work with me some things about how a database works, and a lot of other … Continue reading

Posted in SQLServer | Tagged , , , , , , | 1 Comment