Tip: Jobs without a scheduled run
It’s awfully comforting to see all those backup and maintenance jobs in your SQL Agent list, isn’t it? It’d be...
2014-01-22
537 reads
Blog Posts
Using multiple CTEs in one query
This is a fairly simple thing to do, but I had to look it up the other day and thought...
2014-01-22
1,403 reads
Volunteers Needed For PASS SUMMIT
Last night I submitted my application to volunteer for the 2014 PASS Summit Program Committee.
Not know what PASS is? head...
2014-01-22
1,181 reads
Get Rid of These 5 T-SQL Bad Habits with SQL Prompt
We all have bad habits. Maybe we eat too many snacks, spend too much time on the couch watching TV,...
2014-01-21
610 reads
Power BI for Office 365 pricing announced
Pricing for Power BI for Office 365 has been announced (see pricing).
It’s all very confusing to me but Melissa Coates does a...
2014-01-21
772 reads
SQL Server 2014 – Delayed Durability
Pop quiz: What does ACID stand for?
That should be a pretty easy question for database professionals:
AtomicityConsistencyIsolationDurabilityIt’s that last property, durability,...
2014-01-21 (first published: 2014-01-13)
2,926 reads
Table Hierarchy updated
Recently a need resurfaced to explore the foreign key tree (hierarchy/genealogy) as it related to a specific table within a database. As I pulled out the script from the...
2014-01-21
7 reads
Table Hierarchy updated
Recently a need resurfaced to explore the foreign key tree (hierarchy/genealogy) as it related to a specific table within a...
2014-01-21
849 reads
Thaw, Rinse, Repeat – #SQLPlunge
Three years ago in March of 2011, on a whim, I jumped into a hole in a frozen lake into...
2014-01-21
602 reads
Three Hundred!
Just announced on Friday, SQLSaturday #300 will be held in Kansas City, MO, on September 13, 2014 . Everything about that...
2014-01-21
486 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