DBCC CLONEDATABASE and sensitive data
Just over 2 months ago Service Pack 2 for SQL server 2014 was released. Included in this Service Pack is...
2016-09-28
1,791 reads
An open letter to the PASS community
PASS is our community.
It may sound a little cliche in this time of election propaganda in the US, but it’s...
2016-09-28
730 reads
Connecting to Twitter with R and RStudio
Social Media and Analytics is always an interesting combination. Twitter has an API that you can so you can connect...
2016-09-28
1,173 reads
Query shortcuts in SQL Server Management Studio
Tired of typing out the same queries day after day? Well query shortcuts in SSMS are for you!
Following on from...
2016-10-13 (first published: 2016-09-28)
4,144 reads
Power BI Desktop hosted on premises with SSRS 2016
UPDATE 2016-10-27: the preview is available as a VM in the Azure Marketplace. More information can be found on the...
2016-10-12 (first published: 2016-09-28)
3,888 reads
A really simple bug with SSMS
If you’re a long time IT professional or an occasional user of high or even low tech software you’ll know...
2016-09-28
552 reads
Configuring Passwordless PowerShell Remoting over SSH
Open Source PowerShell has been on fire, getting tons of community support and really making people think about what’s to come with a single language to manage a heterogenous...
2016-09-28
20 reads
Configuring Passwordless PowerShell Remoting over SSH
Open Source PowerShell has been on fire, getting tons of community support and really making people think about what’s to...
2016-09-28
3,488 reads
SQL Server Execution Plan Operator – Table Scan
In my previous blog we discussed about the different format of SQL Server execution plan. Now in upcoming blogs we...
2016-09-28
532 reads
SQL Server: Monitoring Disk Space with FSUTIL command line utility
Table of Contents
IntroductionPre-requisitesData flowEnable xp_cmdshellDownloadSQL CodeOutputConclusionReferencesSee Also
Introduction
This article talks about one of SQL method to fetch the disk usage details...
2016-09-27
1,701 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