-
Join 937 other subscribers
-
Recent Posts
Categories
Tag Archives: Scripts
BIML first steps
BIML stands for Business Intelligence Markup Language. It adds some things on top of SSIS (SQL Server Integration Services, now called SQL Data Tools, or BI Development Studio, or even DTS – Microsoft should really make up their mind and stop … Continue reading
Posted in BI, SQLServer
Tagged BI, BIDS, BIML, ETL, Scripts, SQL Data Tools, Training
Leave a comment
Oracle: Error ORA-00955 name is already used by an existing object
Sometimes things just won’t work as expected. You know, programming has its quirks and the like. Normally this error alone would mean you are creating some object with a name that is already in use. But what if you just … Continue reading
SQ: Logical Query Processing Order
Just saw this while watching (a part of) MVA Jump Start: Querying SQL Server 2012: Logical Query Processing Order. This is great to keep in mind while tuning your queries. As I was blogging around and found this content on a … Continue reading
SQL: Management Studio not saving changes to table
Having a blog about something you like is a great way to learn more things about it. If you keep an eye open for the other bloggers the term “community” really makes sense. This week while checking the recent activity I … Continue reading
SSMS Tips and Tweaks – Keyboard shortcuts
After some time just saving drafts here (I have a lot of unpublished content right now), I wanted to share some tips to make your life easier when working inside SSMS. The first tip is about keyboard shortcuts. on SSMS hit … Continue reading
SQL Restore without Percentage
Have you ever wanted to restore a database to create some documentation? In this case it usually is done outside of production environment, so it does not matter how long the restore process will take. And if you have a … Continue reading
Monitoring SQL Agent jobs
And this is the second post of today, only a quick link to a great script from SQLFool. That girl is really a script junkie – and I love her scripts. http://sqlfool.com/2012/09/sql-agent-job-script-2/ It is extremely useful to be able to … Continue reading
Posted in SQLServer
Tagged Job Monitor, Maintenance, Scripts, SQL Agent Jobs, SQLServer
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
Unused Indexes Size
Today I had to quickly find which indexes are not used on a database and the size of each one. Because of the hurry, I just googled a little and found two scripts with parts of the solution. I simply … Continue reading
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