Azure SQL Database sa Connections?
I was using a query on one of my local SQL Servers where I wanted to know what logins were...
2018-02-07
1,099 reads
Expanding My Reach
I am so thrilled to have the opportunity to expand my writing with my first Simple-Talk article posted. Simple- Talk is technical journal and...
2018-02-07
318 reads
SQL Server in Kubernetes on Docker for Windows
Last week Docker announced a feature that I’ve been looking forward to for a while: –
And sure enough, when I...
2018-02-07
1,444 reads
Scale-out SSRS (a brain dump)
So, I just got finished with a SQL Server Reporting Services (SSRS) scale-out deployment, based largely on this step-by-step guide. Things mostly went...
2018-02-06
424 reads
SQL Server – Internals of sp_spaceused
This article is an effort to dissect the output of the sp_spaceused stored procedure.
Introduction
Understanding the database usage internals and the growth trends...
2018-02-06
466 reads
Power BI Screen Reader Accessibility
I recently wrote a post on the BlueGranite blog called Improving Screen Reader Accessibility in Power BI Reports. It contains...
2018-02-13 (first published: 2018-02-06)
2,036 reads
tSQLt Course
In the last half of 2017, I decided to run a tSQLt course and went down the route of putting...
2018-02-16 (first published: 2018-02-06)
3,046 reads
tSQLt Course
In the last half of 2017, I decided to run a tSQLt course and went down the route of putting together a free 12-week email course. The intention was...
2018-02-06
12 reads
tSQLt Course
In the last half of 2017, I decided to run a tSQLt course and went down the route of putting...
2018-02-06
243 reads
tSQLt Course
In the last half of 2017, I decided to run a tSQLt course and went down the route of putting...
2018-02-06
297 reads
Blogs
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...
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Forums
Alamat BCA KCP Abdul Muis Telp/Wa:08218520154
Alamat: Gedung Graha Motor City, Jl. Abdul Muis No.24-26 Level I Suite 101, RT.2/RW.8,...
Alamat BCA KCP Sabang Telp/Wa:08218520154
Alamat: Jl. H. Agus Salim No.57 B, RT.3/RW.1, Kb. Sirih, Kec. Menteng, Kota Jakarta...
Alamat BCA KCP Kebon Sirih Telp/Wa:08218520154
Alamat: Plaza Pupuk Kaltim, Jl. Kebon Sirih No.6A Gedung B Lantai 1, RT.14/RW.2, Gambir,...
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