In this blog post, we’ll explore various methods to retrieve the current date using SQL Server commands. Get Current Date & Time in SQL Server GETDATE(): Get Precise Date & Time in SQL Server SYSDATETIME(): if you require a higher level of precision in…
Looping is a foundational concept in PowerShell, integral to the very essence of programming. It becomes essential in various scenarios where we need to process one object at a time within an array or collection of objects. According to Microsoft’s documentation on Foreach, it…
Encountering the error message “PS1 cannot be loaded because running scripts is disabled on this system” in PowerShell can be a roadblock in your scripting or development. It’s a common error in PowerShell while attempting to run a command. This post aims to guide…
This post contains a guide on how to export data from SQL Server to your local desktop using SQL Server Management Studio (SSMS). The default export option in SSMS is Column-Aligned, and we need to change it to Comma-Delimited to align the data correctly…
The quest for randomness in SQL Server leads us to two prominent players: RAND() and NEWID(). This blog post shows examples of both functions, exploring their capabilities, use cases, and the subtle distinctions that set them apart when generating random values. RAND() Function The…
If you’re working with SQL Server in a corporate environment, you may need to connect to the server using a different Domain User account. For example, you may need to test the access and permissions of newly created SQL Server AD Users. Connecting to…
_
Hi, my name is Peter Whyte. I’m an experienced SQL Database Administrator (DBA) & Blogger, working remotely from home in Edinburgh, Scotland.
I help maintain High Availability SQL Server database environments, troubleshoot issues, and optimize performance within my role as a Site Reliability Engineer (SRE) at GoDaddy. This blog includes a lot of information and skills required working as a SQL Server DBA.