Excel, SQL Agent and 64bit
Using SSIS we had a Excel Source to import regularly into a database. We constructed a simple project in SSDT and it ran successfully. We then deployed the project, started an SQL Agent job step with a step as an SQL
SQL Server ROUND and Reporting Services
An interesting point came to my attention today with regards to rounding in SQL Server and its features, in this case Reporting Services.Let’s take 62.5 as our magic number, as 3 doesn’t illustrate the issue!In SQL Server Management Studio, we
Second Shot is back
Once again the excellent second shot offer for the Microsoft Certification is back. Get a second shot at your Microsoft Certification for free here http://www.microsoft.com/learning/en-us/second-shot.aspx
Reporting Services – Show this in tile view
Sometimes we’ll want to hide lots items from the tile view in Reporting Services. There’s no quick way to, for example, hide all your sub reports view the user interface. As long as you’ve got a standardised naming convention, such as prefixing
Simple UK Mapping in SQL Server 2012 using spatial data types – geography
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
AlwaysOn and SQL Agent Jobs
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
SQL Server 2014 CTP1 Available
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
SQL 2014
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
SQL Scotland Pre-con: SQL Skills training – SQL Saturday #202
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
SQL Saturday #202 – SQL Scotland
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