BI Sanil Mhatre in BI Text Mining and Sentiment Analysis: Analysis with R In the third article of this series, Sanil Mhatre demonstrates how to perform a sentiment analysis using R including generating... 13 May 2020 19 min read
Blogs Annette Allen in Blogs Isn’t the technical Community great?!! With everything that’s been going on in the world recently and all events being cancelled or postponed you might mistakenly... 07 May 2020 4 min read
Blogs Phil Factor in Blogs Tackling Imperial and US Customary Measurements in Databases The old measurements of length, area, volume and weight in the UK and the States refuse to die. They are... 06 May 2020 10 min read
Blogs Louis Davidson in Blogs SQL Agent Job Generator: Scheduling A Job In this last entry in the initial series of posts on building a SQL Agent Job Generator, I am going... 17 April 2020 10 min read
Blogs Dennes Torres in Blogs Identity column vs ETL Process Creating ETL process can pose so many challenges we will only fully discover them when really building the ETL. Before... 01 March 2020 6 min read
Blogs Louis Davidson in Blogs Mixing Relational and Graph DB Objects (Book and Session Prep) Graph structures are something that I have lightly covered in my Database Design book in the last few book editions... 27 February 2020 5 min read
Blogs Phil Factor in Blogs Copying of all data between SQL Server databases and servers This script will copy out all the tables from one version of a database in native BCP format, and place... 31 January 2020 7 min read
Louis Davidson Happy New Year’s Resolutions This has been quite a year, which is why this year’s resolutions are not in October as had been my... 01 January 2020 7 min read
Blogs Phil Factor in Blogs The Gloop: An Easier way of Managing SQL Server Documentation Here, in this blog, I’m continuing a theme that I started in a previous blog, ‘What’s in that database? Getting... 03 December 2019 11 min read
Blogs Phil Factor in Blogs What’s in that database? Getting information about routines There is a lot of information held in SQL Server metadata about your SQL Server procedures, triggers, views and functions.... 04 November 2019 18 min read
Darko Martinović Programming SQL Server with SQL Server Management Objects Framework SQL Server Management Objects (SMO) is a great tool for managing SQL Server. Darko Martinovic demonstrates how to use SMO... 09 April 2018 26 min read
Darko Martinović An Easier Way of Transposing Query Result in SQL Server T-SQL does not have an easy way to transpose a row and a column. Of course, there is the PIVOT... 13 March 2018 17 min read
Bud Aaron How to set up a database-driven Azure site So how easy is it to set up a database-driven application on Azure, using the tools that one is familar... 26 April 2012 12 min read
