Updating a view
I was recently asked how to update views. Specifically the question was about using triggers to update a view.
So...
2015-10-12 (first published: 2015-09-30)
3,133 reads
Utility link for excel import to SQL
Utility link for excel import to SQL
Save Excel Data into Databases
http://www.savetodb.com/Connect to databases, edit data, and save changes back. Edit data...
2015-09-30
448 reads
What’s happening in Asia Pacific?
TweetG’day,
I really am going to make an effort to blog more, and this post is really the start of that.
I...
2015-09-30
1,205 reads
SQL Licensing
Recently, there are lots of questions about SQL licenses, many of them came from the fact that they starting to upgrade to 2012/2014 from their old 2005 servers as...
2015-09-30
32 reads
Bitwise XOR in DAX
In T-SQL and other languages we have bitwise XOR natively supported; the T-SQL operator is simply ^. Here’s the explanation of...
2015-10-08 (first published: 2015-09-29)
3,194 reads
Data Warehouse from the Ground Up at SQL Saturday Orlando, FL on Oct. 10th
SQL Saturday #442 is upon us and yours truly will be presenting in Orlando, Florida on October 10th alongside Mitchell...
2015-09-29
1,037 reads
Azure Data Lake enhancements
I first blogged about Microsoft’s new product, the Azure Data Lake, a few months back (here). There are already enhancements, as...
2015-09-29
1,179 reads
Congrats to Jen, Tim, Ryan, and Argenis
Last week we received the results of the PASS Board of Directors elections for 2015. Jen Stirrup and Tim Ford...
2015-09-29
823 reads
Congrats to Jen, Tim, Ryan, and Argenis
Last week we received the results of the PASS Board of Directors elections for 2015. Jen Stirrup and Tim Ford...
2015-09-29
990 reads
Load Testing Your Storage Subsystem with Diskspd – Part II
In this post we’re going discuss how to implement load testing of your storage subsystem with DiskSpd. We’re going to craft tests to measure bandwidth and latency for specific...
2015-09-29
35 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