Month: February 2019

First published on MSDN on Mar 05, 2018 Over the years of troubleshooting SQL Server we have come to see the need for manually generating a memory dump of the SQL Server process for in-depth analysis. On several occasions, generating multiple memory … Continue reading Automatically Generating SQL Server Memory Dumps at a Defined Interval→

First published on MSDN on Mar 05, 2018 The following functions were introduced in SQL Server 2017.
STRING_AGG()
 
CONCAT_WS()
 
TRIM()
 
TRANSLATE().
Question: How come they don’t work in Visual Studio 2017? SQL72014: .Net SqlClien… Continue reading Functions like STRING_AGG(), CONCAT_WS(), TRIM() Appear to Break in Visual Studio 2017 Database Projects→

First published on MSDN on Jun 21, 2018 Here is a request that came up recently:
“When installing SSDT manually it downloads a shell copy of Visual Studio 2017 from the Internet. However, if I get the offline copy of SSDT for VS2017 it does not in… Continue reading How to install Sql Server Data Tools (SSDT) 2017 Offline (Internal Network installation)→

First published on MSDN on Jun 21, 2018 Recently I worked on an issue that encountered this error and I had to research the source code to figure it out.
Msg 42029, Level 16, State 1, Line 3 An internal error happened while generating a new DBTS for… Continue reading An internal error happened while generating a new DBTS for database ‘Db1’→

This article is part 4 of a 4 part series previously hosted on BBC. From robots to smart pens, tech can help teachers create an inclusive classroom. At Ulladulla High School, close to the ocean in New South Wales, Year 7 student Jacob dreams of being a coder. That might not seem so unusual, yet… Continue reading Learning for all→

This article is part 3 of a 4 part series previously hosted on BBC. Learning to program develops a raft of 21st-century skills When the visionary mathematician and programmer Seymour Paperts first introduced the idea of computers in the classroom in the 1960s, it seemed like science fiction. Even the new minicomputers were the size… Continue reading Cracking the code→

This article is part 2 of a 4 part series previously hosted on BBC. To equip today’s students for the workplace of 2030, a whole new curriculum is needed: one that centres on skills, not content. In a Canberra classroom, a group of teachers are getting educated. Yet, as they break out into groups to… Continue reading From hard facts to soft skills→

This article is part 1 of a 4 part series previously hosted on BBC. Australian schools hold sensitive data on teachers, students and their families. Following best practices can help them keep it safe. Whether it’s a sustained hacking assault, a mischievous teenager practising their coding skills, or simply a logged-in device left unattended, network… Continue reading Securing our schools→