Why Do People Think Dynamic Data Masking is a Good Idea? - SQL SERVER 2016 #5
Data security is always one of the important points which can not be ignored. Nowadays if you are working for...
2016-11-27
935 reads
Data Channel - Launch
Dear All,
I am starting a YouTube channel for SQL Server and Microsoft Data Platform Technologies called "Data Channel". What this...
2016-11-26
424 reads
Change the Collation Setting for Clustered SQL Server 2014 Instance
One of our SQL Server 2014 clusters was installed and after the install, my client told me that we are...
2016-11-26
220 reads
Don't Count on Me
This post is in support of Tim Ford’s (blog|twitter) #iwanttohelp challenge. And also written because this has burned me twice in the past 3 months and by blogging about it,...
2016-11-26
18 reads
ETL #73–NULL or NOT NULL and SQL Interview Questions
Today is the day after Thanksgiving. There are many things to be thankful so I decided to write a short...
2016-11-25
669 reads
Quick PoSh Kills with Stop-DbaProcess
I’ve been trying to get used to using the dbatools cmdlets in PoSh. They help me learn some PowerShell, but...
2016-12-02 (first published: 2016-11-25)
1,544 reads
Friday Reading 2016-11-25
Friday again so before I spend a weekend watching sci-fi movies, I’ll be reading:-
Virtue in the Virtual
Tony Davies discusses containerisation...
2016-11-25
491 reads
sqlservr.exe
We all know what the sqlservr.exe and its importance, but have you noticed the size difference of the .exe when comparing...
2016-11-25
727 reads
XmlReader vs XmlDocument Performance
Recently I have been working on a project where I needed to parse XML files that were between 5mb and 20mb in size. Performance was critical for the project,...
2016-11-24
30 reads
Retrieving Query Store query performance data through sp_WhatsupQueryStore
This afternoon I tweeted that a new Query Store related stored procedure I created is available: sp_WhatsupQueryStore.This blog post goes...
2016-12-01 (first published: 2016-11-24)
2,603 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
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...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan Resmi BCA KCP Tanggul Hub/Wa. 0817-819-444
Jl. PB.Sudirman No.40, Tekoan, Tanggul Kulon, Kec. Tanggul, Kabupaten Jember, Jawa Timur 68155
Layanan BCA KCP Jajag Hub/Wa. 0817-819-444
Jl. YOS Sudarso No.49, Dusun Kp. Baru, Jajag, Kec. Gambiran, Kabupaten Banyuwangi, Jawa Timur...
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