tempdb: Are We There Yet?
- Posted in:
- Database Administration
- SQL Agent
- SQL Server
SQL Server can tell you when [tempdb] is out of space. And you don't even have to ask!
[...Read More]
Formatting Dates with CONVERT
- Posted in:
- Development
- SQL Server
- SSMS
- T-SQL
Can you remember all the date and time styles supported by CONVERT? Me neither!
[...Read More]
Generating Random Passwords In Bulk
- Posted in:
- Database Administration
- Development
- PowerShell
- SQL Server
- T-SQL
Two approaches for generating random passwords. One with T-SQL, another with PowerShell. Which will I settle on?
[...Read More]Machine Learning Services and Result Sets part 2
Dave ponders Machine Learning Services and sp_execute_external_script WITH RESULT SETS...again.
[...Read More]
Machine Learning Services and Result Sets
Dave ponders Machine Learning Services and sp_execute_external_script WITH RESULT SETS.
[...Read More]
T-SQL Tuesday #96: Folks Who Have Made a Difference
- Posted in:
- Blogging
- Career
- PASS
- SQL Server
- T-SQL
My 100th blog post coincides with T-SQL Tuesday: Folks Who Have Made a Difference.
[...Read More]
XE Profiler - Initial Thoughts
- Posted in:
- Microsoft
- SQL Server
- SSMS
- XEvents
Initial thoughts on XE Profiler, a new feature in SSMS 17.3.
[...Read More]
Regular Expressions With R And T-SQL
- Posted in:
- Development
- R
- SQL Server
- SQL Server 2016
- T-SQL
I've finally found a tangible example of something I could use R for.
[...Read More]
Azure Virtual Machines: Initial Thoughts
If you're late getting to the Azure party as I was, you should know what you're up against.
[...Read More]
Dipping My Toes In The Azure Pool
- Posted in:
- Azure
- Backup
- Restore
- SQL Server
Trying out Microsoft Azure Blob Storage for SQL Server backup and restore.
[...Read More]