Community Circle
Search this blog
Steve’s tweets
- Grateful I can watch my kid present his senior college graduation project, sad I can't be there in person 3 hours ago
- 2020 Advent of Code – Day 4 voiceofthedba.com/2021/04/16/202… 3 hours ago
- RT @datasaturdays: A new Data Saturday event has been scheduled Data Saturday #12 - DATA ANZAC June 25 at 21:00 UTC through till June 25… 4 hours ago
The Current Book
MVP Award
Tags
- administration
- AI
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- business
- career
- career
- cell phone
- Cloud Computing
- containers
- continuous delivery
- continuous integration
- coping
- data
- data analysis
- database design
- databases
- Database Weekly
- data privacy
- dbatools
- DevOps
- disaster recovery
- DLM
- encryption
- Friday Poll
- GDPR
- Git
- goals
- hardware
- high availability
- Humor
- life
- Linux
- machine learning
- mcm
- Microsoft
- misc
- monitoring
- networking
- NoSQL
- PASS
- Performance
- powershell
- presentations
- Redgate
- republish
- sabbatical
- security
- software development
- software development
- speaking
- SQL Clone
- SQL Connections
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- testing
- tools
- travel
- tsqlt
- vacation
- version control
- webinar
- windows
- work
Tag Archives: Excel
Chopping Off Data
Do you know the difference between XLS and XLSX? They’re both Excel formats, and many of us might just use one or the other. After all, the latest versions of Excel work with both, and if you’ve been using a … Continue reading
What’s the Mashup Engine?
I was testing something the other day and ran sp_who2 on a test instance. I saw this in the program listing: I had never seen the Mashup Engine listed in a program list, and I certainly don’t have any program … Continue reading
Getting the Hyperlink from Excel
I had a spreadsheet of data that contained hyperlinks. In this case, it was a series of Microsoft Knowledge Base Articles with a hyperlink associated with them. I would assume there’s an easy function in Excel to extract these, but … Continue reading
Adding Minutes in Excel
A short one, but I found myself wasting time recently. I use an Excel sheet to schedule some items out each day. It’s not my choice to do this, but the service I use requires this to not manually set … Continue reading