The Bit Bucket

SQL Down Under Demographics and Technologies

As most websites do, we collect analytics on the people visiting our site https://sqldownunder.com

I thought it might be interesting to share the breakdown of visitors to our site. Keep in mind that we have a primarily Microsoft-oriented audience. Enjoy!

No surprise on the native languages:

image

Country breakdown reflects the amount of local traffic we have for instructor-led courses. Most others are podcast listeners:

image

We first noticed Chrome slightly outstripping IE a while back but recently, it’s changed a lot. I suspect that IE11 will have been as issue here:

2014-10-30

SQL Down Under Show 64 – Ryan Crawcour–What SQL Server DBAs and Developers Need to Know About Azure DocumentDB

I had the pleasure of recording another SQL Down Under show today.

Show 64 features Microsoft Azure DocumentDB product group member discussing Azure DocumentDB and what SQL Server DBAs and developers need to know about it.

JSON-based storage has been one of the highest rated requests for enhancements to SQL Server. While we haven’t got those enhancements yet, DocumentDB nicely fills a gap between NoSQL databases (I use the term loosely Smile ) and relational databases.

2014-10-30

FIX: Visible preview window in SQL Server Reporting Services gone!

It’s great to see that the Connect site leading to fixes in the product.

I was really pleased when SQL Server Data Tools for BI appeared for Visual Studio 2013. What I wasn’t pleased about where a number of UI issues that came with that version.

In particular, there was a problem with previewing Reporting Services reports. If I create a new report project, add a blank report, and drag on a text box:

2014-10-29

SSMS SQL Server 2014 CU4 Issue: The type initializer for ‘PropertyMetadataProvider’ threw an exception

When I installed CU4 for SQL Server 2014, I started to receive an error in SSMS (SQL Server Management Studio) every time I connected to a database server:

clip_image002

It was interesting that it was a type that wasn’t being found in Microsoft.SqlServer.SqlEnum. I presumed it was a problem with a type being missing in that DLL and that I must have had an older one.

Turns out that the problem was with the Microsoft.SqlServer.Smo.dll.

2014-10-29

Easier way to try SQL Server Availability Groups using Azure

Over the last year, I’ve been delivering a number of partner enablement training sessions for Microsoft. They target the changes in SQL Server 2014 and also provide an introduction to Power BI.

During the sessions for day two, I have been getting the attendees to set up a high availability environment in Azure, with a Windows Server 2012 R2 domain controller and a couple of SQL Server 2014 Enterprise member servers. This process basically involves:

2014-10-13

Azure SQL Database Hourly Billing

There were a number of great announcements from Scott Guthrie today: http://weblogs.asp.net/scottgu/azure-sql-databases-api-management-media-services-websites-role-based-access-control-and-more

One that particularly caught my eye was a subtle change to the billing for Azure SQL Database. Databases used to be billed at a daily charge.

While this might not have seemed a big deal, the only way to create a transactionally-consistent backup of the database was to first copy it using CREATE DATABASE AS COPY OF original database, then to use the database export functions on the copy. The export needed to be done on the copy (not on the original) as it just copied the data in each table, one table at a time.

2014-09-14

Updated offline SQL Server 2014 Books Online install now includes T-SQL Reference

Many customers want to install Books Online (BOL) when working with SQL Server. Generally I always think it’s a good idea.

Not all environments though, allow external connectivity for the systems where the clients want to install BOL.

A friend of mine Rob Sanders documented how to install BOL in an offline method a while back on his blog.

The problem with this was that the T-SQL Reference documentation was not included in the download for offline installation. Given the T-SQL language reference was the major reason that most people wanted to install BOL, it all seemed quite pointless.

2014-09-14

3rd Party Tools: dbForge Studio for SQL Server

I’ve been taking a look at some of the 3rd party tools for SQL Server. Today, I looked at DBForge Studio for SQL Server from the team at DevArt.

Installation was smooth. I did find it odd that it defaults to SQL authentication, not to Windows but either works fine.

I like the way they have followed the SQL Server Management Studio visual layout. That will make the product familiar to existing SQL Server Management Studio users.

2014-08-25

Azure Search Preview

One of the things I’ve been keeping an eye on for quite a while now is the development of the Azure Search system.

While it’s not a full replacement for the full-text indexing service in SQL Server on-premises as yet, it’s a really, really good start.

Liam Cavanagh, Pablo Castro and the team have done a great job bringing this to the preview stage and I suspect it could be quite popular. I was very impressed by how they incorporated quite a bit of feedback I gave them early on, and I’m sure that others involved would have felt the same.

2014-08-25