Report Builder Changes in SQL Server 2016
As a lot of features, Report Builder will improve as well in SQL Server 2016. At the moment of writing CTP 2.3...
2015-09-07
5,084 reads
Dustin Ryan: Power Pivot 101: An Introduction
The PASS Excel Business Intelligence virtual chapter presents Dustin Ryan introducing everybody to Power Pivot in Excel. This chapter has...
2015-09-07
655 reads
Extended Events Packages
The first core building block to the data that builds Extended Events is the concept around packages.
Related Posts:
Correlate Trace and XE Events December 28, 2017
SQL Servers Black Box...
2015-09-07
23 reads
Extended Events Packages
Today, I continue on with exploring some of the metadata concerning Extended Events. To date, I have explored various aspects...
2015-09-07
574 reads
Populating My DBA Database for Power Bi with PowerShell – SQL Info
Following my post about using Power Bi with my DBA Database I have been asked if I would share the...
2015-09-07
926 reads
VARCHAR = @NVARCHAR and SARGability
In my previous post, I mentioned the use of functions, specifically ISNULL and the effects on SARGability of the query....
2015-09-07
1,359 reads
Columnstore Indexes – part 65 (“Clustered Columnstore Improvements in SQL Server 2016”)
Continuation from the previous 64 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This article is dedicated to the improvements...
2015-09-06
602 reads
Use Twitter to get #PowerShell help
A quick post today just to add some weight to something that Mike Fal b | t has kicked off. The #SQLHelp...
2015-09-06
506 reads
How to deploy SSIS Package ? Step by Step SSIS TIP #114
Dear Friends,
In last post we have successfully created our fist basic package. So, Now the next thing is how...
2015-09-05
24,023 reads
018 – Learn Like A Pro! - Syndication – WaterOx Consulting
Learn Like A Pro In WOxPod!, episode # 018 – “Learn Like...
The post 018 – Learn Like A Pro! appeared first on WaterOx...
2015-09-04
509 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Alamat BCA KCP Cilandak KKO I Telp/Wa:0821-8200-233
Telp/Wa 62 821-8200-233 Jl. Raya Cilandak KKO No.9, RT.1/RW.5, Ragunan, Ps. Minggu, Kota Jakarta...
Alamat BCA KCP Arkadia Telp/Wa:0821-8200-203
Telp/Wa 62 821-8200-203 Gedung Perkantoran Hijau Arkadia, Tower C - Ground Floor, unit C103,...
BCA KCU KUNINGAN Telp/Wa:0821-8200-174
Telp/Wa 62 821-8200-174 Menara Karya, Jl. H. R. Rasuna Said Ground floor, RT.1/RW.2, Kuningan,...
Question of the Day
Adding new column with DEFAULT
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers