AI In the Nov 2023 Enterprise
An OReilly Radar report on AI has some interesting data to Steve. Read what he thinks about the state of this technology in 2023.
Why Don't You Upgrade in Place?
Is there a reason to upgrade your SQL Server in place instead of building a new instance? Andy Warren has a few thoughts today on why this might be the right choice.
Sending resource alerts on Managed Instance using db_mail
One of the biggest issue that you might experience in Managed Instance is reaching storage limit or finding out that you don't have enough CPU. In this case you would need to get the bigger instance; however, this is not instant operation. In this post, you will see how you can monitor resource usage and send email alerts if there is a risk that you might reach the limits.
Stairway to Server Management Objects (SMO) Level 1: Concepts and Basics
Learn how to get started working with SMO and PowerShell.
Stairway to Server Management Objects (SMO) Level 2: Connections and Creating Server Inventories
Learn how to get started working with SMO and PowerShell.
Stairway to Server Management Objects (SMO) Level 3: The Database Class
Learn how to get started working with SMO and PowerShell.
Stairway to Server Management Objects (SMO) Level 4: Scripting and Copying Small Databases
In the fourth level of this series, we will examine how you can use the scripting classes to create the code to manage your SQL Server instances and databases.
Configuring an SSIS ForEach Loop for Multiple File Types
The ForEach loop works with only one file type at a time by default. Learn how you can add code to your packages to work with multiple types of files.
Migrations are Worth the Effort
Steve prefers database migrations as a way of making changes to a database, though he knows they are hard. He gives a few reasons to choose them.
Source Control with GIT, Power BI and Microsoft Fabric
Source control is fundamental when dealing with projects and sharing code between multiple developers. Power BI present some challenges related to source control. But it’s finally providing us with a solution to these challenges. Let’s analyse this piece-by-piece.
Blogs
Creating a Scripts Folder in SQL Compare
By Steve Jones
While I was at a conference recently, someone asked me about the Scripts Folder...
Hello Microsoft Entra ID, good bye Azure Active Directory
A couple of months ago where I work, a major product started undergoing a...
Can you take a differential backup of master?
In one of the sessions I attended during the Pass Data Community Summit the...
Forums
SQL2019 ODBC Connection from Linux setup help.
I can connect to the sql server 2019 from my linux machine with tsql...
Database space issue
Hi experts, I am facing issue with the database file space used. Here are...
Why Don't You Upgrade in Place?
Comments posted to this topic are about the item Why Don't You Upgrade in...
Question of the Day
Parameter Defaults
I have a T-SQL stored procedure that looks like this:
CREATE PROCEDURE dbo.AddTogether @a int
, @b int = 1
AS
BEGIN
-- Declare a variable to store the result
DECLARE @result INT;
-- Add the two parameters and assign to the variable
SET @result = @a + @b;
-- Return the result
SELECT @result;
END;
Where can I query the DMVs to get the parameter defaults? (null for @a, 1 for @b) See possible answers