• Quote of the Day
    "The only normal people are the ones you don't know very well."
    Alfred Adler, posted by David Baxter

Daniel

Forum Supporter
MVP
Joined
Aug 5, 2004
Messages
18,183
Points
113
Reminders for database geeks:


SQLCMD is a command line application that comes with Microsoft SQL Server...It allows SQL queries to be written and executed from the command prompt. It can also act as a scripting language to create and run a set of SQL statements as a script. Such scripts are stored as a .sql file, and are used either for management of databases or to create the database schema during the deployment of a database.


SQL Server Profiler is an interface to create and manage traces and analyze and replay trace results. Events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when diagnosing a problem.

Newer stuff related to Azure:


Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. Azure SQL Database is always running on the latest stable version of the SQL Server database engine and patched OS with 99.99% availability. PaaS capabilities that are built into Azure SQL Database enable you to focus on the domain-specific database administration and optimization activities that are critical for your business.


 
Last edited:

Daniel

Forum Supporter
MVP
Joined
Aug 5, 2004
Messages
18,183
Points
113
Free, quick, online "mini masters" in public health:


"Because of the commitment to ensure access to education around pressing public health issues, Boston University School of Public Health (BUSPH) now offers a free, online Mini-MPH. The Mini-MPH provides foundational knowledge in public health to all interested learners. The program includes six hours of engaging, online content that covers key concepts of public health, with expert faculty, accessible to everyone."
 

Daniel

Forum Supporter
MVP
Joined
Aug 5, 2004
Messages
18,183
Points
113
 
Last edited:

Daniel

Forum Supporter
MVP
Joined
Aug 5, 2004
Messages
18,183
Points
113

Under Creative Commons licences, authors retain copyright of their articles...

The CC BY licence (Creative Commons Attribution 4.0 International licence)...is the most open licence available and considered the industry 'gold standard' for open access; it is also preferred by many funders. This licence allows readers to copy and redistribute the material in any medium or format, and to alter, transform, or build upon the material, including for commercial use, providing the original author is credited.
 
Last edited:

Daniel

Forum Supporter
MVP
Joined
Aug 5, 2004
Messages
18,183
Points
113

A video can get more eyes on your product and boost your sales.

Here’s a step-by-step guide on how to create an explainer video.
 
Last edited:

Daniel

Forum Supporter
MVP
Joined
Aug 5, 2004
Messages
18,183
Points
113

Python for Excel: A Modern Environment for Automation and Data Analysis

While Excel remains ubiquitous in the business world, recent Microsoft feedback forums are full of requests to include Python as an Excel scripting language. In fact, it's the top feature requested. What makes this combination so compelling? In this hands-on guide, Felix Zumstein--creator of xlwings, a popular open source package for automating Excel with Python--shows experienced Excel users how to integrate these two worlds efficiently.
Excel has added quite a few new capabilities over the past couple of years, but its automation language, VBA, stopped evolving a long time ago. Many Excel power users have already adopted Python for daily automation tasks. This guide gets you started.
  • Use Python without extensive programming knowledge
  • Get started with modern tools, including Jupyter notebooks and Visual Studio code
  • Use pandas to acquire, clean, and analyze data and replace typical Excel calculations
  • Automate tedious tasks like consolidation of Excel workbooks and production of Excel reports
  • Use xlwings to build interactive Excel tools that use Python as a calculation engine
  • Connect Excel to databases and CSV files and fetch data from the internet using Python code
  • Use Python as a single tool to replace VBA, Power Query, and Power Pivot
 
Last edited:

Daniel

Forum Supporter
MVP
Joined
Aug 5, 2004
Messages
18,183
Points
113
My new favorite app for taking notes and writing:




"A new kind of word processor. A way of reading and writing hierarchical documents. A mix between Evernote + Workflowy."

Cost is free to minimal (donation-based), and you can export to Microsoft Word, HTML, LaTeX, etc., as well as the presentation format Impress.js (below).
 
Last edited:

Daniel

Forum Supporter
MVP
Joined
Aug 5, 2004
Messages
18,183
Points
113
Alternative to Microsoft PowerPoint:


 
Last edited:

David Baxter

Administrator
Joined
Mar 26, 2004
Messages
37,567
Points
83
There are also several free alternatives to the Microsoft Office suite, notably:



For more, see

 

Daniel

Forum Supporter
MVP
Joined
Aug 5, 2004
Messages
18,183
Points
113
Free Kindle book:

Learn Human-Computer Interaction: Solve human problems and focus on rapid prototyping and validating solutions through user testing

"This book is for software engineers, UX designers, entrepreneurs, or anyone who is just getting started with user interface design and looking to gain a solid understanding of human-computer interaction and UX design. No prior HCI knowledge is required to get started."

Table of Contents​

  1. Introducing HCI and UX Design
  2. Human Centered Design Principles
  3. Interface Design Values
  4. Human Centered Thinking for Design and Development
  5. Human Centered Methods for User Research
  6. User Insights for Software Solutions
  7. Storytelling and Rapid Prototyping
  8. Validating Software Solutions
  9. Improving Software Systems with Data
  10. Human Centered Solutions
  11. Extending HCI
  12. The Future of HCI
 

Latest posts

Top Bottom