Alerts and Monitoring for Always on
I’d been looking for a simple alert to run in SQL Agent to notify me of failover and alert number’s 41074 and 35266 seem to work reliably if you just need to know you’ve failed over. Also using some of
Automate your way to Travel back in time!
Never underestimate the importance of automation and the benefits it gives you. If possible automate the task, any task done more than once should be automated. Quite a sweeping statement but the benefits to you and your team outweigh the
Which SQL Agent job runs my SSRS report schedule
To find out which SQL Agent job is running your SSRS schedule simply use the query below substituting your ReportServer name and your ReportName. Many reports can run using the same shared schedule so use caution if running the job
SQL Server Service Pack 1 is available
SQL Server Service Pack 1 is available from http://www.microsoft.com/en-gb/download/details.aspx?id=35575 including slipstream options.
Converting FLOAT to VARCHAR
The conversion from a float datatype to varchar datatype can be fraught with peril! Lets take our fictional number 7555000001 which is helpfully stored in a float datatype. Now in the context of a telephone number we have an issue.
Second Shot is Back
The Second Shot offer for taking certain certifications from Microsoft is back so for a limited time, you’ll get a free second chance. If you’re thinking of taking the new SQL Server 2012 exams or finishing your exam track on
Disable an SQL Server Agent job on failure
Sometimes when your SQL Server Agent jobs fail you don’t want them to run again, It’s a simple extra step to disable the job. Firstly create a new job step to disable the job, perhaps called DISABLE JOB STEP and
Database Mail is your friend
Monitoring SQL Server Agent jobs and getting alerts is one of the most important ways we can react to any instance or server issues. Database Mail is great! It’s our friend that can let us know when SQL Server isn’t
Migrating your Database to a later version of SQL Server
Plan your migration When migrating our older databases in versions 7 and 2000 we have a few more things to consider than a migration from 2005 or above to a later version but the gains in ease of administration are fantastic.
SQL 2012 RTM Evaluation Available
Looks like SQL 2012 RTM is available for download with an evaluation version available now, the main release on April 1st.On technet “Exciting news! Microsoft announced today that SQL Server 2012 has released to manufacturing..” Download the evaluation from http://blogs.technet.com/b/dataplatforminsider/archive/2012/03/06/sql-server-2012-released-to-manufacturing.aspx