Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1
In Unix, a timestamp is a whole number that represents a date and time. Learn how we can convert those correctly in SQL Server.
2022-11-15 (first published: 2022-09-14)
56,484 reads
Articles
Tutorial to Create a Power BI Report Using PostgreSQL
Learn how you can use PostgreSQL data in a Power BI report.
2022-11-14
6,399 reads
Build Your Own SQL Server Central Monitoring Solution with PowerShell
In this article, we look at how to use PowerShell scripts to query all of your SQL Server instances to build your own central monitoring solution.
2022-11-14
How monitoring tools can help you excel at your job
Want to make the most of your scarce resources and do your job even better? Join us at PASS Data Community Summit, from November 15-18, and learn how database monitoring tools can speed up your maintenance tasks and give you the time to support strategic initiatives.
2022-11-14
The Art of Data Ingestion - Part 1
Data movement is a fundamental piece of a data engineer’s duties, and recently I’ve been thinking about the art of data movement. What are some of the most important pieces that a data engineer needs to think about when confronted with data ingestion? There is of course data exporting as well, and in that case, […]
2022-11-11
6,187 reads
Join a community like no other at Summit
There's less than one week until PASS Data Community Summit takes place, and there's still time to register for an in-person or online pass, and unlock access to over 300 world-class sessions. Join liked-minded attendees at the year's largest hybrid data platform conference. Register now.
2022-11-11
Refresh a Power BI Dataset using Microsoft Power Automate
Learn how to refresh a Power BI dataset by integrating Power Automate into the report.
2022-11-11
Women as Tech Leads – Tackling the Challenges at the Data Community Summit
The WIT panel at this year's PASS Data Community Summit includes a number of women who will answer questions on growing your career and rising up the org chart within your organization.
2022-11-09 (first published: 2022-11-08)
568 reads
Backing up MySQL Part 1: mysqldump
mysqldump is one of the most popular database backup tools in the MySQL world. The tool is prevalent partly because it’s very basic and quite powerful – mysqldump database backup tool is command line-based, very simple and very straightforward to use. As far as MySQL or its flavors (MariaDB and Percona Server) are concerned, this command line-based tool is one of the top choices for junior and senior database engineers across the world alike.
2022-11-09
Expert-led PASS Data Community Summit Pre-cons
Spaces are still available for next month's PASS Data Community Summit pre-conference sessions - but they’re booking up fast! Choose from 18 deep-dive full day pre-cons, featuring some of the best minds in the data industry, covering everything from technical processes to personal growth.
Register now
2022-11-09
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
When the Token Meter is Zero
Comments posted to this topic are about the item When the Token Meter is...
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers