The Pen Cap
This post is for all you up and coming data professionals out there. Over the course of the last week...
2017-03-21
531 reads
Blog Posts
UK Budget 2017 – The Death Knell for Small Business?
Well I suspect not however I suspect it will likely have a major impact. What has this got to do...
2017-03-21
522 reads
Using Azure CLI to do stuff….
For this post I am going to talk about one of the methods I use to manage my Azure resources.
The...
2017-03-21
341 reads
Backup and Restore Strategies in SQL Server : A Brief Introduction
Establishment of a successful business requires the proper maintenance of the data. SQL Server is one the popular platform for the same. In SQL Server, a proper strategy has...
2017-03-20
18 reads
Backup and Restore Strategies in SQL Server : A Brief Introduction
Establishment of a successful business requires the proper maintenance of the data. SQL Server is one the popular platform for...
2017-03-20
1,360 reads
Generating Frequency Table
This week’s blog post is rather simple. One of the main characteristics of a data set involving classes, or discrete...
2017-03-20 (first published: 2017-03-06)
8,551 reads
Help Me, Help You, Deliver DevOps
I believe in DevOps.
Actually, that’s a pretty horrible way to put it. It’s not about belief, like keeping Tinkerbell alive.
I...
2017-03-20 (first published: 2017-03-07)
1,850 reads
TDE: Looking inside your database and backups
TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file...
2017-03-20
325 reads
Testing Your SQL Server Backups the Easy Way with PowerShell & dbatools
In a previous post I wrote about how easy it was to restore a whole SQL Servers user databases from...
2017-03-20
1,042 reads
The parts of an object’s name
Any object within a database in SQL Server has what is called a four part name. Which rather implies four...
2017-03-20
383 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...
Kantor BCA KCU SOLO SLAMET RIYADI Telp:0817°825°533
Telp/Wa 62817825533 Jl. Brigjen Jl. Slamet Riyadi No.3, Kauman, Kec. Ps. Kliwon, Kota Surakarta,...
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