Change Tracking for Data Warehouse Loads (Webinar)
For data warehouse professionals, data change detection is is a central part of what we do. Accurately detecting new, changed,...
2016-03-01
604 reads
Now exactly which proposal is this
Introduction
Oft times we are forced into situations where we clearly need to think outside of the box. A case at...
2016-03-10 (first published: 2016-03-01)
1,377 reads
Another Source of Knowledge
It started with a tweet from one the many members of the #sqlfamily who always has something meaningful to say,...
2016-03-07 (first published: 2016-03-01)
1,817 reads
SQL Server Locks – Back to Basics
A fundamental component of SQL Server is locking and locks. The locking mechanism helps to control access to resources to help maintain data integrity.
Related Posts:
An Experiment with Deadlocks March...
2016-03-01
59 reads
SQL Server Locks – Back to Basics
Prelude in SQL Minor
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to...
2016-03-08 (first published: 2016-03-01)
3,284 reads
Trekking through the DAX Jungle In Search of Lost Customers
I like to think I’m proficient at writing DAX and building SSAS tabular models. I enjoy a good challenge and...
2016-03-01
474 reads
Installation of SQL Server (Part 2 - Post-installation)
Previously we discussed about the pre-installation consideration, which can be found here. In the second part of this series, we...
2016-03-01
1,580 reads
Goodness-of-Fit Testing with SQL Server Part 6.1: The Shapiro-Wilk Test
By Steve Bolton
…………Just as a good garage mechanic will fill his or her Craftsman with tools designed to fix specific...
2016-03-08 (first published: 2016-02-29)
2,885 reads
PowerShell – Backup Individual database and delete all it’s respective files by keeping a recent file
Problem Statement
The requirement is to backup individual database and after successful backup the script should retain the most recent file...
2016-03-09 (first published: 2016-02-29)
2,143 reads
Wait Statistics in Azure SQL Database
You need to be aware that you’re going to see differences when you’re working with Azure SQL Database when it...
2016-03-07 (first published: 2016-02-29)
1,967 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