-
Join 937 other subscribers
-
Recent Posts
Categories
Tag Archives: SQLServer
Get a taste on the cloud: MS Azure Free Trial
Continuing with the inevitable move to the sky, and trying to self-quote myself here (well, self-post actually), I’m back to tell you that you can have one month of free experimentation with all Azure platform for free. You can set-up … Continue reading
How It Works: SQL Server I/O Presentation by Bob Dorr
Once upon a time, in a server farm far far away… enough talk. I was researching some warning messages on my SQL boxes and came to this 2010 paper by one of the Microsoft Customer Service and Support (CSS) SQL … Continue reading
Posted in SQLServer, Windows
Tagged Maintenance, Performance, SQLServer, storage, Training
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 Certification, DBA, Microsoft, SQLServer, Training, VirtualAcademy
2 Comments
Last post of the year: SQL Server 2014 Checklist for Performance
I would like to share these kind of things directly from SqlServerCentral, and not only posting links. But linking seems the best way to do it currently. Also I decided to increase that post count to 20 (yea, the yearly … Continue reading
SQL versions compatible with Windows Server 2012
Times of change are ahead of us. Lately the technology reached some kind of plateau, with performance and features staying relatively at the same level for several years. Go and check the hardware market: despite some big savings on power, the … Continue reading
MVA: Microsoft Virtual Academy free courses
Quick post: for a while I know the Virtual Academy, but I was not using it lately. It looks like a lot has changed, and there are new products out in the wild too. So it’s worth to give a shot … Continue reading
SQL: Increase performance by fully qualifying procedure names
There is a “best practice” when programming in T-SQL that consists in fully qualifying any object referenced in your code. And this article explains one of the reasons why this is recommended. In short: if you don’t write “dbo.my_proc” when … Continue reading
Posted in SQLServer
Tagged Best Practices, Performance, SQLServer, Stored Procedures, Tuning
Leave a comment
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
SQL Server Developer Edition not free anymore
It looks like MS wants to make some more cash. The Developer Edition of SQL Server 2008 R2 and 2012 are NOT free anymore. Now you must buy it for U$ 50 or 60. Not too much, but not exactly … Continue reading
Posted in SQLServer
Tagged Developer, Download, Microsoft, SQLServer, SQLServer Developer Edition
Leave a comment
Changes in maintenance plan overwriting SQL job ownership
Sometimes some things strange happens. Usually when you are trying to fix other things. This issue happened to me when revising some SQL Agent jobs to make sure all backups were running fine. I removed to old DBA account from … Continue reading
Posted in SQLServer
Tagged Bugs, Job Activity, Job Monitor, Maintenance, Security, SQLServer, SSMS
Leave a comment
The Lonely DBA 