Data loading into Azure SQL Data Warehouse
Azure SQL Data Warehouse (SQL DW) is a new platform-as-a service (PaaS) that distributes workloads across multiple compute resources, called massively parallel processing (MPP)....
2016-03-23
627 reads
I’m presenting for the Pass Security Virtual Chapter!
Tomorrow (3/24/2016) at noon CT I’ll be presenting my SQL Server Security Basics session for the Pass Security Virtual Chapter....
2016-03-23
479 reads
The ‘In Recovery’ Mystery
Last week I received an email from one of our sysadmins asking why one of our databases kept showing as...
2016-03-31 (first published: 2016-03-22)
1,666 reads
Color Themes for Power BI
Color coordination is important in report and dashboard design. We’ve seen theming and color pallet options in the prior iteration...
2016-03-22
1,184 reads
SQLBits in Space
It’s coming in May. The official UK SQL Server 2016 launch event is SQL Bits and the conference returns to...
2016-03-29 (first published: 2016-03-22)
1,405 reads
ETL Auditing
It happens far too often: Once an ETL process has been tested and executes successfully, there are no further checks...
2016-03-29 (first published: 2016-03-22)
2,304 reads
SQL Server Service Broker – Introduction
SQL Server Service Broker is a messaging technology that’s baked right into the SQL Server engine. It was first introduced...
2016-03-30 (first published: 2016-03-22)
2,311 reads
Recertification, too easy?
3 years I was awarded the MCSE: Data Platform certification and as per the recertification rules, I needed to recertify this year to keep it active. So shortly after...
2016-03-21
21 reads
Recertification, too easy?
3 years I was awarded the MCSE: Data Platform certification and as per the recertification rules, I needed to recertify...
2016-03-21
212 reads
Recertification, too easy?
3 years I was awarded the MCSE: Data Platform certification and as per the recertification rules, I needed to recertify...
2016-03-28 (first published: 2016-03-21)
1,802 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