Overview of Published Articles – 2015Q4
Here is an overview of the articles I published in the final quarter of 2015:
Integrated Logging with the Integration Services Package...
2016-01-22
503 reads
Blog Posts
Power BI Export Data
If you missed it last week, Microsoft released a Service Update for Power BI , and a long awaited feature is...
2016-01-22 (first published: 2016-01-13)
2,267 reads
The SQL Server Security Model, Part 1: Logins [Foundations Friday]
How secure are your databases?
No, not your network. Just your databases. If your company is like most, the strongest security...
2016-01-22
778 reads
T-SQL Code Coverage in SSDT using the SSDT Dev Pack
Code Coverage
What is code coverage?
When you write some code and then test it, how sure are you that you have...
2016-01-22 (first published: 2016-01-13)
2,079 reads
Using Change Tracking in SSIS
Recently, I wrote about how to get started with SQL Server change tracking, and I demonstrated a design pattern I...
2016-01-22
2,683 reads
What Do You Want?
It’s that time of year, planning for PASS Summit 2016. We’ve already put out the Call for Volunteers, which closes...
2016-01-22
394 reads
All about the Change
The second Tuesday of January 2016 is now upon us and you know what that means. Well, I hope you...
2016-01-21 (first published: 2016-01-12)
1,430 reads
Basic Windows Administration through Powershell
Hi Guys,
In the previous blog I took you through PowerShell basics We know that PowerShell to works with different modules...
2016-01-21 (first published: 2016-01-13)
2,598 reads
Counting Your VLFs, or, Temp Tables Inside IF...ELSE Blocks
There are many many blog posts out there about Virtual Log Files (VLFs) - one of the absolute best is "8...
2016-01-21
878 reads
Foundations Friday starts now
Earlier this month, my friend Tim Ford (b|t) proposed an idea:
A 2016 challenge to technical bloggers: 1 introductory level blog...
2016-01-21
451 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