One of your five a day
I’ve been looking forward to using some of the features of spatial data in SQL Server 2012 but realised I hadn’t found a quick way to utilise UK Maps. Since it’s highly graphical and tangible in nature I believe this
Now we have our AlwaysOn solution and the same SQL Agent jobs running on each availability replica and they reference the availability group listener. So we’re all set up and running with our Availability solution but our SQL Agent jobs are unaware
The Community Technology Preview is now available for SQL Server 2014. Get it now at http://www.microsoft.com/en-us/sqlserver/sql-server-2014.aspx
There is some SQL Server 2014 information available at http://www.microsoft.com/en-us/sqlserver/sql-server-2014.aspxincluding an SQL Server 2014 Data Sheet which makes for interesting reading and of course you can register to be notified when the trial is ready for evaluation.My takeaway: that there won’t
I attended the pre-con day at SQL Scotland in Edinburgh with Jonathan Kehayias and Joseph Sack from SQLSkills. It was exceptional! It was a very quick day, which is usually a very good thing. I also came away with a
I wanted to arrive early to network, meet my friends and colleagues in the community and then discuss the various vendor solutions with the sponsors. Also I’d made a point of staying in a particular track this time, rather than
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
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
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 from http://www.microsoft.com/en-gb/download/details.aspx?id=35575 including slipstream options.