Install SQL Server using Powershell Desired State Configuration (DSC)
This article shows the basics of using PowerShell Desired State Configuration to install a SQL Server.
2023-05-29
7,913 reads
This article shows the basics of using PowerShell Desired State Configuration to install a SQL Server.
2023-05-29
7,913 reads
Learn how a Jenkins server can be used to schedule SQL scripts to execute against SQL Server.
2020-12-22
28,609 reads
Introduction PowerShell is a task-based command-line shell and scripting language; it is designed specifically for system administrators and power-users, to rapidly automate the administration of multiple operating systems (Linux, OSX, and Windows) and the processes related to the applications that run on those operating systems. For system administrators (DBAs\Wintel Admins), creating PowerShell scripts is a […]
2020-12-10
4,408 reads
Configuration of SQL Server Always on in Azure Virtual machines differs in multiple ways comparing with the on-premise Implementations. This article will help you to have a handy note to configure always on in Azure servers from a DBA perspective.
2020-09-04 (first published: 2018-12-06)
14,735 reads
This article is to explain a scenario I started facing in my work environment after some Windows Security patches rolled out .
A required privilege is not held by the client. The step failed.
2018-07-16
44,419 reads
This article will give you insight to understand how you can schedule a powershell script you have written using SQL Server Agent.
2018-05-22
40,965 reads
Install Visual Studio 2015 in Windows Server without Internet Connection
2018-01-15
8,914 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers