Common Mistakes in SQL Server – Part 5
Last week, in the post Common Mistakes in SQL Server - Part 4 I explained about the Auto Growth configuration in SQL Server and how it can adversely impact....
2023-10-16
44 reads
Blog Posts
SQL Saturday Boston 2023 Recap
First Things First Thank you to everyone who attended my session “Answering the Automator’s Call with Automation.” My slide deck and demo code are now available on my Github.....
2023-10-16 (first published: 2023-10-15)
82 reads
The 5 Best SQL Course for Beginners – Reviews and Guide
In the technologically driven world of 2024, more individuals are finding themselves drawn towards the intricacies of database management. Central to this booming sector is SQL, a programming language exclusively...
2023-10-16 (first published: 2023-10-04)
538 reads
Using the Pure Storage PowerShellSDK2 - Part 1 - Connecting to FlashArray
Welcome to our blog series on using the Pure Storage PowerShell SDK2. In this series, we will provide you with practical insights and examples on how to harness the...
2023-10-16 (first published: 2023-10-03)
195 reads
SQL Saturday Boston 2023 Slide Decks
Thanks to everyone who came to my sessions at SQL Saturday Boston 2023. I’ve added the decks to the schedule, so you can click my session and will see...
2023-10-14
70 reads
A New Word: Harmonoia
harmonoia – n. an itchy sense of dread when life feels just a hint too peaceful – when everyone seems to get along suspiciously well, with an eerie stillness...
2023-10-13
57 reads
Creating an Empty Repo in GitHub–#SQLNewBlogger
I saw someone struggling with getting started with a Visual Studio project and Azure DevOps. They got a conflict, which I’ll show and then get you started with an...
2023-10-13 (first published: 2023-09-20)
256 reads
Parameterize your Databricks notebooks with widgets
Widgets provide a way to parameterize notebooks in Databricks. If you need to call the same process for different values, you can create widgets to allow you to pass...
2023-10-13 (first published: 2023-09-28)
409 reads
dataMinds Connect 2023 – Raiders of the Lost ADX slides
You can find the slides for the session that I gave with Johan at dataMinds Connect 2023 at GitHub. As usual, the event was amazing. A lot of great...
2023-10-12
44 reads
A NEW’er Solution For An Old Problem: How To Gain Access To SQL Server When No DBA Around
How To Gain Access To SQL Server When No DBA
When I showed a draft of this article to a friend of mine, to...
2023-10-11 (first published: 2023-09-22)
938 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
Question of the Day
Adding Bits I
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