Monday Coffee 2016-12-12
Speaking and presenting
One of my biggest fears is public speaking and judging by this article, I’m not alone.
However it’s something...
2016-12-12
301 reads
Database synchronization in the Software Development Life Cycle
Reading the title, most of you are probably thinking: What does database synchronization have to do with the Software Development Life Cycle (SDLC)? Stick around, because I'll get to...
2016-12-12
28 reads
Database synchronization in the Software Development Life Cycle
Reading the title, most of you are probably thinking: What does database synchronization have to do with the Software Development...
2016-12-12
858 reads
How to use DTA (Database Tuning Advisor) with Plan Cache option?
SQL Server 2012 comes up with new workload option in DTA (Database Tuning Advisor). In addition, on existing options File...
2016-12-12
2,671 reads
My Interview at SQL Server Geeks 2016
One of the biggest highlights of this year for me was speaking at SQL Server Geeks Annual Summit 2016. In...
2016-12-11
395 reads
Aggregate Functions
Aggregate Functions
MINReturns the smallest value in a given columnMAXReturns the largest value in a given columnSUMReturns the sum of the...
2016-12-11
263 reads
Analysis Services and Power BI: Time-travel, Space-warping and Teleportation
As I visit businesses, consulting clients and training classes, to teach data reporting and analytics; there is a recurring conversation. ...
2016-12-28 (first published: 2016-12-10)
1,561 reads
Linux – How to generate and configure SSH Key authentication to connect to a remote system
Using SSH keys provide a more secure way of logging into a remote computer when compared to password authentication, and today...
2016-12-10
400 reads
Interviewed on Channel 9
Had a quick interview at Microsoft on Channel 9 last month, and it’s now live. Enjoy.
https://channel9.msdn.com/Blogs/vsppstories/Including-the-database-in-your-DevOps-pipeline/player
Filed under: Blog Tagged: DevOps,...
2016-12-09
716 reads
Easily Move Databases with Copy-SqlDatabase
One of the things that people have asked to be implemented for many years is an easy way to copy...
2016-12-29 (first published: 2016-12-09)
2,485 reads
Blogs
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Forums
Alamat BCA KCP Mall Grand Indonesia Telp:08218520153
WhatsApp Cs 628218520153 Gedung Grand Indonesia Mall A, Lower Ground No. 20-21, Jl. M.H....
Alamat Kantor BCA KCP Senen Telp:08218520153
WhatsApp Cs 628218520153 Pusat Grosir Senen Jaya Blok A8-9, Lantai 2, RW.3, Senen, Kec....
BCA KCU PANGERAN JAYAKARTA Tlp:08218520153
WhatsApp Cs 628218520153 Jl. P Jayakarta Komp. No.127, RT.7/RW.7, Mangga Dua Sel., Kecamatan Sawah...
Question of the Day
Adding new column with DEFAULT II
Which number did the two COUNT(*) return:
DROP TABLE IF EXISTS #tmp CREATE TABLE #tmp (id INT NOT NULL) INSERT INTO #tmp (id) SELECT gs.value FROM GENERATE_SERIES(1, 5) AS gs ALTER TABLE #tmp ADD my_value INT NOT NULL CONSTRAINT df_tmp_my_value DEFAULT 1 SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1 ALTER TABLE #tmp DROP CONSTRAINT df_tmp_my_value ALTER TABLE #tmp ADD CONSTRAINT df_tmp_my_value DEFAULT 2 FOR my_value SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1See possible answers