T-SQL Tuesday #73 Invitation – Naughty or Nice?
Hello Dear Reader! This is the first Tuesday of the month and you know what that means. It’s time to announce the T-SQL Tuesday Topic of the month! This...
2015-12-01
26 reads
T-SQL Tuesday #73 Invitation – Naughty or Nice?
Hello Dear Reader! This is the first Tuesday of the month and you know what that means. It’s time to...
2015-12-07 (first published: 2015-12-01)
1,735 reads
High Availability and Disaster Recovery Training in Austin
I’ll be doing a precon for SQLSaturday #461 in Austin on January 29th, 2016 titled “Creating a High Availability and Disaster Recovery...
2015-12-01
489 reads
Changing Scales and Creating Disappointment
I got an email recently that notified me that session feedback from the Summit was available for my talk. I’d...
2015-12-01
612 reads
Storage options on Azure
Microsoft Azure is a cloud computing platform and infrastructure, created by Microsoft, for building, deploying and managing applications and services...
2015-12-01
616 reads
It’s Not Too Late
You know you want to go on the SQL Cruise. You can. You just have to convince the boss that...
2015-12-01
485 reads
Announcing SQL Server Management Studio - November 2015 Release
For Summary On Improvements In the Latest Release
Please go through the below link.
Summary On Improvements In SSMS Nov 2015
To Download...
2015-12-01
86 reads
Why would you want to name a transaction?
Something that i keep seeing in documentation, in forum code and in real systems is transactions that have names
BEGIN TRANSACTION...
2015-12-04 (first published: 2015-12-01)
5,919 reads
Querying the Plan Cache
I love working with indexes, and I need to know what’s using them to work on them intelligently. Most of...
2015-12-08 (first published: 2015-12-01)
2,023 reads
The Discomfort Zone
Over the Thanksgiving holiday, I read a book entitled The Phoenix Project. This book has been in my Kindle library...
2015-12-04 (first published: 2015-12-01)
1,538 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