Remotely Copy Files To Multiple Destinations Using PowerShell
Remotely Copy Files To Multiple Destinations Using PowerShell
Basic Copy-Item cmdletIf you have used some PowerShell, you are probably familiar with Copy-Item...
2023-08-12
57 reads
Remotely Copy Files To Multiple Destinations Using PowerShell
Remotely Copy Files To Multiple Destinations Using PowerShell
Basic Copy-Item cmdletIf you have used some PowerShell, you are probably familiar with Copy-Item...
2023-08-13 (first published: 2023-08-12)
2,431 reads
Friday Flyway Tips: Searching Migrations
When a Flyway Desktop (FWD) project (or Flyway project) has been around for a long time, there can be a lot of migration scripts. That can be a pain...
2023-09-15 (first published: 2023-08-11)
125 reads
How to Create a Time Table in Power BI Using DAX
Lately, I’ve been having to create items in Power BI, that I haven’t had to do for a while, this week it was a Time table. Of course, I...
2023-08-28 (first published: 2023-08-11)
507 reads
A New Word: Aubadoir
aubadoir – n. the outworldly atmosphere just before 5 am, when the bleary melodrama of an extremely late night becomes awkwardly conflated with the industrious flourescence of a very...
2023-08-11
246 reads
Webinar: Unlock the Full Potential of Flyway to Achieve Automated Database Releases
On Aug 22, 2023, I’m co-hosting a webinar with Anderson Rangel, Redgate Solution Engineer in Brisbane. You can register here for the 11am AEST webinar. No, I’m not going...
2023-08-11
41 reads
The 2023 Redgate UK DevOps Roadshow
Years ago Redgate did some traveling events under the SQL in the City brand. These were a lot of fun and kind of amazing. One of the longer tours...
2023-08-10
43 reads
Serving layers with a data lake
Data lakes typically have three layers: raw, cleaned, and presentation (also called bronze, silver, and gold if using the medallion architecture popularized by Databricks). I talk about this is...
2023-08-28 (first published: 2023-08-09)
426 reads
Finding Encrypted Stored Procedures–#SQLNewBlogger
I had a client ask about how to deal with encrypted stored procedures in their database. This post looks at how to find them and I’ll have future posts...
2023-08-09
334 reads
T-SQL Tuesday #165–Job Titles
This T-SQL Tuesday is from a new host, Josephine Bush, leader of the Boulder group just North of me. It’s an interesting invitation, asking what our job titles really...
2023-08-08
226 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