Search this blog
-
The Current Book
MVP Award
Tags
- administration
- AI
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- business
- career
- career2
- car update
- Cloud Computing
- conferences
- 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 Compare
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- Tesla
- testing
- travel
- tsqlt
- vacation
- version control
- webinar
- windows
- work
Search this blog
Steve’s Tweets
- @BrentO We love you and appreciate you. Keep doing you 36 minutes ago
- Not quite an Elvis impersonator but I'm sure @Ko_Ver will do a great job to open @TechoramaBE today https://t.co/ILewOGqzX4 37 minutes ago
- @INS2I_CNRS @CNRS @LAMIH_UPHF @CNRS_HdF @UphfOfficiel belles couleurs. toutes nos félicitations 1 hour ago
- Good thing this song never gets old. It's playing on a loop https://t.co/yN6fV4SOah 1 hour ago
- Quick commute to @TechoramaBE https://t.co/d6gOYpm2is 1 hour ago
- The precons for the @PASSDataSummit are out passdatacommunitysummit.com/sessions/pre-c… 2 hours ago
- Still time to register for VSLive Austin, June 13th-17th and learn #DevOps, databases, and more Save $400 with SPK… twitter.com/i/web/status/1… 10 hours ago
- You can see the @PASSDataSummit Learning Pathways for November: passdatacommunitysummit.com/sessions/learn… Register for the Summit an… twitter.com/i/web/status/1… 11 hours ago
- administration
- AI
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- business
- career
- career2
- car update
- Cloud Computing
- conferences
- 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 Compare
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- Tesla
- testing
- travel
- tsqlt
- vacation
- version control
- webinar
- windows
- work
Older Posts
Meta
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