Uppercase All String Columns (and in a Single Query!)
(last updated: 2019-03-21 @ 15:00 EST / 2019-03-21 @ 19:00 UTC )
Intro
The other day, Steve Jones published a short post with a quick...
2019-04-10 (first published: 2019-03-20)
1,549 reads
(last updated: 2019-03-21 @ 15:00 EST / 2019-03-21 @ 19:00 UTC )
Intro
The other day, Steve Jones published a short post with a quick...
2019-04-10 (first published: 2019-03-20)
1,549 reads
It’s just two weeks until the SQL in the City Streamed starts up again in 2019. I’m ready to travel...
2019-03-20
450 reads
(2019-Mar-20) File management may not be at the top of my list of priorities during data integration projects. I assume that...
2019-04-09 (first published: 2019-03-20)
4,578 reads
The March release of Azure Data Studio now supports Jupyter Notebooks with SQL kernels. This is a very interesting feature...
2019-04-08 (first published: 2019-03-20)
704 reads
Earlier this month I released a new, free tool to export SQL Server query data to Excel files without needing Excel....
2019-03-20
686 reads
Do you want to identify the correct Service Tier and Compute Size ( was once known as performance level) for your...
2019-03-20
676 reads
March is Women’s History Month, to celebrate the PASS Women in Technology Virtual Group (@PASS_WIT) held a webcast featuring prominent...
2019-04-09 (first published: 2019-03-20)
1,050 reads
ISACA, which is primarily an Audit and Compliance professional organization, has recently started an initiative with the following purpose:
ISACA’s SheLeadsTech...
2019-03-20
342 reads
As of SQL 2019 CTP2.0 or SQL 2017 CU12 Microsoft has given us a long-awaited addition to the truncation error....
2019-04-05 (first published: 2019-03-20)
2,054 reads
A powerful little expression in SQL Server is the CASE statement. The CASE statement has the ability to "transform" data per business rules to help better understand the data...
2019-03-20
23 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