Install SSMS using Powershell DSC
Learn how you can install SMSS automatically using PowerShell DSC as this series continues.
Mind Over Milkshake (Thoughts Matter)
You mind can influence your body. Maybe. A study Steve found says that could be true, but he certainly thinks it can influence your attitude and how you respond to situations at work.
Gracefully Handle Errors using TRY CATCH Logic in SQL Server Stored Procedures
Learn how to capture errors in SQL Server stored procedures and gracefully handle errors using Try Catch coding in your stored procedures.
Ask For What You Need
Today we have a guest editorial where Andy Warren asks you if you know how to ask for things at work. Many IT works struggle to ask for resources, but read on to understand how Andy might help you get more done at your job.
Server Dashboards in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how the tool works, and this one continues the series. In this article, I want to look at the server and database dashboards and how you can customize them. Another article will cover the Database dashboards. […]
PowerShell Dynamic Parameters and SQL Server
Have you ever been in a situation that you want to call a cmdlet or a function with a parameter that depends on a conditional criteria that is available as a list? In this article I will show a technique where you can use PowerShell Dynamic Parameters to assist the user with parameter values.
Sharing the Work You Do
During one my yearly review, I got one particularly interesting piece of feedback. “You need to share the work you are doing and share with the company.” This is basically a matter of letting people know about the stuff we are putting out on Simple-Talk.com. It is something that is regularly done here, but to […]
A Great Place to Work
Do you enjoy your workplace or employer? Steve does and has a few thoughts on what that is like for him.
Django's ORM vs. Raw SQL: When to Use Which
When it comes to building websites, how you work with your database can make a huge difference in how well your site runs. That's especially true if you're using Django, a popular tool for making websites with Python. Django comes with something called an Object-Relational Mapping (ORM) layer, which is a fancy way of saying […]
SQL WAITFOR Command to Delay SQL Code Execution
One of the most rarely used commands in SQL is the WAITFOR command. It is one option to invoke a delay in program execution in absentia. Because it is sparsely used, how and where it can be applied when needed is often forgotten. For example, we could use this to mimic a user response or input or perhaps to collect data at certain intervals during the day.
Blogs
How to Find Where Your Databases Reside In The File System
By SQLPals
How to Find Where Your Databases Reside In The File System SQL Script: Copy ...
Understanding and Using xp_sqlagent_enum_jobs in SQL Server
By SQLPals
Understanding and Using xp_sqlagent_enum_jobs in SQL Server What is xp_sqlagent_enum_jobs? xp_sqlagent_enum_jobs is an undocumented, extended stored procedure...
Darling Data SQL Server Stored Procs in Azure SQL Database
Erik Darling, founder of Darling Data, has created these fantastic stored procedures to query...
Forums
Get rid off master key
Hello everyone, I'm currently working with Visual Studio 2022 and SQL Server 2019 Enterprise...
dtexecui.exe not found
Hi All, I have VS 2022 installed along with SQL server data tools enabled....
How to replace a specific part of string contains value in side whole string
Good Morning, CREATE TABLE MyTable (ID int, DATA NVARCHAR(MAX)) INSERT INTO MyTable values (1,...
Question of the Day
Dacpac Data
Can a .dacpac file created with sqlpackage.exe /extract include data?
See possible answers