I just published a new article for June. This article shows you how to use an Azure DocumentDB database from a .Net application. It is using the API provided by Microsoft.
You can read it from http://emoreau.com/Entries/Articles/2015/06/Using-Azure-DocumentDB-from-a-Net-application.aspx
Another free event is coming soon: The 24 hours of PASS. The event will be held June 24 and 25 2015. 24 online sessions of 60 minutes each relaying for a full non-stop 24 hours.
All the details are available from http://www.sqlpass.org/24hours/2015/goc/Sessions.aspx
Encore cette année, Microsoft m'a demandé de mettre sur peid un Samedi SQL à Québec. Le thème cette année est "SQL et Azure".
Une journée complète sur différentes facettes de SQL dans le monde Azure. Le tout offert gratuitement.
Cette journée aura lieu le samedi 6 juin 2015 prochain. Pour l'horaire et l'inscription, visiter http://www.meetup.com/msdevmtl/events/222193944/
I just published my article for May. This month, I introduce you to the new and/or improved debugging features of Visual Studio 2015 which is currently in RC.
You can read this article from http://emoreau.com/Entries/Articles/2015/05/New-and-enhanced-debugging-features-of-Visual-Studio-2015.aspx
Ne manquez pas ce samedi 16 mai à 11h00, mon deuxième webinaire sur SQLPass.org. Cette fois-ci mon sujet sera "Sauvegarde et copie de BDs locales vers Azure"
Pour vous inscrire, visitez http://globalfrench.sqlpass.org/Home.aspx?EventID=2922
Not all applications are suited to run with your big fingers on your tiny tablet. Trying to click sliders and other small controls is often an achievement!
I just found a small and free tool that creates a virtual touch pad directly on your screen. It works for both Windows 8.1 and Windows 10.
Give it a try by visiting http://www.lovesummertrue.com/touchmousepointer/en-us/.
I have been selected to speak at the Sharepoint Saturday 2015 in Montréal next May 23, 2015 at the College Maisonneuve.
This event is fully free and offers 25 sessions in 5 rooms.
For more information and to register for free, visit http://www.spsevents.org/city/Montreal/Montreal2015/.
I was going through a couple of emails this morning when I found one from Pinal Dave. It was exposing a really nifty T-SQL trick that I will surely used very soon.
Very often, we have a CSV field in a database and we want to split on the separator. This can be done easily. Have a look at this snippet:
DECLARE @t TABLE
INSERT @t VALUES (1,'B.E.,MCA, MCDBA, PGDCA'), (2,'M.Com.,B.Sc.'), (3,'M.Sc.,M.Tech.')
SELECT * FROM @t
SELECT EmployeeID, LTRIM(RTRIM(m.n.value('.','varchar(8000)'))) AS Certs
SELECT EmployeeID,CAST('' + REPLACE(Certs,',','') + '' AS XML) AS x
) AS t
CROSS APPLY x.nodes('/XMLRoot/RowData')m(n)
The snippet starts by creating an in-memory table with some CSV values. then the trick is to convert this field to an XML value which makes it easier to access each value inside it.
If you have a small amount of rows, that trick can really help you but if you have a large result set this same trick could hurt you because we all know that SQL Server is not really at its best with XML!
BTW, this trick was found on http://blog.sqlauthority.com/2015/04/21/sql-server-split-comma-separated-list-without-using-a-function/ which also link to other ways of achieving the same thing using a stored proc and a UDF.
I have been invited by the SQL Pass Global French Virtual Chapter to present 2 webcasts.
The first one will be presented Saturday, May 2nd. It will be presented in French and it will be about SQL CLR Integration (related to my latest article). More details are available from http://globalfrench.sqlpass.org/Home.aspx?EventID=2921.
The second one will be presented Saturday, May 16. This one will show how to backup Microsoft SQL Server 2014 databases to Azure, how to copy database to SQL Databases (still in Azure). More details on this one are available from http://globalfrench.sqlpass.org/Home.aspx?EventID=2922.
Recordings should be available some time after the live events from the archive.
Yes another (surely) great free virtual conference is coming in May. The 2-days event will be held May 14 and 15.
This conference will be hosted by MVPs. It offers 5 tracks (IT Pro, Developer, Consumer, Spanish, and Portuguese).
Join me! Register for the MVP Virtual Conference and feel the power of community! #MVPvConf #MVPBuzz